-- Create Table Statement for 'Tsys Onboarding Terminal'
DROP TABLE IF EXISTS `TSYS_ONBOARDING_TERMINAL`;
CREATE TABLE `TSYS_ONBOARDING_TERMINAL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ONBOARDING_TERMINAL_FK bigint(20),
	TERMINAL_NUMBER varchar,
	STORE_NUMBER varchar,
	RESULT_DATA longtext,
	FAULT_CODE varchar,
	FAULT_STRING varchar,
	ERROR_CODE varchar,
	ERROR_DESCRIPTION varchar,
	TRANSACTION_ID varchar,
	ERROR_LIST longtext,
	WARNING_LIST longtext,
	VITAL_SERVICE_NUMBER varchar,
	REQUEST_ID varchar,
	MIF_LOCATION_CODE varchar,
	TSYS_PROVISIONING_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;