| CREATE TABLE ode_job ( | |
| jobid CHAR(64) NOT NULL DEFAULT '', | |
| ts BIGINT NOT NULL DEFAULT 0, | |
| nodeid char(64), | |
| scheduled int NOT NULL DEFAULT 0, | |
| transacted int NOT NULL DEFAULT 0, | |
| instanceId BIGINT, | |
| mexId varchar(255), | |
| processId varchar(255), | |
| type varchar(255), | |
| channel varchar(255), | |
| correlatorId varchar(255), | |
| correlationKeySet varchar(255), | |
| retryCount int, | |
| inMem int, | |
| detailsExt blob(4096), | |
| PRIMARY KEY(jobid)) |