cfc/cfc-backend/src/main/resources/seed-test-data.sql

-- ==========================================================
-- 测试种子数据：活动 / 文章 / 商品
-- 每个维度（身/智/行/心/富）各3条记录，合计15条
-- 价格均不超过 0.1 元（≤ 10 分），适合测试环境使用
-- 使用方法: mysql -u root -p cfc < seed-test-data.sql
-- 幂等: INSERT IGNORE 避免重复插入
-- ==========================================================

-- ==========================================================
-- 1. 活动（activities）—— 覆盖身/智/行/心/富 五维
-- ==========================================================

INSERT IGNORE INTO activities (title, description, dimension_code, dimension_weights, activity_type, status, start_time, end_time, location, max_participants, current_participants, price, member_price, require_registration, checkin_points, created_at, updated_at)
VALUES
('亲子户外徒步探险', '周末亲子徒步活动，在自然中锻炼体魄、增进亲子关系，全程约5公里。',
 'body', '{"body":80,"mind":0,"wisdom":0,"action":20,"wealth":0}',
 'offline', 'published',
 '2026-08-15 09:00:00', '2026-08-15 16:00:00',
 '北京奥林匹克森林公园', 50, 0, 0, 0, 1, 10, NOW(), NOW()),

('少儿科学思维探索营', '通过动手实验激发孩子对科学的兴趣，培养逻辑思维与创造力。',
 'wisdom', '{"body":0,"mind":0,"wisdom":70,"action":30,"wealth":0}',
 'online', 'published',
 '2026-09-05 10:00:00', '2026-09-05 12:00:00',
 '线上直播', 200, 0, 10, 5, 1, 10, NOW(), NOW()),

('家庭协作挑战赛', '家庭成员共同完成挑战任务，培养行动力与团队配合精神。',
 'action', '{"body":20,"mind":0,"wisdom":0,"action":70,"wealth":10}',
 'offline', 'published',
 '2026-08-25 14:00:00', '2026-08-25 17:00:00',
 '北京市朝阳区青少年活动中心', 30, 0, 10, 5, 1, 10, NOW(), NOW()),

('家庭正念静心工作坊', '专业导师带领的正念冥想体验，学习情绪调节和家庭沟通技巧。',
 'mind', '{"body":0,"mind":80,"wisdom":10,"action":10,"wealth":0}',
 'offline', 'published',
 '2026-08-22 14:00:00', '2026-08-22 17:00:00',
 '北京市朝阳区心理成长中心', 30, 0, 10, 5, 1, 10, NOW(), NOW()),

('理财启蒙工作坊', '从小培养金钱意识，学习基础的理财知识与财富观念。',
 'wealth', '{"body":0,"mind":0,"wisdom":20,"action":10,"wealth":70}',
 'offline', 'published',
 '2026-09-10 10:00:00', '2026-09-10 12:00:00',
 '线上直播', 100, 0, 10, 5, 1, 10, NOW(), NOW());

-- ==========================================================
-- 2. 文章（articles）—— 覆盖身/智/行/心/富 五维
-- ==========================================================

INSERT IGNORE INTO articles (title, summary, content, content_type, category_id, related_dimensions, dimension_weights, status, author, article_type, read_time, word_count, is_featured, view_count, author_type, audit_status, visibility, created_at, updated_at)
VALUES
('儿童饮食营养搭配指南',
 '帮助孩子建立健康饮食习惯的营养搭配方案与食谱建议。',
 '（测试数据：本文为示例文章正文，实际数据应在运营后台编辑发布。）',
 'article', 1, '["body"]',
 '{"body":70,"mind":10,"wisdom":10,"action":10,"wealth":0}',
 'published', '营养师', 'normal', 6, 2000, 1, 0, 'admin', 'approved', 'public', NOW(), NOW()),

