14 lines
378 B
SQL
14 lines
378 B
SQL
-- 将 984523799@qq.com 设置为管理员
|
|
-- 执行此脚本前请确保已连接到正确的数据库
|
|
|
|
-- 更新用户角色为管理员
|
|
UPDATE users
|
|
SET role = 'ROLE_ADMIN',
|
|
updated_at = NOW()
|
|
WHERE email = '984523799@qq.com';
|
|
|
|
-- 验证更新结果
|
|
SELECT id, username, email, role, points, is_active, created_at, updated_at
|
|
FROM users
|
|
WHERE email = '984523799@qq.com';
|