2017-05-15.sql 520 B

12345678910111213
  1. alter table `demand`
  2. change column `release` `release_status` int(1) comment '是否发布(0-未发布,1-发布)';
  3. CREATE TABLE `demand_log` (
  4. `id` VARCHAR(36) NOT NULL,
  5. `demand_id` VARCHAR(36) NOT NULL COMMENT '需求表主键',
  6. `status` INT(1) NOT NULL COMMENT '状态',
  7. `operator` VARCHAR(36) NULL COMMENT '操作人',
  8. `principal` VARCHAR(36) NULL,
  9. `recored_time` DATETIME NOT NULL COMMENT '记录时间',
  10. `comment` VARCHAR(128) NULL COMMENT '备注',
  11. PRIMARY KEY (`id`))
  12. ENGINE = InnoDB