· 6 years ago · Jun 11, 2019, 08:28 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL,
3 `admin` int(1) NOT NULL DEFAULT '0',
4 `birthday` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '01/01/1990',
5 `birthday_visibility` enum('month_date_and_year','month_and_date','none') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'month_date_and_year',
6 `comment_privacy` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone',
7 `confirm_followers` int(1) NOT NULL DEFAULT '0',
8 `country_id` int(11) NOT NULL DEFAULT '0',
9 `current_city` text COLLATE utf8_unicode_ci,
10 `follow_privacy` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone',
11 `gender` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'male',
12 `go_offline` int(1) NOT NULL DEFAULT '0',
13 `hometown` text COLLATE utf8_unicode_ci,
14 `ip_address` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
15 `mailnotif_comment` tinyint(1) NOT NULL DEFAULT '1',
16 `mailnotif_postlike` tinyint(1) NOT NULL DEFAULT '1',
17 `mailnotif_postshare` tinyint(1) NOT NULL DEFAULT '1',
18 `mailnotif_follow` tinyint(1) NOT NULL DEFAULT '1',
19 `mailnotif_friendrequests` tinyint(1) NOT NULL DEFAULT '1',
20 `mailnotif_groupjoined` tinyint(1) NOT NULL DEFAULT '1',
21 `mailnotif_message` tinyint(1) NOT NULL DEFAULT '1',
22 `mailnotif_pagelike` tinyint(1) NOT NULL DEFAULT '1',
23 `mailnotif_timelinepost` tinyint(1) NOT NULL DEFAULT '1',
24 `message_privacy` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone',
25 `payment_method` enum('paypal','stripe') COLLATE utf8_unicode_ci DEFAULT NULL,
26 `paypal_agreement_id` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
27 `post_privacy` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone',
28 `social_login_facebook` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
29 `social_login_google` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
30 `social_login_instagram` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
31 `social_login_linkedin` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
32 `social_login_twitch` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
33 `social_login_twitter` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
34 `social_login_vk` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
35 `start_up` tinyint(1) NOT NULL DEFAULT '0',
36 `stripe_card_last4` int(4) NOT NULL DEFAULT '0',
37 `stripe_customer_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
38 `stripe_customer_id` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
39 `stripe_subscription_id` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
40 `subscription_plan` int(5) NOT NULL DEFAULT '1',
41 `subscription_time` int(11) NOT NULL DEFAULT '0',
42 `timeline_post_privacy` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone'