cfc/cfc-backend/src/main/resources/create-teacher-account.sql

-- 创建测试成长规划师账号
-- 用于测试成长规划师管理功能（成长规划师套餐、家庭任务管理、家长咨询）

-- 1. 创建一个成长规划师角色的用户
INSERT INTO users (phone, nickname, role, status, created_at, updated_at)
VALUES ('13800138000', '测试成长规划师', 'teacher', 'active', NOW(), NOW())
ON DUPLICATE KEY UPDATE role='teacher';

-- 2. 获取刚插入的用户 ID（假设是最后一个）
SET @teacher_user_id = (SELECT id FROM users WHERE phone = '13800138000' LIMIT 1);

-- 3. 在 teachers 表中创建成长规划师记录
INSERT INTO teachers (user_id, teacher_no, title, specialty, status, created_at, updated_at)
SELECT 
  @teacher_user_id,
  'T2026001',
  '资深家庭教育成长规划师',
  '亲子关系、习惯培养',
  'active',
  NOW(),
  NOW()
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM teachers WHERE user_id = @teacher_user_id
);

-- 4. 验证创建结果
SELECT 
  u.id,
  u.phone,
  u.nickname,
  u.role,
  t.teacher_no,
  t.title
FROM users u
LEFT JOIN teachers t ON u.id = t.user_id
WHERE u.phone = '13800138000';