-- RRC Church System - Payment Method Patch
-- Adds a payment_method field to all finance transactions.
-- Safe to run more than once on MariaDB/MySQL versions used by XAMPP.

ALTER TABLE transactions ADD COLUMN IF NOT EXISTS payment_method VARCHAR(30) NOT NULL DEFAULT 'Cash';

SET @idx_payment := (SELECT COUNT(1) FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME='transactions' AND INDEX_NAME='idx_tx_payment_method');
SET @sql_payment := IF(@idx_payment = 0, 'ALTER TABLE transactions ADD INDEX idx_tx_payment_method (payment_method)', 'SELECT "Index idx_tx_payment_method already exists"');
PREPARE stmt_payment FROM @sql_payment;
EXECUTE stmt_payment;
DEALLOCATE PREPARE stmt_payment;

UPDATE settings SET value='8' WHERE `key`='schema_version';