Project

General

Profile

« Previous | Next » 

Revision 7035

Added by ben leinfelder about 12 years ago

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

View differences:

src/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