CREATE TABLE `admini` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(31) COLLATE utf8_czech_ci NOT NULL,
  `password` varchar(63) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `category` set('rock','jazz','vážná hudba','pop','rap','experimentální','folk','country','mluvené slovo','ambient') COLLATE utf8_czech_ci NOT NULL,
  `date` datetime NOT NULL,
  `description` varchar(1023) COLLATE utf8_czech_ci NOT NULL,
  `capacity` int(11) NOT NULL,
  `location` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;