API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 25th, 2015
167
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.35 KB | None | 0 0
raw download clone embed print report
  1. -- Adminer 4.2.0 MySQL dump
  2.  
  3. SET NAMES utf8mb4;
  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 `cron`;
  9. CREATE TABLE `cron` (
  10. `id` int(11) NOT NULL AUTO_INCREMENT,
  11. `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  12. `val` tinyint(1) NOT NULL,
  13. PRIMARY KEY (`id`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  15.  
  16. INSERT INTO `cron` (`id`, `date`, `val`) VALUES
  17. (1, '2015-08-25 15:10:01', 1);
  18.  
  19. DROP TABLE IF EXISTS `image`;
  20. CREATE TABLE `image` (
  21. `id` int(11) NOT NULL AUTO_INCREMENT,
  22. `url` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  23. `path` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  24. PRIMARY KEY (`id`)
  25. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  26.  
  27.  
  28. DROP TABLE IF EXISTS `page`;
  29. CREATE TABLE `page` (
  30. `id` int(11) NOT NULL AUTO_INCREMENT,
  31. `title` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  32. `text` text COLLATE utf8_unicode_ci NOT NULL,
  33. PRIMARY KEY (`id`)
  34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  35.  
  36.  
  37. DROP TABLE IF EXISTS `project`;
  38. CREATE TABLE `project` (
  39. `id` int(11) NOT NULL AUTO_INCREMENT,
  40. `title` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  41. `desc` text COLLATE utf8_unicode_ci NOT NULL,
  42. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  43. `youtube_link` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  44. `status` int(11) NOT NULL DEFAULT '0',
  45. `status_date` timestamp NULL DEFAULT NULL,
  46. `province_id` int(11) NOT NULL,
  47. `user_id` int(10) NOT NULL,
  48. `votes` int(10) NOT NULL COMMENT 'Statické, aktualizované CRONem pro složitější filtrování',
  49. `position` int(10) NOT NULL COMMENT 'Statické, aktualizované CRONem pro složitější filtrování',
  50. PRIMARY KEY (`id`),
  51. KEY `user_id` (`user_id`),
  52. KEY `province_id` (`province_id`),
  53. CONSTRAINT `project_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION,
  54. CONSTRAINT `project_ibfk_4` FOREIGN KEY (`province_id`) REFERENCES `province` (`id`) ON DELETE NO ACTION
  55. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  56.  
  57. INSERT INTO `project` (`id`, `title`, `desc`, `date`, `youtube_link`, `status`, `status_date`, `province_id`, `user_id`, `votes`, `position`) VALUES
  58. (1, 'Koloběžka', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam a nunc vitae sem tincidunt maximus. Nam id ante turpis. In id condimentum leo. Duis pulvinar justo ante, vitae scelerisque eros ullamcorper nec. Pellentesque sit amet aliquam nulla. Praesent libero ex, egestas non pellentesque scelerisque, convallis eget risus. Praesent faucibus lectus non ligula dictum fermentum. Etiam at metus ut lorem accumsan laoreet. Cras non ex vel urna semper semper. Etiam non aliquam felis. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque tempor lectus eros, eget facilisis tellus dignissim sed.', '2015-08-25 15:42:01', NULL, 1, '2015-08-25 15:13:01', 1, 2, 3, 2),
  59. (2, 'Hodinky s vodotryskem', 'Pellentesque accumsan luctus scelerisque. Maecenas semper, lectus id accumsan ullamcorper, magna leo gravida nibh, eget gravida ipsum arcu faucibus odio. Nullam a rutrum dolor. Integer nec velit in tortor pretium dictum in egestas enim. Quisque blandit ac diam a semper. Nullam quis tellus sit amet quam efficitur convallis viverra vel ligula. Nullam laoreet metus ipsum, eget ultrices nisl fringilla sit amet. Aenean tristique lectus non ultricies porttitor. Sed eget lorem vel nulla convallis pretium. Ut non blandit dolor. Fusce semper augue sed nisi imperdiet vestibulum.', '2015-08-25 15:42:01', NULL, 1, '2015-08-25 15:16:00', 21, 5, 7, 1);
  60.  
  61. DROP TABLE IF EXISTS `project_round`;
  62. CREATE TABLE `project_round` (
  63. `id` int(11) NOT NULL AUTO_INCREMENT,
  64. `round_id` int(11) DEFAULT NULL,
  65. `project_id` int(11) DEFAULT NULL,
  66. PRIMARY KEY (`id`),
  67. UNIQUE KEY `round_id_project_id` (`round_id`,`project_id`),
  68. KEY `project_id` (`project_id`),
  69. KEY `round_id` (`round_id`),
  70. CONSTRAINT `project_round_ibfk_1` FOREIGN KEY (`round_id`) REFERENCES `project_round` (`id`),
  71. CONSTRAINT `project_round_ibfk_3` FOREIGN KEY (`project_id`) REFERENCES `project_round` (`id`)
  72. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  73.  
  74. INSERT INTO `project_round` (`id`, `round_id`, `project_id`) VALUES
  75. (1, 1, 1),
  76. (2, 1, 2);
  77.  
  78. DROP TABLE IF EXISTS `project_vote`;
  79. CREATE TABLE `project_vote` (
  80. `id` int(11) NOT NULL AUTO_INCREMENT,
  81. `user_id` int(10) NOT NULL,
  82. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  83. `ip` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  84. `project_id` int(11) NOT NULL,
  85. `round_id` int(11) NOT NULL,
  86. PRIMARY KEY (`id`),
  87. KEY `user_id` (`user_id`),
  88. KEY `round_id` (`round_id`),
  89. KEY `project_id` (`project_id`),
  90. CONSTRAINT `project_vote_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  91. CONSTRAINT `project_vote_ibfk_3` FOREIGN KEY (`round_id`) REFERENCES `round` (`id`),
  92. CONSTRAINT `project_vote_ibfk_4` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`)
  93. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  94.  
  95. INSERT INTO `project_vote` (`id`, `user_id`, `date`, `ip`, `project_id`, `round_id`) VALUES
  96. (1, 1, '2015-08-25 15:13:22', '127.0.0.1', 1, 1),
  97. (2, 4, '2015-08-25 15:18:11', '127.0.0.1', 1, 1),
  98. (3, 6, '2015-08-25 15:18:42', '127.0.0.1', 2, 1),
  99. (4, 1, '2015-08-25 15:20:03', '127.0.0.1', 1, 1),
  100. (5, 1, '2015-08-25 15:20:41', '127.0.0.1', 2, 1),
  101. (6, 1, '2015-08-25 15:20:42', '127.0.0.1', 2, 1),
  102. (7, 1, '2015-08-25 15:20:43', '127.0.0.1', 2, 1),
  103. (8, 1, '2015-08-25 15:20:44', '127.0.0.1', 2, 1),
  104. (9, 1, '2015-08-25 15:20:45', '127.0.0.1', 2, 1),
  105. (10, 1, '2015-08-25 15:20:45', '127.0.0.1', 2, 1);
  106.  
  107. DROP TABLE IF EXISTS `province`;
  108. CREATE TABLE `province` (
  109. `id` int(11) NOT NULL AUTO_INCREMENT,
  110. `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  111. `state_id` int(11) NOT NULL,
  112. PRIMARY KEY (`id`),
  113. KEY `state_id` (`state_id`),
  114. CONSTRAINT `province_ibfk_2` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`) ON DELETE NO ACTION
  115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  116.  
  117. INSERT INTO `province` (`id`, `title`, `state_id`) VALUES
  118. (1, 'Amazonas', 1),
  119. (2, 'Ancash', 1),
  120. (3, 'Apurímac', 1),
  121. (4, 'Arequipa', 1),
  122. (5, 'Ayacucho', 1),
  123. (6, 'Cajamarca', 1),
  124. (7, 'Callao', 1),
  125. (8, 'Cusco', 1),
  126. (9, 'Huancavelica', 1),
  127. (10, 'Huánuco', 1),
  128. (11, 'Ica', 1),
  129. (12, 'Junín', 1),
  130. (13, 'La Libertad', 1),
  131. (14, 'Lambayeque', 1),
  132. (15, 'Lima Metropolitana', 1),
  133. (16, 'Lima', 1),
  134. (17, 'Loreto', 1),
  135. (18, 'Madre de Dios', 1),
  136. (19, 'Moquegua', 1),
  137. (20, 'Pasco', 1),
  138. (21, 'Piura', 1),
  139. (22, 'Puno', 1),
  140. (23, 'San Martín', 1),
  141. (24, 'Tacna', 1),
  142. (25, 'Tumbes', 1),
  143. (26, 'Ucayali', 1);
  144.  
  145. DROP TABLE IF EXISTS `round`;
  146. CREATE TABLE `round` (
  147. `id` int(11) NOT NULL AUTO_INCREMENT,
  148. `start_date` timestamp NULL DEFAULT NULL,
  149. `end_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  150. `status` int(11) NOT NULL DEFAULT '0',
  151. PRIMARY KEY (`id`)
  152. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  153.  
  154. INSERT INTO `round` (`id`, `start_date`, `end_date`, `status`) VALUES
  155. (1, NULL, '2015-08-29 15:00:00', 1),
  156. (2, NULL, '2015-09-04 15:00:00', 2);
  157.  
  158. DROP TABLE IF EXISTS `setting`;
  159. CREATE TABLE `setting` (
  160. `id` int(11) NOT NULL AUTO_INCREMENT,
  161. `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  162. `value` text COLLATE utf8_unicode_ci NOT NULL,
  163. `attribute1` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  164. `attribute2` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  165. `attribute3` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  166. `attribute4` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  167. `attribute5` varchar(26) COLLATE utf8_unicode_ci NOT NULL,
  168. PRIMARY KEY (`id`)
  169. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  170.  
  171. INSERT INTO `setting` (`id`, `title`, `value`, `attribute1`, `attribute2`, `attribute3`, `attribute4`, `attribute5`) VALUES
  172. (1, 'actuality', 'Aplikace je ve velice ranném stádiu vývoje, budu rád, když nahlasíte každou nalezenou chybu či oznámite podivné chování a podáte návrhy k vylepšení na ondra.rehak@gmail.com', '', '', '', '', '');
  173.  
  174. DROP TABLE IF EXISTS `state`;
  175. CREATE TABLE `state` (
  176. `id` int(11) NOT NULL AUTO_INCREMENT,
  177. `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  178. PRIMARY KEY (`id`)
  179. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  180.  
  181. INSERT INTO `state` (`id`, `title`) VALUES
  182. (1, 'Peru');
  183.  
  184. DROP TABLE IF EXISTS `user`;
  185. CREATE TABLE `user` (
  186. `id` int(10) NOT NULL AUTO_INCREMENT,
  187. `register_date` datetime NOT NULL,
  188. `username` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  189. `first_name` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  190. `last_name` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  191. `password` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  192. `email` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  193. `state_id` int(11) NOT NULL,
  194. `province_id` int(11) NOT NULL,
  195. `city` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  196. `phone_number` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  197. `dni` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  198. `bio` text COLLATE utf8_unicode_ci,
  199. `birth_date` datetime DEFAULT NULL,
  200. `gender` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  201. `account_type` tinyint(1) NOT NULL,
  202. `activated` tinyint(1) NOT NULL DEFAULT '0',
  203. `wall_ban` tinyint(1) NOT NULL DEFAULT '0',
  204. `activation_hash` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  205. `profile_pic_id` int(11) DEFAULT NULL,
  206. PRIMARY KEY (`id`),
  207. KEY `state_id` (`state_id`),
  208. KEY `province_id` (`province_id`),
  209. KEY `profile_pic_id` (`profile_pic_id`),
  210. CONSTRAINT `user_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`),
  211. CONSTRAINT `user_ibfk_2` FOREIGN KEY (`province_id`) REFERENCES `province` (`id`),
  212. CONSTRAINT `user_ibfk_6` FOREIGN KEY (`profile_pic_id`) REFERENCES `image` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
  213. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  214.  
  215. INSERT INTO `user` (`id`, `register_date`, `username`, `first_name`, `last_name`, `password`, `email`, `state_id`, `province_id`, `city`, `phone_number`, `dni`, `bio`, `birth_date`, `gender`, `account_type`, `activated`, `wall_ban`, `activation_hash`, `profile_pic_id`) VALUES
  216. (1, '2015-08-10 14:32:17', 'Connor', 'Ondřej', 'Rehák', '$2y$10$qwAfS6f4s84mOV4Q9tWYJet84mVi82neDeGFogcYLlCn0.8ERBCLe', 'ondra.rehak@gmail.com', 1, 1, 'Krupka', '', '', 'Jsem obyčejný malý muž, z občejné... ne kecám - jsem nejvíc boží na svetě!', '1995-11-16 00:00:00', 'm', 0, 1, 0, 'f3c047412da324a36d06ed6875fb11cc', NULL),
  217. (2, '2015-08-10 14:38:28', 'Balik22', 'Michaela', 'Balíková', '$2y$10$WRYQc.7Bxh5d5V80chcFz.xHHB8QjD/nrp4U5JSVhTdJNQJ9B11d2', 'Shrod1939@armyspy.com', 1, 1, 'Ustí nad Labem', '77431529', '12345678', '', '1995-10-30 00:00:00', 'f', 1, 1, 0, '8f2c496fffee6ba45fceb5dc8f35c076', NULL),
  218. (3, '2015-08-11 21:14:46', 'admin', 'Vladimír', 'Vladimírovič', '$2y$10$33wIwv2F/aP8qUKjeOJHgOwF4LB4fRrojirFaQuLM0K88cRvWSiI2', 'admin@saltskin.eu', 1, 1, 'Krupka', '', '', '', '1995-11-16 00:00:00', 'm', 2, 1, 0, 'ab6576106de955b8345d524dfd15765b', NULL),
  219. (4, '2015-08-12 19:14:39', 'deamont66', 'Jiří', 'Šimeček', '$2y$10$hnBKFvzdaNMAcT33yptaCObBeI8d286mU4sYRhdsIdF2os8WatRJC', 'jirkasimecek@seznam.cz', 1, 1, 'Ústí nad Labem', '', '', '...', '2015-08-12 00:00:00', 'm', 0, 1, 0, 'a9715cabf98f2413d863332eef51dde4', NULL),
  220. (5, '2015-08-12 21:23:13', 'cameroncz', 'Tomáš', 'Trbola', '$2y$10$/AN0Xf8hKdQUDbG1PWUiPeo6OEZX/2bgiL0MuU8x/rqHe8tF/.heq', 'm.trbolatomas@gmail.com', 1, 21, 'Usti Nad Labem', '77319298', '56987412', '', '2015-08-12 00:00:00', 'm', 1, 1, 1, '4ba5331b115fb47790f679fc0187e9f8', NULL),
  221. (6, '2015-08-23 13:07:17', 'lukky11', 'Lukáš', 'Nogol', '$2y$10$nQt80INSifzgyev61yuREOt16zy06IveDg96xdfX1Ag2pDWmCDXTa', 'asdf@fasdf.cz', 1, 1, 'asdfasdf', '', '', '', '2015-08-02 00:00:00', 'm', 0, 1, 0, '8db75f7b05cff8ae4b25e42bd6febaac', NULL);
  222.  
  223. DROP TABLE IF EXISTS `wall_post`;
  224. CREATE TABLE `wall_post` (
  225. `id` int(11) NOT NULL AUTO_INCREMENT,
  226. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  227. `text` text COLLATE utf8_unicode_ci NOT NULL,
  228. `user_id` int(10) NOT NULL,
  229. PRIMARY KEY (`id`),
  230. KEY `user_id` (`user_id`),
  231. CONSTRAINT `wall_post_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
  232. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  233.  
  234.  
  235. -- 2015-08-25 16:06:34
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!