-- CareBill — CCAvenue and Razorpay side by side. Existing database:  mysql carebill < sql/razorpay_both.sql
ALTER TABLE payment_links
  ADD COLUMN gateway_provider VARCHAR(20) NULL AFTER short_url,
  ADD COLUMN gateway_ref VARCHAR(120) NULL AFTER gateway_provider,
  ADD COLUMN gateway_url VARCHAR(255) NULL AFTER gateway_ref;
INSERT INTO settings (k,v) VALUES ('pay_methods','ccavenue,razorpay'), ('pay_base_url','https://api.razorpay.com/v1')
ON DUPLICATE KEY UPDATE k=k;