-- Run this once on an existing Lea 405 database before uploading the updated PHP files.
ALTER TABLE meetings
  ADD COLUMN special_event_type ENUM('none','ladies_evening','white_table','blue_table')
  NOT NULL DEFAULT 'none' AFTER visitor_price;

ALTER TABLE bookings
  ADD COLUMN attendee_type ENUM('lodge_member','visiting_member','ladies_evening_guest','white_table_guest','blue_table_guest')
  NOT NULL DEFAULT 'visiting_member' AFTER is_lodge_member;

UPDATE bookings
SET attendee_type = CASE WHEN is_lodge_member = 1 THEN 'lodge_member' ELSE 'visiting_member' END;