2017-06-07.sql 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. UPDATE `organization_identity`
  2. SET licence_area = NULL,
  3. licence_city = NULL,
  4. licence_province = NULL,
  5. location_area = NULL,
  6. location_city = NULL,
  7. location_province = NULL;
  8. UPDATE `user_identity`
  9. SET province = NULL,
  10. city = NULL,
  11. area = NULL;
  12. UPDATE `user_info`
  13. SET residence_area = null,
  14. residence_city = null,
  15. residence_province = null;
  16. alter table user_identity
  17. modify column `province` int(2) null comment '所在地-省份',
  18. modify column `city` int(3) null comment '所在地--市',
  19. modify column `area` int(4) null comment '所在地--区';
  20. alter table organization_identity
  21. modify column `licence_province` int(2) null comment '营业执照所在地--省',
  22. modify column `licence_city` int(3) null comment '营业执照所在地-市',
  23. modify column `licence_area` int(4) null comment '营业执照所在地-区(县)',
  24. modify column `location_province` int(2) null comment '开户行所在地-省',
  25. modify column `location_city` int(3) null comment '开户行所在地-市',
  26. modify column `location_area` int(4) null comment '开户行所在地-区(县)';
  27. alter table user_info
  28. modify column `residence_province` int(2) null comment '居住地--省',
  29. modify column `residence_city` int(3) null comment '居住地--市',
  30. modify column `residence_area` int(4) null comment '居住地--区';
  31. CREATE TABLE `district_glossory` (
  32. `id` INT(4) NOT NULL,
  33. `name` VARCHAR(16) NULL COMMENT '名称',
  34. `pid` INT(4) NULL COMMENT '上级ID',
  35. `level` INT(1) NULL COMMENT '层级',
  36. PRIMARY KEY (`id`))
  37. ENGINE = InnoDB
  38. COMMENT = '地区数据字典';
  39. delete from `permission` where name = '系统设置--管理员列表';
  40. update `permission` set url = 'api/admin/supervise/insertAdmin'
  41. where url = 'api/admin/insertAdmin';
  42. update `permission` set url = 'api/admin/supervise/resetPwd'
  43. where url = 'api/admin/resetPwd';
  44. update `permission` set url = '/api/admin/supervise/updateAdmin'
  45. where url = 'api/admin/updateAdmin';
  46. insert into `permission`(`id`, `url`, `name`)
  47. values
  48. (UUID(), 'api/admin/supervise/adminList', '系统设置--管理员列表');