-- Create Table Statement for 'File Batch'
DROP TABLE IF EXISTS `FILE_BATCH`;
CREATE TABLE `FILE_BATCH` (
	ID bigint(20) NOT NULL,
	IS_PROCESSED tinyint(1),
	IS_WAIT_RESPONSE tinyint(1),
	IS_AGGREGATED tinyint(1),
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	FILE_STORE_FK bigint(20),
	SUB_BATCH_FK bigint(20),
	AGGREGATED_FILE_STORE_FK bigint(20),
	IS_PERSISTENT tinyint(1),
	SUBMISSION_SUMMARY_FK bigint(20),
	AGGREGATED_FILE_STORE_FK bigint(20),
	AGGREGATED_FILE_STORE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;