| -- Apache ODE - SimpleScheduler Database Schema | |
| -- | |
| -- Apache Derby scripts by Maciej Szefler. | |
| -- | |
| -- | |
| 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, | |
| details blob(4096), | |
| PRIMARY KEY(jobid)); | |
| CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); | |
| CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); | |