-- Create Table Statement for 'File Store'
DROP TABLE IF EXISTS `FILE_STORE`;
CREATE TABLE `FILE_STORE` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ORIGINAL_MERCHANT_ACCOUNT_CODE int(11),
	REQUEST_FILE_NAME varchar,
	REQUEST_DATE datetime,
	RENAME_TO varchar,
	RESPONSE_FILE_NAME varchar,
	RESPONSE_DATE datetime,
	TOTAL_COUNT int(11),
	TOTAL_AMOUNT bigint(20),
	IS_WAIT_RESPONSE tinyint(1),
	STATUS varchar,
	PROVIDER_CODE bigint(20),
	OPERATION_CL varchar,
	NEXT_ATTEMPT_DATE datetime,
	IS_COMPRESSED_FILE_CONTENT tinyint(1),
	IS_BINARY tinyint(1),
	REQUEST_PGP_ACTION_CL varchar,
	FORMAT_PATTERN varchar,
	IS_TOKENIZED tinyint(1),
	EXTRACTOR varchar,
	ENCODER varchar,
	FILE_STORE_RESOLVER varchar,
	IS_ON_DOWNLOAD_DELETE_REQUIRED tinyint(1),
	IS_VIRTUAL_REMOTE_FOLDER tinyint(1),
	DELIVERY_MODE_CL varchar,
	RESPONSE_PGP_ACTION_CL varchar,
	FILE_STORE_CONTENT_FK bigint(20),
	CONFIG_DATA_FK bigint(20),
	PROVIDER_ACCOUNT_FK bigint(20),
	DECRYPT_TOKENIZATION_FILE_STORE_FK bigint(20),
	ENCRYPT_TOKENIZATION_FILE_STORE_FK bigint(20),
	TOKEN_REGISTER_PROFILE_FK bigint(20),
	AGGREGATION_PROTOTYPE varchar,
	AGGREGATION_CODE varchar,
	IS_AGGREGATED tinyint(1),
	AGGREGATION_FILE_STORE_FK bigint(20),
	IS_PERSISTENT tinyint(1),
	DOWNLOAD_ATTEMPT_DATE datetime,
	REQUEST_LOCK_PATH varchar,
	RESPONSE_LOCK_PATH varchar,
	FILE_STORE_CL varchar,
	BILLING_PROFILE_TYPE varchar,
	TOKENIZATION_PROVIDER_CL varchar,
	AGGREGATION_CYCLE_FK bigint(20),
	RESPONSE_DELAY int(11),
	BILLING_PROFILE_CODE bigint(20),
	METADATA varchar,
	SUBMISSION_SUMMARY_FK bigint(20),
	TOKENIZATION_FILE_STORE_FK bigint(20),
	FILE_STORE_FK bigint(20),
	AGGREGATED_FILE_STORE_FK bigint(20),
	AGGREGATION_DATE datetime,
	AGGREGATION_DATE datetime,
	AGGREGATION_FILE_STORE_FK bigint(20),
	AGGREGATION_FILE_STORE_FK bigint(20),
	AGGREGATION_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;