API tools faq
paste
RintoMuhamad

crzbook.com DB Leaked By Rinto AR - Xai Syndicate Team

RintoMuhamad
Oct 16th, 2016
729
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.70 KB | None | 0 0
raw download clone embed print report
  1. -- Adminer 4.2.4 MySQL dump
  2.  
  3. SET NAMES utf8;
  4. SET time_zone = '+00:00';
  5. SET foreign_key_checks = 0;
  6. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  7.  
  8. DROP TABLE IF EXISTS `ads`;
  9. CREATE 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.  
  19. DROP TABLE IF EXISTS `conversations`;
  20. CREATE 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.  
  27. DROP TABLE IF EXISTS `conversations_messages`;
  28. CREATE 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.  
  39. DROP TABLE IF EXISTS `conversations_users`;
  40. CREATE 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.  
  49. DROP TABLE IF EXISTS `followings`;
  50. CREATE 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.  
  56. INSERT INTO `followings` (`user_id`, `following_id`) VALUES
  57. (2, 1);
  58.  
  59. DROP TABLE IF EXISTS `friends`;
  60. CREATE 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.  
  69. INSERT INTO `friends` (`id`, `user_one_id`, `user_two_id`, `status`) VALUES
  70. (1, 2, 1, 0);
  71.  
  72. DROP TABLE IF EXISTS `games`;
  73. CREATE 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.  
  83. DROP TABLE IF EXISTS `groups`;
  84. CREATE 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.  
  98. DROP TABLE IF EXISTS `groups_members`;
  99. CREATE 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.  
  106. DROP TABLE IF EXISTS `notifications`;
  107. CREATE 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.  
  119. INSERT 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.  
  123. DROP TABLE IF EXISTS `pages`;
  124. CREATE 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.  
  140. DROP TABLE IF EXISTS `pages_categories`;
  141. CREATE 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.  
  147. INSERT 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.  
  156. DROP TABLE IF EXISTS `pages_likes`;
  157. CREATE 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.  
  164. DROP TABLE IF EXISTS `posts`;
  165. CREATE 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.  
  183. INSERT 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.  
  186. DROP TABLE IF EXISTS `posts_comments`;
  187. CREATE 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.  
  201. DROP TABLE IF EXISTS `posts_comments_likes`;
  202. CREATE 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.  
  209. DROP TABLE IF EXISTS `posts_hidden`;
  210. CREATE 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.  
  217. DROP TABLE IF EXISTS `posts_likes`;
  218. CREATE 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.  
  224. INSERT INTO `posts_likes` (`user_id`, `post_id`) VALUES
  225. (1, 1),
  226. (2, 1);
  227.  
  228. DROP TABLE IF EXISTS `posts_links`;
  229. CREATE 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.  
  241. DROP TABLE IF EXISTS `posts_media`;
  242. CREATE 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.  
  254. DROP TABLE IF EXISTS `posts_photos`;
  255. CREATE 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.  
  265. DROP TABLE IF EXISTS `posts_photos_likes`;
  266. CREATE 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.  
  273. DROP TABLE IF EXISTS `reports`;
  274. CREATE 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.  
  284. DROP TABLE IF EXISTS `static_pages`;
  285. CREATE 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.  
  294. INSERT 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.  
  299. DROP TABLE IF EXISTS `system_languages`;
  300. CREATE 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.  
  312. INSERT 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.  
  324. DROP TABLE IF EXISTS `system_options`;
  325. CREATE 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.  
  352. INSERT 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.  
  355. DROP TABLE IF EXISTS `system_themes`;
  356. CREATE 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.  
  364. INSERT INTO `system_themes` (`theme_id`, `name`, `default`) VALUES
  365. (1, 'default', '1'),
  366. (3, '', '');
  367.  
  368. DROP TABLE IF EXISTS `users`;
  369. CREATE 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.  
  417. INSERT 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', '[email protected]', '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', '[email protected]', '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.  
  421. DROP TABLE IF EXISTS `users_blocks`;
  422. CREATE 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.  
  429. DROP TABLE IF EXISTS `users_online`;
  430. CREATE 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.  
  436. INSERT INTO `users_online` (`user_id`, `last_seen`) VALUES
  437. (2, '2016-10-16 11:07:41');
  438.  
  439. DROP TABLE IF EXISTS `widgets`;
  440. CREATE 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
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!