-- Update sheldon@blueguruz.com to be a regular user, not an organizer
UPDATE public.users
SET role = 'user'
WHERE email = 'sheldon@blueguruz.com';

-- Add a 'user' role option to the users table if it doesn't exist
ALTER TABLE public.users DROP CONSTRAINT IF EXISTS users_role_check;
ALTER TABLE public.users ADD CONSTRAINT users_role_check 
  CHECK (role IN ('organizer', 'staff', 'admin', 'user'));
