· 7 years ago · Feb 07, 2019, 07:24 AM
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 TABLE IF EXISTS `autori`;
9CREATE TABLE `autori` (
10 `id_autori` int(11) NOT NULL AUTO_INCREMENT,
11 `jmeno` varchar(255) COLLATE utf8_bin NOT NULL,
12 `prijmeni` varchar(255) COLLATE utf8_bin NOT NULL,
13 `vek` int(11) NOT NULL,
14 PRIMARY KEY (`id_autori`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
16
17INSERT INTO `autori` (`id_autori`, `jmeno`, `prijmeni`, `vek`) VALUES
18(1, 'Karel', 'Sabina', 55),
19(2, 'Dan', 'Brown', 60),
20(3, 'Božena', 'Němcová', 77),
21(4, 'Ernest', 'Cline', 20),
22(5, 'J.K.', 'Rowling', 50);
23
24DROP TABLE IF EXISTS `knihy`;
25CREATE TABLE `knihy` (
26 `id_knihy` int(11) NOT NULL AUTO_INCREMENT,
27 `nazev` varchar(255) COLLATE utf8_bin NOT NULL,
28 `strany` varchar(255) COLLATE utf8_bin DEFAULT NULL,
29 `isbn` varchar(255) COLLATE utf8_bin NOT NULL,
30 `id_zanr` varchar(255) COLLATE utf8_bin NOT NULL,
31 `rok_vydani` year(4) DEFAULT NULL,
32 `created_at` datetime DEFAULT NULL,
33 `modifed_at` datetime DEFAULT NULL,
34 PRIMARY KEY (`id_knihy`)
35) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
36
37INSERT INTO `knihy` (`id_knihy`, `nazev`, `strany`, `isbn`, `id_zanr`, `rok_vydani`, `created_at`, `modifed_at`) VALUES
38(1, 'Oživené hroby', '952', ' 978-80-200-2254-7', '1', NULL, NULL, NULL),
39(2, 'Král Ferdinand V. Dobrotivý', '952', ' 978-80-200-2254-7', '2', NULL, NULL, NULL),
40(3, 'Osudná kniha', '384', '978-80-7308-487-5', '2', NULL, NULL, NULL),
41(7, 'BabiÄka', '224', '978-80-7390-049-6', '7', NULL, NULL, NULL),
42(8, 'ÄŒert a KáÄa', '32', '978-80-7483-052-5', '4', NULL, NULL, NULL),
43(9, 'Divá Bára a jiné prózy', '240', '978-80-7390-130-1', '3', NULL, NULL, NULL),
44(4, 'Andělé a démoni', '464', '978-80-257-0128-7', '5', NULL, NULL, NULL),
45(5, 'Inferno', '424', '978-80-257-0934-4', '5', NULL, NULL, NULL),
46(6, 'PoÄátek', '464', '978-80-257-2386-9', '5', NULL, NULL, NULL),
47(10, 'Armada', '352', '978-80-242-5569-9', '6', NULL, NULL, NULL),
48(11, 'Ready Player One', '432', '978-80-242-6042-6', '6', NULL, NULL, NULL),
49(12, 'Harry Potter a Kámen mudrců', '336', '978-80-00-04724-9', '6', NULL, NULL, NULL),
50(13, 'Harry Potter a Tajemná komnata', '336', '978-80-00-04780-5', '6', NULL, NULL, NULL),
51(14, 'Harry Potter a Fénixův řád', '800', '978-80-00-04968-7', '6', NULL, NULL, NULL),
52(15, 'Harry Potter a Ohnivý pohár', '784', '978-80-00-04828-4', '6', NULL, NULL, NULL);
53
54DROP TABLE IF EXISTS `knihy_autori`;
55CREATE TABLE `knihy_autori` (
56 `id_knihy` int(11) NOT NULL AUTO_INCREMENT,
57 `id_autori` int(11) NOT NULL,
58 PRIMARY KEY (`id_knihy`)
59) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
60
61INSERT INTO `knihy_autori` (`id_knihy`, `id_autori`) VALUES
62(1, 1),
63(2, 1),
64(3, 1),
65(4, 2),
66(5, 2),
67(6, 2),
68(7, 3),
69(8, 3),
70(9, 3),
71(10, 4),
72(11, 4),
73(12, 5),
74(13, 5),
75(14, 5),
76(15, 5);
77
78DROP TABLE IF EXISTS `zanry`;
79CREATE TABLE `zanry` (
80 `id_zanr` int(11) NOT NULL AUTO_INCREMENT,
81 `zanr` varchar(255) COLLATE utf8_bin NOT NULL,
82 PRIMARY KEY (`id_zanr`)
83) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
84
85INSERT INTO `zanry` (`id_zanr`, `zanr`) VALUES
86(1, 'autobiograficky'),
87(2, 'historicky'),
88(3, 'povidka'),
89(4, 'pohadka'),
90(5, 'krimi'),
91(6, 'fantasy'),
92(7, 'roman');
93
94-- 2019-02-07 07:20:43