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
2021-07-13 15:30:22
363KB
mysql
1