Project

General

Profile

Revision 6012

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