· 9 years ago · Oct 16, 2016, 01:48 PM
1-- Adminer 4.2.4 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `ads`;
9CREATE TABLE `ads` (
10 `ads_id` int(10) NOT NULL AUTO_INCREMENT,
11 `title` varchar(255) NOT NULL,
12 `place` varchar(255) NOT NULL,
13 `code` text NOT NULL,
14 `time` datetime NOT NULL,
15 PRIMARY KEY (`ads_id`)
16) ENGINE=MyISAM DEFAULT CHARSET=utf8;
17
18
19DROP TABLE IF EXISTS `conversations`;
20CREATE TABLE `conversations` (
21 `conversation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
22 `last_message_id` int(10) unsigned NOT NULL,
23 PRIMARY KEY (`conversation_id`)
24) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
25
26
27DROP TABLE IF EXISTS `conversations_messages`;
28CREATE TABLE `conversations_messages` (
29 `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
30 `conversation_id` int(10) unsigned NOT NULL,
31 `user_id` int(10) unsigned NOT NULL,
32 `message` longtext NOT NULL,
33 `image` varchar(255) NOT NULL,
34 `time` datetime NOT NULL,
35 PRIMARY KEY (`message_id`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
37
38
39DROP TABLE IF EXISTS `conversations_users`;
40CREATE TABLE `conversations_users` (
41 `conversation_id` int(10) unsigned NOT NULL,
42 `user_id` int(10) unsigned NOT NULL,
43 `seen` enum('0','1') NOT NULL DEFAULT '0',
44 `deleted` enum('0','1') NOT NULL DEFAULT '0',
45 UNIQUE KEY `conversation_id_user_id` (`conversation_id`,`user_id`)
46) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
47
48
49DROP TABLE IF EXISTS `followings`;
50CREATE TABLE `followings` (
51 `user_id` int(10) unsigned NOT NULL,
52 `following_id` int(10) unsigned NOT NULL,
53 UNIQUE KEY `user_id_following_id` (`user_id`,`following_id`)
54) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
55
56INSERT INTO `followings` (`user_id`, `following_id`) VALUES
57(2, 1);
58
59DROP TABLE IF EXISTS `friends`;
60CREATE TABLE `friends` (
61 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
62 `user_one_id` int(10) unsigned NOT NULL,
63 `user_two_id` int(10) unsigned NOT NULL,
64 `status` tinyint(1) NOT NULL,
65 PRIMARY KEY (`id`),
66 UNIQUE KEY `user_one_id_user_two_id` (`user_one_id`,`user_two_id`)
67) ENGINE=MyISAM DEFAULT CHARSET=utf8;
68
69INSERT INTO `friends` (`id`, `user_one_id`, `user_two_id`, `status`) VALUES
70(1, 2, 1, 0);
71
72DROP TABLE IF EXISTS `games`;
73CREATE TABLE `games` (
74 `game_id` int(10) NOT NULL AUTO_INCREMENT,
75 `title` varchar(255) NOT NULL,
76 `description` text NOT NULL,
77 `source` text NOT NULL,
78 `thumbnail` varchar(255) NOT NULL,
79 PRIMARY KEY (`game_id`)
80) ENGINE=MyISAM DEFAULT CHARSET=latin1;
81
82
83DROP TABLE IF EXISTS `groups`;
84CREATE TABLE `groups` (
85 `group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
86 `group_admin` int(10) unsigned NOT NULL,
87 `group_name` varchar(50) NOT NULL,
88 `group_title` varchar(255) NOT NULL,
89 `group_picture` varchar(255) NOT NULL,
90 `group_cover` varchar(255) NOT NULL,
91 `group_description` text NOT NULL,
92 `group_members` int(10) unsigned NOT NULL DEFAULT '0',
93 PRIMARY KEY (`group_id`),
94 UNIQUE KEY `username` (`group_name`)
95) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
96
97
98DROP TABLE IF EXISTS `groups_members`;
99CREATE TABLE `groups_members` (
100 `group_id` int(10) unsigned NOT NULL,
101 `user_id` int(10) unsigned NOT NULL,
102 UNIQUE KEY `group_id_user_id` (`group_id`,`user_id`)
103) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
104
105
106DROP TABLE IF EXISTS `notifications`;
107CREATE TABLE `notifications` (
108 `notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
109 `to_user_id` int(10) unsigned NOT NULL,
110 `from_user_id` int(10) unsigned NOT NULL,
111 `action` varchar(50) NOT NULL,
112 `node_type` varchar(50) NOT NULL,
113 `node_url` varchar(255) NOT NULL,
114 `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
115 `seen` enum('0','1') NOT NULL DEFAULT '0',
116 PRIMARY KEY (`notification_id`)
117) ENGINE=MyISAM DEFAULT CHARSET=utf8;
118
119INSERT INTO `notifications` (`notification_id`, `to_user_id`, `from_user_id`, `action`, `node_type`, `node_url`, `time`, `seen`) VALUES
120(1, 1, 2, 'follow', '', '', '2016-10-16 11:06:49', '0'),
121(2, 1, 2, 'like', 'post', '1', '2016-10-16 11:07:00', '0');
122
123DROP TABLE IF EXISTS `pages`;
124CREATE TABLE `pages` (
125 `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
126 `page_admin` int(10) unsigned NOT NULL,
127 `page_category` int(10) unsigned NOT NULL,
128 `page_name` varchar(50) NOT NULL,
129 `page_title` varchar(255) NOT NULL,
130 `page_picture` varchar(255) NOT NULL,
131 `page_cover` varchar(255) NOT NULL,
132 `page_description` text NOT NULL,
133 `page_verified` enum('0','1') NOT NULL DEFAULT '0',
134 `page_likes` int(10) unsigned NOT NULL DEFAULT '0',
135 PRIMARY KEY (`page_id`),
136 UNIQUE KEY `username` (`page_name`)
137) ENGINE=MyISAM DEFAULT CHARSET=utf8;
138
139
140DROP TABLE IF EXISTS `pages_categories`;
141CREATE TABLE `pages_categories` (
142 `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
143 `category_name` varchar(255) NOT NULL,
144 PRIMARY KEY (`category_id`)
145) ENGINE=MyISAM DEFAULT CHARSET=utf8;
146
147INSERT INTO `pages_categories` (`category_id`, `category_name`) VALUES
148(1, 'Service'),
149(2, 'Musician/Band'),
150(3, 'Brand or Product'),
151(4, 'Company, Organization or Institution'),
152(5, 'Artist, Public figure'),
153(6, 'Entertainment'),
154(7, 'Cause or Community');
155
156DROP TABLE IF EXISTS `pages_likes`;
157CREATE TABLE `pages_likes` (
158 `page_id` int(10) unsigned NOT NULL,
159 `user_id` int(10) unsigned NOT NULL,
160 UNIQUE KEY `page_id_user_id` (`page_id`,`user_id`)
161) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
162
163
164DROP TABLE IF EXISTS `posts`;
165CREATE TABLE `posts` (
166 `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
167 `user_id` int(10) unsigned NOT NULL,
168 `user_type` enum('user','page') NOT NULL,
169 `in_group` enum('0','1') NOT NULL DEFAULT '0',
170 `group_id` int(10) unsigned DEFAULT NULL,
171 `post_type` varchar(50) NOT NULL,
172 `origin_id` int(10) unsigned DEFAULT NULL,
173 `time` datetime NOT NULL,
174 `location` varchar(50) NOT NULL,
175 `privacy` enum('friends','public') NOT NULL,
176 `text` longtext NOT NULL,
177 `likes` int(10) unsigned NOT NULL DEFAULT '0',
178 `comments` int(10) unsigned NOT NULL DEFAULT '0',
179 `shares` int(10) unsigned NOT NULL DEFAULT '0',
180 PRIMARY KEY (`post_id`)
181) ENGINE=MyISAM DEFAULT CHARSET=utf8;
182
183INSERT INTO `posts` (`post_id`, `user_id`, `user_type`, `in_group`, `group_id`, `post_type`, `origin_id`, `time`, `location`, `privacy`, `text`, `likes`, `comments`, `shares`) VALUES
184(1, 1, 'user', '0', 0, '', NULL, '2016-10-15 09:37:58', '', 'public', 'Mantaf :v', 2, 0, 0);
185
186DROP TABLE IF EXISTS `posts_comments`;
187CREATE TABLE `posts_comments` (
188 `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
189 `node_id` int(10) unsigned NOT NULL,
190 `node_type` enum('post','photo') NOT NULL,
191 `user_id` int(10) unsigned NOT NULL,
192 `user_type` enum('user','page') NOT NULL,
193 `text` longtext NOT NULL,
194 `image` varchar(255) DEFAULT NULL,
195 `time` datetime NOT NULL,
196 `likes` int(10) unsigned NOT NULL DEFAULT '0',
197 PRIMARY KEY (`comment_id`)
198) ENGINE=MyISAM DEFAULT CHARSET=utf8;
199
200
201DROP TABLE IF EXISTS `posts_comments_likes`;
202CREATE TABLE `posts_comments_likes` (
203 `user_id` int(10) unsigned NOT NULL,
204 `comment_id` int(10) unsigned NOT NULL,
205 UNIQUE KEY `comment_id_user_id` (`comment_id`,`user_id`)
206) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
207
208
209DROP TABLE IF EXISTS `posts_hidden`;
210CREATE TABLE `posts_hidden` (
211 `user_id` int(10) unsigned NOT NULL,
212 `post_id` int(10) unsigned NOT NULL,
213 UNIQUE KEY `post_id_user_id` (`post_id`,`user_id`)
214) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
215
216
217DROP TABLE IF EXISTS `posts_likes`;
218CREATE TABLE `posts_likes` (
219 `user_id` int(10) unsigned NOT NULL,
220 `post_id` int(10) unsigned NOT NULL,
221 UNIQUE KEY `post_id_user_id` (`post_id`,`user_id`)
222) ENGINE=MyISAM DEFAULT CHARSET=utf8;
223
224INSERT INTO `posts_likes` (`user_id`, `post_id`) VALUES
225(1, 1),
226(2, 1);
227
228DROP TABLE IF EXISTS `posts_links`;
229CREATE TABLE `posts_links` (
230 `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
231 `post_id` int(10) unsigned NOT NULL,
232 `source_url` tinytext NOT NULL,
233 `source_host` varchar(255) NOT NULL,
234 `source_title` varchar(255) NOT NULL,
235 `source_text` text NOT NULL,
236 `source_thumbnail` varchar(255) NOT NULL,
237 PRIMARY KEY (`link_id`)
238) ENGINE=MyISAM DEFAULT CHARSET=utf8;
239
240
241DROP TABLE IF EXISTS `posts_media`;
242CREATE TABLE `posts_media` (
243 `media_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
244 `post_id` int(10) NOT NULL,
245 `media_type` enum('youtube','vimeo','soundcloud') NOT NULL,
246 `source_uid` varchar(255) NOT NULL,
247 `source_url` text NOT NULL,
248 `source_title` varchar(255) DEFAULT NULL,
249 `source_text` text,
250 PRIMARY KEY (`media_id`)
251) ENGINE=MyISAM DEFAULT CHARSET=utf8;
252
253
254DROP TABLE IF EXISTS `posts_photos`;
255CREATE TABLE `posts_photos` (
256 `photo_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
257 `post_id` int(10) unsigned NOT NULL,
258 `source` varchar(255) NOT NULL,
259 `likes` int(10) unsigned NOT NULL DEFAULT '0',
260 `comments` int(10) unsigned NOT NULL DEFAULT '0',
261 PRIMARY KEY (`photo_id`)
262) ENGINE=MyISAM DEFAULT CHARSET=utf8;
263
264
265DROP TABLE IF EXISTS `posts_photos_likes`;
266CREATE TABLE `posts_photos_likes` (
267 `user_id` int(10) unsigned NOT NULL,
268 `photo_id` int(10) unsigned NOT NULL,
269 UNIQUE KEY `user_id_photo_id` (`user_id`,`photo_id`)
270) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
271
272
273DROP TABLE IF EXISTS `reports`;
274CREATE TABLE `reports` (
275 `report_id` int(10) NOT NULL AUTO_INCREMENT,
276 `user_id` int(10) NOT NULL,
277 `node_id` int(10) NOT NULL,
278 `node_type` varchar(50) NOT NULL,
279 `time` datetime NOT NULL,
280 PRIMARY KEY (`report_id`)
281) ENGINE=MyISAM DEFAULT CHARSET=utf8;
282
283
284DROP TABLE IF EXISTS `static_pages`;
285CREATE TABLE `static_pages` (
286 `page_id` int(10) NOT NULL AUTO_INCREMENT,
287 `page_url` varchar(50) NOT NULL,
288 `page_title` varchar(255) NOT NULL,
289 `page_text` text NOT NULL,
290 PRIMARY KEY (`page_id`),
291 UNIQUE KEY `page_url` (`page_url`)
292) ENGINE=MyISAM DEFAULT CHARSET=utf8;
293
294INSERT INTO `static_pages` (`page_id`, `page_url`, `page_title`, `page_text`) VALUES
295(1, 'about', 'About', '<p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>\r\n <h3 class="text-info">\r\n Big Title\r\n </h3>\r\n <p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>\r\n <h3 class="text-info">\r\n Big Title\r\n </h3>\r\n <p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>'),
296(2, 'terms', 'Terms', '<p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>\r\n <h3 class="text-info">\r\n Big Title\r\n </h3>\r\n <p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>\r\n <h3 class="text-info">\r\n Big Title\r\n </h3>\r\n <p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>'),
297(3, 'privacy', 'Privacy', '<p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>\r\n <h3 class="text-info">\r\n Big Title\r\n </h3>\r\n <p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>\r\n <h3 class="text-info">\r\n Big Title\r\n </h3>\r\n <p>\r\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n </p>');
298
299DROP TABLE IF EXISTS `system_languages`;
300CREATE TABLE `system_languages` (
301 `language_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
302 `code` varchar(50) NOT NULL,
303 `title` varchar(255) NOT NULL,
304 `flag_icon` varchar(50) NOT NULL,
305 `dir` enum('LTR','RTL') NOT NULL,
306 `default` enum('0','1') NOT NULL,
307 `enabled` enum('0','1') NOT NULL DEFAULT '1',
308 PRIMARY KEY (`language_id`),
309 UNIQUE KEY `code` (`code`)
310) ENGINE=MyISAM DEFAULT CHARSET=utf8;
311
312INSERT INTO `system_languages` (`language_id`, `code`, `title`, `flag_icon`, `dir`, `default`, `enabled`) VALUES
313(1, 'en_US', 'English', 'us', 'LTR', '1', '1'),
314(2, 'ar_EG', 'Arabic', 'sa', 'RTL', '', '1'),
315(3, 'fr_FR', 'Français', 'fr', 'LTR', '', '1'),
316(4, 'es_ES', 'Español', 'es', 'LTR', '', '1'),
317(5, 'pt_PT', 'Português', 'pt', 'LTR', '', '1'),
318(6, 'de_DE', 'Deutsch', 'de', 'LTR', '', '1'),
319(7, 'tr_TR', 'Türkçe', 'tr', 'LTR', '', '1'),
320(8, 'nl_NL', 'Dutch', 'nl', 'LTR', '', '1'),
321(9, 'it_IT', 'Italiano', 'it', 'LTR', '', '1'),
322(10, 'ru_RU', 'Russian', 'ru', 'LTR', '', '1');
323
324DROP TABLE IF EXISTS `system_options`;
325CREATE TABLE `system_options` (
326 `ID` int(10) NOT NULL AUTO_INCREMENT,
327 `system_live` enum('1','0') NOT NULL DEFAULT '1',
328 `system_message` text NOT NULL,
329 `system_title` varchar(255) NOT NULL DEFAULT 'Sngine',
330 `system_description` text NOT NULL,
331 `system_url` varchar(255) NOT NULL,
332 `system_uploads_directory` varchar(255) NOT NULL,
333 `system_domain` varchar(255) NOT NULL,
334 `users_can_register` enum('1','0') NOT NULL DEFAULT '1',
335 `reCAPTCHA_enabled` enum('1','0') NOT NULL DEFAULT '0',
336 `reCAPTCHA_site_key` varchar(255) NOT NULL,
337 `reCAPTCHA_secret_key` varchar(255) NOT NULL,
338 `email_send_activation` enum('1','0') NOT NULL DEFAULT '1',
339 `email_smtp_enabled` enum('1','0') NOT NULL DEFAULT '0',
340 `email_smtp_authentication` enum('1','0') NOT NULL DEFAULT '1',
341 `email_smtp_server` varchar(255) NOT NULL,
342 `email_smtp_port` varchar(255) NOT NULL,
343 `email_smtp_username` varchar(255) NOT NULL,
344 `email_smtp_password` varchar(255) NOT NULL,
345 `min_results` int(10) NOT NULL DEFAULT '5',
346 `min_results_even` int(10) NOT NULL DEFAULT '6',
347 `max_results` int(10) NOT NULL DEFAULT '10',
348 `games_enabled` enum('1','0') NOT NULL DEFAULT '0',
349 PRIMARY KEY (`ID`)
350) ENGINE=MyISAM DEFAULT CHARSET=utf8;
351
352INSERT INTO `system_options` (`ID`, `system_live`, `system_message`, `system_title`, `system_description`, `system_url`, `system_uploads_directory`, `system_domain`, `users_can_register`, `reCAPTCHA_enabled`, `reCAPTCHA_site_key`, `reCAPTCHA_secret_key`, `email_send_activation`, `email_smtp_enabled`, `email_smtp_authentication`, `email_smtp_server`, `email_smtp_port`, `email_smtp_username`, `email_smtp_password`, `min_results`, `min_results_even`, `max_results`, `games_enabled`) VALUES
353(1, '1', 'We are updating the system please come later!', 'Crzbook', 'Sosmed Mantap :v', 'http://crzbook.com/', 'content/uploads', 'crzbook.com', '1', '', '', '', '', '', '', '', '', '', '', 5, 6, 10, '1');
354
355DROP TABLE IF EXISTS `system_themes`;
356CREATE TABLE `system_themes` (
357 `theme_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
358 `name` varchar(50) NOT NULL,
359 `default` enum('0','1') NOT NULL,
360 PRIMARY KEY (`theme_id`),
361 UNIQUE KEY `name` (`name`)
362) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
363
364INSERT INTO `system_themes` (`theme_id`, `name`, `default`) VALUES
365(1, 'default', '1'),
366(3, '', '');
367
368DROP TABLE IF EXISTS `users`;
369CREATE TABLE `users` (
370 `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
371 `user_group` tinyint(1) unsigned NOT NULL DEFAULT '3',
372 `user_name` varchar(64) NOT NULL,
373 `user_email` varchar(100) NOT NULL,
374 `user_token` varchar(64) NOT NULL,
375 `user_password` varchar(64) NOT NULL,
376 `user_fullname` varchar(255) NOT NULL,
377 `user_gender` enum('M','F') NOT NULL,
378 `user_picture` varchar(255) NOT NULL,
379 `user_cover` varchar(255) NOT NULL,
380 `user_work_title` varchar(50) NOT NULL,
381 `user_work_place` varchar(50) NOT NULL,
382 `user_current_city` varchar(50) NOT NULL,
383 `user_hometown` varchar(50) NOT NULL,
384 `user_edu_major` varchar(50) DEFAULT NULL,
385 `user_edu_school` varchar(50) NOT NULL,
386 `user_edu_class` varchar(50) NOT NULL,
387 `user_birthdate` date DEFAULT NULL,
388 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
389 `user_last_login` datetime NOT NULL,
390 `user_privacy_birthdate` enum('friends','public') NOT NULL DEFAULT 'public',
391 `user_privacy_work` enum('friends','public') NOT NULL DEFAULT 'public',
392 `user_privacy_location` enum('friends','public') NOT NULL DEFAULT 'public',
393 `user_privacy_education` enum('friends','public') NOT NULL DEFAULT 'public',
394 `user_privacy_friends` enum('me','friends','public') NOT NULL DEFAULT 'public',
395 `user_privacy_pages` enum('me','friends','public') NOT NULL DEFAULT 'public',
396 `user_privacy_groups` enum('me','friends','public') NOT NULL DEFAULT 'public',
397 `user_activation_key` varchar(64) NOT NULL,
398 `user_activated` enum('0','1') NOT NULL DEFAULT '0',
399 `user_verified` enum('0','1') NOT NULL DEFAULT '0',
400 `user_reseted` enum('0','1') NOT NULL DEFAULT '0',
401 `user_reset_key` varchar(64) NOT NULL,
402 `user_blocked` enum('0','1') NOT NULL DEFAULT '0',
403 `user_ip` varchar(64) NOT NULL,
404 `user_chat_enabled` enum('0','1') NOT NULL DEFAULT '1',
405 `user_live_requests_counter` int(10) NOT NULL DEFAULT '0',
406 `user_live_requests_lastid` int(10) NOT NULL DEFAULT '0',
407 `user_live_messages_counter` int(10) NOT NULL DEFAULT '0',
408 `user_live_messages_lastid` int(10) NOT NULL DEFAULT '0',
409 `user_live_notifications_counter` int(10) NOT NULL DEFAULT '0',
410 `user_live_notifications_lastid` int(10) NOT NULL DEFAULT '0',
411 PRIMARY KEY (`user_id`),
412 UNIQUE KEY `username` (`user_name`),
413 UNIQUE KEY `user_email` (`user_email`),
414 UNIQUE KEY `user_token` (`user_token`)
415) ENGINE=MyISAM DEFAULT CHARSET=utf8;
416
417INSERT INTO `users` (`user_id`, `user_group`, `user_name`, `user_email`, `user_token`, `user_password`, `user_fullname`, `user_gender`, `user_picture`, `user_cover`, `user_work_title`, `user_work_place`, `user_current_city`, `user_hometown`, `user_edu_major`, `user_edu_school`, `user_edu_class`, `user_birthdate`, `user_registered`, `user_last_login`, `user_privacy_birthdate`, `user_privacy_work`, `user_privacy_location`, `user_privacy_education`, `user_privacy_friends`, `user_privacy_pages`, `user_privacy_groups`, `user_activation_key`, `user_activated`, `user_verified`, `user_reseted`, `user_reset_key`, `user_blocked`, `user_ip`, `user_chat_enabled`, `user_live_requests_counter`, `user_live_requests_lastid`, `user_live_messages_counter`, `user_live_messages_lastid`, `user_live_notifications_counter`, `user_live_notifications_lastid`) VALUES
418(1, 1, 'admin.crzstore', 'ahlulmukhramin11@gmail.com', '1528d024c0116e9bdd9138fdab74697b', '7551e103dd8866a5df4f9e7a799fc36b', 'Ahlul Mukhramin', 'M', 'sngine_b303b8740e6f0d231762672ebbddf300.png', 'sngine_2f9403035bd4111855da891530bbc8bf.jpg', '', '', '', '', NULL, '', '', '2001-11-27', '2016-10-15 09:27:27', '2016-10-15 14:24:03', 'public', 'public', 'public', 'public', 'public', 'public', 'public', '', '1', '1', '0', '', '0', '36.84.62.42', '1', 1, 0, 0, 0, 2, 0),
419(2, 3, 'ergafdsc', 'rgdsa@gmail.com', 'a522bd040b214f8e8bab4394313d7fa4', '513718c536bb0000416871e0fd0f7d99', 'Weerg', 'M', '', '', '', '', '', '', NULL, '', '', NULL, '2016-10-16 11:06:26', '2016-10-16 11:06:26', 'public', 'public', 'public', 'public', 'public', 'public', 'public', 'd58153058ce005c6e53e953cdd112a8b', '0', '0', '0', '', '0', '115.178.202.36', '1', 0, 0, 0, 0, 0, 0);
420
421DROP TABLE IF EXISTS `users_blocks`;
422CREATE TABLE `users_blocks` (
423 `user_id` int(10) unsigned NOT NULL,
424 `blocked_id` int(10) unsigned NOT NULL,
425 UNIQUE KEY `user_id_blocked_id` (`user_id`,`blocked_id`)
426) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
427
428
429DROP TABLE IF EXISTS `users_online`;
430CREATE TABLE `users_online` (
431 `user_id` int(10) unsigned NOT NULL,
432 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
433 UNIQUE KEY `UserID` (`user_id`)
434) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
435
436INSERT INTO `users_online` (`user_id`, `last_seen`) VALUES
437(2, '2016-10-16 11:07:41');
438
439DROP TABLE IF EXISTS `widgets`;
440CREATE TABLE `widgets` (
441 `widget_id` int(10) NOT NULL AUTO_INCREMENT,
442 `title` varchar(255) NOT NULL,
443 `place` varchar(255) NOT NULL,
444 `code` text NOT NULL,
445 PRIMARY KEY (`widget_id`)
446) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
447
448
449-- 2016-10-16 13:45:46