webmagic.sql 687 Bytes

Edit Raw Blame History

DROP TABLE IF EXISTS `nature_article`;
CREATE TABLE `nature_article` (
          `id` bigint NOT NULL AUTO_INCREMENT,
          `article_code` varchar(64) DEFAULT NULL COMMENT '文章标识',
          `author_name` varchar(256) DEFAULT NULL COMMENT '作者名称',
          `title` varchar(256) DEFAULT NULL COMMENT '文章标题',
          `publish_time` varchar(64) DEFAULT NULL COMMENT '发布时间',
          `email_info` varchar(512) DEFAULT NULL COMMENT '邮箱信息',
          PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='nature-文章信息';


alter table `nature_article` add column `article_code` varchar(256) DEFAULT NULL COMMENT '文章标识';