('如何培养孩子的自主学习力',
 '从内在动机出发，帮助孩子建立自主学习习惯的实用方法指南。',
 '（测试数据：本文为示例文章正文，实际数据应在运营后台编辑发布。）',
 'article', 3, '["wisdom"]',
 '{"body":0,"mind":0,"wisdom":60,"action":40,"wealth":0}',
 'published', '曹老师', 'normal', 5, 1800, 1, 0, 'admin', 'approved', 'public', NOW(), NOW()),

('亲子运动的正确打开方式',
 '不同年龄段孩子的运动建议，让全家人在快乐中收获健康。',
 '（测试数据：本文为示例文章正文，实际数据应在运营后台编辑发布。）',
 'article', 4, '["action"]',
 '{"body":40,"mind":0,"wisdom":0,"action":60,"wealth":0}',
 'published', '王老师', 'normal', 3, 1500, 1, 0, 'admin', 'approved', 'public', NOW(), NOW()),

('儿童情绪管理的五个关键步骤',
 '当孩子情绪爆发时，家长应该如何应对？本文提供一套可操作的情绪管理框架。',
 '（测试数据：本文为示例文章正文，实际数据应在运营后台编辑发布。）',
 'article', 2, '["mind"]',
 '{"body":0,"mind":80,"wisdom":10,"action":10,"wealth":0}',
 'published', '李老师', 'premium', 4, 2200, 1, 0, 'admin', 'approved', 'public', NOW(), NOW()),

('家庭财务规划基础入门',
 '从零开始的家庭预算管理方法，建立正确的消费与储蓄习惯。',
 '（测试数据：本文为示例文章正文，实际数据应在运营后台编辑发布。）',
 'article', 5, '["wealth"]',
 '{"body":0,"mind":10,"wisdom":20,"action":10,"wealth":60}',
 'published', '财务顾问', 'normal', 8, 2500, 1, 0, 'admin', 'approved', 'public', NOW(), NOW());

-- ==========================================================
-- 3. 商品（products）—— 覆盖身/智/行/心/富 五维
-- ==========================================================

INSERT IGNORE INTO products (name, description, price, product_type, vendor_id, vendor_name, status, domain, member_eligible, member_price, stock, sales_count, created_at, updated_at)
VALUES
('儿童营养补充套装',
 '维生素D+钙质+锌，全面支持孩子健康成长发育。',
 10, 'physical', NULL, '平台官方', 'on_shelf', 'body', 'all', 5, 999, 0, NOW(), NOW()),

('少儿专注力训练教具盒',
 '含舒尔特方格、记忆卡片等8种专注力训练工具，适合5-12岁儿童。',
 10, 'physical', NULL, '平台官方', 'on_shelf', 'wisdom', 'all', 5, 999, 0, NOW(), NOW()),

('家庭年度VIP成长会员',
 '体验版会员，畅享线上课程与活动折扣。',
 10, 'digital', NULL, '平台官方', 'on_shelf', 'action', 'all', 5, 9999, 0, NOW(), NOW()),

('儿童情绪管理绘本套装',
 '5本精选情绪主题绘本，帮助孩子认识和管理各种情绪。',
 10, 'physical', NULL, '平台官方', 'on_shelf', 'mind', 'all', 5, 999, 0, NOW(), NOW()),

('儿童财商教育工具包',
 '包含记账本、存钱罐、游戏规则，系统培养财商思维。',
 10, 'physical', NULL, '平台官方', 'on_shelf', 'wealth', 'all', 5, 999, 0, NOW(), NOW());

-- ==========================================================
-- 验证插入结果
-- ==========================================================
SELECT '[活动]' AS `维度`, COUNT(*) AS `记录数` FROM activities WHERE created_at >= DATE_SUB(NOW(), INTERVAL 1 MINUTE)
UNION ALL
SELECT '[文章]', COUNT(*) FROM articles WHERE created_at >= DATE_SUB(NOW(), INTERVAL 1 MINUTE)
UNION ALL
SELECT '[商品]', COUNT(*) FROM products WHERE created_at >= DATE_SUB(NOW(), INTERVAL 1 MINUTE);