-- Create Table Statement for 'Subuno Fraud Transaction'
DROP TABLE IF EXISTS `SUBUNO_FRAUD_TRANSACTION`;
CREATE TABLE `SUBUNO_FRAUD_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SOURCE varchar,
	TID bigint(20),
	IP_ADDR varchar,
	CUSTOMER_NAME varchar,
	PHONE varchar,
	EMAIL varchar,
	COMPANY varchar,
	PRICE varchar,
	BILL_STREET1 varchar,
	BILL_CITY varchar,
	BILL_STATE varchar,
	BILL_COUNTRY varchar,
	BILL_ZIP varchar,
	SHIP_NAME varchar,
	SHIP_STREET1 varchar,
	SHIP_CITY varchar,
	SHIP_STATE varchar,
	SHIP_ZIP varchar,
	AVS_RESPONSE varchar,
	CVV_RESPONSE varchar,
	ACTION varchar,
	REF_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;