Metacat

 */

CREATE INDEX xml_documents_idx1 ON xml_documents (docid, doctype);

CREATE INDEX xml_documents_idx2 ON xml_documents (lower(user_owner));

/*

 * Revised Documents -- table to store XML documents saved after an UPDATE

 */

CREATE INDEX xml_index_idx1 ON xml_index (path);

CREATE INDEX xml_index_idx2 ON xml_index (docid);

CREATE SEQUENCE xml_relation_id_seq;

CREATE TABLE xml_relation (