Project

General

Profile

« Previous | Next » 

Revision 2567

Added by sgarg over 19 years ago

Small bugfixes to the oracle upgrade script for metacat 1.6

View differences:

src/upgrade-db-to-1.6.sql
27 27 
 * Create the xml_path_index table
28 28 
 */
29 29 

  		




  
  30
  
    
CREATE SEQUENCE xml_path_index_id_seq;


  		




  30
  31
  
    
CREATE TABLE xml_path_index (


  		




  31
  32
  
    
        nodeid          NUMBER(20),     -- the unique node id


  		




  32
  33
  
    
        docid           VARCHAR2(250),  -- index to the document id


  		




  ......




  42
  43
  
    
                FOREIGN KEY (docid) REFERENCES xml_documents


  		




  43
  44
  
    
);


  		




  44
  45
  
    
                                                                                                                                                             


  		




  45
  
  
    
CREATE SEQUENCE xml_path_index_id_seq;


  		




  46
  
  
    
                                                                                                                                                             


  		




  47
  46
  
    
CREATE TRIGGER xml_path_index_before_insert


  		




  48
  
  
    
BEFORE INSERT ON xml_path_indexn FOR EACH ROW


  		




  
  47
  
    
BEFORE INSERT ON xml_path_index FOR EACH ROW


  		




  49
  48
  
    
BEGIN


  		




  50
  49
  
    
  SELECT xml_path_index_id_seq.nextval


  		




  51
  
  
    
    INTO :new.relationid


  		




  
  50
  
    
    INTO :new.nodeid


  		




  52
  51
  
    
    FROM dual;


  		




  53
  52
  
    
END;


  		




  54
  53
  
    
/


  		












Also available in:  Unified diff