-- Account closure audit details.
-- Safe to import again on deployments that support ADD COLUMN IF NOT EXISTS.

ALTER TABLE `clients`
    ADD COLUMN IF NOT EXISTS `key_returned` TINYINT(1) NULL AFTER `close_reason`,
    ADD COLUMN IF NOT EXISTS `key_deposit_settlement` VARCHAR(30) NULL AFTER `key_returned`,
    ADD COLUMN IF NOT EXISTS `refund_bank_name` VARCHAR(150) NULL AFTER `key_deposit_settlement`,
    ADD COLUMN IF NOT EXISTS `refund_account_name` VARCHAR(150) NULL AFTER `refund_bank_name`,
    ADD COLUMN IF NOT EXISTS `refund_account_number` VARCHAR(100) NULL AFTER `refund_account_name`,
    ADD COLUMN IF NOT EXISTS `refund_ifsc_code` VARCHAR(30) NULL AFTER `refund_account_number`;