Skip to content

GitLab

Closed
Created by 金小龙@xiaolong.jinDeveloper

添加incremental_update_config

CREATE TABLE `incremental_update_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT '0' COMMENT 'company_search表的id',
  `type` enum('domain','warning','logo','other') NOT NULL DEFAULT 'domain' COMMENT '类型',
  `max_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '最大id，用于增量更新',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_ctc` (`cid`,`type`,`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='脚本增量更新配置表，颗粒度为公司';