CREATE TABLE `rooms101_rtsdev`.`tbl_openweather`  (
                                               `id` int(0) NOT NULL AUTO_INCREMENT,
                                               `city_id` int(0) NOT NULL COMMENT ' openweather CityId',
                                               `name` varchar(80) NULL,
                                               `lat` decimal(11, 8) NULL,
                                               `lon` decimal(10, 8) NULL,
                                               `weather_id` int(0) NULL,
                                               `weather_main` varchar(80) NULL,
                                               `weather_description` varchar(255) NULL,
                                               `weather_icon` varchar(10) NULL,
                                               `temp` varchar(10) NULL,
                                               `expire` datetime NULL,
                                               PRIMARY KEY (`id`)
);
