yvjia/db/cms_banner.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/12/08 21:00:15
*/

DROP TABLE IF EXISTS `cms_banner`;
CREATE TABLE `cms_banner` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `type` TINYINT(1) COMMENT '幻灯片类型 (1首页幻灯片, 2内页幻灯片)',
    `sort` INT DEFAULT '1' COMMENT '排序',
    `status` TINYINT(1) DEFAULT '1' COMMENT '幻灯片状态 (-1禁用, 1启用)',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='资讯表';

INSERT INTO cms_banner(type, sort, status) VALUES
    (1, 1, 1)
;