-- Adds Cheque and COD (Cash on Delivery) as payment methods to an already-
-- provisioned database. Only needed if your `payments` table predates this
-- change — a fresh `mysql -u root -p < schema.sql` import already includes
-- these values.
--
-- Usage: mysql -u root -p petzy_pos < add_payment_methods.sql

ALTER TABLE payments
    MODIFY COLUMN method ENUM('cash','card','upi','bank_transfer','wallet','online','cheque','cod','room_charge','credit','other') NOT NULL DEFAULT 'cash';