-- Create Table Statement for 'Job Message'
DROP TABLE IF EXISTS `IAPP_JOB_MESSAGE`;
CREATE TABLE `IAPP_JOB_MESSAGE` (
	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),
	LAST_ATTEMPT_DATE datetime(3),
	CREATE_DATE datetime(3),
	LAST_ATTEMPT_DATE datetime(3),
	CREATE_DATE datetime(3),
	CREATE_DATE datetime(3),
	CREATE_DATE datetime(3),
	CREATE_DATE datetime(3) NOT NULL,
	QUEUE_NAME varchar NOT NULL,
	QUEUE_NAME varchar NOT NULL,
	QUEUE_NAME varchar,
	QUEUE_NAME varchar,
	DUE_DATE datetime(3),
	START_DATE datetime(3),
	END_DATE datetime(3),
	LAST_ATTEMPT_DATE datetime(3),
	CREATE_DATE datetime(3),
	MERCHANT_ACCOUNT_CODE int(11),
	QUEUE_NAME varchar,
	PRIORITY int(11),
	STATUS_CL varchar,
	DUE_DATE datetime(3),
	START_DATE datetime(3),
	END_DATE datetime(3),
	LAST_ATTEMPT_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,
	CREATE_DATE datetime(3),
	DUE_DATE datetime(3),
	CREATE_DATE datetime(3),
	DUE_DATE datetime(3),
	START_DATE datetime(3),
	END_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),
	QUEUE_NAME varchar,
	END_DATE datetime(3),
	START_DATE datetime(3),
	DUE_DATE datetime(3),
	CREATE_DATE datetime(3),
	ID bigint(20) NOT NULL,
	ID bigint(20) NOT NULL,
	QUEUE_NAME varchar,
	END_DATE datetime(3),
	START_DATE datetime(3),
	DUE_DATE datetime(3),
	CREATE_DATE datetime(3),
	PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;