Revision 4975
Added by daigle about 15 years ago
xmltables-postgres.sql | ||
---|---|---|
427 | 427 |
date_created TIMESTAMP, -- the datetime on which the version was created |
428 | 428 |
CONSTRAINT db_version_pk PRIMARY KEY (db_version_id) |
429 | 429 |
); |
430 |
|
|
431 |
/* |
|
432 |
* scheduled_job -- table to store scheduled jobs |
|
433 |
*/ |
|
434 |
CREATE SEQUENCE scheduled_job_id_seq; |
|
435 |
CREATE TABLE scheduled_job ( |
|
436 |
id INT8 NOT NULL default nextval('scheduled_job_id_seq'), |
|
437 |
date_created TIMESTAMP NOT NULL, |
|
438 |
date_updated TIMESTAMP NOT NULL, |
|
439 |
status VARCHAR(64) NOT NULL, |
|
440 |
name VARCHAR(512) NOT NULL, |
|
441 |
trigger_name VARCHAR(512) NOT NULL, |
|
442 |
group_name VARCHAR(512) NOT NULL, |
|
443 |
class_name VARCHAR(1024) NOT NULL, |
|
444 |
start_time TIMESTAMP NOT NULL, |
|
445 |
interval_value INT NOT NULL, |
|
446 |
interval_unit VARCHAR(8) NOT NULL, |
|
447 |
CONSTRAINT scheduled_job_pk PRIMARY KEY (id), |
|
448 |
CONSTRAINT scheduled_job_uk UNIQUE (name) |
|
449 |
); |
|
450 |
|
|
451 |
/* |
|
452 |
* scheduled_job_params -- table to store scheduled jobs |
|
453 |
*/ |
|
454 |
CREATE SEQUENCE scheduled_job_params_id_seq; |
|
455 |
CREATE TABLE scheduled_job_params ( |
|
456 |
id INT8 NOT NULL default nextval('scheduled_job_params_id_seq'), |
|
457 |
date_created TIMESTAMP NOT NULL, |
|
458 |
date_updated TIMESTAMP NOT NULL, |
|
459 |
status VARCHAR(64) NOT NULL, |
|
460 |
job_id INT8 NOT NULL, |
|
461 |
key VARCHAR(64) NOT NULL, |
|
462 |
value VARCHAR(1024) NOT NULL, |
|
463 |
CONSTRAINT scheduled_job_params_pk PRIMARY KEY (id), |
|
464 |
CONSTRAINT scheduled_job_params_fk |
|
465 |
FOREIGN KEY (job_id) REFERENCES scheduled_job(id) |
|
466 |
); |
Also available in: Unified diff
Add upgrade scripts for 1.9.2 (scheduler tables)