DROP TABLE IF EXISTS `cms_page_i18n`;
CREATE TABLE `cms_page_i18n` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `page_sign` VARCHAR(255) NOT NULL COMMENT '内容标识',
    `language` VARCHAR(10) NOT NULL COMMENT '语种',
    `title` VARCHAR(255) NOT NULL COMMENT '内容标题',
    `description` VARCHAR(500) COMMENT '内容描述',
    `content` TEXT NOT NULL COMMENT '内容详情',
    `meta_keyword` VARCHAR(255) COMMENT 'SEO-Keyword',
    `meta_description` VARCHAR(500) COMMENT 'SEO-Description',
    INDEX `idx_page_sign` (`page_sign`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='内容翻译表';

INSERT INTO cms_page_i18n(page_sign, language, title, description, content) VALUES
    ('about', 'zh', '关于我们', '一家致力于为用户提供智能生活解决方案的科技公司', '是一家致力于为用户提供智能生活解决方案的科技公司。我们的使命是利用最先进的人工智能技术，使每个人都能享受更智能、更便捷的生活体验。无论是通过我们的智能助手或者其他创新产品，我们都致力于为大家提供优质的服务和技术。'),
    ('about', 'en', 'About us', 'A technology company dedicated to providing intelligent lifestyle solutions for users', 'WeTab is a technology company dedicated to providing intelligent lifestyle solutions for users. Our mission is to leverage cutting-edge artificial intelligence technology to enable everyone to enjoy a smarter and more convenient life experience. Whether through our smart assistant or other innovative products, we are committed to providing high-quality service and technology.'),
    ('contact', 'zh', '联系我们', '', '<p>联系电话：+1234567890</p><p>邮箱地址：info@WeTab.com</p><p>企业地址：XXXX街道，XX城市，XX国家</p>'),
    ('contact', 'en', 'Contact us', '', '<p>Phone：+1234567890</p><p>Email：info@WeTab.com</p><p>Address： XXXX Street, XX City, XX Country</p>')
;