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(10) AUTO_INCREMENT COMMENT 'ID',
    `title` VARCHAR(255) NOT NULL COMMENT '幻灯片标题',
    `type` TINYINT(1) COMMENT '幻灯片类型 (1首页幻灯片, 2内页幻灯片)',
    `link` VARCHAR(500) COMMENT '链接',
    `image` VARCHAR(500) NOT NULL COMMENT '图片',
    `image_thumb` VARCHAR(500) NOT NULL COMMENT '图片 (缩略图)',
    `sort` BIGINT(10) 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 '更新时间',
    INDEX `idx_title` (`title`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='资讯表';

INSERT INTO cms_banner(title, link, image, image_thumb, sort) VALUES
    ('aaa', '/page/index/index', '/uploads/banners/banners.1680162484582.png', '/uploads/banners/banners.1680162484582.png', 1)
;