DROP TABLE IF EXISTS `cms_article_i18n`;

CREATE TABLE `cms_article_i18n` (
    PRIMARY KEY (`id`),
    `id` BIGINT(10) AUTO_INCREMENT COMMENT 'ID',
    `article_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 '资讯详情',
    `meta_keyword` VARCHAR(255) COMMENT 'SEO-Keyword',
    `meta_description` VARCHAR(500) COMMENT 'SEO-Description'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='资讯表 (翻译)';

INSERT INTO cms_article_i18n(article_id, language, title, description, content, meta_keyword, meta_description) VALUES
    (1, 'zh', '时下流行的音乐节盛况', '随着夏季的到来，各种音乐节热情洋溢', '无数欢乐的人们聚集在户外，在舞台上欢呼跳跃，享受着音乐的魔力。从摇滚、电子到流行音乐，每个音乐节都有其独特的风格和魅力，成为年轻人追捧的狂欢盛事。', '音乐,舞台,年轻人,盛事', '每个音乐节都有其独特的风格和魅力，成为年轻人追捧的狂欢盛事'),
    (1, 'en', 'The current popularity of music festivals', 'With the arrival of summer, various music festivals are in full swing', 'Countless happy people gathered outdoors, cheering and jumping on the stage, enjoying the magic of the music. From rock, electronic to pop music, each music festival has its own unique style and charm, and has become a carnival event sought after by young people.', 'Music, stage, young people, events', 'Each music festival has its own unique style and charm, and has become a carnival event sought after by young people'),
    (2, 'zh', '阿阿2', '阿阿阿阿', '阿', 'metaKeyword-2', 'metaDescription-2'),
    (2, 'en', 'aa2', 'aaaaaaaa', 'a', 'metaKeyword-2', 'metaDescription-2'),
    (3, 'zh', '吧吧3', '吧吧吧吧', '吧', 'metaKeyword-3', 'metaDescription-3'),
    (3, 'en', 'bb2', 'bbbbbbb', 'b', 'metaKeyword-3', 'metaDescription-3')
;