Revision 2377
Added by sgarg over 19 years ago
| xmltables.sql | ||
|---|---|---|
| 257 | 257 |
doctype VARCHAR2(100), -- public id indicating document type |
| 258 | 258 |
parentnodeid NUMBER(20), -- id of the parent of the node |
| 259 | 259 |
-- represented by this row |
| 260 |
nodedata VARCHAR2(4000), -- the data for the given path |
|
| 260 | 261 |
CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path), |
| 261 | 262 |
CONSTRAINT xml_index_nodeid_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes, |
| 262 | 263 |
CONSTRAINT xml_index_docid_fk |
| ... | ... | |
| 267 | 268 |
* Index of the paths in xml_index |
| 268 | 269 |
*/ |
| 269 | 270 |
CREATE INDEX xml_index_idx1 ON xml_index (path); |
| 271 |
CREATE INDEX xml_index_idx2 ON xml_index (docid); |
|
| 270 | 272 |
|
| 271 | 273 |
CREATE TABLE xml_relation ( |
| 272 | 274 |
relationid NUMBER(20) PRIMARY KEY, -- unique id |
Also available in: Unified diff
Modified xmltables to add nodedata as part of the xml_index tables.