· 7 years ago · Feb 18, 2019, 11:20 AM
1-- phpMyAdmin SQL Dump
2-- version 4.6.5.2
3-- https://www.phpmyadmin.net/
4--
5-- PoÄÃtaÄ: 127.0.0.1
6-- Vytvořeno: Pát 16. bře 2018, 19:56
7-- Verze serveru: 10.1.21-MariaDB
8-- Verze PHP: 5.6.30
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT = @@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS = @@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION = @@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Databáze: `web`
21--
22CREATE DATABASE IF NOT EXISTS `web`
23 DEFAULT CHARACTER SET utf8
24 COLLATE utf8_czech_ci;
25USE `web`;
26
27-- --------------------------------------------------------
28
29--
30-- Struktura tabulky `clanek`
31--
32
33CREATE TABLE `clanek` (
34 `ID_clanku` INT(11) NOT NULL,
35 `ID_uzivatele` INT(11) NOT NULL,
36 `nazev` VARCHAR(80)
37 COLLATE utf8_czech_ci DEFAULT NULL,
38 `anotace` TEXT COLLATE utf8_czech_ci,
39 `clanek` LONGTEXT COLLATE utf8_czech_ci,
40 `datum_zverejneni` DATE DEFAULT NULL,
41 `datum_ukonceni` DATE DEFAULT NULL,
42 `hodnoceni` INT(11) DEFAULT NULL
43)
44 ENGINE = InnoDB
45 DEFAULT CHARSET = utf8
46 COLLATE = utf8_czech_ci;
47
48-- --------------------------------------------------------
49
50--
51-- Struktura tabulky `komentar`
52--
53
54CREATE TABLE `komentar` (
55 `ID_komentare` INT(11) NOT NULL,
56 `ID_clanku` INT(11) NOT NULL,
57 `ID_uzivatele` INT(11) NOT NULL,
58 `komentar` TEXT COLLATE utf8_czech_ci,
59 `hodnoceni` INT(11) DEFAULT NULL
60)
61 ENGINE = InnoDB
62 DEFAULT CHARSET = utf8
63 COLLATE = utf8_czech_ci;
64
65-- --------------------------------------------------------
66
67--
68-- Struktura tabulky `kosik`
69--
70
71CREATE TABLE `kosik` (
72 `ID_kosik` INT(11) NOT NULL,
73 `ID_uzivatele` INT(11) NOT NULL,
74 `ID_vyrobku` INT(11) NOT NULL,
75 `mnozstvi` INT(11) NOT NULL,
76 `kos_cena` INT(11) NOT NULL
77)
78 ENGINE = InnoDB
79 DEFAULT CHARSET = utf8
80 COLLATE = utf8_czech_ci;
81
82-- --------------------------------------------------------
83
84--
85-- Struktura tabulky `objednavka`
86--
87
88CREATE TABLE `objednavka` (
89 `ID_objednavky` INT(11) NOT NULL,
90 `ID_uzivatele` INT(11) NOT NULL,
91 `datum` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
92 `vyrizeni` VARCHAR (1) COLLATE utf8_czech_ci NOT NULL,
93 `poznamka` TEXT(200),
94 `cena_celkem` int(20),
95 `text_objednavky` TEXT COLLATE utf8_czech_ci NOT NULL
96)
97 ENGINE = InnoDB
98 DEFAULT CHARSET = utf8
99 COLLATE = utf8_czech_ci;
100
101-- --------------------------------------------------------
102
103--
104-- Struktura tabulky `uzivatel`
105--
106
107CREATE TABLE `uzivatel` (
108 `ID_uzivatele` INT(11) NOT NULL,
109 `first_name` VARCHAR(30)
110 COLLATE utf8_czech_ci NOT NULL,
111 `sur_name` VARCHAR(30)
112 COLLATE utf8_czech_ci NOT NULL,
113 `login` VARCHAR(30)
114 COLLATE utf8_czech_ci NOT NULL,
115 `pass` VARCHAR(50)
116 COLLATE utf8_czech_ci NOT NULL,
117 `mesto` CHAR(60)
118 COLLATE utf8_czech_ci DEFAULT NULL,
119 `ulice` CHAR(30)
120 COLLATE utf8_czech_ci DEFAULT NULL,
121 `cislo_popisne` VARCHAR(10)
122 COLLATE utf8_czech_ci DEFAULT NULL,
123 `psc` INT(11) DEFAULT NULL,
124 `email` VARCHAR(40)
125 COLLATE utf8_czech_ci NOT NULL,
126 `telefon` VARCHAR(13)
127 COLLATE utf8_czech_ci DEFAULT NULL,
128 `pravo` CHAR(10)
129 COLLATE utf8_czech_ci NOT NULL
130)
131 ENGINE = InnoDB
132 DEFAULT CHARSET = utf8
133 COLLATE = utf8_czech_ci;
134
135-- --------------------------------------------------------
136
137--
138-- Struktura tabulky `vyrobky`
139--
140
141CREATE TABLE `vyrobky` (
142 `ID_vyrobku` INT(11) NOT NULL,
143 `nazev` VARCHAR(80)
144 COLLATE utf8_czech_ci NOT NULL,
145 `vyrobce` VARCHAR(30)
146 COLLATE utf8_czech_ci NOT NULL,
147 `popis` TEXT COLLATE utf8_czech_ci NOT NULL,
148 `vyr_cena` INT(11) NOT NULL,
149 `prodavat` VARCHAR(1)
150 COLLATE utf8_czech_ci NOT NULL
151)
152 ENGINE = InnoDB
153 DEFAULT CHARSET = utf8
154 COLLATE = utf8_czech_ci;
155
156--
157-- Kl̀e pro exportovan̩ tabulky
158--
159
160--
161-- KlÃÄe pro tabulku `clanek`
162--
163ALTER TABLE `clanek`
164 ADD PRIMARY KEY (`ID_clanku`),
165 ADD KEY `clanek_uzivatel_FK` (`ID_uzivatele`);
166
167--
168-- KlÃÄe pro tabulku `komentar`
169--
170ALTER TABLE `komentar`
171 ADD PRIMARY KEY (`ID_komentare`),
172 ADD KEY `komentar_clanek_FK` (`ID_clanku`),
173 ADD KEY `komentar_uzivatel_FK` (`ID_uzivatele`);
174
175--
176-- KlÃÄe pro tabulku `kosik`
177--
178ALTER TABLE `kosik`
179 ADD PRIMARY KEY (`ID_kosik`),
180 ADD KEY `kosik_vyrobky_FK` (`ID_vyrobku`),
181 ADD KEY `kosik_uzivatel_FK` (`ID_uzivatele`);
182
183--
184-- KlÃÄe pro tabulku `objednavka`
185--
186ALTER TABLE `objednavka`
187 ADD PRIMARY KEY (`ID_objednavky`);
188
189--
190-- KlÃÄe pro tabulku `uzivatel`
191--
192ALTER TABLE `uzivatel`
193 ADD PRIMARY KEY (`ID_uzivatele`);
194
195--
196-- KlÃÄe pro tabulku `vyrobky`
197--
198ALTER TABLE `vyrobky`
199 ADD PRIMARY KEY (`ID_vyrobku`);
200
201--
202-- AUTO_INCREMENT pro tabulky
203--
204
205--
206-- AUTO_INCREMENT pro tabulku `clanek`
207--
208ALTER TABLE `clanek`
209 MODIFY `ID_clanku` INT(11) NOT NULL AUTO_INCREMENT;
210--
211-- AUTO_INCREMENT pro tabulku `komentar`
212--
213ALTER TABLE `komentar`
214 MODIFY `ID_komentare` INT(11) NOT NULL AUTO_INCREMENT;
215--
216-- AUTO_INCREMENT pro tabulku `kosik`
217--
218ALTER TABLE `kosik`
219 MODIFY `ID_kosik` INT(11) NOT NULL AUTO_INCREMENT;
220--
221-- AUTO_INCREMENT pro tabulku `objednavka`
222--
223ALTER TABLE `objednavka`
224 MODIFY `ID_objednavky` INT(11) NOT NULL AUTO_INCREMENT;
225--
226-- AUTO_INCREMENT pro tabulku `uzivatel`
227--
228ALTER TABLE `uzivatel`
229 MODIFY `ID_uzivatele` INT(11) NOT NULL AUTO_INCREMENT;
230--
231-- AUTO_INCREMENT pro tabulku `vyrobky`
232--
233ALTER TABLE `vyrobky`
234 MODIFY `ID_vyrobku` INT(11) NOT NULL AUTO_INCREMENT;
235--
236-- Omezenà pro exportované tabulky
237--
238
239--
240-- Omezenà pro tabulku `clanek`
241--
242ALTER TABLE `clanek`
243 ADD CONSTRAINT `clanek_uzivatel_FK` FOREIGN KEY (`ID_uzivatele`) REFERENCES `uzivatel` (`ID_uzivatele`)
244 ON DELETE CASCADE;
245
246--
247-- Omezenà pro tabulku `komentar`
248--
249ALTER TABLE `komentar`
250 ADD CONSTRAINT `komentar_clanek_FK` FOREIGN KEY (`ID_clanku`) REFERENCES `clanek` (`ID_clanku`)
251 ON DELETE CASCADE,
252 ADD CONSTRAINT `komentar_uzivatel_FK` FOREIGN KEY (`ID_uzivatele`) REFERENCES `uzivatel` (`ID_uzivatele`);
253
254--
255-- Omezenà pro tabulku `kosik`
256--
257ALTER TABLE `kosik`
258 ADD CONSTRAINT `kosik_uzivatel_FK` FOREIGN KEY (`ID_uzivatele`) REFERENCES `uzivatel` (`ID_uzivatele`),
259 ADD CONSTRAINT `kosik_vyrobky_FK` FOREIGN KEY (`ID_vyrobku`) REFERENCES `vyrobky` (`ID_vyrobku`);
260
261
262/*!40101 SET CHARACTER_SET_CLIENT = @OLD_CHARACTER_SET_CLIENT */;
263/*!40101 SET CHARACTER_SET_RESULTS = @OLD_CHARACTER_SET_RESULTS */;
264/*!40101 SET COLLATION_CONNECTION = @OLD_COLLATION_CONNECTION */;