API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2015
156
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.59 KB | None | 0 0
raw download clone embed print report
  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.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET 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. --
  22. CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  23. USE `test`;
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Struktura tabeli dla tabeli `comment`
  29. --
  30.  
  31. CREATE 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.  
  48. INSERT 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>&nbsp;</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.  
  73. CREATE 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.  
  89. INSERT 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.  
  98. CREATE 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.  
  114. INSERT 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.  
  123. CREATE 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.  
  138. INSERT 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.  
  149. CREATE 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.  
  166. CREATE 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.  
  182. INSERT 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.  
  192. CREATE 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.  
  211. INSERT 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.  
  240. CREATE 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.  
  251. INSERT 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.  
  277. CREATE 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.  
  293. INSERT 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>&nbsp;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;">&nbsp;</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.  
  313. CREATE 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.  
  325. INSERT 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. --
  337. ALTER 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. --
  344. ALTER 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. --
  351. ALTER 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. --
  358. ALTER 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 */;
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!