-- Create Table Statement for 'Giact Account Verification Transaction' DROP TABLE IF EXISTS `GIACT_ACCOUNT_VERIFICATION_TRANSACTION`; CREATE TABLE `GIACT_ACCOUNT_VERIFICATION_TRANSACTION` ( ID bigint(20) NOT NULL, MERCHANT_ACCOUNT_CODE int(11), CHARGE_TRANSACTION_FK bigint(20), API_USERNAME varchar, UNIQUE_ID varchar, ACCOUNT_TYPE varchar, ITEM_REFERENCE_ID varchar, CREATED_DATE varchar, VERIFICATION_RESPONSE varchar, ACCOUNT_RESPONSE_CODE varchar, BANK_NAME varchar, BANK_ACCOUNT_TYPE varchar, ACCOUNT_ADDED_DATE varchar, ACCOUNT_LAST_UPDATED_DATE varchar, ACCOUNT_CLOSED_DATE varchar, ERROR_MESSAGE varchar, PRIMARY KEY (ID) ) ENGINE=InnoDB;