| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- 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 = '地区数据字典';
- delete from `permission` where name = '系统设置--管理员列表';
- update `permission` set url = 'api/admin/supervise/insertAdmin'
- where url = 'api/admin/insertAdmin';
- update `permission` set url = 'api/admin/supervise/resetPwd'
- where url = 'api/admin/resetPwd';
- update `permission` set url = '/api/admin/supervise/updateAdmin'
- where url = 'api/admin/updateAdmin';
- insert into `permission`(`id`, `url`, `name`)
- values
- (UUID(), 'api/admin/supervise/adminList', '系统设置--管理员列表');
|