UPDATE `organization_identity` SET licence_area = NULL, licence_city = NULL, licence_province = NULL, location_area = NULL, location_city = NULL, location_province = NULL; UPDATE `user_identity` SET province = NULL, city = NULL, area = NULL; UPDATE `user_info` SET residence_area = null, residence_city = null, residence_province = null; alter table user_identity modify column `province` int(2) null comment '所在地-省份', modify column `city` int(3) null comment '所在地--市', modify column `area` int(4) null comment '所在地--区'; alter table organization_identity modify column `licence_province` int(2) null comment '营业执照所在地--省', modify column `licence_city` int(3) null comment '营业执照所在地-市', modify column `licence_area` int(4) null comment '营业执照所在地-区(县)', modify column `location_province` int(2) null comment '开户行所在地-省', modify column `location_city` int(3) null comment '开户行所在地-市', modify column `location_area` int(4) null comment '开户行所在地-区(县)'; alter table user_info modify column `residence_province` int(2) null comment '居住地--省', modify column `residence_city` int(3) null comment '居住地--市', modify column `residence_area` int(4) null comment '居住地--区'; CREATE TABLE `district_glossory` ( `id` INT(4) NOT NULL, `name` VARCHAR(16) NULL COMMENT '名称', `pid` INT(4) NULL COMMENT '上级ID', `level` INT(1) NULL COMMENT '层级', PRIMARY KEY (`id`)) ENGINE = InnoDB COMMENT = '地区数据字典';