-- PARAM Hospital: Registration Billing wiring.
-- Purely additive: seeds one settings row so the receptionist's Registration Fee amount is
-- configurable from Admin > System Settings. Does NOT create, alter or drop any table, and
-- does NOT touch any existing data. Safe to run multiple times (INSERT IGNORE).
-- Run once, after the existing accounting/billing migrations (accounting_billing_upgrade.sql,
-- part1_patient_advance_payment_upgrade.sql, part2_advance_balance_adjustment_upgrade.sql).

INSERT INTO `settings` (`type`, `description`)
SELECT 'registration_fee', '500' FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM `settings` WHERE `type` = 'registration_fee');