-- ========================================== -- Migration: Add exam_password to profiles -- ========================================== -- Add the new column to store exam passwords ALTER TABLE public.profiles ADD COLUMN IF NOT EXISTS exam_password TEXT; -- (Optional) Add a comment to the column for documentation COMMENT ON COLUMN public.profiles.exam_password IS 'Stores the exam password associated with the user profile';