-- Create Table Statement for 'Authentication Three D Secure'
DROP TABLE IF EXISTS `AUTHENTICATION_THREE_D_SECURE`;
CREATE TABLE `AUTHENTICATION_THREE_D_SECURE` (
	ID bigint(20) NOT NULL,
	BANK_URL varchar,
	THREE_D_SECURE_MPI_CL varchar,
	ACCEPTANCE_POLICY varchar,
	STATUS_CL varchar,
	THREE_D_SECURE_PROFILE_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	VERIFY_ENROLLMENT_STATUS varchar,
	THREE_D_SECURE_AUTHENTICATION_STATUS varchar,
	ECI varchar,
	SIGNATURE_STATUS varchar,
	THREE_D_SECURE_LOG_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	THREE_D_SECURE_VERSION varchar,
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	CHALLENGE_ID varchar,
	STATUS varchar,
	CHALLENGE_ERROR varchar,
	THREE_D_SECURE_VERSION varchar,
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	CHALLENGE_ID varchar,
	STATUS varchar,
	CHALLENGE_ERROR varchar,
	THREE_D_SECURE_VERSION varchar,
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	CHALLENGE_ID varchar,
	STATUS varchar,
	CHALLENGE_ERROR varchar,
	STATUS_REASON_CODE varchar,
	STATUS_REASON_CODE varchar,
	STATUS_REASON_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;