yvjia/db/cms_banner_i18n.sql

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

DROP TABLE IF EXISTS `cms_banner_i18n`;
CREATE TABLE `cms_banner_i18n` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `banner_id` BIGINT NOT NULL COMMENT '幻灯片ID',
    `language` VARCHAR(10) NOT NULL COMMENT '语种',
    `title` VARCHAR(255) NOT NULL COMMENT '幻灯片标题',
    `link` VARCHAR(1000) COMMENT '链接',
    `image` VARCHAR(1000) NOT NULL COMMENT '图片',
    `image_thumb` VARCHAR(1000) NOT NULL COMMENT '图片 (缩略图)'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片表 (翻译)';

INSERT INTO cms_banner_i18n(banner_id, language, title, link, image, image_thumb) VALUES
    (1, 'zh', '幻灯片-A', '/PageDao/index/index', '/uploads/banners/banners.1680162484582.png', '/uploads/banners/banners.1680162484582.png'),
    (1, 'zh-tw', '幻燈片-A', '/PageDao/index/index', '/uploads/banners/banners.1680162484582.png', '/uploads/banners/banners.1680162484582.png'),
    (1, 'en', 'aaaadfqwea', '/PageDao/index/index', '/uploads/banners/banners.1680162484582.png', '/uploads/banners/banners.1680162484582.png')
;