-- Seed data for: users (Admin + one shared login per CLRC)
-- Passwords are hardcoded defaults, matching the rest of this app:
--   admin login_id 'admin'      password 'Admin@123#'
--   every CLRC login_id <clrccode>  password 'admin123'
-- Both are bcrypt-hashed (cost 10) and verify correctly with PHP's
-- password_verify() -- no need to re-run scripts/create_admin.php after this.
-- must_change_password = 1 for every row, so each login is forced to set
-- its own password on first sign-in, exactly like a fresh php scripts/create_admin.php run.
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- Admin
INSERT INTO users (login_id, password_hash, role, clrccode, display_name, active, must_change_password) VALUES
('admin', '$2b$10$KZ/7.z79RWavgOfhPqVbCuduicPmZWbHoxzRmN5k6w0V4HmwwOe6S', 'admin', NULL, 'District Admin', 1, 1)
ON DUPLICATE KEY UPDATE password_hash = VALUES(password_hash), must_change_password = 1, active = 1;

-- CLRC logins (44 rows)
INSERT INTO users (login_id, password_hash, role, clrccode, display_name, active, must_change_password) VALUES
('192501', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192501', 'AUSGRAM-I', 1, 1),
('192502', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192502', 'AUSGRAM-II', 1, 1),
('192503', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192503', 'BHATAR', 1, 1),
('192504', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192504', 'BHATAR WEST', 1, 1),
('192505', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192505', 'BUDBUD', 1, 1),
('192506', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192506', 'DAINHAT', 1, 1),
('192507', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192507', 'GALSI', 1, 1),
('192508', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192508', 'GALSI WEST', 1, 1),
('192509', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192509', 'GUSHKARA-I', 1, 1),
('192510', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192510', 'GUSHKARA-II', 1, 1),
('192511', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192511', 'JAMALPUR', 1, 1),
('192512', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192512', 'JAMALPUR EAST', 1, 1),
('192513', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192513', 'KALANABAGRAM', 1, 1),
('192514', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192514', 'KALNA EAST', 1, 1),
('192515', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192515', 'KALNA NORTH', 1, 1),
('192516', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192516', 'KALNA-III', 1, 1),
('192517', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192517', 'KALNA-IV', 1, 1),
('192518', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192518', 'KATWA EAST', 1, 1),
('192519', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192519', 'KATWA WEST', 1, 1),
('192520', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192520', 'KETUGRAM', 1, 1),
('192521', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192521', 'KETUGRAM WEST', 1, 1),
('192522', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192522', 'KHANDOGHOSH-I', 1, 1),
('192523', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192523', 'KHANDOGHOSH-II', 1, 1),
('192524', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192524', 'MEMARI', 1, 1),
('192525', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192525', 'MONGALKOTE-I', 1, 1),
('192526', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192526', 'MONGALKOTE-II', 1, 1),
('192527', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192527', 'MONGALKOTE-III', 1, 1),
('192528', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192528', 'MONTESWAR-I', 1, 1),
('192529', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192529', 'MONTESWAR-II', 1, 1),
('192530', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192530', 'MONTESWAR-III', 1, 1),
('192531', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192531', 'PURBASTHALI', 1, 1),
('192532', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192532', 'PURBASTHALI NORTH', 1, 1),
('192533', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192533', 'PURBASTHALI SOUTH', 1, 1),
('192534', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192534', 'RAINA-I', 1, 1),
('192535', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192535', 'RAINA-II', 1, 1),
('192536', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192536', 'RAINA-III', 1, 1),
('192537', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192537', 'RAINA-IV', 1, 1),
('192538', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192538', 'SADAR EAST', 1, 1),
('192539', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192539', 'SADAR NORTH', 1, 1),
('192540', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192540', 'SADAR URBAN-I', 1, 1),
('192541', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192541', 'SADAR URBAN-II', 1, 1),
('192542', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192542', 'SADAR WEST', 1, 1),
('192543', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192543', 'SATGACHIA', 1, 1),
('192544', '$2b$10$QELs7ctCDAlmM4HBnI0kDu04QjSHIHFoSN5crROJu7Iv9tgDCl3z6', 'clrc', '192544', 'SATGACHIA WEST', 1, 1)
ON DUPLICATE KEY UPDATE password_hash = VALUES(password_hash), display_name = VALUES(display_name), must_change_password = 1, active = 1;
SET FOREIGN_KEY_CHECKS = 1;
