kadupul-git/BridgeDiseaseBackend-main/sql/docker_patch_admin_login.sql

-- 将管理员改为 README 默认账号（适配当前库中 role/status 为大写枚举）
USE bridge_disease;

UPDATE `user` SET
  `username` = 'admin',
  `email` = 'admin@example.com',
  `password` = 'scrypt:32768:8:1$D3KfZgegKywPsVOR$9a87dafc3391fb8339e79b1b8c433b073d31dc63e9407dcc09a6cffa118582b0a5334cd07d71d18c924a59faf14e727507f75bc881176459c853d1f2190a0445',
  `first_name` = '系统',
  `last_name` = '管理员',
  `role` = 'ADMIN',
  `status` = 'INACTIVE'
WHERE `user_id` = 1;

-- 可选：第二账号改为 developer 便于模型 owner_id=2
UPDATE `user` SET
  `username` = 'developer',
  `email` = 'dev@example.com',
  `password` = 'scrypt:32768:8:1$UtMwYLX1KSnmu6lk$3d7404f212eda78413ccab1c8a20a1836306d169cda9f5da635f92b3f3bd1c7649246d30feef87e093bb49508441eca5218c1bcec3638d33e0d68640732bc331',
  `first_name` = '开发',
  `last_name` = '人员',
  `role` = 'DEVELOPER',
  `status` = 'INACTIVE'
WHERE `user_id` = 2;

UPDATE `user` SET
  `username` = 'demo',
  `email` = 'user@example.com',
  `password` = 'scrypt:32768:8:1$mWhiEV1orl2PKEmM$2a43af98b53f934dfec2841394dd5e5b40bd913b973f0c8b0aba7929a16e215f7aa03001378ea8c23a5d575f992a377eafa0789f19f6359d3d5a876ba973de84',
  `first_name` = '演示',
  `last_name` = '用户',
  `role` = 'USER',
  `status` = 'INACTIVE'
WHERE `user_id` = 3;