-- EMI payment module migration for existing Gold Loan databases.
-- Run this if loan_module.sql was already imported before EMI payments were added.

CREATE TABLE IF NOT EXISTS `loan_emi_payments` (
  `pay_id` int NOT NULL AUTO_INCREMENT,
  `pay_emi_id` int NOT NULL,
  `pay_loan_id` int NOT NULL,
  `pay_amount_type` enum('Online','UPI','Cash','Other') NOT NULL DEFAULT 'Cash',
  `pay_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `pay_date` date NOT NULL,
  `pay_transaction_id` varchar(120) DEFAULT NULL,
  `pay_remarks` text,
  `pay_received_by` int DEFAULT NULL,
  `pay_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`pay_id`),
  KEY `pay_emi_id` (`pay_emi_id`),
  KEY `pay_loan_id` (`pay_loan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;