-- Create Table Statement for 'Three D Secure Profile'
DROP TABLE IF EXISTS `THREE_D_SECURE_PROFILE`;
CREATE TABLE `THREE_D_SECURE_PROFILE` (
ID bigint(20) NOT NULL,
THREE_D_SECURE_MPI_CL varchar,
MERCHANT_ID varchar,
MERCHANT_NAME varchar,
MERCHANT_COUNTRY varchar,
MERCHANT_BIN_MASTER_CARD varchar,
MERCHANT_URL varchar,
ACCEPTANCE_POLICY varchar,
MERCHANT_PASSWORD varchar,
MERCHANT_BIN_VISA varchar,
ACCOUNT_NUMBER varchar,
API_KEY varchar,
AUTHENTICATION_THREE_D_SECURE_FK bigint(20),
MERCHANT_ACCOUNT_PROFILE_FK bigint(20),
THREE_D_SECURE_VERSION varchar NOT NULL,
THREE_D_SECURE_VERSION varchar NOT NULL,
MERCHANT_IDENTIFIER varchar,
IS_TEST tinyint(1),
SCRIPT_API_KEY varchar,
REQUESTOR_ID varchar,
MERCHANT_IDENTIFIER varchar,
IS_TEST tinyint(1),
SCRIPT_API_KEY varchar,
REQUESTOR_ID varchar,
THREE_D_SECURE_VERSION varchar NOT NULL,
MERCHANT_IDENTIFIER varchar,
IS_TEST tinyint(1),
SCRIPT_API_KEY varchar,
REQUESTOR_ID varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;