Revision 4975
Added by daigle over 15 years ago
xmltables-oracle.sql | ||
---|---|---|
576 | 576 |
END; |
577 | 577 |
/ |
578 | 578 |
|
579 |
/* |
|
580 |
* scheduled_job -- table to store scheduled jobs |
|
581 |
*/ |
|
582 |
CREATE TABLE scheduled_job ( |
|
583 |
id NUMBER(20) NOT NULL default nextval('scheduled_job_id_seq'), |
|
584 |
date_created TIMESTAMP NOT NULL, |
|
585 |
date_updated TIMESTAMP NOT NULL, |
|
586 |
status VARCHAR2(64) NOT NULL, |
|
587 |
name VARCHAR2(512) NOT NULL, |
|
588 |
trigger_name VARCHAR2(512) NOT NULL, |
|
589 |
group_name VARCHAR2(512) NOT NULL, |
|
590 |
class_name VARCHAR2(1024) NOT NULL, |
|
591 |
start_time TIMESTAMP NOT NULL, |
|
592 |
interval_value NUMBER NOT NULL, |
|
593 |
interval_unit VARCHAR2(8) NOT NULL, |
|
594 |
CONSTRAINT scheduled_job_pk PRIMARY KEY (id), |
|
595 |
CONSTRAINT scheduled_job_uk UNIQUE (name) |
|
596 |
); |
|
597 |
|
|
598 |
CREATE SEQUENCE scheduled_job_id_seq; |
|
599 |
CREATE TRIGGER scheduled_job_before_insert |
|
600 |
BEFORE INSERT ON scheduled_job FOR EACH ROW |
|
601 |
BEGIN |
|
602 |
SELECT scheduled_job_id_seq.nextval |
|
603 |
INTO :new.id |
|
604 |
FROM dual; |
|
605 |
END; |
|
606 |
/ |
|
607 |
|
|
608 |
/* |
|
609 |
* scheduled_job_params -- table to store scheduled job parameters |
|
610 |
*/ |
|
611 |
CREATE TABLE scheduled_job_params ( |
|
612 |
id NUMBER(20) NOT NULL default nextval('scheduled_job_params_id_seq'), |
|
613 |
date_created TIMESTAMP NOT NULL, |
|
614 |
date_updated TIMESTAMP NOT NULL, |
|
615 |
status VARCHAR2(64) NOT NULL, |
|
616 |
job_id NUMBER(20) NOT NULL, |
|
617 |
key VARCHAR2(64) NOT NULL, |
|
618 |
value VARCHAR2(1024) NOT NULL, |
|
619 |
CONSTRAINT scheduled_job_params_pk PRIMARY KEY (id), |
|
620 |
CONSTRAINT scheduled_job_params_fk |
|
621 |
FOREIGN KEY (job_id) REFERENCES scheduled_job(id) |
|
622 |
); |
|
623 |
|
|
624 |
CREATE SEQUENCE scheduled_job_params_id_seq; |
|
625 |
CREATE TRIGGER scheduled_job_params_before_insert |
|
626 |
BEFORE INSERT ON scheduled_job_params FOR EACH ROW |
|
627 |
BEGIN |
|
628 |
SELECT scheduled_job_id_params_seq.nextval |
|
629 |
INTO :new.id |
|
630 |
FROM dual; |
|
631 |
END; |
|
632 |
/ |
|
633 |
|
Also available in: Unified diff
Add upgrade scripts for 1.9.2 (scheduler tables)