Project

General

Profile

« Previous | Next » 

Revision 6209

Added by ben leinfelder almost 13 years ago

merge changes from 1.9.5 branch for upgrade process (1.9.3->1.9.4->1.9.5)

View differences:

src/xmltables-oracle.sql
296 296 
  startnodeid NUMBER(20), -- start node for sub tree
297 297 
  endnodeid NUMBER(20),    -- end node for sub tree
298 298 
   CONSTRAINT xml_access_ck CHECK (begin_time < end_time),
299 
   CONSTRAINT xml_access_accessfileid_fk
300 
		FOREIGN KEY (accessfileid) REFERENCES xml_documents
301 299 
);
302 300 
CREATE INDEX xml_access_idx1 ON xml_access (lower(principal_name));
303 301 
CREATE INDEX xml_access_idx2 ON xml_access (permission);
src/upgrade-db-to-1.9.4-oracle.sql
1 
UPDATE db_version SET status=0;
2 

  		




  
  3
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  4
  
    
  VALUES ('1.9.4', 1, CURRENT_DATE);


  		




  0
  5
  
    

  		












  

    
      src/upgrade-db-to-1.9.5-postgres.sql
    
  





  
  1
  
    
ALTER TABLE xml_access DROP CONSTRAINT xml_access_accessfileid_fk;


  		




  
  2
  
    

  		




  
  3
  
    
UPDATE db_version SET status=0;


  		




  
  4
  
    

  		




  
  5
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  6
  
    
  VALUES ('1.9.5', 1, CURRENT_DATE);


  		




  0
  7
  
    

  		












  

    
      src/xmltables-postgres.sql
    
  





  222
  222
  
    
  subtreeid VARCHAR(32),


  		




  223
  223
  
    
  startnodeid INT8,


  		




  224
  224
  
    
  endnodeid INT8,


  		




  225
  
  
    
   CONSTRAINT xml_access_ck CHECK (begin_time < end_time),


  		




  226
  
  
    
   CONSTRAINT xml_access_accessfileid_fk


  		




  227
  
  
    
		FOREIGN KEY (accessfileid) REFERENCES xml_documents


  		




  
  225
  
    
   CONSTRAINT xml_access_ck CHECK (begin_time < end_time)


  		




  228
  226
  
    
);


  		




  229
  227
  
    
CREATE INDEX xml_access_idx1 ON xml_access (lower(principal_name));


  		




  230
  228
  
    
CREATE INDEX xml_access_idx2 ON xml_access (permission);


  		












  

    
      src/upgrade-db-to-1.9.4-postgres.sql
    
  





  
  1
  
    
UPDATE db_version SET status=0;


  		




  
  2
  
    

  		




  
  3
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  4
  
    
  VALUES ('1.9.4', 1, CURRENT_DATE);


  		




  0
  5
  
    

  		












  

    
      src/upgrade-db-to-1.9.5-oracle.sql
    
  





  
  1
  
    
ALTER TABLE xml_access DROP CONSTRAINT xml_access_accessfileid_fk;


  		




  
  2
  
    

  		




  
  3
  
    
UPDATE db_version SET status=0; 


  		




  
  4
  
    

  		




  
  5
  
    
INSERT INTO db_version (version, status, date_created) 


  		




  
  6
  
    
  VALUES ('1.9.5', 1, CURRENT_DATE);


  		




  0
  7
  
    

  		












Also available in:  Unified diff