-- Create Table Statement for 'MiGS Auth Retail Transaction'
DROP TABLE IF EXISTS `MIGS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `MIGS_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	VPC_COMMAND varchar,
	VPC_ACCESS_CODE varchar,
	VPC_MERCHANT varchar,
	VPC_ORDER_INFO varchar,
	VPC_AMOUNT int(11),
	VPC_MERCH_TXN_REF varchar,
	VPC_TICKET_NO varchar,
	VPC_TX_SOURCE varchar,
	VPC_TX_SOURCE_SUB_TYPE varchar,
	VPC_SHOP_TRANSACTION_NO varchar,
	VPC_AUTHORISED_AMOUNT int(11),
	VPC_CAPTURED_AMOUNT int(11),
	VPC_REFUNDED_AMOUNT int(11),
	VPC3_DS_ENROLLED varchar,
	VPC3_DS_STATUS varchar,
	VPC_TXN_RESPONSE_CODE varchar,
	VPC_TRANSACTION_NO varchar,
	VPC_MESSAGE varchar,
	VPC_ACQ_RESPONSE_CODE varchar,
	VPC_RECEIPT_NO varchar,
	VPC_BATCH_NO varchar,
	VPC_AUTHORIZE_ID varchar,
	VPC_CARD varchar,
	VPC_ACQ_C_S_C_RESP_CODE varchar,
	VPC_CSC_RESULT_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	VPC_VER_STATUS varchar,
	VPC_VER_SECURITY_LEVEL varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;