CREATE TABLE `letisko2`.`let` (
  `id_letu` int(5) NOT NULL AUTO_INCREMENT,
  `id_lietadla` int(5) DEFAULT NULL,
  `start_mesto` varchar(30) COLLATE utf8_slovak_ci NOT NULL,
  `ciel_mesto` varchar(30) COLLATE utf8_slovak_ci NOT NULL,
  `cas_odletu` varchar(5) COLLATE utf8_slovak_ci NOT NULL,
  `cas_priletu` varchar(5) COLLATE utf8_slovak_ci NOT NULL,
  `terminal` varchar(2) COLLATE utf8_slovak_ci NOT NULL,
  PRIMARY KEY (`id_letu`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci

CREATE TABLE  `letisko2`.`technik` (
  `id_technika` int(5) NOT NULL AUTO_INCREMENT,
  `meno` varchar(20) COLLATE utf8_slovak_ci NOT NULL,
  `priezvisko` varchar(20) COLLATE utf8_slovak_ci NOT NULL,
  `vek` int(5) unsigned NOT NULL,
  `telefon` varchar(20) COLLATE utf8_slovak_ci DEFAULT NULL,
  `email` varchar(40) COLLATE utf8_slovak_ci DEFAULT NULL,
  `cislo_uctu` varchar(30) COLLATE utf8_slovak_ci NOT NULL,
  `mesto` varchar(30) COLLATE utf8_slovak_ci NOT NULL,
  `adresa` varchar(40) COLLATE utf8_slovak_ci NOT NULL,
   PRIMARY KEY (`id_technika`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci

CREATE TABLE  `letisko2`.`vykon_letu` (
  `id_vykonu_letu` int(5) NOT NULL AUTO_INCREMENT,
  `id_letu` int(5) NOT NULL,
  `datum` date DEFAULT NULL,
  PRIMARY KEY (`id_vykonu_letu`),
  KEY `id_letu` (`id_letu`),
  CONSTRAINT `vykon_letu_ibfk_1` FOREIGN KEY (`id_letu`) REFERENCES `let` (`id_letu`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci

CREATE TABLE  `letisko2`.`udrzba_letu` (
  `id_technika` int(5) NOT NULL,
  `id_vykonu_letu` int(5) NOT NULL,
  KEY `id_technika` (`id_technika`),
  KEY `id_vykonu_letu` (`id_vykonu_letu`),
  CONSTRAINT `udrzba_letu_ibfk_2` FOREIGN KEY (`id_technika`) REFERENCES `technik` (`id_technika`),
  CONSTRAINT `udrzba_letu_ibfk_1` FOREIGN KEY (`id_vykonu_letu`) REFERENCES `vykon_letu` (`id_vykonu_letu`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci