-- SQL migration: Change IsAmbassador to MembershipClass
ALTER TABLE Beneficiary ADD COLUMN MembershipClass VARCHAR(20) DEFAULT NULL;
UPDATE Beneficiary SET MembershipClass = 'Ambassador' WHERE IsAmbassador = 1;
-- Optionally, migrate existing routes from BeneficiaryEnquiry if needed
-- Remove IsAmbassador column
ALTER TABLE Beneficiary DROP COLUMN IsAmbassador;
