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