-- Create admin user for Tikkets
-- Email: admin@tikkets.com | Password: 12345678
-- 
-- NOTE: This script should be run AFTER creating the user through Supabase Auth
-- You can create the auth user by:
-- 1. Running the create-admin-user.ts script, OR
-- 2. Signing up normally then running this SQL to grant admin role

-- First, check if user exists and update their role
UPDATE users 
SET role = 'admin', 
    full_name = COALESCE(full_name, 'Tikkets Admin'),
    updated_at = NOW()
WHERE email = 'admin@tikkets.com';

-- If the user doesn't exist yet, we need to create them through Supabase Auth first
-- The following is informational only - actual user creation happens via Auth API

-- To manually create an admin via Supabase Dashboard:
-- 1. Go to Authentication > Users
-- 2. Click "Add User"
-- 3. Enter email: admin@tikkets.com, password: 12345678
-- 4. Then run: UPDATE users SET role = 'admin' WHERE email = 'admin@tikkets.com';
