-- RRC Church System: Missions Fund Pledge Seed/Mbegu field
-- Safe to run more than once.

ALTER TABLE transactions ADD COLUMN seed_amount DECIMAL(12,2) NOT NULL DEFAULT 0;
ALTER TABLE transactions ADD INDEX idx_tx_seed_amount (seed_amount);

UPDATE settings SET value='11' WHERE `key`='schema_version' AND CAST(value AS UNSIGNED) < 11;