-- Add Next of Kin and Membership Fee fields to Beneficiary
ALTER TABLE Beneficiary 
  ADD COLUMN NextOfKinName VARCHAR(100) DEFAULT NULL,
  ADD COLUMN NextOfKinTitle VARCHAR(100) DEFAULT NULL,
  ADD COLUMN NextOfKinPhone VARCHAR(20) DEFAULT NULL,
  ADD COLUMN NextOfKinAddress TEXT DEFAULT NULL,
  ADD COLUMN NextOfKinOccupation VARCHAR(100) DEFAULT NULL,
  ADD COLUMN FeePaid TINYINT(1) DEFAULT 0,
  ADD COLUMN FeeAmount DECIMAL(10,2) DEFAULT NULL,
  ADD COLUMN PaymentConfirmation VARCHAR(100) DEFAULT NULL;
