微信小程序开发

后端数据库

drop table if exists t_article;

CREATE TABLE `t_article`
(
    `id`              bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `article_id`      varchar(64)         NOT NULL DEFAULT '' COMMENT '文章ID，UUID',
    `article_content` text                NOT NULL COMMENT '文章内容',
    `author`          varchar(50)         NOT NULL DEFAULT '0' COMMENT '作者',
    `create_time`     datetime            NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time`     datetime            NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE `uniq_article_id` (`article_id`),
    KEY `idx_create_time` (`create_time`),
    KEY `idx_update_time` (`update_time`)
) ENGINE = InnoDB
  CHARSET = utf8mb4 COMMENT '文章表';