kindergarten_java/reading-platform-java/init-test-data.sql
En 30b9cd5e05 feat: 套餐管理功能完整实现
前端新增:
- 套餐管理列表页 PackageListView.vue
- 套餐详情页 PackageDetailView.vue
- 套餐编辑页 PackageEditView.vue
- 套餐 API 客户端 productBundle.ts

后端新增:
- ProductBundle 实体(产品套餐)
- ProductBundleCoursePackage 实体(套餐 - 课程包关联)
- TenantProductBundle 实体(学校套餐购买记录)
- CoursePackageCourse 实体(课程包 - 课程关联)
- AdminProductBundleController(套餐管理接口)
- AdminBundleCoursePackageController(套餐课程包关联接口)
- AdminPackageCourseController(课程包课程关联接口)
- AdminTenantBundleController(学校套餐购买接口)
- 对应 Service 和 Mapper

数据库迁移:
- 添加 Flyway 迁移脚本 V20260312__create_bundle_tables.sql

代码规范:
- Service 层统一继承 IService 和 ServiceImpl
- Entity 类补充 @Schema 注解
- DTO/VO 类补充 @Schema 注解
2026-03-12 10:47:03 +08:00

14 lines
643 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- ============================================
-- Reading Platform 测试数据初始化 SQL
-- 版本1.0.0
-- 说明:包含完整的测试数据,涵盖所有主要业务实体
-- ============================================
USE reading_platform;
-- ============================================
-- 1. 管理员账户 (密码admin123)
-- ============================================
INSERT INTO t_admin_user (id, username, password, name, email, phone, status) VALUES
('10000000000000000000000000000001', 'admin', '\a\0\.7JHq3aKzYOxLNqZzK8U8MqP0JzXzZ5Z5Z5Z5Z5Z5Z', '系统管理员', 'admin@reading.com', '13800138000', 'active');