-- Add super-tester role to users table
-- Super-testers can run rapid-fire tests with auto duplicate bypass
-- 2026-02-26

ALTER TABLE users ADD COLUMN IF NOT EXISTS is_super_tester BOOLEAN NOT NULL DEFAULT false;

-- Create charlie user (password: efsi1, bcrypt hashed)
-- INSERT INTO users (username, password, is_admin, is_super_tester)
-- VALUES ('charlie', '<bcrypt hash>', true, true);
-- INSERT INTO user_practices (user_id, practice_id, role, is_default)
-- VALUES (<charlie_id>, 1, 'admin', false), (<charlie_id>, 3, 'admin', true);
