-- Create Table Statement for 'FTP Gates Log'
DROP TABLE IF EXISTS `FTP_GATES_LOG`;
CREATE TABLE `FTP_GATES_LOG` (
	ID bigint(20) NOT NULL,
	MERCHANT_CODE int(11),
	REQUEST_DATE datetime,
	REQUEST_FILE_NAME varchar,
	RESPONSE_FILE_NAME varchar,
	SUBMISSION_ID bigint(20),
	PROCESSED_DATE datetime,
	STATUS_CL varchar,
	ERROR_MESSAGE varchar,
	IS_COMPRESSED_REQUEST_CONTENT tinyint(1),
	REQUEST_FILE_CONTENT_FK bigint(20),
	RESPONSE_FILE_CONTENT_FK bigint(20),
	FILE_CL varchar,
	AGGREGATION_CODE varchar,
	AGGREGATED_FTP_GATES_LOG_FK bigint(20),
	REQUEST_FILE_CHECKSUM varchar,
	VALIDATION_FILE_CONTENT_FK bigint(20),
	VALIDATION_FILE_NAME varchar,
	IS_LOCKED tinyint(1),
	AGGREGATION_LEVEL_CL varchar,
	AGGREGATION_LEVEL_CL varchar,
	AGGREGATION_LEVEL_CL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;