0Nt5BVu2

1-- Adminer 4.2.5 MySQL 
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `actors`;
9CREATE TABLE `actors` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `jmeno` varchar(255) COLLATE utf8_czech_ci NOT NULL,
12  `prijmeni` varchar(255) COLLATE utf8_czech_ci NOT NULL,
13  PRIMARY KEY (`id`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
15
16INSERT INTO `actors` (`id`, `jmeno`, `prijmeni`) VALUES
17(1,	'Lukáš',	'Rožnovják'),
18(2,	'Miroslav',	'Dorňak'),
19(3,	'Barbora',	'Rožnovjákova');
20
21DROP TABLE IF EXISTS `box`;
22CREATE TABLE `box` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `page` char(255) COLLATE utf8_bin NOT NULL,
25  `text` text COLLATE utf8_bin NOT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
28
29INSERT INTO `box` (`id`, `page`, `text`) VALUES
30(1,	':Front:Home:default-infobox',	'<center><h1>Vítejte na našem webu.</h1>\n<h4 style=\"font-size:1.6rem;\">Naše studio se zabývá točením krátkých filmů, svateb, sportovních akcí a mnoho dalšího.</h4>\n<h4 style=\"font-size:1.6rem;\">Náš tým se skládá ze 3 členů.</h4>\n<h4 style=\"font-size:1.6rem;\">Studio bylo založeno v roce 2016.</h4>\n</center>\n\n'),
31(2,	':*:footer-box',	'<p class=\"white-text\">Zabýváme se točením amatérských filmů a scének.<br>Pocházíme z okolí Zlína a Ostravy. </p>');
32
33DROP TABLE IF EXISTS `categories`;
34CREATE TABLE `categories` (
35  `id` int(11) NOT NULL AUTO_INCREMENT,
36  `image` varchar(255) COLLATE utf8_czech_ci NOT NULL,
37  `name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
38  `desc` tinytext COLLATE utf8_czech_ci NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
41
42INSERT INTO `categories` (`id`, `image`, `name`, `desc`) VALUES
43(1,	'',	'Sci-Fi',	'ascascascsa'),
44(2,	'',	'Horor',	'acasas');
45
46DROP TABLE IF EXISTS `films`;
47CREATE TABLE `films` (
48  `id` int(11) NOT NULL AUTO_INCREMENT,
49  `categories_id` int(11) NOT NULL,
50  `name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
51  `image` varchar(255) COLLATE utf8_czech_ci NOT NULL,
52  `url` varchar(255) COLLATE utf8_czech_ci NOT NULL,
53  `director` varchar(255) COLLATE utf8_czech_ci NOT NULL,
54  `camera` varchar(255) COLLATE utf8_czech_ci NOT NULL,
55  `desc` text COLLATE utf8_czech_ci NOT NULL,
56  `actors` text COLLATE utf8_czech_ci NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
59
60INSERT INTO `films` (`id`, `categories_id`, `name`, `image`, `url`, `director`, `camera`, `desc`, `actors`) VALUES
61(1,	0,	'15',	'14231908_1652382048424410_1127535716807160989_o.jpg',	'PDEKaNxeUAo',	'Martin Zetocha',	'Martin Zetocha, Jan Koňařík',	'Film povídá o muži který byl unesen jistou společností aby soutěžil o svůj život. Čeká ho mnoho nástrah ale hlavně jeho nepřátelé.',	'Vladimír Žid, Lukáš Rožnovják, Jakub Koňařík, Miroslav Dorňak, Jak Koňařík, Barbora Rožnovjákova, ');
62
63DROP TABLE IF EXISTS `requests`;
64CREATE TABLE `requests` (
65  `id` int(11) NOT NULL AUTO_INCREMENT,
66  `fname` char(200) COLLATE utf8_czech_ci NOT NULL,
67  `sname` char(200) COLLATE utf8_czech_ci NOT NULL,
68  `file` varchar(255) COLLATE utf8_czech_ci NOT NULL,
69  `email` varchar(255) COLLATE utf8_czech_ci NOT NULL,
70  `content` tinytext COLLATE utf8_czech_ci NOT NULL,
71  PRIMARY KEY (`id`)
72) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
73
74
75DROP TABLE IF EXISTS `slider`;
76CREATE TABLE `slider` (
77  `id` int(11) NOT NULL AUTO_INCREMENT,
78  `image` varchar(255) COLLATE utf8_czech_ci NOT NULL,
79  `title` varchar(255) COLLATE utf8_czech_ci NOT NULL,
80  `text` tinytext COLLATE utf8_czech_ci NOT NULL,
81  `button` varchar(255) COLLATE utf8_czech_ci NOT NULL,
82  `color` varchar(50) COLLATE utf8_czech_ci NOT NULL,
83  PRIMARY KEY (`id`)
84) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
85
86INSERT INTO `slider` (`id`, `image`, `title`, `text`, `button`, `color`) VALUES
87(1,	'http://bm.babybluef1.eu/images/scenaÅ™.png',	'',	'\r\n',	'#',	'green');
88
89DROP TABLE IF EXISTS `team`;
90CREATE TABLE `team` (
91  `id` int(11) NOT NULL AUTO_INCREMENT,
92  `jmeno` varchar(255) COLLATE utf8_czech_ci NOT NULL,
93  `prijmeni` varchar(255) COLLATE utf8_czech_ci NOT NULL,
94  `prezdivka` varchar(255) COLLATE utf8_czech_ci NOT NULL,
95  `pozice` varchar(255) COLLATE utf8_czech_ci NOT NULL,
96  `avatar` char(200) COLLATE utf8_czech_ci NOT NULL DEFAULT 'noavatar.jpg',
97  PRIMARY KEY (`id`)
98) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
99
100INSERT INTO `team` (`id`, `jmeno`, `prijmeni`, `prezdivka`, `pozice`, `avatar`) VALUES
101(1,	'Martin',	'Zetocha',	'NotSid7',	'Režisér, Zakladatel',	'notsid.jpg'),
102(2,	'Patrik',	'Olšanský',	'Altisek',	'Webmaster',	'noavatar.jpg'),
103(3,	'Jan',	'Zahalka',	'Johnny',	'ZvukaÅ™',	'noavatar.jpg'),
104(4,	'Jan',	'Koňařík',	'',	'Kameraman',	'noavatar.jpg');
105
106-- 2016-12-21 22:09:48