-- Add base amount in EGP for all finance records
ALTER TABLE app.finance_record ADD COLUMN amount_egp NUMERIC(12,2);

-- For existing EGP records, set amount_egp = amount
UPDATE app.finance_record SET amount_egp = amount WHERE currency = 'EGP';