-- Direct SQL to add missing columns to will_beneficiaries table
-- Run this if migrations fail

ALTER TABLE `will_beneficiaries` ADD COLUMN `email` VARCHAR(255) NULL AFTER `phone`;
ALTER TABLE `will_beneficiaries` ADD COLUMN `address` LONGTEXT NULL AFTER `email`;

-- Verify columns were added
DESCRIBE `will_beneficiaries`;

-- Check a few records
SELECT id, will_id, full_name, relationship, email, address FROM `will_beneficiaries` LIMIT 5;