Revision 440
Added by bojilova over 23 years ago
| xmltables.sql | ||
|---|---|---|
| 56 | 56 |
FOREIGN KEY (parentnodeid) REFERENCES xml_nodes |
| 57 | 57 |
); |
| 58 | 58 |
|
| 59 |
/* |
|
| 60 |
* Indexes of rootnodeid & parentnodeid in xml_nodes |
|
| 61 |
*/ |
|
| 62 |
CREATE INDEX xml_nodes_idx1 ON xml_nodes (rootnodeid); |
|
| 63 |
CREATE INDEX xml_nodes_idx2 ON xml_nodes (parentnodeid); |
|
| 64 |
|
|
| 59 | 65 |
CREATE SEQUENCE xml_nodes_id_seq; |
| 60 | 66 |
|
| 61 | 67 |
/* |
| ... | ... | |
| 78 | 84 |
); |
| 79 | 85 |
|
| 80 | 86 |
/* |
| 87 |
* Index of <docid,doctype> in xml_document |
|
| 88 |
*/ |
|
| 89 |
CREATE INDEX xml_documents_idx1 ON xml_documents (docid, doctype); |
|
| 90 |
|
|
| 91 |
/* |
|
| 81 | 92 |
* ACL -- table to store ACL for XML documents by principals |
| 82 | 93 |
*/ |
| 83 | 94 |
CREATE TABLE xml_access ( |
Also available in: Unified diff
3 indexes added on:
xml_nodes (rootnodeid)
xml_nodes (parentnodeid)
xml_documents (docid, doctype)