﻿CREATE TABLE IF NOT EXISTS `accounting` (
`id` int(11) NOT NULL,
  `id_zarizeni` varchar(12) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL,
  `nazev_zarizeni` varchar(20) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL,
  `ip_zarizeni` varchar(15) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL,
  `mac_zarizeni` varchar(17) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL,
  `datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `stav` int(11) DEFAULT NULL,
  `poznamka` varchar(40) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;


ALTER TABLE `accounting`
 ADD PRIMARY KEY (`id`);


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