init_table.sql 405 B

1234567
  1. CREATE TABLE `data_lifecycle_table` (
  2. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3. `ip` varchar(20) NOT NULL DEFAULT '0' COMMENT '执行清理操作的机器ip',
  4. `last_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上次删除的记录对应的id',
  5. `last_update_time` timestamp COMMENT '上次删除的记录对应的更新时间',
  6. PRIMARY KEY (`id`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;