Kf9vAY0h

1-- Adminer 4.3.1 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 `hromadne_rezervace`;
9CREATE TABLE `hromadne_rezervace` (
10  `id` int(7) NOT NULL AUTO_INCREMENT,
11  `nazev` varchar(35) NOT NULL,
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14
15
16DROP TABLE IF EXISTS `lokality`;
17CREATE TABLE `lokality` (
18  `id` int(7) NOT NULL AUTO_INCREMENT,
19  `nazev` varchar(35) NOT NULL,
20  PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8;
22
23
24DROP TABLE IF EXISTS `mistnosti`;
25CREATE TABLE `mistnosti` (
26  `id` int(7) NOT NULL AUTO_INCREMENT,
27  `lokalitaid` int(7) NOT NULL,
28  `nazev` varchar(35) NOT NULL,
29  `kapacita` int(5) NOT NULL,
30  PRIMARY KEY (`id`),
31  KEY `lokalitaid` (`lokalitaid`),
32  CONSTRAINT `mistnosti_ibfk_1` FOREIGN KEY (`lokalitaid`) REFERENCES `lokality` (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35
36DROP TABLE IF EXISTS `rezervace`;
37CREATE TABLE `rezervace` (
38  `id` int(7) NOT NULL AUTO_INCREMENT,
39  `uzivatelid` int(7) NOT NULL,
40  `lokalitaid` int(7) NOT NULL,
41  `mistnostid` int(7) NOT NULL,
42  `hromadnarezervaceid` int(7) NOT NULL,
43  `nazev` varchar(35) NOT NULL,
44  `od` datetime NOT NULL,
45  `do` datetime NOT NULL,
46  `ucastniku` int(5) NOT NULL,
47  PRIMARY KEY (`id`),
48  KEY `uzivatelid` (`uzivatelid`),
49  KEY `lokalitaid` (`lokalitaid`),
50  KEY `hromadnarezervaceid` (`hromadnarezervaceid`),
51  KEY `mistnostid` (`mistnostid`),
52  CONSTRAINT `rezervace_ibfk_4` FOREIGN KEY (`mistnostid`) REFERENCES `mistnosti` (`id`),
53  CONSTRAINT `rezervace_ibfk_1` FOREIGN KEY (`uzivatelid`) REFERENCES `uzivatele` (`id`),
54  CONSTRAINT `rezervace_ibfk_2` FOREIGN KEY (`lokalitaid`) REFERENCES `lokality` (`id`),
55  CONSTRAINT `rezervace_ibfk_3` FOREIGN KEY (`hromadnarezervaceid`) REFERENCES `hromadne_rezervace` (`id`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57
58
59DROP TABLE IF EXISTS `role`;
60CREATE TABLE `role` (
61  `id` int(7) NOT NULL AUTO_INCREMENT,
62  `nazev` varchar(40) NOT NULL,
63  PRIMARY KEY (`id`)
64) ENGINE=InnoDB DEFAULT CHARSET=utf8;
65
66
67DROP TABLE IF EXISTS `sablona`;
68CREATE TABLE `sablona` (
69  `id` int(7) NOT NULL AUTO_INCREMENT,
70  `uzivatelid` int(7) NOT NULL,
71  `nazev` varchar(35) NOT NULL,
72  `lokalitaid` int(7) NOT NULL,
73  `mistnostid` int(7) NOT NULL,
74  `popis` varchar(155) NOT NULL,
75  `delkamin` int(7) NOT NULL,
76  PRIMARY KEY (`id`),
77  KEY `uzivatelid` (`uzivatelid`),
78  KEY `mistnostid` (`mistnostid`),
79  KEY `lokalitaid` (`lokalitaid`),
80  CONSTRAINT `sablona_ibfk_3` FOREIGN KEY (`lokalitaid`) REFERENCES `lokality` (`id`),
81  CONSTRAINT `sablona_ibfk_1` FOREIGN KEY (`uzivatelid`) REFERENCES `uzivatele` (`id`),
82  CONSTRAINT `sablona_ibfk_2` FOREIGN KEY (`mistnostid`) REFERENCES `mistnosti` (`id`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84
85
86DROP TABLE IF EXISTS `uzivatele`;
87CREATE TABLE `uzivatele` (
88  `id` int(7) NOT NULL AUTO_INCREMENT,
89  `jmeno` varchar(35) NOT NULL,
90  `prijmeni` varchar(35) NOT NULL,
91  `roleid` int(7) NOT NULL,
92  PRIMARY KEY (`id`),
93  KEY `roleid` (`roleid`),
94  CONSTRAINT `uzivatele_ibfk_1` FOREIGN KEY (`roleid`) REFERENCES `role` (`id`)
95) ENGINE=InnoDB DEFAULT CHARSET=utf8;
96
97
98-- 2019-12-14 14:52:40