-- 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;