-- Seed Admin User for initial system access

INSERT INTO users (id, username, email, password_hash, branch_id, status, created_at, last_login)
VALUES (
    '00000000-0000-0000-0000-000000000001',
    'admin',
    'admin@effigenix.com',
    '$2a$12$SJmX80hUZoA66W77CX7cHeRw1TPscXD6S8HYEZfhJ5PxTfkbwbLdi',
    NULL,
    'ACTIVE',
    CURRENT_TIMESTAMP,
    NULL
);

INSERT INTO user_roles (user_id, role_id)
SELECT '00000000-0000-0000-0000-000000000001', id
FROM roles
WHERE name = 'ADMIN';
