...
In this case you must change in all SQL files (./db/mysql/*.sql) the TYPh1. InnoDB to ENGINEInnoDB.
Furthermore, missing three four CREATE TABLE statements.
Insert the following CREATE TABLEs to ./db/mysql/scheduler.sql:
| 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;
|
| Code Block |
|---|
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; |
| Code Block |
|---|
CREATE TABLE IF NOT EXISTS SCHEDULER_CLUSTERS (
"MEMBER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"SCHEDULER_ID" varchar(100) CHARACTER SET latin1 NOT NULL,
"PRECEDENCE" int(11),
"LAST_HEART_BEAT" int(11),
"NEXT_HEART_BEAT" int(11),
"ACTIVE" int(1),
"EXCLUSIVE" int(1),
"DEAD" int(1),
"COMMAND" varchar(250),
"HTTP_URL" varchar(100),
"DEACTIVATING_MEMBER_ID" varchar(100),
"XML" longtext,
PRIMARY KEY ("MEMBER_ID")
) ENGINE=InnoDB;
|
Start the ./install/scheduler_install_tables.(cmd|sh) script.