ALTER TABLE `kyc_customers` ADD `id_type` VARCHAR(50) NULL DEFAULT NULL AFTER `address_verified`, ADD `live_verification` TINYINT(1) NOT NULL DEFAULT '0' AFTER `id_type`, ADD `live_verification_data` JSON NULL DEFAULT NULL AFTER `live_verification`, ADD `admin_verified_by` INT NULL DEFAULT NULL AFTER `live_verification_data`, ADD `admin_verified_at` DATETIME NULL DEFAULT NULL AFTER `admin_verified_by`;
ALTER TABLE `kyc_customers` CHANGE `passport_url` `nin_card_url` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;
ALTER TABLE `kyc_customers` ADD `state` VARCHAR(50) NULL DEFAULT NULL AFTER `address`, ADD `city` VARCHAR(60) NULL DEFAULT NULL AFTER `state`, ADD `postal_code` VARCHAR(6) NULL DEFAULT NULL AFTER `city`, ADD `gender` VARCHAR(8) NULL DEFAULT NULL AFTER `postal_code`, ADD `marital_status` VARCHAR(20) NULL DEFAULT NULL AFTER `gender`, ADD `occupation` VARCHAR(50) NULL DEFAULT NULL AFTER `marital_status`;