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-oracle.sql
24 24 
);
25 25 

  		




  26
  26
  
    
/*


  		




  
  27
  
    
 * add the nodedatadate column to xml_nodes 


  		




  
  28
  
    
 * TODO: load the data into it (java?)


  		




  
  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_idx4 ON xml_path_index (nodedatadate);


  		




  
  34
  
    

  		




  
  35
  
    

  		




  
  36
  
    
/*


  		




  27
  37
  
    
 * Register the DataONE schemas


  		




  28
  38
  
    
 */


  		




  29
  39
  
    
INSERT INTO xml_catalog (entry_type, public_id, system_id)


  		












Also available in:  Unified diff