| -- Apache ODE - SimpleScheduler Database Schema | |
| -- | |
| -- MySQL scripts by Maciej Szefler. | |
| -- | |
| -- | |
| DROP TABLE IF EXISTS ODE_JOB; | |
| CREATE TABLE ODE_JOB ( | |
| jobid CHAR(64) NOT NULL DEFAULT '', | |
| ts BIGINT NOT NULL DEFAULT 0, | |
| nodeid char(64) NULL, | |
| scheduled int NOT NULL DEFAULT 0, | |
| transacted int NOT NULL DEFAULT 0, | |
| details blob(4096) NULL, | |
| PRIMARY KEY(jobid), | |
| INDEX IDX_ODE_JOB_TS(ts), | |
| INDEX IDX_ODE_JOB_NODEID(nodeid) | |
| ) | |
| TYPE=InnoDB; | |
| COMMIT; | |