2017-06-06.sql 806 B

123456789101112131415161718192021222324
  1. alter table `admin`
  2. add column `superior_id` varchar(36) null comment '上级管理用户ID',
  3. add column `city` int(3) null comment '所在市';
  4. CREATE TABLE `industry_category` (
  5. `id` INT NOT NULL,
  6. `name` VARCHAR(45) NULL,
  7. `pid` INT NULL,
  8. `value` DECIMAL(4,2) NULL,
  9. PRIMARY KEY (`id`));
  10. CREATE TABLE .`admin_location` (
  11. `id` VARCHAR(36) NOT NULL,
  12. `admin_id` VARCHAR(36) NOT NULL COMMENT '管理员ID',
  13. `province` INT(2) NOT NULL COMMENT '省份',
  14. `city` INT(3) NULL COMMENT '市',
  15. PRIMARY KEY (`id`))
  16. ENGINE = InnoDB
  17. COMMENT = '管理员地区';
  18. alter table user_identity
  19. modify column `province` int(2) null comment '所在地-省份',
  20. modify column `city` int(3) null comment '所在地--市',
  21. modify column `area` int(4) null comment '所在地--区';