-- RRC Church System: Offering types, pledge amount, and member offering reports
ALTER TABLE transactions ADD COLUMN pledge_amount DECIMAL(12,2) NULL;
ALTER TABLE transactions ADD KEY idx_tx_member_offering_report (type, sub_type, member_id, tx_date);

INSERT INTO settings(`key`, value) VALUES
('schema_version','9')
ON DUPLICATE KEY UPDATE value = IF(CAST(value AS UNSIGNED) < 9, '9', value);

INSERT INTO settings(`key`, value) VALUES
('offering_types_json','{"sunday_offering":{"key":"sunday_offering","name":"Sunday Offering","active":1,"include_in_10pct":1,"deduct_expenses":1,"member_report":0,"has_pledge":0,"system":1,"description":"Main Sunday service offering."},"midweek_service_offering":{"key":"midweek_service_offering","name":"Midweek Service Offering","active":1,"include_in_10pct":1,"deduct_expenses":1,"member_report":0,"has_pledge":0,"system":1,"description":"Monday, Tuesday, Wednesday, Friday, Saturday and Friday Overnight offerings."},"zone_offering":{"key":"zone_offering","name":"Zone Offering","active":1,"include_in_10pct":1,"deduct_expenses":1,"member_report":0,"has_pledge":0,"system":1,"description":"Zone/group offering."},"ministry_offering":{"key":"ministry_offering","name":"Ministry Offering","active":1,"include_in_10pct":1,"deduct_expenses":1,"member_report":0,"has_pledge":0,"system":1,"description":"Department/ministry offering."},"missions_fund_pledge":{"key":"missions_fund_pledge","name":"Missions Fund Pledge","active":1,"include_in_10pct":0,"deduct_expenses":0,"member_report":1,"has_pledge":1,"system":1,"description":"Separate pledge fund. Not tithed and not used for expense deduction."},"monthly_bills":{"key":"monthly_bills","name":"Monthly Bills","active":1,"include_in_10pct":0,"deduct_expenses":0,"member_report":1,"has_pledge":1,"system":1,"description":"Separate monthly bills fund. Not tithed and not used for expense deduction."}}')
ON DUPLICATE KEY UPDATE value=value;