Project

General

Profile

Revision 440

Added by bojilova over 20 years ago

3 indexes added on:
xml_nodes (rootnodeid)
xml_nodes (parentnodeid)
xml_documents (docid, doctype)

View differences:

src/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