Project

General

Profile

Revision 6012

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

View differences:

xmltables-oracle.sql
116 116
	docid		VARCHAR2(250),	-- index to the document id
117 117
	date_created	DATE,
118 118
	date_updated	DATE,
119
	nodedatanumerical NUMBER,       -- the data for this node if
120
					-- it is a number
119
	nodedatanumerical NUMBER,       -- the data for this node if it is a number
120
	nodedatadate TIMESTAMP,       -- the data for this node if it is a date
121 121
   CONSTRAINT xml_nodes_pk PRIMARY KEY (nodeid),
122 122
   CONSTRAINT xml_nodes_root_fk
123 123
		FOREIGN KEY (rootnodeid) REFERENCES xml_nodes,
......
162 162
        docid           VARCHAR2(250),  -- index to the document id
163 163
        date_created    DATE,
164 164
        date_updated    DATE,
165
        nodedatanumerical NUMBER,       -- the data for this node if
166
                                        -- it is a number
165
        nodedatanumerical NUMBER,       -- the data for this node if it is a number
166
        nodedatadate TIMESTAMP,       -- the data for this node if it is a date
167 167
   CONSTRAINT xml_nodes_revisions_pk PRIMARY KEY (nodeid),
168 168
   CONSTRAINT xml_nodes_revisions_root_fk
169 169
                FOREIGN KEY (rootnodeid) REFERENCES xml_nodes_revisions,
......
338 338
        path            VARCHAR2(1000), -- precomputed path through tree
339 339
	    nodedata        VARCHAR2(4000), -- the data for this node e.g.,
340 340
        nodedatanumerical NUMBER(20),   -- the data for this node if
341
        parentnodeid    NUMBER(20),     -- index of the parent of this node
341
		nodedatadate TIMESTAMP,       -- the data for this node if it is a date        
342
		parentnodeid    NUMBER(20),     -- index of the parent of this node
342 343
        CONSTRAINT xml_path_index_pk PRIMARY KEY (nodeid),
343 344
        CONSTRAINT xml_path_index_docid_fk FOREIGN KEY (docid) REFERENCES xml_documents
344 345
 );                                                                                        
......
364 365
CREATE INDEX xml_path_index_idx1 ON xml_path_index (path);
365 366
CREATE INDEX xml_path_index_idx2 ON xml_path_index (nodedata);
366 367
CREATE INDEX xml_path_index_idx3 ON xml_path_index (nodedatanumerical);
368
CREATE INDEX xml_path_index_idx4 ON xml_path_index (nodedatadate);
367 369

  
368 370

  
369 371

  
372

  
370 373
CREATE TABLE xml_relation (
371 374
	relationid    NUMBER(20) PRIMARY KEY, -- unique id
372 375
	docid         VARCHAR2(250),          -- the docid of the package file

Also available in: Unified diff