· 8 years ago · Jul 05, 2018, 10:34 AM
1-- Adminer 4.6.2 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
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `comments`;
11CREATE TABLE `comments` (
12 `id` int(11) NOT NULL AUTO_INCREMENT,
13 `event_id` int(11) NOT NULL,
14 `text` text COLLATE utf8mb4_czech_ci NOT NULL,
15 `likes` int(11) NOT NULL DEFAULT '0',
16 `created` datetime NOT NULL,
17 PRIMARY KEY (`id`),
18 KEY `event_id` (`event_id`),
19 CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci;
21
22INSERT INTO `comments` (`id`, `event_id`, `text`, `likes`, `created`) VALUES
23(10, 1, 'PARÃDNà HERECKÉ VÃKONY. KLOBOUK DOLÅ®.', 9, '2018-06-28 20:56:12'),
24(11, 1, 'KRÃSNÃ VZPOMÃNKA NA V+W.', 9, '2018-06-28 20:57:22'),
25(12, 1, 'MOC HEZKY ZAZPÃVANÉ', 13, '2018-06-28 20:57:33'),
26(13, 1, 'JÃ JSEM SE BAVIL!!!!!!!!!!', 0, '2018-06-28 20:57:54'),
27(14, 1, 'Chytrý text, pÅ™esvÄ›dÄivé herecké výkony!', 2, '2018-06-28 21:04:42'),
28(15, 1, 'výborný text a skvěle odehrané', 3, '2018-06-28 21:07:44'),
29(16, 1, 'ÄeÅ¡tina je krásný jayzk', 1, '2018-06-28 21:28:06'),
30(17, 1, 'ÄeÅ¡tina je krásný jayzk', 1, '2018-06-28 21:28:06'),
31(18, 1, 'Jsem nadÅ¡ená! Kde jste vzali Miroslava HornÃÄka ??', 0, '2018-06-28 21:29:39'),
32(19, 1, 'nenà tÅ™eba se hlasitrÄ› chechtat, staÄà se vesele usmÃvat', 0, '2018-06-28 21:30:50'),
33(20, 1, 'obdivuji množstvà textu,a krásnÄ› zazpÃvané pÃsnÄ›', 0, '2018-06-28 21:35:50'),
34(21, 1, 'pÅ™Ãjemné, osvěžujÃcà a soudobé...krásná ÄeÅ¡tina', 0, '2018-06-28 21:36:23');
35
36DROP TABLE IF EXISTS `events`;
37CREATE TABLE `events` (
38 `id` int(11) NOT NULL AUTO_INCREMENT,
39 `date` date NOT NULL,
40 `show_name` varchar(200) COLLATE utf8mb4_czech_ci NOT NULL,
41 `group_name` varchar(200) COLLATE utf8mb4_czech_ci NOT NULL,
42 `happy_votes` int(11) NOT NULL DEFAULT '0',
43 `smile_votes` int(11) NOT NULL DEFAULT '0',
44 `normal_votes` int(11) NOT NULL DEFAULT '0',
45 `furious_votes` int(11) NOT NULL DEFAULT '0',
46 PRIMARY KEY (`id`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci;
48
49INSERT INTO `events` (`id`, `date`, `show_name`, `group_name`, `happy_votes`, `smile_votes`, `normal_votes`, `furious_votes`) VALUES
50(1, '2018-06-28', 'JÃzlivý glosátor', 'Divadelnà spolek Bratřà MrÅ¡tÃků Boleradice', 28, 9, 0, 0);
51
52-- 2018-07-05 10:30:12