-- Add admin_notes column to registrations table
-- This column will store rich text admin notes for each registration

USE xchange_reg;

ALTER TABLE registrations 
ADD COLUMN admin_notes TEXT 
AFTER payment_deadline;

-- Add comment to describe the column
ALTER TABLE registrations 
MODIFY COLUMN admin_notes TEXT COMMENT 'Rich text admin notes for this registration';
