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