/** Source Server Version: 8.0.31 Source Database: backendsys Date: 2025/03/29 17:09:22 */ DROP TABLE IF EXISTS `cms_article_i18n`; CREATE TABLE `cms_article_i18n` ( PRIMARY KEY (`id`), `id` BIGINT AUTO_INCREMENT COMMENT 'ID', `article_id` BIGINT 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, 'zh-tw', '夏日戶外露營指南', '如何在戶外享受舒適露營', '夏天是露營的最佳季節,以下是一些實用的露營技巧:
希望這些技巧能幫助你在大自然中度過一個愉快的露營之旅!
', '露營,戶外,指南', '一份全面的戶外露營指南,幫助你享受大自然'), (1, 'en', 'Summer Camping Guide', 'How to enjoy comfortable camping outdoors', 'Summer is the perfect season for camping. Here are some useful camping tips:
Hope these tips help you enjoy a pleasant camping trip in nature!
', 'Camping, outdoors, guide', 'A comprehensive camping guide to help you enjoy nature'), (2, 'zh', '城市夜景摄影技巧', '捕捉城市夜晚的美丽瞬间', '城市夜景摄影可以捕捉到独特的光影效果,以下是一些技巧:
通过这些技巧,你可以拍摄出令人惊叹的城市夜景照片!
', '摄影,夜景,技巧', '捕捉城市夜晚的美丽瞬间'), (2, 'zh-tw', '城市夜景攝影技巧', '捕捉城市夜晚的美麗瞬間', '城市夜景攝影可以捕捉到獨特的光影效果,以下是一些技巧:
通過這些技巧,你可以拍攝出令人驚嘆的城市夜景照片!
', '攝影,夜景,技巧', '捕捉城市夜晚的美麗瞬間'), (2, 'en', 'Urban Night Photography Tips', 'Capturing the beauty of the city at night', 'Capturing the beauty of urban night scenes can produce unique lighting effects. Here are some tips:
With these tips, you can capture amazing urban night photos!
', 'Photography, night view, tips', 'Capturing the beauty of the city at night'), (3, 'zh', '春季赏花好去处', '推荐几个适合赏花的地方', '春天是赏花的好季节,以下是一些国内最美的赏花地点:
这些地方不仅能让你欣赏到美丽的花朵,还能感受春天的气息。
', '赏花,春季,地点', '推荐几个适合赏花的地方'), (3, 'zh-tw', '春季賞花好去處', '推薦幾個適合賞花的地方', '春天是賞花的好季節,以下是一些國內最美的賞花地點:
這些地方不僅能讓你欣賞到美麗的花朵,還能感受春天的氣息。
', '賞花,春季,地點', '推薦幾個適合賞花的地方'), (3, 'en', 'Best Flower Viewing Spots in Spring', 'Recommend some great places for flower viewing', 'Spring is the perfect season for flower viewing. Here are some of the most beautiful flower viewing spots in the country:
These places not only allow you to enjoy beautiful flowers but also let you feel the spring atmosphere.
', 'Flower viewing, spring, locations', 'Recommend some great places for flower viewing'), (4, 'zh', '健身新手入门指南', '如何开始你的健身之旅', '健身可以改善身体素质和健康状况,以下是一些入门建议:
希望这些指南能帮助你迈出健身的第一步!
', '健身,新手,指南', '帮助你开始健身之旅'), (4, 'zh-tw', '健身新手入門指南', '如何開始你的健身之旅', '健身可以改善身體素質和健康狀況,以下是一些入門建議:
希望這些指南能幫助你邁出健身的第一步!
', '健身,新手,指南', '幫助你開始健身之旅'), (4, 'en', 'Fitness Beginner\'s Guide', 'How to start your fitness journey', 'Fitness can improve physical fitness and health. Here are some tips for getting started:
Hope these guides help you take the first step in fitness!
', 'Fitness, beginner, guide', 'Help you start your fitness journey'), (5, 'zh', '冬季滑雪攻略', '如何享受滑雪的乐趣', '冬季是滑雪的最佳季节,以下是一些滑雪技巧:
希望这些攻略能帮助你在雪地上尽情驰骋!
', '滑雪,冬季,攻略', '享受滑雪的乐趣'), (5, 'zh-tw', '冬季滑雪攻略', '如何享受滑雪的樂趣', '冬季是滑雪的最佳季節,以下是一些滑雪技巧:
希望這些攻略能幫助你在雪地上盡情馳騁!
', '滑雪,冬季,攻略', '享受滑雪的樂趣'), (5, 'en', 'Winter Skiing Tips', 'How to enjoy skiing', 'Winter is the perfect season for skiing. Here are some skiing tips:
Hope these tips help you enjoy skiing on the snow!
', 'Skiing, winter, tips', 'Enjoy skiing'), (6, 'zh', '春季养生小贴士', '春季如何保持健康', '春季是万物复苏的季节,也是养生的好时机。以下是一些春季养生的小贴士:
希望这些小贴士能帮助你度过一个健康的春季!
', '春季,养生,健康', '春季养生小贴士,帮助你保持健康'), (6, 'zh-tw', '春季養生小貼士', '春季如何保持健康', '春季是萬物復甦的季節,也是養生的好時機。以下是一些春季養生的小貼士:
希望這些小貼士能幫助你度過一個健康的春季!
', '春季,養生,健康', '春季養生小貼士,幫助你保持健康'), (6, 'en', 'Spring Health Tips', 'How to stay healthy in spring', 'Spring is the season of renewal and a great time for health maintenance. Here are some tips for staying healthy in spring:
Hope these tips help you have a healthy spring!
', 'Spring, health, tips', 'Spring health tips to keep you in good shape'), (7, 'zh', '家庭园艺入门指南', '如何打造自己的小花园', '园艺不仅能美化环境,还能带来乐趣。以下是一些家庭园艺的入门建议:
希望这些指南能帮助你打造一个美丽的小花园!
', '园艺,家庭,入门', '家庭园艺入门指南,打造你的小花园'), (7, 'zh-tw', '家庭園藝入門指南', '如何打造自己的小花園', '園藝不仅能美化環境,還能帶來樂趣。以下是一些家庭園藝的入門建議:
希望這些指南能幫助你打造一個美麗的小花園!
', '園藝,家庭,入門', '家庭園藝入門指南,打造你的小花園'), (7, 'en', 'Home Gardening Beginner\'s Guide', 'How to create your own little garden', 'Gardening not only beautifies the environment but also brings joy. Here are some tips for getting started with home gardening:
Hope these guides help you create a beautiful little garden!
', 'Gardening, home, beginner', 'Home gardening guide to create your own garden'), (8, 'zh', '夏季防晒全攻略', '如何有效防晒', '夏季阳光强烈,防晒至关重要。以下是一些防晒建议:
希望这些攻略能帮助你有效防晒,享受夏日阳光!
', '防晒,夏季,攻略', '夏季防晒全攻略,保护你的皮肤'), (8, 'zh-tw', '夏季防曬全攻略', '如何有效防曬', '夏季陽光強烈,防曬至關重要。以下是一些防曬建議:
希望這些攻略能幫助你有效防曬,享受夏日陽光!
', '防曬,夏季,攻略', '夏季防曬全攻略,保護你的皮膚'), (8, 'en', 'Summer Sun Protection Guide', 'How to protect your skin from the sun', 'With intense summer sun, sun protection is essential. Here are some tips:
Hope these tips help you enjoy the summer sun while staying protected!
', 'Sun protection, summer, guide', 'Summer sun protection guide to keep your skin safe'), (9, 'zh', '秋季美食推荐', '秋季不可错过的美食', '秋季是丰收的季节,有许多美味的食物值得一试:
这些美食不仅能满足味蕾,还能补充营养,让你享受秋季的丰收喜悦!
', '美食,秋季,推荐', '秋季美食推荐,享受丰收的美味'), (9, 'zh-tw', '秋季美食推薦', '秋季不可錯過的美食', '秋季是豐收的季節,有許多美味的食物值得一試:
這些美食不僅能滿足味蕾,還能補充營養,讓你享受秋季的豐收喜悅!
', '美食,秋季,推薦', '秋季美食推薦,享受豐收的美味'), (9, 'en', 'Autumn Food Recommendations', 'Delicious foods to enjoy in autumn', 'Autumn is the season of harvest, with many delicious foods to try:
These foods not only satisfy your taste buds but also provide nutrition, letting you enjoy the joy of autumn harvest!
', 'Food, autumn, recommendations', 'Autumn food recommendations to enjoy the harvest'), (10, 'zh', '冬季保暖小妙招', '如何在寒冷中保持温暖', '冬季寒冷,保暖很重要。以下是一些保暖小妙招:
希望这些小妙招能帮助你在寒冷的冬季保持温暖!
', '保暖,冬季,小妙招', '冬季保暖小妙招,让你温暖过冬'), (10, 'zh-tw', '冬季保暖小妙招', '如何在寒冷中保持溫暖', '冬季寒冷,保暖很重要。以下是一些保暖小妙招:
希望這些小妙招能幫助你在寒冷的冬季保持溫暖!
', '保暖,冬季,小妙招', '冬季保暖小妙招,讓你溫暖過冬'), (10, 'en', 'Winter Warmth Tips', 'How to stay warm in the cold', 'Winter is cold, and staying warm is crucial. Here are some tips:
Hope these tips help you stay warm in the cold winter!
', 'Warmth, winter, tips', 'Winter warmth tips to keep you cozy'), (11, 'zh', '春季户外徒步指南', '如何享受徒步的乐趣', '春季是徒步的好季节,以下是一些徒步建议:
希望这些指南能帮助你享受徒步的乐趣!
', '徒步,春季,指南', '春季户外徒步指南,享受徒步的乐趣'), (11, 'zh-tw', '春季戶外徒步指南', '如何享受徒步的樂趣', '春季是徒步的好季節,以下是一些徒步建議:
希望這些指南能幫助你享受徒步的樂趣!
', '徒步,春季,指南', '春季戶外徒步指南,享受徒步的樂趣'), (11, 'en', 'Spring Hiking Guide', 'How to enjoy hiking', 'Spring is a great season for hiking. Here are some tips:
Hope these guides help you enjoy hiking!
', 'Hiking, spring, guide', 'Spring hiking guide to enjoy the outdoors'), (12, 'zh', '家居收纳技巧大全', '如何打造整洁有序的家', '一个整洁有序的家能让人感到舒适和放松。以下是一些实用的家居收纳技巧:
希望这些技巧能帮助你打造一个整洁有序的家!
', '家居,收纳,技巧', '家居收纳技巧大全,打造整洁有序的家'), (12, 'zh-tw', '家居收納技巧大全', '如何打造整潔有序的家', '一個整潔有序的家能讓人感到舒適和放鬆。以下是一些實用的家居收納技巧:
希望這些技巧能幫助你打造一個整潔有序的家!
', '家居,收納,技巧', '家居收納技巧大全,打造整潔有序的家'), (12, 'en', 'Home Organization Tips', 'How to create a tidy and organized home', 'A tidy and organized home can bring comfort and relaxation. Here are some practical tips for home organization:
Hope these tips help you create a tidy and organized home!
', 'Home, organization, tips', 'Home organization tips to keep your space tidy') ;