-- Update registrations table to match new form structure
-- This script ensures investment_units is required and other fields are properly configured

ALTER TABLE registrations MODIFY address TEXT NULL;
ALTER TABLE registrations MODIFY investment_units VARCHAR(50) NOT NULL;
ALTER TABLE registrations MODIFY other_amount DECIMAL(15, 2) NULL;