cfc/create-role-users.sql

-- 手动创建测试用户 SQL
-- 执行方式: mysql -h192.168.16.251 -P3306 -uzxyj -pzxyj@123 zxyj < create-role-users.sql

-- 先确认当前 role 字段类型
SHOW COLUMNS FROM users WHERE Field = 'role';

-- 创建用户（密码字段留空，用验证码登录）
INSERT INTO users (phone, nickname, role, real_name, password, openid, family_id, created_at, updated_at) VALUES
('13900139000', '文章管理员', 'article_admin', '文章管理', '', 'admin_article_001', 0, NOW(), NOW()),
('13900139001', '活动管理员', 'activity_admin', '活动管理', '', 'admin_activity_001', 0, NOW(), NOW()),
('13900139002', '商品管理员', 'supplier_admin', '商品管理', '', 'admin_supplier_001', 0, NOW(), NOW()),
('13900139003', '供应商体系管理员', 'supplier_admin', '供应商管理', '', 'admin_vendor_001', 0, NOW(), NOW()),
('13900139004', '营养师管理员', 'nutritionist', '营养管理', '', 'admin_nutritionist_001', 0, NOW(), NOW()),
('13900139005', '成长规划师', 'teacher', '规划师', '', 'admin_teacher_001', 0, NOW(), NOW());

-- 验证结果
SELECT id, phone, nickname, role, real_name FROM users WHERE phone LIKE '139001390%' ORDER BY phone;