-- Add email and role columns to users table
ALTER TABLE users ADD COLUMN IF NOT EXISTS email VARCHAR(255) AFTER username;
ALTER TABLE users ADD COLUMN IF NOT EXISTS role VARCHAR(50) DEFAULT 'user' AFTER password;

-- Set existing admin user to admin role
UPDATE users SET role = 'admin' WHERE username = 'admin';