USE spchs;

-- Temporary administrator account
-- Email: admin@spchs.local
-- Password: Admin@12345
-- Change the email and password immediately after first login.

INSERT INTO users
    (id, fullname, email, phone, workplace, zone_name, password, role, status)
VALUES
    (
        1,
        'System Administrator',
        'admin@spchs.local',
        '',
        'Provincial Education Department',
        NULL,
        '$2y$12$V3Pz0iPLIEOZgicNntiPX.opB95l6SdxQxrILBo.jYdVg/j4zKz/q',
        'admin',
        'Active'
    )
ON DUPLICATE KEY UPDATE
    fullname = VALUES(fullname),
    role = 'admin',
    status = 'Active';
