· 11 years ago · Aug 25, 2015, 04:07 PM
1-- Adminer 4.2.0 MySQL dump
2
3SET NAMES utf8mb4;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `cron`;
9CREATE 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
16INSERT INTO `cron` (`id`, `date`, `val`) VALUES
17(1, '2015-08-25 15:10:01', 1);
18
19DROP TABLE IF EXISTS `image`;
20CREATE 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
28DROP TABLE IF EXISTS `page`;
29CREATE 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
37DROP TABLE IF EXISTS `project`;
38CREATE 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
57INSERT 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
61DROP TABLE IF EXISTS `project_round`;
62CREATE 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
74INSERT INTO `project_round` (`id`, `round_id`, `project_id`) VALUES
75(1, 1, 1),
76(2, 1, 2);
77
78DROP TABLE IF EXISTS `project_vote`;
79CREATE 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
95INSERT 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
107DROP TABLE IF EXISTS `province`;
108CREATE 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
117INSERT 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
145DROP TABLE IF EXISTS `round`;
146CREATE 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
154INSERT 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
158DROP TABLE IF EXISTS `setting`;
159CREATE 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
171INSERT 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
174DROP TABLE IF EXISTS `state`;
175CREATE 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
181INSERT INTO `state` (`id`, `title`) VALUES
182(1, 'Peru');
183
184DROP TABLE IF EXISTS `user`;
185CREATE 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
215INSERT 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
223DROP TABLE IF EXISTS `wall_post`;
224CREATE 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