CREATE TABLE `hotel` (
 `ID` int(11) NOT NULL AUTO_INCREMENT,
 `invia_ID` int(11) NOT NULL,
 `updated` datetime NOT NULL,
 `stars` int(11) NOT NULL,
 `rating` float NOT NULL,
 `rating_count` int(11) NOT NULL,
 `rating_ubytovani` float NOT NULL,
 `rating_strava` float NOT NULL,
 `rating_okoli` float NOT NULL,
 `rating_cena` float NOT NULL,
 `lat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `lng` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `invia_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `destination_ID` int(11) NOT NULL,
 `locality_ID` int(11) DEFAULT NULL,
 `content_poloha` longtext COLLATE utf8_unicode_ci,
 `content_vybaveni` longtext COLLATE utf8_unicode_ci,
 `content_ubytovani` longtext COLLATE utf8_unicode_ci,
 `content_strava` longtext COLLATE utf8_unicode_ci,
 `content_sluzby` longtext COLLATE utf8_unicode_ci,
 `master_rating` float DEFAULT NULL,
 PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=12378 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci


CREATE TABLE `term` (
 `ID` int(11) NOT NULL AUTO_INCREMENT,
 `hotel_ID` int(11) NOT NULL,
 `date_from` date NOT NULL,
 `date_to` date NOT NULL,
 `length` int(11) NOT NULL,
 `currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `price` float NOT NULL,
 `tax` float NOT NULL,
 `totalprice` float NOT NULL,
 `discount` float NOT NULL,
 `food` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `transportation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `termtype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `url` text COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`ID`),
 KEY `hotel_ID` (`hotel_ID`),
 KEY `termtype` (`termtype`)
) ENGINE=MyISAM AUTO_INCREMENT=290565 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `airport` (
 `ID` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `airport_term` (
 `ID` int(11) NOT NULL AUTO_INCREMENT,
 `term_ID` int(11) NOT NULL,
 `airport_ID` int(11) NOT NULL,
 PRIMARY KEY (`ID`),
 KEY `term_ID` (`term_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=291476 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci