· 7 years ago · Oct 10, 2018, 03:38 PM
1-- Adminer 4.6.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP DATABASE IF EXISTS `telecule`;
9CREATE DATABASE `telecule` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci */;
10USE `telecule`;
11
12SET NAMES utf8mb4;
13
14DROP TABLE IF EXISTS `article`;
15CREATE TABLE `article` (
16 `id` int(11) NOT NULL AUTO_INCREMENT,
17 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
18 `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
19 `date_created` datetime NOT NULL,
20 `author_id` int(11) NOT NULL,
21 PRIMARY KEY (`id`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
23
24TRUNCATE `article`;
25
26DROP TABLE IF EXISTS `genre`;
27CREATE TABLE `genre` (
28 `id` int(11) NOT NULL AUTO_INCREMENT,
29 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
32
33TRUNCATE `genre`;
34INSERT INTO `genre` (`id`, `name`) VALUES
35(1, 'Action'),
36(2, 'Adventure'),
37(3, 'Comedy'),
38(4, 'Crime'),
39(5, 'Drama'),
40(6, 'Historical'),
41(7, 'Horror'),
42(8, 'Musical'),
43(9, 'Sci-Fi'),
44(10, 'War'),
45(11, 'Western');
46
47DROP TABLE IF EXISTS `migration_versions`;
48CREATE TABLE `migration_versions` (
49 `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
50 PRIMARY KEY (`version`)
51) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
52
53TRUNCATE `migration_versions`;
54INSERT INTO `migration_versions` (`version`) VALUES
55('20180922082106'),
56('20180922115550'),
57('20180922121325'),
58('20180923210454'),
59('20180923210542'),
60('20180924092727'),
61('20180926153538'),
62('20180927071019'),
63('20180927072023'),
64('20180930130449'),
65('20180930130703'),
66('20180930150506'),
67('20181001143247'),
68('20181005063409'),
69('20181005073110'),
70('20181005222411'),
71('20181009061806'),
72('20181009090913'),
73('20181009124039'),
74('20181009124432'),
75('20181010074438'),
76('20181010075841'),
77('20181010081315'),
78('20181010092438');
79
80DROP TABLE IF EXISTS `movie`;
81CREATE TABLE `movie` (
82 `id` int(11) NOT NULL AUTO_INCREMENT,
83 `title` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
84 `short_description` longtext COLLATE utf8mb4_unicode_ci,
85 `description` longtext COLLATE utf8mb4_unicode_ci,
86 `premiere` datetime NOT NULL,
87 `rating` int(11) DEFAULT NULL,
88 `date_created` datetime NOT NULL,
89 `thumbnail` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
90 `slug` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
91 PRIMARY KEY (`id`)
92) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
93
94TRUNCATE `movie`;
95INSERT INTO `movie` (`id`, `title`, `short_description`, `description`, `premiere`, `rating`, `date_created`, `thumbnail`, `slug`) VALUES
96(1, 'Akta x', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. A adipisci at consequuntur, debitis delectus deserunt dignissimos doloremque ea fugit laborum modi nihil nostrum perspiciatis quisquam sapiente ut vel velit! Voluptatum?', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Aliquid doloremque id illum molestiae voluptatem. Accusantium, asperiores dolores eligendi esse ipsa labore molestias nisi porro repellat soluta? Aliquid eius expedita veritatis. Lorem ipsum dolor sit amet, consectetur adipisicing elit. A adipisci consectetur, cum cupiditate dignissimos dolorum est in ipsum molestiae obcaecati officiis praesentium quas quisquam suscipit velit? Cumque harum hic tempore.', '2000-01-01 09:46:59', NULL, '2018-10-05 09:46:59', '6fb4a204b0fcb84154b32b61c21db97e.jpg', 'akta-x'),
97(2, 'Venom', 'When Eddie Brock acquires the powers of a symbiote, he will have to release his alter-ego \"Venom\" to save his life.', 'When Eddie Brock acquires the powers of a symbiote, he will have to release his alter-ego \"Venom\" to save his life.', '2018-10-04 00:00:00', NULL, '2018-10-06 00:21:06', '45d549deb031b550ee02126a5d9d12a6.jpg', 'venom'),
98(4, 'Revenant', 'A frontiersman on a fur trading expedition in the 1820s fights for survival after being mauled by a bear and left for dead by members of his own hunting team.', 'While exploring uncharted wilderness in 1823, legendary frontiersman Hugh Glass sustains injuries from a brutal bear attack. When his hunting team leaves him for dead, Glass must utilize his survival skills to find a way back home while avoiding natives on their own hunt. Grief-stricken and fueled by vengeance, Glass treks through the wintry terrain to track down John Fitzgerald, the former confidant who betrayed and abandoned him.', '2015-12-16 00:00:00', NULL, '2018-10-09 08:45:58', '93bfdf2b0777e01a307735a0af66da47.jpeg', 'revenant');
99
100DROP TABLE IF EXISTS `movie_genre`;
101CREATE TABLE `movie_genre` (
102 `movie_id` int(11) NOT NULL,
103 `genre_id` int(11) NOT NULL,
104 PRIMARY KEY (`movie_id`,`genre_id`),
105 KEY `IDX_FD1229648F93B6FC` (`movie_id`),
106 KEY `IDX_FD1229644296D31F` (`genre_id`),
107 CONSTRAINT `FK_FD1229644296D31F` FOREIGN KEY (`genre_id`) REFERENCES `genre` (`id`),
108 CONSTRAINT `FK_FD1229648F93B6FC` FOREIGN KEY (`movie_id`) REFERENCES `movie` (`id`)
109) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
110
111TRUNCATE `movie_genre`;
112
113DROP TABLE IF EXISTS `role`;
114CREATE TABLE `role` (
115 `id` int(11) NOT NULL AUTO_INCREMENT,
116 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
117 `value` int(11) NOT NULL,
118 PRIMARY KEY (`id`)
119) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
120
121TRUNCATE `role`;
122INSERT INTO `role` (`id`, `name`, `value`) VALUES
123(1, 'guest', 0),
124(2, 'admin', 1);
125
126DROP TABLE IF EXISTS `tv_show`;
127CREATE TABLE `tv_show` (
128 `id` int(11) NOT NULL AUTO_INCREMENT,
129 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
130 `short_description` longtext COLLATE utf8mb4_unicode_ci,
131 `description` longtext COLLATE utf8mb4_unicode_ci,
132 `premiere` datetime NOT NULL,
133 `rating` int(11) DEFAULT NULL,
134 PRIMARY KEY (`id`)
135) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
136
137TRUNCATE `tv_show`;
138
139DROP TABLE IF EXISTS `user`;
140CREATE TABLE `user` (
141 `id` int(11) NOT NULL AUTO_INCREMENT,
142 `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
143 `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
144 `email_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
145 `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
146 `bio` longtext COLLATE utf8mb4_unicode_ci,
147 `birthday` datetime NOT NULL,
148 `date_created` datetime NOT NULL,
149 `role_id` int(11) NOT NULL,
150 `profile_picture` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
151 `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
152 PRIMARY KEY (`id`)
153) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
154
155TRUNCATE `user`;
156INSERT INTO `user` (`id`, `first_name`, `last_name`, `email_address`, `password`, `bio`, `birthday`, `date_created`, `role_id`, `profile_picture`, `username`) VALUES
157(1, 'VojtÄ›ch', 'Morávek', 'vojtech.moravek@email.cz', '$2y$10$0A8.6RCtTUmyVqjv0HbSXO0WTzwhaggxVgnvFQSeA6J734owJhoi.', 'Rád jÃm a rád spÃm', '2000-06-16 16:38:26', '2018-09-23 16:38:26', 1, '06daefa43534cb494c15ade16a840a30.jpg', 'vojtech.moravek'),
158(4, 'David', 'HubáÄek', 'davhu86@gmail.com', '$2y$10$tUlj21xA28tgbU2Sn10nwu2jc6IUfBwRLKAcRKb9fxtVBAQxyndaK', 'Tohle je Davidovo bio', '1999-06-08 00:00:00', '2018-09-25 11:53:18', 0, 'http://foundrychurch.org/wp-content/uploads/2015/11/temporary-profile-placeholder.jpg', 'twajky'),
159(5, 'Nikol', 'Knesplová', 'knikoleta@seznam.cz', '$2y$10$7UuxWWwOSyZtT/2T4.Uu5Odu1RY8ShU8JyRCAeviXSmaJCwMbszeC', 'Miluju tuÄňáka <3', '2000-03-13 00:00:00', '2018-09-25 14:43:56', 0, 'http://foundrychurch.org/wp-content/uploads/2015/11/temporary-profile-placeholder.jpg', 'nicolka'),
160(7, 'Laura', 'Daniell', 'laura.d@gmail.com', '$2y$10$.EmSjDSUg4kvcS5LcuyWZOMrM1om6vA/E0CLmWY0PBAM5C527azuy', NULL, '1992-02-29 00:00:00', '2018-09-30 23:27:18', 0, '7c4cb323532ec74e6b0fcca065069ce4.jpeg', 'laura.daniell'),
161(8, 'Äuus', 'Äuus', 'jalkjasd@aslkjad.cz', '$2y$10$RNFbPN5lHo4CCDoceKG6ReWBz326fBEiQgKwxP0hgLP2ykUrBdx7W', NULL, '2018-10-01 00:00:00', '2018-10-01 08:46:18', 0, '8ab0842f7f9babd8422755e76f8fa73c.png', 'aslkdjalskjd'),
162(9, 'Aleš', 'Snětina', 'ales.snetina@gmail.com', '$2y$10$bHnJggnTpvtXFfDN0kNnWu/FHEEtevHN3HMn86c8QK0g.RcU2zMti', 'Udělat maturitu za 4', '1999-07-29 00:00:00', '2018-10-03 09:53:17', 0, '64543c8ed38113296f9d44b7abbfc843.jpeg', 'alda');
163
164-- 2018-10-10 15:34:53