Revision 2519
Added by sgarg almost 19 years ago
| xmltables.sql | ||
|---|---|---|
| 140 | 140 |
|
| 141 | 141 |
|
| 142 | 142 |
/* |
| 143 |
* xml_nodes_revision -- table to store nodes from xml_nodes which are of old revisions and deleted document |
|
| 143 |
* xml_nodes_revisions -- table to store nodes from xml_nodes which are of old revisions and deleted document
|
|
| 144 | 144 |
*/ |
| 145 | 145 |
|
| 146 |
CREATE TABLE xml_nodes_revision ( |
|
| 146 |
CREATE TABLE xml_nodes_revisions (
|
|
| 147 | 147 |
nodeid NUMBER(20), -- the unique node id (pk) |
| 148 | 148 |
nodeindex NUMBER(10), -- order of nodes within parent |
| 149 | 149 |
nodetype VARCHAR2(20), -- type (DOCUMENT, COMMENT, PI, |
| ... | ... | |
| 160 | 160 |
date_updated DATE, |
| 161 | 161 |
nodedatanumerical NUMBER, -- the data for this node if |
| 162 | 162 |
-- it is a number |
| 163 |
CONSTRAINT xml_nodes_revision_pk PRIMARY KEY (nodeid), |
|
| 164 |
CONSTRAINT xml_nodes_revision_root_fk |
|
| 165 |
FOREIGN KEY (rootnodeid) REFERENCES xml_nodes_revision, |
|
| 166 |
CONSTRAINT xml_nodes_revision_parent_fk |
|
| 167 |
FOREIGN KEY (parentnodeid) REFERENCES xml_nodes_revision |
|
| 163 |
CONSTRAINT xml_nodes_revisions_pk PRIMARY KEY (nodeid),
|
|
| 164 |
CONSTRAINT xml_nodes_revisions_root_fk
|
|
| 165 |
FOREIGN KEY (rootnodeid) REFERENCES xml_nodes_revisions,
|
|
| 166 |
CONSTRAINT xml_nodes_revisions_parent_fk
|
|
| 167 |
FOREIGN KEY (parentnodeid) REFERENCES xml_nodes_revisions
|
|
| 168 | 168 |
); |
| 169 | 169 |
|
| 170 | 170 |
|
| 171 | 171 |
/* |
| 172 | 172 |
* Indexes of rootnodeid, parentnodeid, and nodename in xml_nodes_revision |
| 173 | 173 |
*/ |
| 174 |
CREATE INDEX xml_nodes_revision_idx1 ON xml_nodes_revision (rootnodeid);
|
|
| 175 |
CREATE INDEX xml_nodes_revision_idx2 ON xml_nodes_revision (parentnodeid);
|
|
| 176 |
CREATE INDEX xml_nodes_revisions_idx3 ON xml_nodes_revision (nodename); |
|
| 174 |
CREATE INDEX xml_nodes_revisions_idx1 ON xml_nodes_revisions (rootnodeid);
|
|
| 175 |
CREATE INDEX xml_nodes_revisions_idx2 ON xml_nodes_revisions (parentnodeid);
|
|
| 176 |
CREATE INDEX xml_nodes_revisions_idx3 ON xml_nodes_revisions (nodename);
|
|
| 177 | 177 |
|
| 178 | 178 |
/* |
| 179 | 179 |
* XML Catalog -- table to store all external sources for XML documents |
Also available in: Unified diff
Added code to create new tables xml_path_index and xml_nodes_revisions...