SQL TIU4

-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Hostiteľ: localhost
-- Vygenerované: Út 22.Okt 2013, 20:28
-- Verzia serveru: 5.5.24-log
-- Verzia PHP: 5.3.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

CREATE DATABASE eshop DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;
USE eshop;

--
-- Databáza: `eshop`
--

-- --------------------------------------------------------

--
-- Štruktúra tabuľky pre tabuľku `objednavka`
--

CREATE TABLE IF NOT EXISTS `objednavka` (
  `id_objednavka` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `datum` date NOT NULL,
  `platba` varchar(15) COLLATE utf8_slovak_ci NOT NULL,
  `dodavka` varchar(15) COLLATE utf8_slovak_ci 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_idx` (`zakaznik_id_zakaznik`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=13 ;

--
-- Sťahujem dáta pre tabuľku `objednavka`
--

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);

-- --------------------------------------------------------

--
-- Štruktúra tabuľky pre tabuľku `objednavka_has_tovar`
--

CREATE TABLE IF NOT EXISTS `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_idx` (`tovar_id_tovar`),
  KEY `fk_objednavka_has_tovar_objednavka1_idx` (`objednavka_id_objednavka`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

--
-- Sťahujem dáta pre tabuľku `objednavka_has_tovar`
--

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);

-- --------------------------------------------------------

--
-- Štruktúra tabuľky pre tabuľku `tovar`
--

CREATE TABLE IF NOT EXISTS `tovar` (
  `id_tovar` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nazov` varchar(45) COLLATE utf8_slovak_ci 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_idx` (`vyrobca_id_vyrobca`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=21 ;

--
-- Sťahujem dáta pre tabuľku `tovar`
--

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, 'Huawei P9 Lite', 380, 24, 9),
(15, 'Asus Zenbook Flip UX360CA', 608, 24, 4),
(16, 'Kingston UV400 SSD, 240GB', 73.8, 24, 5),
(17, 'Corsair zdroj 650W VS', 59.6, 24, 6),
(18, 'Kingston microSDHC 32GB UHS-I', 13, 24, 5 ),
(19, 'Asus ZenFone Max ZC550KL', 219, 36, 4),
(20, 'DDRAM2 1GB 400 CL3', 20, 24, 7);

-- --------------------------------------------------------

--
-- Štruktúra tabuľky pre tabuľku `vyrobca`
--

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

--
-- Sťahujem dáta pre tabuľku `vyrobca`
--

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),
(9, 'Huawei', 'Čína', 3);

-- --------------------------------------------------------

--
-- Štruktúra tabuľky pre tabuľku `zakaznik`
--

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

--
-- Sťahujem dáta pre tabuľku `zakaznik`
--

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@azet.sk', 22),
(5, 'Daniel', 'Polák', 'batman15@facebook.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, 'Peter', 'Krajňák', 'petokrajnak@pobox.sk', 26),
(11, 'Jakub', 'Tóth', 'jato@outlook.com', 40),
(12, 'Šimon', 'Slivka', 'simonplum@gmail.com', 35),
(13, 'Vladimír', 'Petráš', 'superman37@azet.sk', 38),
(14, 'Pavol', 'Dudáš', 'dudi@post.sk', 29),
(15, 'Branislav', 'Rajňák', 'brano@hotmail.com', 26);

--
-- Obmedzenie pre exportované tabuľky
--

--
-- Obmedzenie pre tabuľku `objednavka`
--
ALTER TABLE `objednavka`
  ADD CONSTRAINT `fk_objednavka_zakaznik` FOREIGN KEY (`zakaznik_id_zakaznik`) REFERENCES `zakaznik` (`id_zakaznik`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Obmedzenie pre tabuľku `objednavka_has_tovar`
--
ALTER TABLE `objednavka_has_tovar`
  ADD CONSTRAINT `fk_objednavka_has_tovar_objednavka1` FOREIGN KEY (`objednavka_id_objednavka`) REFERENCES `objednavka` (`id_objednavka`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_objednavka_has_tovar_tovar1` FOREIGN KEY (`tovar_id_tovar`) REFERENCES `tovar` (`id_tovar`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Obmedzenie pre tabuľku `tovar`
--
ALTER TABLE `tovar`
  ADD CONSTRAINT `fk_tovar_vyrobca1` FOREIGN KEY (`vyrobca_id_vyrobca`) REFERENCES `vyrobca` (`id_vyrobca`) ON DELETE NO ACTION ON UPDATE NO ACTION;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;