-- Store the extended merchant onboarding profile fields.
|
DELIMITER $$
|
DROP PROCEDURE IF EXISTS add_merchant_onboarding_profile_columns$$
|
CREATE PROCEDURE add_merchant_onboarding_profile_columns()
|
BEGIN
|
DECLARE col_exists INT DEFAULT 0;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'merchant_name';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN merchant_name VARCHAR(128) DEFAULT NULL AFTER registered_address; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'merchant_short_name';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN merchant_short_name VARCHAR(128) DEFAULT NULL AFTER merchant_name; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'company_type';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN company_type VARCHAR(64) DEFAULT NULL AFTER merchant_short_name; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'business_license_url';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN business_license_url VARCHAR(512) DEFAULT NULL AFTER company_type; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'established_date';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN established_date CHAR(10) DEFAULT NULL AFTER business_license_url; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'registered_capital';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN registered_capital VARCHAR(64) DEFAULT NULL AFTER established_date; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'legal_id_front_url';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN legal_id_front_url VARCHAR(512) DEFAULT NULL AFTER registered_capital; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'legal_id_back_url';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN legal_id_back_url VARCHAR(512) DEFAULT NULL AFTER legal_id_front_url; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'legal_certificate_address';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN legal_certificate_address VARCHAR(255) DEFAULT NULL AFTER legal_id_back_url; END IF;
|
SELECT COUNT(*) INTO col_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'merchant_onboarding_application' AND COLUMN_NAME = 'administrator_email';
|
IF col_exists = 0 THEN ALTER TABLE merchant_onboarding_application ADD COLUMN administrator_email VARCHAR(128) DEFAULT NULL AFTER legal_certificate_address; END IF;
|
END$$
|
DELIMITER ;
|
CALL add_merchant_onboarding_profile_columns();
|
DROP PROCEDURE IF EXISTS add_merchant_onboarding_profile_columns;
|
