Project

General

Profile

« Previous | Next » 

Revision 2443

Added by sgarg about 19 years ago

Removed the code which created triggers. Added this code in the build file

View differences:

upgrade-db-to-1.5.sql
100 100
101 101 
CREATE SEQUENCE xml_returnfield_id_seq;
102 102
103 
CREATE TRIGGER xml_returnfield_before_insert
104 
BEFORE INSERT ON xml_returnfield FOR EACH ROW
105 
BEGIN
106 
  SELECT xml_returnfield_id_seq.nextval
107 
    INTO :new.returnfield_id
108 
    FROM dual;
109 
END;
110 
/
111 103 

  		




  112
  
  
    

  		




  113
  104
  
    
/*


  		




  114
  105
  
    
 * Queryresults -- table to store queryresults for a given docid


  		




  115
  106
  
    
 * and returnfield_id


  		




  ......




  128
  119
  
    
CREATE INDEX xml_queryresult_idx1 ON xml_queryresult (returnfield_id, docid);


  		




  129
  120
  
    
                                                                                 


  		




  130
  121
  
    
CREATE SEQUENCE xml_queryresult_id_seq;


  		




  131
  
  
    
                                                                                 


  		




  132
  
  
    
CREATE TRIGGER xml_queryresult_before_insert


  		




  133
  
  
    
BEFORE INSERT ON xml_queryresult FOR EACH ROW


  		




  134
  
  
    
BEGIN


  		




  135
  
  
    
 SELECT xml_queryresult_id_seq.nextval


  		




  136
  
  
    
   INTO :new.queryresult_id


  		




  137
  
  
    
   FROM dual;


  		




  138
  
  
    
END;


  		




  139
  
  
    
/


  		




  140
  122
  
    

  		












Also available in:  Unified diff