中国地区(省市区,大区,中英文翻译)

CREATE TABLE `cn_base_district` ( `district_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID', `district_name` varchar(50) NOT NULL COMMENT '地区名称', `district_name_en` varchar(50) NOT NULL DEFAULT '', `district_parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地区父ID', `district_displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `district_region` varchar(3) NOT NULL DEFAULT '' COMMENT '大区名称', `district_is_level` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '地区深度，从1开始', `district_is_leaf` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '无子类', PRIMARY KEY (`district_id`), KEY `area_parent_id` (`district_parent_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=46743 DEFAULT CHARSET=utf8 COMMENT='地区表'; -- ---------------------------- -- Records of cn_base_district -- ---------------------------- INSERT INTO `cn_base_district` VALUES ('1', '北京市', 'BeiJing City', '0', '0', '华北', '1', '0'); INSERT INTO `cn_base_district` VALUES ('2', '天津市', 'TianJin City', '0', '0', '华北', '1', '0'); CREATE TABLE `cn_base_district` ( `district_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID', `district_name` varchar(50) NOT NULL COMMENT '地区名称', `district_name_en` varchar(50) NOT NULL DEFAULT '', `district_parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地区父ID', `district_displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `district_region` varchar(3) NOT NULL DEFAULT '' COMMENT '大区名称', `district_is_level` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '地区深度，从1开始', `district_is_leaf` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '无子类', PRIMARY KEY (`district_id`), KEY `area_parent_id` (`district_parent_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=46743 DEFAULT CHARSET=utf8 COMMENT='地区表'; -- ---------------------------- -- Records of cn_base_district -- ---------------------------- INSERT INTO `cn_base_district` VALUES ('1', '北京市', 'BeiJing City', '0', '0', '华北', '1', '0