2017-06-06.sql 313 B

12345678910
  1. alter table `admin`
  2. add column `superior_id` varchar(36) null comment '上级管理用户ID',
  3. add column `city` varchar(16) 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`));