· 10 years ago · Nov 22, 2015, 05:39 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.4
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas wygenerowania: 22 Lis 2015, 17:35
7-- Wersja serwera: 5.6.12-log
8-- Wersja PHP: 5.4.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Baza danych: `test`
21--
22CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `test`;
24
25-- --------------------------------------------------------
26
27--
28-- Struktura tabeli dla tabeli `comment`
29--
30
31CREATE TABLE IF NOT EXISTS `comment` (
32 `id` int(11) NOT NULL AUTO_INCREMENT,
33 `postID` int(11) NOT NULL,
34 `authorID` int(11) NOT NULL,
35 `authorName` varchar(60) NOT NULL,
36 `createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
37 `plusCount` int(11) NOT NULL,
38 `minusCount` int(11) NOT NULL,
39 `message` varchar(2000) NOT NULL,
40 `visible` tinyint(4) NOT NULL,
41 PRIMARY KEY (`id`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
43
44--
45-- Zrzut danych tabeli `comment`
46--
47
48INSERT INTO `comment` (`id`, `postID`, `authorID`, `authorName`, `createdDate`, `plusCount`, `minusCount`, `message`, `visible`) VALUES
49(1, 9, 30, 'Jakub', '2015-02-24 21:29:08', 0, 0, 'Moj komentarz', 1),
50(2, 9, 30, 'Jakub', '2015-02-25 21:23:35', 0, 0, '<p>asdasdasd</p>', 1),
51(3, 9, 30, 'Jakub', '2015-02-25 21:24:39', 0, 0, '<p>aaaaaaaaaaaaaaa</p>', 1),
52(4, 9, 30, 'Jakub', '2015-02-25 21:25:08', 0, 0, '<p>sss</p>', 1),
53(5, 9, 30, 'Jakub', '2015-02-25 21:26:00', 0, 0, '<p>ddd</p>', 1),
54(6, 9, 30, 'Jakub', '2015-02-25 21:26:19', 0, 0, '<p>aaaaaaaaa</p>', 1),
55(7, 9, 30, 'Jakub', '2015-02-25 21:27:32', 0, 0, '<p>aaaaaaaaaaaaaaa</p>', 1),
56(8, 9, 30, 'Jakub', '2015-02-25 21:34:35', 0, 0, '<p>ssssssssss</p>', 1),
57(9, 9, 30, 'Jakub', '2015-02-25 21:39:47', 0, 0, '<p>Hehehe niezle :)</p>', 1),
58(10, 9, 30, 'Jakub', '2015-02-25 21:50:42', 0, 0, '<p>aaaaaaa</p>', 1),
59(11, 9, 30, 'Jakub', '2015-02-28 23:08:02', 0, 0, '<p>okokokoko</p>', 1),
60(12, 10, 30, 'Jakub', '2015-03-01 18:08:46', 1238, 34, '<p>Już jest komentarz XD</p>', 1),
61(13, 10, 30, 'Jakub', '2015-03-01 17:57:58', 5, 10, '<p>aaaaa</p>', 1),
62(14, 10, 30, 'Jakub', '2015-03-01 19:48:38', 0, 0, '<p>Hahahaha :)</p>', 1),
63(15, 11, 30, 'Jakub', '2015-03-08 14:55:27', 0, 0, '<p>PomyÅ?laÅ?em sobie że skomentuje :)</p>\r\n<p> </p>\r\n<p>Pozdrawiam</p>', 1),
64(16, 11, 30, 'Jakub', '2015-03-08 15:00:40', 0, 0, '<p><strong>Commenting this shit :</strong>)</p>', 1),
65(17, 12, 57, 'asadasdasd', '2015-11-22 14:03:02', 0, 0, '<p>Hehehe!</p>', 1);
66
67-- --------------------------------------------------------
68
69--
70-- Struktura tabeli dla tabeli `movie`
71--
72
73CREATE TABLE IF NOT EXISTS `movie` (
74 `id` int(11) NOT NULL AUTO_INCREMENT,
75 `premiere` datetime NOT NULL,
76 `title` varchar(200) NOT NULL,
77 `director_id` int(11) DEFAULT NULL,
78 `scenarist_id` int(11) DEFAULT NULL,
79 PRIMARY KEY (`id`),
80 UNIQUE KEY `UK_o6ifx5x4vtwfrpu1a42l8u81w` (`title`),
81 KEY `FK_knk31d66c180td9ydo8kqd84l` (`director_id`),
82 KEY `FK_f80ksoosg8y5mxvqws0hgvym8` (`scenarist_id`)
83) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
84
85--
86-- Zrzut danych tabeli `movie`
87--
88
89INSERT INTO `movie` (`id`, `premiere`, `title`, `director_id`, `scenarist_id`) VALUES
90(1, '1970-01-01 01:00:00', 'Kubus puchatek', 1, 2);
91
92-- --------------------------------------------------------
93
94--
95-- Struktura tabeli dla tabeli `moviecast`
96--
97
98CREATE TABLE IF NOT EXISTS `moviecast` (
99 `id` int(11) NOT NULL AUTO_INCREMENT,
100 `name` varchar(255) NOT NULL,
101 `surname` varchar(255) NOT NULL,
102 `movieEntity_id` int(11) DEFAULT NULL,
103 `moviePerson_id` int(11) DEFAULT NULL,
104 `function` varchar(255) NOT NULL,
105 PRIMARY KEY (`id`),
106 KEY `FK_4vo6fto1tvy55sk6o3920axhk` (`movieEntity_id`),
107 KEY `FK_tku6ufisob8qfb85ebb6801hs` (`moviePerson_id`)
108) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
109
110--
111-- Zrzut danych tabeli `moviecast`
112--
113
114INSERT INTO `moviecast` (`id`, `name`, `surname`, `movieEntity_id`, `moviePerson_id`, `function`) VALUES
115(1, 'Ala', 'Drozdzala', 1, 3, '');
116
117-- --------------------------------------------------------
118
119--
120-- Struktura tabeli dla tabeli `movieperson`
121--
122
123CREATE TABLE IF NOT EXISTS `movieperson` (
124 `id` int(11) NOT NULL AUTO_INCREMENT,
125 `born` datetime NOT NULL,
126 `died` datetime NOT NULL,
127 `gender` varchar(255) NOT NULL,
128 `name` varchar(255) NOT NULL,
129 `surname` varchar(255) NOT NULL,
130 `function` varchar(255) NOT NULL,
131 PRIMARY KEY (`id`)
132) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
133
134--
135-- Zrzut danych tabeli `movieperson`
136--
137
138INSERT INTO `movieperson` (`id`, `born`, `died`, `gender`, `name`, `surname`, `function`) VALUES
139(1, '2015-11-08 12:08:00', '2015-11-08 12:08:00', 'male', 'Jakub', 'Homlala', ''),
140(2, '2015-11-08 12:08:00', '2015-11-08 12:08:00', 'male', 'Jakub2', 'Homlala2', ''),
141(3, '2015-11-08 12:08:00', '2015-11-08 12:08:00', 'male', 'Jakub2', 'Homlala2', '');
142
143-- --------------------------------------------------------
144
145--
146-- Struktura tabeli dla tabeli `movierate`
147--
148
149CREATE TABLE IF NOT EXISTS `movierate` (
150 `id` int(11) NOT NULL AUTO_INCREMENT,
151 `created` datetime NOT NULL,
152 `description` varchar(255) NOT NULL,
153 `movieEntity_id` int(11) DEFAULT NULL,
154 `person_id` int(11) DEFAULT NULL,
155 PRIMARY KEY (`id`),
156 KEY `FK_gl7245p5eyf3vf8opklf5iu60` (`movieEntity_id`),
157 KEY `FK_drqkqgpneprb9f53a3j5wcj8h` (`person_id`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
159
160-- --------------------------------------------------------
161
162--
163-- Struktura tabeli dla tabeli `news`
164--
165
166CREATE TABLE IF NOT EXISTS `news` (
167 `id` int(11) NOT NULL AUTO_INCREMENT,
168 `created` datetime NOT NULL,
169 `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_polish_ci NOT NULL,
170 `title` varchar(255) NOT NULL,
171 `person_id` int(11) DEFAULT NULL,
172 `movieEntity_id` int(11) DEFAULT NULL,
173 PRIMARY KEY (`id`),
174 KEY `FK_o8oj2motf9ubou5st8cp56yii` (`person_id`),
175 KEY `FK_9s7hpxjbca353jpllhklw8edd` (`movieEntity_id`)
176) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=125 ;
177
178--
179-- Zrzut danych tabeli `news`
180--
181
182INSERT INTO `news` (`id`, `created`, `message`, `title`, `person_id`, `movieEntity_id`) VALUES
183(1, '2015-11-22 00:00:00', 'Dzisiaj wystartowaliśmy! Mamy już kilka filmów w bazie oraz kilka użytkowników. Czekamy na nowych!', 'Start', 30, NULL),
184(124, '2015-11-22 00:00:00', 'Jest już nas coraz więcej! Zapraszajcie znajomych!', 'Informacja', 55, NULL);
185
186-- --------------------------------------------------------
187
188--
189-- Struktura tabeli dla tabeli `person`
190--
191
192CREATE TABLE IF NOT EXISTS `person` (
193 `id` int(11) NOT NULL AUTO_INCREMENT,
194 `login` varchar(60) NOT NULL,
195 `password` varchar(60) NOT NULL,
196 `registerDate` date NOT NULL,
197 `lastOnlineDate` date NOT NULL,
198 `email` varchar(60) NOT NULL,
199 `visibleName` varchar(20) NOT NULL,
200 `enabled` tinyint(4) NOT NULL DEFAULT '0',
201 `generated` varchar(60) NOT NULL,
202 `avatarSet` tinyint(4) NOT NULL DEFAULT '0',
203 `lastPostTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
204 PRIMARY KEY (`id`)
205) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;
206
207--
208-- Zrzut danych tabeli `person`
209--
210
211INSERT INTO `person` (`id`, `login`, `password`, `registerDate`, `lastOnlineDate`, `email`, `visibleName`, `enabled`, `generated`, `avatarSet`, `lastPostTime`) VALUES
212(30, 'jhomlala', '$2a$10$K1sgtfwFrtgqm4GOpFq6H.t3kfuKakR8coiFb/sXSvwETb3qrNjoW', '2015-02-22', '2015-02-22', 'jhomlala341@gmail.com', 'Jakub', 1, '0', 1, '2015-10-25 22:38:43'),
213(31, 'jhomlala2', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala2@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
214(32, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
215(33, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
216(34, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
217(35, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
218(36, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
219(37, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
220(38, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
221(39, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
222(40, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
223(41, 'jhomlala3', '$2a$10$URDXksWiD.2wAlynZdaqT.qUAG2fh2DycHJLOZonrloc93ElVmxuS', '2015-02-22', '2015-02-22', 'jhomlala3@gmail.com', 'Jakub2', 0, '885200311958076131229546398946371947982', 0, '2015-02-22 13:37:42'),
224(42, 'alala', '$2a$10$kj2.vAOryRdU3vropNW5Y.nWzccOfdmq85vFwPZFUwmXNddG7N/Pa', '2015-07-08', '2015-07-08', 'xkubaxx@gmail.com', 'JakubHomlala', 0, '359298044490262392557153357231565221194', 0, '2015-07-08 13:54:42'),
225(43, 'jakub', '$2a$10$Dtie.lhlZi8bV4MaMi0F5O3iR9LEc0a3qmo1ygoM9gvR4dwn9lXD6', '2015-10-25', '2015-10-25', 'jhomlala@gmail2.com', 'JakubHomlala', 0, '1184073007701815949650019100777458865859', 0, '2015-10-25 22:05:33'),
226(51, 'jakubhom', '$2a$10$olxc5km5PWGfne/bkmzXQOTMTbWynSei/hrmZ4S9FxtjmqOShpcsS', '2015-10-28', '2015-10-28', 'jhomlala@gmail.coms', 'Jakubha', 1, '0', 0, '2015-11-22 13:28:26'),
227(52, 'jakubjakub', '$2a$10$ZmU3z6Kn915yzfIEGQ74oO.UFzT1obLQhoFgC2Ey6/pou3maqCoBO', '2015-11-22', '2015-11-22', 'khomlala@o2.pl', 'JakubHaa', 0, '535896910607599473467861744858565523604', 0, '2015-11-22 12:57:19'),
228(53, 'jakub123', '$2a$10$4hnR3yIC.gVWt/a6y2nrku0JrEOh4oMxnt8hq6S9T9B6OBlnJ0xD6', '2015-11-22', '2015-11-22', 'jhomlala@gmail.coms', 'JakubasdHaa', 0, '1029057742646708878932989631460053769697', 0, '2015-11-22 13:32:39'),
229(54, 'asdasd', '$2a$10$.D6X2du5mc6oj2PwqHZ5heXNcol2NXk0HZeuQNQbF4Z/AALNw6gUu', '2015-11-22', '2015-11-22', 'asdasdasd@o2.pl', 'asdasd', 0, '49763418721837418901334489008597840276', 0, '2015-11-22 13:03:15'),
230(55, 'asdasdasd', '$2a$10$3tFGvoZ53jCN8s.H5xUun.s0qOFEeMmz8DVBSLlkiokKvFIgxc1r6', '2015-11-22', '2015-11-22', 'asdasdasd@o2.plaa', 'asdasdaasd', 0, '768524446073760861854531859107887707909', 0, '2015-11-22 13:06:37'),
231(56, 'asdasdsdsd', '$2a$10$F9KCcyZ1h9pTm1qbclhWbujBn3b7CN0keA.4dxZZthc56EI/y788i', '2015-11-22', '2015-11-22', 'asdasdasd@o2.plsd', 'asdasdasdasd', 0, '399523306907483414495802178690912195813', 0, '2015-11-22 13:08:54'),
232(57, 'jakubhom123', '$2a$10$vVtGfwMlZXJCRAWmvpfRBuEM6GUISHiErXcl/afSZyaOxNXBMHmdy', '2015-11-22', '2015-11-22', 'jhomlala@gmail.com', 'asadasdasd', 1, '0', 0, '2015-11-22 13:16:53');
233
234-- --------------------------------------------------------
235
236--
237-- Struktura tabeli dla tabeli `person_roles`
238--
239
240CREATE TABLE IF NOT EXISTS `person_roles` (
241 `personRoleID` int(12) NOT NULL AUTO_INCREMENT,
242 `personID` int(12) NOT NULL,
243 `role` varchar(60) NOT NULL,
244 PRIMARY KEY (`personRoleID`)
245) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;
246
247--
248-- Zrzut danych tabeli `person_roles`
249--
250
251INSERT INTO `person_roles` (`personRoleID`, `personID`, `role`) VALUES
252(27, 30, 'ROLE_USER'),
253(28, 31, 'ROLE_USER'),
254(29, 42, 'ROLE_USER'),
255(30, 43, 'ROLE_USER'),
256(31, 44, 'ROLE_USER'),
257(32, 45, 'ROLE_USER'),
258(33, 46, 'ROLE_USER'),
259(34, 47, 'ROLE_USER'),
260(35, 48, 'ROLE_USER'),
261(36, 49, 'ROLE_USER'),
262(37, 50, 'ROLE_USER'),
263(38, 51, 'ROLE_USER'),
264(39, 52, 'ROLE_USER'),
265(40, 53, 'ROLE_USER'),
266(41, 54, 'ROLE_USER'),
267(42, 55, 'ROLE_USER'),
268(43, 56, 'ROLE_USER'),
269(44, 57, 'ROLE_USER');
270
271-- --------------------------------------------------------
272
273--
274-- Struktura tabeli dla tabeli `post`
275--
276
277CREATE TABLE IF NOT EXISTS `post` (
278 `id` int(11) NOT NULL AUTO_INCREMENT,
279 `authorID` int(11) NOT NULL,
280 `authorName` varchar(60) NOT NULL,
281 `createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
282 `plusCount` int(11) NOT NULL,
283 `minusCount` int(11) NOT NULL,
284 `message` varchar(2000) NOT NULL,
285 `visible` tinyint(4) NOT NULL,
286 PRIMARY KEY (`id`)
287) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
288
289--
290-- Zrzut danych tabeli `post`
291--
292
293INSERT INTO `post` (`id`, `authorID`, `authorName`, `createdDate`, `plusCount`, `minusCount`, `message`, `visible`) VALUES
294(1, 30, 'Jakub', '2015-02-22 15:20:48', 1, 0, '<p>Easy! You should check out MoxieManager!asdas</p>', 1),
295(2, 30, 'Jakub', '2015-02-22 15:56:18', 0, 0, '<p>Easy! You should check out MoxieManager!</p>', 1),
296(3, 30, 'Jakub', '2015-02-22 16:37:47', 0, 0, '<p>sdfsdfsdf</p>', 1),
297(4, 30, 'Jakub', '2015-02-22 16:37:54', 0, 0, '<p>sdfsdf</p>', 1),
298(5, 30, 'Jakub', '2015-02-22 16:40:29', 0, 0, '<p>sdfsdf</p>', 1),
299(6, 30, 'Jakub', '2015-02-22 16:40:50', 0, 0, '<p>dsfdsfsdfsdf</p>', 1),
300(7, 30, 'Jakub', '2015-02-22 16:45:06', 1, 0, '<p>asdasd</p>', 1),
301(8, 30, 'Jakub', '2015-02-24 20:24:52', 0, 0, '<p>Witam pierwszy post #lol #heheszki</p>', 1),
302(9, 30, 'Jakub', '2015-02-24 20:31:04', 0, 0, '<p> sdfsdf</p>', 1),
303(10, 30, 'Jakub', '2015-03-01 16:56:23', 6, 5, '<p>MOJ NOWY POST HEHESZKI XDDDD</p>', 1),
304(11, 30, 'Jakub', '2015-03-01 20:10:43', 140, 239, '<p style="text-align: right;">Miusov, as a man man of breeding and deilcacy, could not but feel some inwrd qualms, when he reached the Father Superior''s with Ivan: he felt ashamed of havin lost his temper. He felt that he ought to have disdaimed that despicable wretch, Fyodor Pavlovitch, too much to have been upset by him in Father Zossima''s cell, and so to have forgotten himself. "Teh monks were not to blame, in any case," he reflceted, on the steps. "And if they''re decent people here (and the Father Superior, I understand, is a nobleman) why not be friendly and courteous withthem? I won''t argue, I''ll fall in with everything, I''ll win them by politness, and show them that I''ve nothing to do with that Aesop, thta buffoon, that Pierrot, and have merely been takken in over this affair, just as they have."</p>\r\n<p style="text-align: right;"> </p>\r\n<p><strong>He determined to drop his litigation with the monastry, and relinguish his claims to the wood-cuting and fishery rihgts at once. He was the more ready to do this becuase the rights had becom much less valuable, and he had indeed the vaguest idea where the wood and river in quedtion were.</strong></p>', 1),
305(12, 51, 'Jakubha', '2015-10-28 22:32:19', 0, 0, '<p>Test</p>', 1);
306
307-- --------------------------------------------------------
308
309--
310-- Struktura tabeli dla tabeli `post_vote`
311--
312
313CREATE TABLE IF NOT EXISTS `post_vote` (
314 `postVoteId` int(11) NOT NULL AUTO_INCREMENT,
315 `postId` int(11) NOT NULL,
316 `personId` int(11) NOT NULL,
317 `voteValue` int(11) NOT NULL,
318 PRIMARY KEY (`postVoteId`)
319) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
320
321--
322-- Zrzut danych tabeli `post_vote`
323--
324
325INSERT INTO `post_vote` (`postVoteId`, `postId`, `personId`, `voteValue`) VALUES
326(16, 10, 30, 1),
327(17, 11, 30, 0),
328(18, 7, 30, 1);
329
330--
331-- Ograniczenia dla zrzutĂłw tabel
332--
333
334--
335-- Ograniczenia dla tabeli `movie`
336--
337ALTER TABLE `movie`
338 ADD CONSTRAINT `FK_f80ksoosg8y5mxvqws0hgvym8` FOREIGN KEY (`scenarist_id`) REFERENCES `movieperson` (`id`),
339 ADD CONSTRAINT `FK_knk31d66c180td9ydo8kqd84l` FOREIGN KEY (`director_id`) REFERENCES `movieperson` (`id`);
340
341--
342-- Ograniczenia dla tabeli `moviecast`
343--
344ALTER TABLE `moviecast`
345 ADD CONSTRAINT `FK_4vo6fto1tvy55sk6o3920axhk` FOREIGN KEY (`movieEntity_id`) REFERENCES `movie` (`id`),
346 ADD CONSTRAINT `FK_tku6ufisob8qfb85ebb6801hs` FOREIGN KEY (`moviePerson_id`) REFERENCES `movieperson` (`id`);
347
348--
349-- Ograniczenia dla tabeli `movierate`
350--
351ALTER TABLE `movierate`
352 ADD CONSTRAINT `FK_drqkqgpneprb9f53a3j5wcj8h` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
353 ADD CONSTRAINT `FK_gl7245p5eyf3vf8opklf5iu60` FOREIGN KEY (`movieEntity_id`) REFERENCES `movie` (`id`);
354
355--
356-- Ograniczenia dla tabeli `news`
357--
358ALTER TABLE `news`
359 ADD CONSTRAINT `FK_9s7hpxjbca353jpllhklw8edd` FOREIGN KEY (`movieEntity_id`) REFERENCES `movie` (`id`),
360 ADD CONSTRAINT `FK_o8oj2motf9ubou5st8cp56yii` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`);
361
362/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
363/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
364/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;