-- Add email column to assessors table
ALTER TABLE assessors ADD COLUMN email VARCHAR(255) NOT NULL AFTER contact;