/**
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', '夏日户外露营指南', '如何在户外享受舒适露营', '<h2>夏日户外露营指南</h2><p>夏天是露营的最佳季节，以下是一些实用的露营技巧：</p><ul><li><strong>选择合适的露营地：</strong>选择一个平坦、靠近水源且远离野生动物的地方。</li><li><strong>准备必要的装备：</strong>帐篷、睡袋、防潮垫、头灯、驱蚊剂等。</li><li><strong>注意安全：</strong>在户外要注意防火、防虫、防野生动物。</li></ul><p>希望这些技巧能帮助你在大自然中度过一个愉快的露营之旅！</p>', '露营,户外,指南', '一份全面的户外露营指南，帮助你享受大自然'),
    (1, 'en', 'Summer Camping Guide', 'How to enjoy comfortable camping outdoors', '<h2>Summer Camping Guide</h2><p>Summer is the perfect season for camping. Here are some useful camping tips:</p><ul><li><strong>Choose the right campsite:</strong> Select a flat area near water and away from wildlife.</li><li><strong>Prepare necessary gear:</strong> Tent, sleeping bag, ground pad, headlamp, insect repellent, etc.</li><li><strong>Pay attention to safety:</strong> Be cautious of fire, insects, and wildlife while camping.</li></ul><p>Hope these tips help you enjoy a pleasant camping trip in nature!</p>', 'Camping, outdoors, guide', 'A comprehensive camping guide to help you enjoy nature'),
    (2, 'zh', '城市夜景摄影技巧', '捕捉城市夜晚的美丽瞬间', '<h2>城市夜景摄影技巧</h2><p>城市夜景摄影可以捕捉到独特的光影效果，以下是一些技巧：</p><ul><li><strong>选择合适的拍摄地点：</strong>高楼大厦的顶部或桥梁是绝佳的拍摄点。</li><li><strong>使用三脚架：</strong>稳定相机，避免手抖影响照片质量。</li><li><strong>调整相机设置：</strong>使用低ISO、小光圈和慢快门，以获得清晰的夜景照片。</li></ul><p>通过这些技巧，你可以拍摄出令人惊叹的城市夜景照片！</p>', '摄影,夜景,技巧', '捕捉城市夜晚的美丽瞬间'),
    (2, 'en', 'Urban Night Photography Tips', 'Capturing the beauty of the city at night', '<h2>Urban Night Photography Tips</h2><p>Capturing the beauty of urban night scenes can produce unique lighting effects. Here are some tips:</p><ul><li><strong>Choose the right shooting location:</strong> The tops of skyscrapers or bridges are excellent spots.</li><li><strong>Use a tripod:</strong> Stabilize the camera to avoid blurry photos due to hand shake.</li><li><strong>Adjust camera settings:</strong> Use low ISO, small aperture, and slow shutter speed for clear night photos.</li></ul><p>With these tips, you can capture amazing urban night photos!</p>', 'Photography, night view, tips', 'Capturing the beauty of the city at night'),
    (3, 'zh', '春季赏花好去处', '推荐几个适合赏花的地方', '<h2>春季赏花好去处</h2><p>春天是赏花的好季节，以下是一些国内最美的赏花地点：</p><ul><li><strong>武汉大学樱花大道：</strong>每年三月，樱花盛开，如粉色云霞。</li><li><strong>婺源油菜花田：</strong>金黄的油菜花与古村落相映成趣。</li><li><strong>林芝桃花沟：</strong>桃花盛开时，漫山遍野，如诗如画。</li></ul><p>这些地方不仅能让你欣赏到美丽的花朵，还能感受春天的气息。</p>', '赏花,春季,地点', '推荐几个适合赏花的地方'),
    (3, 'en', 'Best Flower Viewing Spots in Spring', 'Recommend some great places for flower viewing', '<h2>Best Flower Viewing Spots in Spring</h2><p>Spring is the perfect season for flower viewing. Here are some of the most beautiful flower viewing spots in the country:</p><ul><li><strong>Wuhan University Cherry Blossom Avenue:</strong> In March every year, the cherry blossoms bloom like pink clouds.</li><li><strong>Wuyuan Rapeseed Flower Fields:</strong> The golden rapeseed flowers contrast beautifully with ancient villages.</li><li><strong>Linzhi Peach Blossom Valley:</strong> When the peach blossoms bloom, the mountains are covered in a picturesque scene.</li></ul><p>These places not only allow you to enjoy beautiful flowers but also let you feel the spring atmosphere.</p>', 'Flower viewing, spring, locations', 'Recommend some great places for flower viewing'),
    (4, 'zh', '健身新手入门指南', '如何开始你的健身之旅', '<h2>健身新手入门指南</h2><p>健身可以改善身体素质和健康状况，以下是一些入门建议：</p><ul><li><strong>设定目标：</strong>明确你的健身目标，如增肌、减脂或提高体能。</li><li><strong>制定计划：</strong>根据目标制定合理的训练和饮食计划。</li><li><strong>逐步开始：</strong>从简单的动作开始，逐渐增加难度和强度。</li></ul><p>希望这些指南能帮助你迈出健身的第一步！</p>', '健身,新手,指南', '帮助你开始健身之旅'),
    (4, 'en', 'Fitness Beginner\'s Guide', 'How to start your fitness journey', '<h2>Fitness Beginner\'s Guide</h2><p>Fitness can improve physical fitness and health. Here are some tips for getting started:</p><ul><li><strong>Set goals:</strong> Clarify your fitness goals, such as muscle building, fat loss, or improving physical fitness.</li><li><strong>Make a plan:</strong> Create a reasonable training and diet plan based on your goals.</li><li><strong>Start gradually:</strong> Begin with simple exercises and gradually increase the difficulty and intensity.</li></ul><p>Hope these guides help you take the first step in fitness!</p>', 'Fitness, beginner, guide', 'Help you start your fitness journey'),
    (5, 'zh', '冬季滑雪攻略', '如何享受滑雪的乐趣', '<h2>冬季滑雪攻略</h2><p>冬季是滑雪的最佳季节，以下是一些滑雪技巧：</p><ul><li><strong>选择合适的滑雪场：</strong>根据自己的水平选择适合的滑雪场。</li><li><strong>准备必要的装备：</strong>滑雪板、滑雪靴、护具、头盔等。</li><li><strong>注意安全：</strong>遵循滑雪场的规则，避免危险动作。</li></ul><p>希望这些攻略能帮助你在雪地上尽情驰骋！</p>', '滑雪,冬季,攻略', '享受滑雪的乐趣'),
    (5, 'en', 'Winter Skiing Tips', 'How to enjoy skiing', '<h2>Winter Skiing Tips</h2><p>Winter is the perfect season for skiing. Here are some skiing tips:</p><ul><li><strong>Choose the right ski resort:</strong> Select a ski resort suitable for your skill level.</li><li><strong>Prepare necessary gear:</strong> Skis, ski boots, protective gear, helmet, etc.</li><li><strong>Pay attention to safety:</strong> Follow the ski resort rules and avoid dangerous maneuvers.</li></ul><p>Hope these tips help you enjoy skiing on the snow!</p>', 'Skiing, winter, tips', 'Enjoy skiing'),
    (6, 'zh', '春季养生小贴士', '春季如何保持健康', '<h2>春季养生小贴士</h2><p>春季是万物复苏的季节，也是养生的好时机。以下是一些春季养生的小贴士：</p><ul><li><strong>饮食清淡：</strong>多吃蔬菜水果，少吃油腻食物。</li><li><strong>适当运动：</strong>选择适合自己的运动方式，如散步、慢跑等。</li><li><strong>保持心情舒畅：</strong>避免情绪波动，保持心态平和。</li></ul><p>希望这些小贴士能帮助你度过一个健康的春季！</p>', '春季,养生,健康', '春季养生小贴士，帮助你保持健康'),
    (6, 'en', 'Spring Health Tips', 'How to stay healthy in spring', '<h2>Spring Health Tips</h2><p>Spring is the season of renewal and a great time for health maintenance. Here are some tips for staying healthy in spring:</p><ul><li><strong>Eat lightly:</strong> Focus on vegetables and fruits, and avoid greasy foods.</li><li><strong>Exercise moderately:</strong> Choose activities like walking or jogging.</li><li><strong>Stay in good spirits:</strong> Avoid emotional fluctuations and maintain a peaceful mindset.</li></ul><p>Hope these tips help you have a healthy spring!</p>', 'Spring, health, tips', 'Spring health tips to keep you in good shape'),
    (7, 'zh', '家庭园艺入门指南', '如何打造自己的小花园', '<h2>家庭园艺入门指南</h2><p>园艺不仅能美化环境，还能带来乐趣。以下是一些家庭园艺的入门建议：</p><ul><li><strong>选择合适的植物：</strong>根据光照条件选择适合的植物。</li><li><strong>准备基本工具：</strong>铲子、喷壶、花盆等。</li><li><strong>定期浇水和施肥：</strong>保持土壤湿润，适时补充养分。</li></ul><p>希望这些指南能帮助你打造一个美丽的小花园！</p>', '园艺,家庭,入门', '家庭园艺入门指南，打造你的小花园'),
    (7, 'en', 'Home Gardening Beginner\'s Guide', 'How to create your own little garden', '<h2>Home Gardening Beginner\'s Guide</h2><p>Gardening not only beautifies the environment but also brings joy. Here are some tips for getting started with home gardening:</p><ul><li><strong>Choose the right plants:</strong> Select plants based on your light conditions.</li><li><strong>Prepare basic tools:</strong> Trowel, watering can, pots, etc.</li><li><strong>Water and fertilize regularly:</strong> Keep the soil moist and add nutrients as needed.</li></ul><p>Hope these guides help you create a beautiful little garden!</p>', 'Gardening, home, beginner', 'Home gardening guide to create your own garden'),
    (8, 'zh', '夏季防晒全攻略', '如何有效防晒', '<h2>夏季防晒全攻略</h2><p>夏季阳光强烈，防晒至关重要。以下是一些防晒建议：</p><ul><li><strong>选择合适的防晒霜：</strong>SPF 30 以上，PA+++ 为佳。</li><li><strong>定时补涂：</strong>每 2-3 小时补涂一次。</li><li><strong>避免长时间暴晒：</strong>尽量减少在紫外线最强时段外出。</li></ul><p>希望这些攻略能帮助你有效防晒，享受夏日阳光！</p>', '防晒,夏季,攻略', '夏季防晒全攻略，保护你的皮肤'),
    (8, 'en', 'Summer Sun Protection Guide', 'How to protect your skin from the sun', '<h2>Summer Sun Protection Guide</h2><p>With intense summer sun, sun protection is essential. Here are some tips:</p><ul><li><strong>Choose the right sunscreen:</strong> SPF 30 or higher, PA+++ is recommended.</li><li><strong>Reapply regularly:</strong> Every 2-3 hours.</li><li><strong>Avoid prolonged exposure:</strong> Minimize outdoor activities during peak UV hours.</li></ul><p>Hope these tips help you enjoy the summer sun while staying protected!</p>', 'Sun protection, summer, guide', 'Summer sun protection guide to keep your skin safe'),
    (9, 'zh', '秋季美食推荐', '秋季不可错过的美食', '<h2>秋季美食推荐</h2><p>秋季是丰收的季节，有许多美味的食物值得一试：</p><ul><li><strong>大闸蟹：</strong>肉质鲜美，营养丰富。</li><li><strong>栗子：</strong>香甜可口，适合烤制或煮食。</li><li><strong>南瓜：</strong>口感软糯，可做多种菜肴。</li></ul><p>这些美食不仅能满足味蕾，还能补充营养，让你享受秋季的丰收喜悦！</p>', '美食,秋季,推荐', '秋季美食推荐，享受丰收的美味'),
    (9, 'en', 'Autumn Food Recommendations', 'Delicious foods to enjoy in autumn', '<h2>Autumn Food Recommendations</h2><p>Autumn is the season of harvest, with many delicious foods to try:</p><ul><li><strong>Crab:</strong> Tender and nutritious.</li><li><strong>Chestnuts:</strong> Sweet and delicious, perfect for roasting or boiling.</li><li><strong>Pumpkin:</strong> Soft and versatile, great for various dishes.</li></ul><p>These foods not only satisfy your taste buds but also provide nutrition, letting you enjoy the joy of autumn harvest!</p>', 'Food, autumn, recommendations', 'Autumn food recommendations to enjoy the harvest'),
    (10, 'zh', '冬季保暖小妙招', '如何在寒冷中保持温暖', '<h2>冬季保暖小妙招</h2><p>冬季寒冷，保暖很重要。以下是一些保暖小妙招：</p><ul><li><strong>穿多层衣物：</strong>增加保暖效果。</li><li><strong>戴帽子和围巾：</strong>减少头部热量散失。</li><li><strong>保持室内温暖：</strong>使用暖气或电热毯。</li></ul><p>希望这些小妙招能帮助你在寒冷的冬季保持温暖！</p>', '保暖,冬季,小妙招', '冬季保暖小妙招，让你温暖过冬'),
    (10, 'en', 'Winter Warmth Tips', 'How to stay warm in the cold', '<h2>Winter Warmth Tips</h2><p>Winter is cold, and staying warm is crucial. Here are some tips:</p><ul><li><strong>Wear multiple layers:</strong> Enhance warmth.</li><li><strong>Wear hats and scarves:</strong> Reduce heat loss from the head.</li><li><strong>Keep indoor warmth:</strong> Use heating or electric blankets.</li></ul><p>Hope these tips help you stay warm in the cold winter!</p>', 'Warmth, winter, tips', 'Winter warmth tips to keep you cozy'),
    (11, 'zh', '春季户外徒步指南', '如何享受徒步的乐趣', '<h2>春季户外徒步指南</h2><p>春季是徒步的好季节，以下是一些徒步建议：</p><ul><li><strong>选择合适的路线：</strong>根据自己的体力选择合适的徒步路线。</li><li><strong>准备必要的装备：</strong>舒适的徒步鞋、背包、水和食物。</li><li><strong>注意安全：</strong>告知他人你的行程，避免独自前往危险区域。</li></ul><p>希望这些指南能帮助你享受徒步的乐趣！</p>', '徒步,春季,指南', '春季户外徒步指南，享受徒步的乐趣'),
    (11, 'en', 'Spring Hiking Guide', 'How to enjoy hiking', '<h2>Spring Hiking Guide</h2><p>Spring is a great season for hiking. Here are some tips:</p><ul><li><strong>Choose the right trail:</strong> Select a trail based on your physical condition.</li><li><strong>Prepare necessary gear:</strong> Comfortable hiking shoes, backpack, water, and food.</li><li><strong>Pay attention to safety:</strong> Inform someone of your itinerary and avoid dangerous areas alone.</li></ul><p>Hope these guides help you enjoy hiking!</p>', 'Hiking, spring, guide', 'Spring hiking guide to enjoy the outdoors'),
    (12, 'zh', '家居收纳技巧大全', '如何打造整洁有序的家', '<h2>家居收纳技巧大全</h2><p>一个整洁有序的家能让人感到舒适和放松。以下是一些实用的家居收纳技巧：</p><ul><li><strong>分类整理：</strong>将物品按照类别进行分类，方便查找。</li><li><strong>利用收纳工具：</strong>如收纳盒、挂钩、置物架等。</li><li><strong>定期清理：</strong>定期检查并清理不需要的物品。</li></ul><p>希望这些技巧能帮助你打造一个整洁有序的家！</p>', '家居,收纳,技巧', '家居收纳技巧大全，打造整洁有序的家'),
    (12, 'en', 'Home Organization Tips', 'How to create a tidy and organized home', '<h2>Home Organization Tips</h2><p>A tidy and organized home can bring comfort and relaxation. Here are some practical tips for home organization:</p><ul><li><strong>Sort and categorize:</strong> Organize items by category for easy access.</li><li><strong>Use storage tools:</strong> Such as storage boxes, hooks, and shelves.</li><li><strong>Regular decluttering:</strong> Periodically check and remove items you no longer need.</li></ul><p>Hope these tips help you create a tidy and organized home!</p>', 'Home, organization, tips', 'Home organization tips to keep your space tidy')
;