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