...
| Code Block |
|---|
CREATE TABLE IF NOT EXISTS SCHEDULER_JOBS (
"SPOOLER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"CLUSTER_MEMBER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"PATH" varchar(255) CHARACTER SET latin1 NOT NULL,
"STOPPED" int(1) NOT NULL DEFAULT 0,
"NEXT_START_TIME" varchar(24) ,
PRIMARY KEY ("SPOOLER_ID","CLUSTER_MEMBER_ID","PATH")
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS SCHEDULER_JOB_CHAINS (
"SPOOLER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"CLUSTER_MEMBER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"PATH" varchar(255) CHARACTER SET latin1 NOT NULL,
"STOPPED" int(1) NOT NULL DEFAULT 0,
PRIMARY KEY ("SPOOLER_ID","CLUSTER_MEMBER_ID","PATH")
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS SCHEDULER_JOB_CHAIN_NODES (
"SPOOLER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"CLUSTER_MEMBER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"JOB_CHAIN" varchar(255) CHARACTER SET latin1 NOT NULL,
"ORDER_STATE" varchar(100) CHARACTER SET latin1 NOT NULL,
"ACTION" varchar(100) ,
PRIMARY KEY ("SPOOLER_ID","CLUSTER_MEMBER_ID","JOB_CHAIN","ORDER_STATE")
) ENGINE=InnoDB;
|
...