-- Adds loan start date support for existing loan tables.

DROP PROCEDURE IF EXISTS add_loan_start_date_column;

DELIMITER //
CREATE PROCEDURE add_loan_start_date_column()
BEGIN
  IF NOT EXISTS (
    SELECT 1
    FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = DATABASE()
      AND TABLE_NAME = 'loans'
      AND COLUMN_NAME = 'loan_start_date'
  ) THEN
    ALTER TABLE `loans` ADD COLUMN `loan_start_date` date DEFAULT NULL AFTER `loan_tenure_months`;
  END IF;
END//
DELIMITER ;

CALL add_loan_start_date_column();

DROP PROCEDURE IF EXISTS add_loan_start_date_column;