-- Adminer 4.6.3 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP DATABASE IF EXISTS `telecule`;
CREATE DATABASE `telecule` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci */;
USE `telecule`;

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_created` datetime NOT NULL,
  `author_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

TRUNCATE `article`;

DROP TABLE IF EXISTS `genre`;
CREATE TABLE `genre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

TRUNCATE `genre`;
INSERT INTO `genre` (`id`, `name`) VALUES
(1,	'Action'),
(2,	'Adventure'),
(3,	'Comedy'),
(4,	'Crime'),
(5,	'Drama'),
(6,	'Historical'),
(7,	'Horror'),
(8,	'Musical'),
(9,	'Sci-Fi'),
(10,	'War'),
(11,	'Western');

DROP TABLE IF EXISTS `migration_versions`;
CREATE TABLE `migration_versions` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

TRUNCATE `migration_versions`;
INSERT INTO `migration_versions` (`version`) VALUES
('20180922082106'),
('20180922115550'),
('20180922121325'),
('20180923210454'),
('20180923210542'),
('20180924092727'),
('20180926153538'),
('20180927071019'),
('20180927072023'),
('20180930130449'),
('20180930130703'),
('20180930150506'),
('20181001143247'),
('20181005063409'),
('20181005073110'),
('20181005222411'),
('20181009061806'),
('20181009090913'),
('20181009124039'),
('20181009124432'),
('20181010074438'),
('20181010075841'),
('20181010081315'),
('20181010092438');

DROP TABLE IF EXISTS `movie`;
CREATE TABLE `movie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` longtext COLLATE utf8mb4_unicode_ci,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `premiere` datetime NOT NULL,
  `rating` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `thumbnail` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

TRUNCATE `movie`;
INSERT INTO `movie` (`id`, `title`, `short_description`, `description`, `premiere`, `rating`, `date_created`, `thumbnail`, `slug`) VALUES
(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'),
(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'),
(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');

DROP TABLE IF EXISTS `movie_genre`;
CREATE TABLE `movie_genre` (
  `movie_id` int(11) NOT NULL,
  `genre_id` int(11) NOT NULL,
  PRIMARY KEY (`movie_id`,`genre_id`),
  KEY `IDX_FD1229648F93B6FC` (`movie_id`),
  KEY `IDX_FD1229644296D31F` (`genre_id`),
  CONSTRAINT `FK_FD1229644296D31F` FOREIGN KEY (`genre_id`) REFERENCES `genre` (`id`),
  CONSTRAINT `FK_FD1229648F93B6FC` FOREIGN KEY (`movie_id`) REFERENCES `movie` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

TRUNCATE `movie_genre`;

DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

TRUNCATE `role`;
INSERT INTO `role` (`id`, `name`, `value`) VALUES
(1,	'guest',	0),
(2,	'admin',	1);

DROP TABLE IF EXISTS `tv_show`;
CREATE TABLE `tv_show` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` longtext COLLATE utf8mb4_unicode_ci,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `premiere` datetime NOT NULL,
  `rating` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

TRUNCATE `tv_show`;

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bio` longtext COLLATE utf8mb4_unicode_ci,
  `birthday` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `role_id` int(11) NOT NULL,
  `profile_picture` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

TRUNCATE `user`;
INSERT INTO `user` (`id`, `first_name`, `last_name`, `email_address`, `password`, `bio`, `birthday`, `date_created`, `role_id`, `profile_picture`, `username`) VALUES
(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'),
(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'),
(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'),
(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'),
(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'),
(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');

-- 2018-10-10 15:34:53