20151225.sql 419 B

1234567891011
  1. CREATE TABLE `config_history` (
  2. `id` BIGINT NOT NULL AUTO_INCREMENT,
  3. `config_id` BIGINT NOT NULL,
  4. `old_value` LONGTEXT NOT NULL,
  5. `new_value` LONGTEXT NOT NULL,
  6. `create_time` VARCHAR(14) NOT NULL DEFAULT '99991231235959',
  7. PRIMARY KEY (`id`)
  8. )DEFAULT CHARSET=utf8 ENGINE=InnoDB;
  9. ALTER TABLE `config`
  10. ADD COLUMN `status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '状态:1是正常 0是删除' AFTER `type`;