Project

General

Profile

Revision 177

Added by Matt Jones over 20 years ago

finsihed basic functionality for structured queries based on the DBQuery and QuerySpecification classes

View differences:

xmltables.sql
102 102
 */
103 103
CREATE TABLE xml_index (
104 104
	nodeid		NUMBER(20),	-- the unique node id
105
	path		VARCHAR2(20),	-- precomputed path through tree
105
	path		VARCHAR2(200),	-- precomputed path through tree
106 106
   CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path),
107 107
   CONSTRAINT xml_nodes_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes
108 108
);
109 109

  
110 110
/* 
111
 * Index of the paths in xml_index 
112
 */
113
CREATE INDEX xml_index_idx1 ON xml_index (path);
114

  
115
/* 
111 116
 * table to store unique Accession # for every document in 2 parts
112 117
 */
113 118
CREATE TABLE xml_acc_numbers (

Also available in: Unified diff