Metacat

CREATE INDEX xml_access_idx4 ON xml_access (perm_order);

CREATE INDEX xml_access_idx5 ON xml_access (subtreeid);

CREATE INDEX xml_access_idx6 on xml_access(guid);

/*

 * Index of Nodes -- table to store precomputed paths through tree for

 * quick searching in structured searches

  date_logged   DATE,           -- the datetime on which the event occurred

  CONSTRAINT access_log_pk PRIMARY KEY (entryid)

);

CREATE SEQUENCE access_log_id_seq;

CREATE TRIGGER access_log_before_insert

CREATE INDEX identifier_docid on identifier(docid);

CREATE INDEX identifier_rev on identifier(rev);

CREATE INDEX identifier_docid_rev on identifier(docid, rev);

/*

 * Table used to store all document identifiers for system metadata objects

  date_logged   TIMESTAMP,      -- the datetime on which the event occurred

  CONSTRAINT access_log_pk PRIMARY KEY (entryid)

);

/*

 * the index_event table for solr-based indexing

 */