Revision 177
Added by Matt Jones almost 24 years ago
| 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
finsihed basic functionality for structured queries based on the DBQuery and QuerySpecification classes