yvjia/db/cms_page_translations.sql

DROP TABLE IF EXISTS `cms_page_translations`;

CREATE TABLE `cms_page_translations` (
    PRIMARY KEY (`id`),
    `id` BIGINT(10) AUTO_INCREMENT COMMENT 'ID',
    `page_id` BIGINT(10) NOT NULL COMMENT '内容ID',
    `language` VARCHAR(10) NOT NULL COMMENT '语种',
    `title` VARCHAR(255) NOT NULL COMMENT '内容标题',
    `description` VARCHAR(500) COMMENT '内容描述',
    `content` TEXT NOT NULL COMMENT '内容详情'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='内容翻译表';

INSERT INTO cms_page_translations(page_id, language, title, description, content) VALUES
    (1, 'zh', '关于我们', '一家致力于为用户提供智能生活解决方案的科技公司', '是一家致力于为用户提供智能生活解决方案的科技公司。我们的使命是利用最先进的人工智能技术，使每个人都能享受更智能、更便捷的生活体验。无论是通过我们的智能助手或者其他创新产品，我们都致力于为大家提供优质的服务和技术。'),
    (1, '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.'),
    (2, 'zh', '联系我们', '', '<p>联系电话：+1234567890</p><p>邮箱地址：info@WeTab.com</p><p>企业地址：XXXX街道，XX城市，XX国家</p>'),
    (2, 'en', 'Contact us', '', '<p>Phone：+1234567890</p><p>Email：info@WeTab.com</p><p>Address： XXXX Street, XX City, XX Country</p>')
;