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 = '地区数据字典';