-- Create Table Statement for 'Retail FirstData Omaha Profile'
DROP TABLE IF EXISTS `RETAIL_FIRST_DATA_OMAHA_PROFILE`;
CREATE TABLE `RETAIL_FIRST_DATA_OMAHA_PROFILE` (
	ID bigint(20) NOT NULL,
	TERMINAL_ID varchar,
	MERCHANT_NUMBER varchar,
	DEVICE_ID1 varchar,
	TPP varchar,
	BATCH_NUMBER1 int(11),
	DEVICE_ID2 varchar,
	DEVICE_ID3 varchar,
	DEVICE_ID4 varchar,
	DEVICE_ID5 varchar,
	DEVICE_ID6 varchar,
	DEVICE_ID7 varchar,
	BATCH_NUMBER2 int(11),
	BATCH_NUMBER3 int(11),
	BATCH_NUMBER4 int(11),
	BATCH_NUMBER5 int(11),
	BATCH_NUMBER6 int(11),
	BATCH_NUMBER7 int(11),
	RETAIL_TRANSACTION_CYCLE_CODE1 bigint(20),
	RETAIL_TRANSACTION_CYCLE_CODE2 bigint(20),
	RETAIL_TRANSACTION_CYCLE_CODE3 bigint(20),
	RETAIL_TRANSACTION_CYCLE_CODE4 bigint(20),
	RETAIL_TRANSACTION_CYCLE_CODE5 bigint(20),
	RETAIL_TRANSACTION_CYCLE_CODE6 bigint(20),
	RETAIL_TRANSACTION_CYCLE_CODE7 bigint(20),
	CURRENT_DEVICE_NUMBER int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;