DROP TABLE IF EXISTS `sentiment_spider_site_rule`;
CREATE TABLE `sentiment_spider_site_rule`
(
    `id`             BIGINT(20) NOT NULL COMMENT 'ID',
    `site_name`      VARCHAR(50) NOT NULL COMMENT '网站名称',
    `collector_name` VARCHAR(50) NOT NULL COMMENT '采集器名称',
    `url_patterns`   text        NOT NULL COMMENT '匹配URL地址',
    `start_urls`     text        NOT NULL COMMENT '启动地址',
    `created_time`   DATETIME    NOT NULL COMMENT '创建时间',
    `created_by`     BIGINT(20) NOT NULL COMMENT '创建人',
    `updated_time`   DATETIME NULL DEFAULT NULL COMMENT '修改时间',
    `updated_by`     BIGINT(20) NULL DEFAULT NULL COMMENT '修改人',
    PRIMARY KEY (`id`)
) COMMENT ='采集网站规则' ENGINE = InnoDB;

delete
from sentiment_spider_event
where id is not null;
delete
from sentiment_spider_result
where id is not null;
