Project

General

Profile

« Previous | Next » 

Revision 2443

Added by sgarg over 19 years ago

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

View differences:

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