-- UAT test accounts — two per role, for customer testing on dev/staging.
-- NEVER run on production: these are throwaway credentials, documented in
-- docs/testing-guide.md, which is the guide handed to the customer.
--
--   Role      Email                        Password
--   ADMIN     sampadak1@test.shodh.net     Sampadak@2026
--   ADMIN     sampadak2@test.shodh.net     Sampadak@2027
--   REVIEWER  samikshak1@test.shodh.net    Samikshak@2026
--   REVIEWER  samikshak2@test.shodh.net    Samikshak@2027
--   AUTHOR    lekhak1@test.shodh.net       Lekhak@2026
--   AUTHOR    lekhak2@test.shodh.net       Lekhak@2027
--
-- Idempotent: re-running resets these six accounts to the passwords above.
-- Apply with:
--   docker exec -i shodh-sanchayan-api-postgres-1 \
--     psql -U shodh -d shodh_sanchayan < scripts/seed-uat-users.sql

INSERT INTO users (id, email, password_hash, name_hi, name_en, role, status,
                   email_verified, must_change_password, designation, institution)
VALUES
  ('aaaaaaaa-0000-0000-0000-000000000001', 'sampadak1@test.shodh.net',
   '$2a$10$j.KUzyIEO6QcSvsYfJItUOiZbFEIoa58PxVGHj/z/TGH.BOAcKcVO',
   'परीक्षण संपादक १', 'Test Editor 1', 'ADMIN', 'ACTIVE', TRUE, FALSE,
   'Chief Editor (Test)', 'Shodh Sanchayan'),
  ('aaaaaaaa-0000-0000-0000-000000000002', 'sampadak2@test.shodh.net',
   '$2a$10$CG4wwMJBPBwsoLkmD7BTtOGMSFRcWHsnB66g1UkfAcgw1H2TQu9zG',
   'परीक्षण संपादक २', 'Test Editor 2', 'ADMIN', 'ACTIVE', TRUE, FALSE,
   'Managing Editor (Test)', 'Shodh Sanchayan'),
  ('aaaaaaaa-0000-0000-0000-000000000003', 'samikshak1@test.shodh.net',
   '$2a$10$V8TY10NrQ/.V0t9/zt6s5.0t27lWGEZQ7bDZZO3hR0h/pND8r2tUi',
   'परीक्षण समीक्षक १', 'Test Reviewer 1', 'REVIEWER', 'ACTIVE', TRUE, FALSE,
   'Professor of Hindi (Test)', 'Test University, Kanpur'),
  ('aaaaaaaa-0000-0000-0000-000000000004', 'samikshak2@test.shodh.net',
   '$2a$10$fP6Wgjgl7T6jIHV0P22KCuR3VD/Ws.jx0Lg1WdvEqtAqMV7YG/Uru',
   'परीक्षण समीक्षक २', 'Test Reviewer 2', 'REVIEWER', 'ACTIVE', TRUE, FALSE,
   'Professor of History (Test)', 'Test University, Lucknow'),
  ('aaaaaaaa-0000-0000-0000-000000000005', 'lekhak1@test.shodh.net',
   '$2a$10$ywFOe5iTpdSe08RQuju73ONu0TVH4TxsXKiTtDaOMYxguXrDW1eNG',
   'परीक्षण लेखक १', 'Test Author 1', 'AUTHOR', 'ACTIVE', TRUE, FALSE,
   'Research Scholar (Test)', 'Test College, Delhi'),
  ('aaaaaaaa-0000-0000-0000-000000000006', 'lekhak2@test.shodh.net',
   '$2a$10$bxUel/Re2HvaM2i.J3QNMeaYeofKx1SRGf4pz9O5b6IFAJtTRWM6S',
   'परीक्षण लेखक २', 'Test Author 2', 'AUTHOR', 'ACTIVE', TRUE, FALSE,
   'Assistant Professor (Test)', 'Test College, Varanasi')
ON CONFLICT (email) DO UPDATE SET
  password_hash = EXCLUDED.password_hash,
  role = EXCLUDED.role,
  status = 'ACTIVE',
  must_change_password = FALSE;