SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for city_list_ru -- ---------------------------- CREATE TABLE `city_list_ru` ( `id` int(11) NOT NULL COMMENT 'Country ID', `title` text NOT NULL COMMENT 'Name country (Title)', `area` text, `country` text, `region` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for country_list_ru -- ---------------------------- CREATE TABLE `country_list_ru` ( `id` int(11) NOT NULL COMMENT 'Country ID', `title` text NOT NULL COMMENT 'Name country (Title)', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for region_list_ru -- ---------------------------- CREATE TABLE `region_list_ru` ( `id` int(11) NOT NULL COMMENT 'Country ID', `title` text NOT NULL COMMENT 'Name country (Title)', `country` int(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;