-- Create Table Statement for 'Job Message Archive'
DROP TABLE IF EXISTS `IAPP_JOB_MESSAGE_ARCHIVE`;
CREATE TABLE `IAPP_JOB_MESSAGE_ARCHIVE` (
	CREATE_DATE datetime(3),
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	QUEUE_NAME varchar,
	LAST_ATTEMPT_DATE datetime(3),
	PRIORITY int(11),
	STATUS_CL varchar,
	JOB_MESSAGE_CONTENT_MESSAGE_FK bigint(20),
	JOB_MESSAGE_CONTENT_LOG_FK bigint(20),
	START_DATE datetime(3),
	END_DATE datetime(3),
	LAST_ATTEMPT_DATE datetime(3),
	DUE_DATE datetime(3),
	CREATE_DATE datetime(3),
	MERCHANT_ACCOUNT_CODE int(11),
	QUEUE_NAME varchar,
	PRIORITY int(11),
	STATUS_CL varchar,
	START_DATE datetime(3),
	END_DATE datetime(3),
	LAST_ATTEMPT_DATE datetime(3),
	DUE_DATE datetime(3),
	CREATE_DATE datetime(3),
	MERCHANT_ACCOUNT_CODE int(11),
	QUEUE_NAME varchar,
	PRIORITY int(11),
	STATUS_CL varchar,
	DURATION varchar,
	DURATION varchar,
	START_DATE datetime(3),
	END_DATE datetime(3),
	DUE_DATE datetime(3),
	DURATION varchar,
	TARGET_CL varchar,
	TARGET_ID bigint(20),
	TARGET_CL varchar,
	TARGET_ID bigint(20),
	TARGET_CL varchar,
	TARGET_ID bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;