# HeidiSQL Dump
#
# --------------------------------------------------------
# Host:                         127.0.0.1
# Database:                     eshop
# Server version:               5.1.36-community-log
# Server OS:                    Win32
# Target compatibility:         HeidiSQL w/ MySQL Server 5.0
# Target max_allowed_packet:    1048576
# HeidiSQL version:             4.0
# Date/time:                    2010-11-30 00:17:36
# --------------------------------------------------------

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


#
# Database structure for database 'eshop'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `eshop` /*!40100 DEFAULT CHARACTER SET cp1250 COLLATE cp1250_czech_cs */;

USE `eshop`;


#
# Table structure for table 'objednavka'
#

CREATE TABLE `objednavka` (
  `id_objednavka` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `datum` date NOT NULL,
  `platba` varchar(15) COLLATE cp1250_czech_cs NOT NULL,
  `dodavka` varchar(15) COLLATE cp1250_czech_cs NOT NULL,
  `zakaznik_id_zakaznik` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_objednavka`),
  UNIQUE KEY `id_objednavka_UNIQUE` (`id_objednavka`),
  KEY `fk_objednavka_zakaznik` (`zakaznik_id_zakaznik`),
  CONSTRAINT `fk_objednavka_zakaznik` FOREIGN KEY (`zakaznik_id_zakaznik`) REFERENCES `zakaznik` (`id_zakaznik`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs;



#
# Dumping data for table 'objednavka'
#

LOCK TABLES `objednavka` WRITE;
/*!40000 ALTER TABLE `objednavka` DISABLE KEYS;*/
INSERT INTO `objednavka` (`id_objednavka`, `datum`, `platba`, `dodavka`, `zakaznik_id_zakaznik`) VALUES
	('1','2010-08-08','karta','osobne','2'),
	('2','2008-12-29','faktúra','UPS','3'),
	('3','2009-04-15','hotovosť','osobne','1'),
	('4','2010-09-23','splátky','osobne','1'),
	('5','2009-07-05','karta','dobierka','4'),
	('6','2008-08-16','faktúra','UPS','5'),
	('7','2010-05-30','karta','osobne','6'),
	('8','2010-03-22','hotovosť','osobne','9'),
	('9','2009-10-19','hotovosť','osobne','7'),
	('10','2008-03-18','faktúra','UPS','8'),
	('11','2009-05-05','splátky','osobne','5'),
	('12','2007-12-22','karta','osobne','10');
/*!40000 ALTER TABLE `objednavka` ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'objednavka_has_tovar'
#

CREATE TABLE `objednavka_has_tovar` (
  `objednavka_id_objednavka` int(10) unsigned NOT NULL,
  `tovar_id_tovar` int(10) unsigned NOT NULL,
  PRIMARY KEY (`objednavka_id_objednavka`,`tovar_id_tovar`),
  KEY `fk_objednavka_has_tovar_tovar1` (`tovar_id_tovar`),
  CONSTRAINT `fk_objednavka_has_tovar_objednavka1` FOREIGN KEY (`objednavka_id_objednavka`) REFERENCES `objednavka` (`id_objednavka`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_objednavka_has_tovar_tovar1` FOREIGN KEY (`tovar_id_tovar`) REFERENCES `tovar` (`id_tovar`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs;



#
# Dumping data for table 'objednavka_has_tovar'
#

LOCK TABLES `objednavka_has_tovar` WRITE;
/*!40000 ALTER TABLE `objednavka_has_tovar` DISABLE KEYS;*/
INSERT INTO `objednavka_has_tovar` (`objednavka_id_objednavka`, `tovar_id_tovar`) VALUES
	('11','1'),
	('2','2'),
	('3','2'),
	('6','2'),
	('8','2'),
	('11','2'),
	('3','3'),
	('5','3'),
	('8','3'),
	('12','3'),
	('2','4'),
	('3','4'),
	('6','4'),
	('8','4'),
	('9','4'),
	('11','4'),
	('2','5'),
	('6','5'),
	('7','5'),
	('8','5'),
	('11','5'),
	('8','6'),
	('9','6'),
	('2','7'),
	('4','7'),
	('6','7'),
	('9','7'),
	('12','7'),
	('5','8'),
	('7','8'),
	('9','8'),
	('10','8'),
	('7','9'),
	('3','10'),
	('4','10'),
	('5','10');
/*!40000 ALTER TABLE `objednavka_has_tovar` ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'tovar'
#

CREATE TABLE `tovar` (
  `id_tovar` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nazov` varchar(45) COLLATE cp1250_czech_cs NOT NULL,
  `cena` float NOT NULL,
  `zaruka` int(11) NOT NULL,
  `vyrobca_id_vyrobca` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_tovar`),
  UNIQUE KEY `id_tovar_UNIQUE` (`id_tovar`),
  KEY `fk_tovar_vyrobca1` (`vyrobca_id_vyrobca`),
  CONSTRAINT `fk_tovar_vyrobca1` FOREIGN KEY (`vyrobca_id_vyrobca`) REFERENCES `vyrobca` (`id_vyrobca`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs;



#
# Dumping data for table 'tovar'
#

LOCK TABLES `tovar` WRITE;
/*!40000 ALTER TABLE `tovar` DISABLE KEYS;*/
INSERT INTO `tovar` (`id_tovar`, `nazov`, `cena`, `zaruka`, `vyrobca_id_vyrobca`) VALUES
	('1','HDD 320G SATA','35.15',24,'1'),
	('2','Switch D-Link DGS-1210','214',24,'2'),
	('3','HDD 160G PATA','39.65',36,'1'),
	('4','WRT160N Wireless-N Router','48.45',36,'3'),
	('5','DIR-600 Wireless Router','25.89',24,'2'),
	('6','ASUS P52F','429.17',24,'4'),
	('7','IdeaPad G560','589.45',36,'5'),
	('8','RTN-13U','61.57',24,'4'),
	('9','Corsair Voyager Mini 16GB','32.8',24,'6'),
	('10','Corsair Voyager GTR 32GB','78.4',36,'6'),
	('13','Kingston MicroSD 2GB','5.5',24,'7'),
	('14','DDRAM2 1GB 400 CL3','20',24,'7');
/*!40000 ALTER TABLE `tovar` ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'vyrobca'
#

CREATE TABLE `vyrobca` (
  `id_vyrobca` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nazov` varchar(45) COLLATE cp1250_czech_cs NOT NULL,
  `stat` varchar(30) COLLATE cp1250_czech_cs NOT NULL,
  `dodacia_lehota` int(11) NOT NULL,
  PRIMARY KEY (`id_vyrobca`),
  UNIQUE KEY `id_vyrobca_UNIQUE` (`id_vyrobca`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs;



#
# Dumping data for table 'vyrobca'
#

LOCK TABLES `vyrobca` WRITE;
/*!40000 ALTER TABLE `vyrobca` DISABLE KEYS;*/
INSERT INTO `vyrobca` (`id_vyrobca`, `nazov`, `stat`, `dodacia_lehota`) VALUES
	('1','Western Digital','USA',14),
	('2','D-Link','Taiwan',21),
	('3','Linksys','USA',14),
	('4','Asus','Japonsko',21),
	('5','Lenovo','Nemecko',5),
	('6','Corsair','USA',14),
	('7','Kingston','Francúzsko',5),
	('8','GoodRam','Poľsko',3);
/*!40000 ALTER TABLE `vyrobca` ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'zakaznik'
#

CREATE TABLE `zakaznik` (
  `id_zakaznik` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `meno` varchar(30) COLLATE cp1250_czech_cs NOT NULL,
  `priezvisko` varchar(30) COLLATE cp1250_czech_cs NOT NULL,
  `email` varchar(30) COLLATE cp1250_czech_cs NOT NULL,
  `vek` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_zakaznik`),
  UNIQUE KEY `id_zakaznik_UNIQUE` (`id_zakaznik`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs;



#
# Dumping data for table 'zakaznik'
#

LOCK TABLES `zakaznik` WRITE;
/*!40000 ALTER TABLE `zakaznik` DISABLE KEYS;*/
INSERT INTO `zakaznik` (`id_zakaznik`, `meno`, `priezvisko`, `email`, `vek`) VALUES
	('1','Andrej','Kováč','a.kovac@post.sk',18),
	('2','Adam','Gajdoš','gajdos@centrum.cz',27),
	('3','Štefan','Franko','franko@email.cz',24),
	('4','Jakub','Hronec','papluha24@azt.sk',22),
	('5','Daniel','Polák','batman15@facebok.com',25),
	('6','Patrik','Jurek','janosik@pobox.sk',30),
	('7','Dominik','Čech','franta123@centrum.sk',19),
	('8','Karol','Varga','karci69@yahoo.com',42),
	('9','Marek','Šimko','citron@gmail.com',21),
	('10','Branislav','Rajňák','brano@hotmail.com',26);
/*!40000 ALTER TABLE `zakaznik` ENABLE KEYS;*/
UNLOCK TABLES;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/