· 9 years ago · Oct 17, 2016, 09:12 AM
1-- phpMyAdmin SQL Dump
2-- version 3.5.1
3-- http://www.phpmyadmin.net
4--
5-- Hostiteľ: localhost
6-- Vygenerované: Út 22.Okt 2013, 20:28
7-- Verzia serveru: 5.5.24-log
8-- Verzia PHP: 5.3.13
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 utf8 */;
18
19CREATE DATABASE eshop DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;
20USE eshop;
21
22--
23-- Databáza: `eshop`
24--
25
26-- --------------------------------------------------------
27
28--
29-- Štruktúra tabuľky pre tabuľku `objednavka`
30--
31
32CREATE TABLE IF NOT EXISTS `objednavka` (
33 `id_objednavka` int(10) unsigned NOT NULL AUTO_INCREMENT,
34 `datum` date NOT NULL,
35 `platba` varchar(15) COLLATE utf8_slovak_ci NOT NULL,
36 `dodavka` varchar(15) COLLATE utf8_slovak_ci NOT NULL,
37 `zakaznik_id_zakaznik` int(10) unsigned NOT NULL,
38 PRIMARY KEY (`id_objednavka`),
39 UNIQUE KEY `id_objednavka_UNIQUE` (`id_objednavka`),
40 KEY `fk_objednavka_zakaznik_idx` (`zakaznik_id_zakaznik`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=13 ;
42
43--
44-- Sťahujem dáta pre tabuľku `objednavka`
45--
46
47INSERT INTO `objednavka` (`id_objednavka`, `datum`, `platba`, `dodavka`, `zakaznik_id_zakaznik`) VALUES
48(1, '2010-08-08', 'karta', 'osobne', 2),
49(2, '2008-12-29', 'faktúra', 'UPS', 3),
50(3, '2009-04-15', 'hotovosť', 'osobne', 1),
51(4, '2010-09-23', 'splátky', 'osobne', 1),
52(5, '2009-07-05', 'karta', 'dobierka', 4),
53(6, '2008-08-16', 'faktúra', 'UPS', 5),
54(7, '2010-05-30', 'karta', 'osobne', 6),
55(8, '2010-03-22', 'hotovosť', 'osobne', 9),
56(9, '2009-10-19', 'hotovosť', 'osobne', 7),
57(10, '2008-03-18', 'faktúra', 'UPS', 8),
58(11, '2009-05-05', 'splátky', 'osobne', 5),
59(12, '2007-12-22', 'karta', 'osobne', 10);
60
61-- --------------------------------------------------------
62
63--
64-- Štruktúra tabuľky pre tabuľku `objednavka_has_tovar`
65--
66
67CREATE TABLE IF NOT EXISTS `objednavka_has_tovar` (
68 `objednavka_id_objednavka` int(10) unsigned NOT NULL,
69 `tovar_id_tovar` int(10) unsigned NOT NULL,
70 PRIMARY KEY (`objednavka_id_objednavka`,`tovar_id_tovar`),
71 KEY `fk_objednavka_has_tovar_tovar1_idx` (`tovar_id_tovar`),
72 KEY `fk_objednavka_has_tovar_objednavka1_idx` (`objednavka_id_objednavka`)
73) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;
74
75--
76-- Sťahujem dáta pre tabuľku `objednavka_has_tovar`
77--
78
79INSERT INTO `objednavka_has_tovar` (`objednavka_id_objednavka`, `tovar_id_tovar`) VALUES
80(11, 1),
81(2, 2),
82(3, 2),
83(6, 2),
84(8, 2),
85(11, 2),
86(3, 3),
87(5, 3),
88(8, 3),
89(12, 3),
90(2, 4),
91(3, 4),
92(6, 4),
93(8, 4),
94(9, 4),
95(11, 4),
96(2, 5),
97(6, 5),
98(7, 5),
99(8, 5),
100(11, 5),
101(8, 6),
102(9, 6),
103(2, 7),
104(4, 7),
105(6, 7),
106(9, 7),
107(12, 7),
108(5, 8),
109(7, 8),
110(9, 8),
111(10, 8),
112(7, 9),
113(3, 10),
114(4, 10),
115(5, 10);
116
117-- --------------------------------------------------------
118
119--
120-- Štruktúra tabuľky pre tabuľku `tovar`
121--
122
123CREATE TABLE IF NOT EXISTS `tovar` (
124 `id_tovar` int(10) unsigned NOT NULL AUTO_INCREMENT,
125 `nazov` varchar(45) COLLATE utf8_slovak_ci NOT NULL,
126 `cena` float NOT NULL,
127 `zaruka` int(11) NOT NULL,
128 `vyrobca_id_vyrobca` int(10) unsigned NOT NULL,
129 PRIMARY KEY (`id_tovar`),
130 UNIQUE KEY `id_tovar_UNIQUE` (`id_tovar`),
131 KEY `fk_tovar_vyrobca1_idx` (`vyrobca_id_vyrobca`)
132) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=21 ;
133
134--
135-- Sťahujem dáta pre tabuľku `tovar`
136--
137
138INSERT INTO `tovar` (`id_tovar`, `nazov`, `cena`, `zaruka`, `vyrobca_id_vyrobca`) VALUES
139(1, 'HDD 320G SATA', 35.15, 24, 1),
140(2, 'Switch D-Link DGS-1210', 214, 24, 2),
141(3, 'HDD 160G PATA', 39.65, 36, 1),
142(4, 'WRT160N Wireless-N Router', 48.45, 36, 3),
143(5, 'DIR-600 Wireless Router', 25.89, 24, 2),
144(6, 'ASUS P52F', 429.17, 24, 4),
145(7, 'IdeaPad G560', 589.45, 36, 5),
146(8, 'RTN-13U', 61.57, 24, 4),
147(9, 'Corsair Voyager Mini 16GB', 32.8, 24, 6),
148(10, 'Corsair Voyager GTR 32GB', 78.4, 36, 6),
149(13, 'Kingston MicroSD 2GB', 5.5, 24, 7),
150(14, 'Huawei P9 Lite', 380, 24, 9),
151(15, 'Asus Zenbook Flip UX360CA', 608, 24, 4),
152(16, 'Kingston UV400 SSD, 240GB', 73.8, 24, 5),
153(17, 'Corsair zdroj 650W VS', 59.6, 24, 6),
154(18, 'Kingston microSDHC 32GB UHS-I', 13, 24, 5 ),
155(19, 'Asus ZenFone Max ZC550KL', 219, 36, 4),
156(20, 'DDRAM2 1GB 400 CL3', 20, 24, 7);
157
158-- --------------------------------------------------------
159
160--
161-- Štruktúra tabuľky pre tabuľku `vyrobca`
162--
163
164CREATE TABLE IF NOT EXISTS `vyrobca` (
165 `id_vyrobca` int(10) unsigned NOT NULL AUTO_INCREMENT,
166 `nazov` varchar(45) COLLATE utf8_slovak_ci NOT NULL,
167 `stat` varchar(30) COLLATE utf8_slovak_ci NOT NULL,
168 `dodacia_lehota` int(11) NOT NULL,
169 PRIMARY KEY (`id_vyrobca`),
170 UNIQUE KEY `id_vyrobca_UNIQUE` (`id_vyrobca`)
171) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=9 ;
172
173--
174-- Sťahujem dáta pre tabuľku `vyrobca`
175--
176
177INSERT INTO `vyrobca` (`id_vyrobca`, `nazov`, `stat`, `dodacia_lehota`) VALUES
178(1, 'Western Digital', 'USA', 14),
179(2, 'D-Link', 'Taiwan', 21),
180(3, 'Linksys', 'USA', 14),
181(4, 'Asus', 'Japonsko', 21),
182(5, 'Lenovo', 'Nemecko', 5),
183(6, 'Corsair', 'USA', 14),
184(7, 'Kingston', 'Francúzsko', 5),
185(8, 'GoodRam', 'Poľsko', 3),
186(9, 'Huawei', 'ÄŒÃna', 3);
187
188-- --------------------------------------------------------
189
190--
191-- Štruktúra tabuľky pre tabuľku `zakaznik`
192--
193
194CREATE TABLE IF NOT EXISTS `zakaznik` (
195 `id_zakaznik` int(10) unsigned NOT NULL AUTO_INCREMENT,
196 `meno` varchar(30) COLLATE utf8_slovak_ci NOT NULL,
197 `priezvisko` varchar(30) COLLATE utf8_slovak_ci NOT NULL,
198 `email` varchar(30) COLLATE utf8_slovak_ci NOT NULL,
199 `vek` int(11) DEFAULT NULL,
200 PRIMARY KEY (`id_zakaznik`),
201 UNIQUE KEY `id_zakaznik_UNIQUE` (`id_zakaznik`)
202) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=16 ;
203
204--
205-- Sťahujem dáta pre tabuľku `zakaznik`
206--
207
208INSERT INTO `zakaznik` (`id_zakaznik`, `meno`, `priezvisko`, `email`, `vek`) VALUES
209(1, 'Andrej', 'KováÄ', 'a.kovac@post.sk', 18),
210(2, 'Adam', 'Gajdoš', 'gajdos@centrum.cz', 27),
211(3, 'Å tefan', 'Franko', 'franko@email.cz', 24),
212(4, 'Jakub', 'Hronec', 'papluha24@azet.sk', 22),
213(5, 'Daniel', 'Polák', 'batman15@facebook.com', 25),
214(6, 'Patrik', 'Jurek', 'janosik@pobox.sk', 30),
215(7, 'Dominik', 'ÄŒech', 'franta123@centrum.sk', 19),
216(8, 'Karol', 'Varga', 'karci69@yahoo.com', 42),
217(9, 'Marek', 'Å imko', 'citron@gmail.com', 21),
218(10, 'Peter', 'Krajňák', 'petokrajnak@pobox.sk', 26),
219(11, 'Jakub', 'Tóth', 'jato@outlook.com', 40),
220(12, 'Å imon', 'Slivka', 'simonplum@gmail.com', 35),
221(13, 'VladimÃr', 'Petráš', 'superman37@azet.sk', 38),
222(14, 'Pavol', 'Dudáš', 'dudi@post.sk', 29),
223(15, 'Branislav', 'Rajňák', 'brano@hotmail.com', 26);
224
225--
226-- Obmedzenie pre exportované tabuľky
227--
228
229--
230-- Obmedzenie pre tabuľku `objednavka`
231--
232ALTER TABLE `objednavka`
233 ADD CONSTRAINT `fk_objednavka_zakaznik` FOREIGN KEY (`zakaznik_id_zakaznik`) REFERENCES `zakaznik` (`id_zakaznik`) ON DELETE NO ACTION ON UPDATE NO ACTION;
234
235--
236-- Obmedzenie pre tabuľku `objednavka_has_tovar`
237--
238ALTER TABLE `objednavka_has_tovar`
239 ADD CONSTRAINT `fk_objednavka_has_tovar_objednavka1` FOREIGN KEY (`objednavka_id_objednavka`) REFERENCES `objednavka` (`id_objednavka`) ON DELETE NO ACTION ON UPDATE NO ACTION,
240 ADD CONSTRAINT `fk_objednavka_has_tovar_tovar1` FOREIGN KEY (`tovar_id_tovar`) REFERENCES `tovar` (`id_tovar`) ON DELETE NO ACTION ON UPDATE NO ACTION;
241
242--
243-- Obmedzenie pre tabuľku `tovar`
244--
245ALTER TABLE `tovar`
246 ADD CONSTRAINT `fk_tovar_vyrobca1` FOREIGN KEY (`vyrobca_id_vyrobca`) REFERENCES `vyrobca` (`id_vyrobca`) ON DELETE NO ACTION ON UPDATE NO ACTION;
247
248/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
249/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
250/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;