CREATE TABLE IF NOT EXISTS `zarizeni` (
`id` int(11) NOT NULL,
  `id_zarizeni` varchar(12) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  `mac_zarizeni` varchar(17) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  `nazev_zarizeni` varchar(20) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  `stav` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


ALTER TABLE `zarizeni`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_zarizeni` (`id_zarizeni`);


ALTER TABLE `zarizeni`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;