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