Project

General

Profile

« Previous | Next » 

Revision 7035

fixed Oracle script issues identified by: Brian Turcotte <>. He provided the fixes, so thank you!

View differences:

upgrade-db-to-1.9.2-oracle.sql
2 2
 * scheduled_job -- table to store scheduled jobs
3 3
 */
4 4
CREATE TABLE scheduled_job (
5
  id NUMBER(20) NOT NULL default nextval('scheduled_job_id_seq'),
5
  id NUMBER(20) NOT NULL default ,
6 6
  date_created TIMESTAMP NOT NULL,
7 7
  date_updated TIMESTAMP NOT NULL,
8 8
  status VARCHAR2(64) NOT NULL,
......
31 31
 * scheduled_job_params -- table to store scheduled job parameters
32 32
 */
33 33
CREATE TABLE scheduled_job_params (
34
  id NUMBER(20)  NOT NULL default nextval('scheduled_job_params_id_seq'),
34
  id NUMBER(20)  NOT NULL ,
35 35
  date_created TIMESTAMP NOT NULL,
36 36
  date_updated TIMESTAMP  NOT NULL,
37 37
  status VARCHAR2(64)  NOT NULL,
......
44 44
);
45 45

  
46 46
CREATE SEQUENCE scheduled_job_params_id_seq;
47
CREATE TRIGGER scheduled_job_params_before_insert
47
CREATE TRIGGER scheduled_job_params_bef_ins
48 48
BEFORE INSERT ON scheduled_job_params FOR EACH ROW
49 49
BEGIN
50 50
  SELECT scheduled_job_id_params_seq.nextval

Also available in: Unified diff