CREATE TABLE IF NOT EXISTS `K1` (
`ID` INT(10) NOT NULL AUTO_INCREMENT ,
`nazev` VARCHAR( 255 ) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`rozdeleni` INT(1) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci

CREATE TABLE IF NOT EXISTS `K2` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`nazev` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`ID_K1` int(10) NOT NULL,
PRIMARY KEY (`ID`),
KEY (`ID_K1`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci



============================ produkt ============================

CREATE TABLE IF NOT EXISTS `produkt` (
`ID` int(10) NOT NULL AUTO_INCREMENT, 
`ID_K2` int(10) NOT NULL,
`ID_dodavatele` int(10) NOT NULL, 
`ID_sazby` int(10) NOT NULL,
`titulek` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`znacka` varchar(30) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL , 
`model` varchar(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL , 
`cena` int(9) NOT NULL,
`sleva` int(2), 
`skladem` int(4), 
`parametry_k` text,
`parametry_d` text,
`informace` text, 
`stav` varchar(10),
`karoserie` varchar(15), 
`palivo` varchar(9),
`najeto` int(6), 
`vyrobeno` DATE,
`rezervace` varchar(15),
`kontrola` varchar(3) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
PRIMARY KEY (`ID`),
KEY (`ID_K3`,`ID_dodavatele`,`ID_sazby`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


============================ zakaznik ============================

CREATE TABLE IF NOT EXISTS `zakaznik` (
`ID` int(11) NOT NULL AUTO_INCREMENT, 
`nick` varchar(50) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`heslo` varchar(255) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`nahrada` varchar(255) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`email` varchar(255) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`jmeno` varchar(50) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`prijmeni` varchar(50) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`telefon` int(9), 
`typ` varchar(5) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL, 
`ulice` varchar(50) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`obec` varchar(50) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`psc` int(5) NOT NULL,
`zeme` varchar(50) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL ,
`ic` int(15),
`dic` int(15),
`otazka` varchar(255) NOT NULL ,
`odpoved` varchar(255) NOT NULL,
`faktura` text,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


============================ dodavatele ============================

CREATE TABLE `dodavatel` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ID_produkt` int(10) NOT NULL,
`druh` varchar(5) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL,
`jmeno` varchar(255) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL,
`telefon` int(9),
`kontakt` text CHARSET utf8 COLLATE utf8_czech_ci NOT NULL,
PRIMARY KEY (`ID`),
KEY (`ID_produkt`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci


============================ kosik ============================

CREATE TABLE IF NOT EXISTS `kosik` (
`ID` int(10) NOT NULL AUTO_INCREMENT, 
`ID_produkt` int(10) NOT NULL,
`ID_zakaznik` int(10) NOT NULL,
`datum` date NOT NULL,
`pocet` int(4) NOT NULL,
`poznamka` text CHARSET utf8 COLLATE utf8_czech_ci NOT NULL,
PRIMARY KEY (`ID`),
KEY (`ID_produkt`, `ID_zakaznik`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci


============================ objednavka ============================

CREATE TABLE IF NOT EXISTS `objednavka` (
`ID` int(11) NOT NULL AUTO_INCREMENT, 
`ID_produkt` int(10) NOT NULL,
`ID_zakaznik` int(10) NOT NULL,
`ID_prodejce` int(10) NOT NULL,
`datum_o` DATE NOT NULL,
`datum_v` DATE NOT NULL,
`cislo` INT(10) NOT NULL,
`doprava` varchar(50) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL,
`platba` varchar(50) CHARSET utf8 COLLATE utf8_czech_ci NOT NULL,
`pocet` int(4) NOT NULL,
`poznamka` text CHARSET utf8 COLLATE utf8_czech_ci NOT NULL,
PRIMARY KEY (`ID`),
KEY (`ID_produkt`, `ID_zakaznik`,`ID_prodejce`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci


============================ prodejce ============================

CREATE TABLE IF NOT EXISTS `prodejce` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`jmeno` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`prijmeni` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`nick` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`heslo` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`email` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`telefon` INT(9) NOT NULL ,
`rozdeleni` INT(2) NOT NULL ,
PRIMARY KEY (`ID`)
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_czech_ci;


============================ admin ============================

CREATE TABLE IF NOT EXISTS `admin` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`jmeno` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`prijmeni` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`nick` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`heslo` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`email` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`telefon` INT(9) NOT NULL ,
PRIMARY KEY (`ID`)
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_czech_ci

CREATE TABLE IF NOT EXISTS `sazby` (
`ID` INT(10) NOT NULL AUTO_INCREMENT ,
`dph_m`	INT(2) NOT NULL,
`dph_v`	INT(2) NOT NULL,
`posta`	INT(4) NOT NULL,
`ppl`	INT(4) NOT NULL,
`osobne`	INT(4) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci

ALTER TABLE `K2` ADD FOREIGN KEY (`ID_K1`) REFERENCES `K1` (`ID`)
ALTER TABLE `produkt` ADD FOREIGN KEY (`ID_K2`) REFERENCES `K2` (`ID`)
ALTER TABLE `produkt` ADD FOREIGN KEY (`ID_sazby`) REFERENCES `sazby` (`ID`)
ALTER TABLE `kosik` ADD FOREIGN KEY (`ID_produkt`) REFERENCES `produkt` (`ID`)
ALTER TABLE `kosik` ADD FOREIGN KEY (`ID_zakaznik`) REFERENCES `zakaznik` (`ID`)
ALTER TABLE `objednavka` ADD FOREIGN KEY (`ID_produkt`) REFERENCES `produkt` (`ID`)
ALTER TABLE `objednavka` ADD FOREIGN KEY (`ID_zakaznik`) REFERENCES `zakaznik` (`ID`)
ALTER TABLE `objednavka` ADD FOREIGN KEY (`ID_prodejce`) REFERENCES `prodejce` (`ID`)






























