Project

General

Profile

« Previous | Next » 

Revision 6012

Added by ben leinfelder over 13 years ago

add support for temporal element query in pathquery
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=2084

View differences:

upgrade-db-to-1.10.0-postgres.sql
25 25 
);
26 26 

  		




  27
  27
  
    
/*


  		




  
  28
  
    
 * add the nodedatadate column to the tables that need it 


  		




  
  29
  
    
 */


  		




  
  30
  
    
ALTER TABLE xml_nodes ADD COLUMN nodedatadate TIMESTAMP;


  		




  
  31
  
    
ALTER TABLE xml_nodes_revisions ADD COLUMN nodedatadate TIMESTAMP;


  		




  
  32
  
    
ALTER TABLE xml_path_index ADD COLUMN nodedatadate TIMESTAMP;


  		




  
  33
  
    
CREATE INDEX xml_path_index_idx5 ON xml_path_index (nodedatadate);


  		




  
  34
  
    

  		




  
  35
  
    
/*


  		




  28
  36
  
    
 * Register the DataONE schemas


  		




  29
  37
  
    
 */


  		




  30
  38
  
    
 


  		












Also available in:  Unified diff