/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `cms_navigation_i18n`;
CREATE TABLE `cms_navigation_i18n` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `navigation_id` BIGINT NOT NULL COMMENT '导航ID',
    `language` VARCHAR(10) NOT NULL COMMENT '语种',
    `navigation_name` VARCHAR(255) NOT NULL COMMENT '菜单名称',
    `link` VARCHAR(1000) COMMENT '链接',
    `link_start_with` text COMMENT '链接匹配路径'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='导航翻译表';

INSERT INTO cms_navigation_i18n(navigation_id, language, navigation_name, link, link_start_with) VALUES
    (1, 'zh', '首页', '/', null),
    (1, 'en', 'Home', '/', null),
    (2, 'zh', '关于我们', '/page/about', null),
    (2, 'en', 'About', '/page/about', null),
    (3, 'zh', '资讯中心', '/article/list', '/article'),
    (3, 'en', 'Article', '/article/list', '/article'),
    (3, 'zh', '联系我们', '/page/contact', null),
    (3, 'en', 'Concat us', '/page/contact', null)
;