| 123456789101112131415161718192021222324 |
- alter table `admin`
- add column `superior_id` varchar(36) null comment '上级管理用户ID',
- add column `city` int(3) null comment '所在市';
- CREATE TABLE `industry_category` (
- `id` INT NOT NULL,
- `name` VARCHAR(45) NULL,
- `pid` INT NULL,
- `value` DECIMAL(4,2) NULL,
- PRIMARY KEY (`id`));
-
- CREATE TABLE .`admin_location` (
- `id` VARCHAR(36) NOT NULL,
- `admin_id` VARCHAR(36) NOT NULL COMMENT '管理员ID',
- `province` INT(2) NOT NULL COMMENT '省份',
- `city` INT(3) NULL COMMENT '市',
- PRIMARY KEY (`id`))
- ENGINE = InnoDB
- COMMENT = '管理员地区';
- 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 '所在地--区';
|