-- ═══════════════════════════════════════════════════════════════════════
-- Bulk Fee Payment — credit issuance/consumption (feature: bulk_fee_payment)
--
-- payments.payment_method += 'credit': when an "Apply Credit" action
-- (fees.php) consumes a student's available student_fee_credits balance
-- against their outstanding fees, it writes ordinary `payments` rows same as
-- any other payment channel, tagged payment_method='credit' so it's clearly
-- distinguishable from actual cash/card/bank_transfer/online money in.
--
-- Idempotent on MariaDB (XAMPP), matching every other migration in this folder.
-- ═══════════════════════════════════════════════════════════════════════

ALTER TABLE `payments` MODIFY COLUMN `payment_method`
    enum('cash','card','bank_transfer','online','credit') DEFAULT 'cash';
