ALTER TABLE users ADD COLUMN IF NOT EXISTS role VARCHAR(50) NOT NULL DEFAULT 'user';
ALTER TABLE users ADD COLUMN IF NOT EXISTS is_active BOOLEAN NOT NULL DEFAULT true;

INSERT INTO users (email, password_hash, name, role, is_active)
VALUES (
    'fikri@softcomp.io',
    '$2b$10$nZQpe2HillzISs4P/SbYj.IKCUL30voZjuuQQHMfPUXRjsXj0LplG',
    'Fikri',
    'superadmin',
    true
)
ON CONFLICT (email) DO UPDATE SET
    password_hash = EXCLUDED.password_hash,
    name = EXCLUDED.name,
    role = EXCLUDED.role,
    is_active = EXCLUDED.is_active;
