Metacat

DROP SEQUENCE xml_relation_id_seq;

DROP SEQUENCE xml_replication_id_seq;

DROP SEQUENCE accnum_uniqueid_seq;

DROP TABLE xml_index;

DROP TABLE xml_access;

DROP TABLE xml_revisions;

/*

 *Replication -- table to store servers that metacat is replicated to

 */

CREATE SEQUENCE xml_replication_id_seq;

CREATE TABLE xml_replication (

  serverid     INT8  default nextval('xml_replication_id_seq'), 

  server        VARCHAR(512),

 * XML Catalog -- table to store all external sources for XML documents

 */

CREATE SEQUENCE xml_catalog_id_seq;

CREATE TABLE xml_catalog (

	catalog_id INT8 default nextval('xml_catalog_id_seq'), -- the id for this catalog entry

	entry_type	VARCHAR(500),	-- the type of this catalog entry

);

/* 

 * Documents -- table to store XML documents

 */

CREATE TABLE xml_documents (

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

 *                    or DELETE

 */

CREATE SEQUENCE xml_revisions_id_seq;

CREATE TABLE xml_revisions (

	revisionid	INT8  default nextval('xml_revisions_id_seq'), -- the revision number we are saving

 */

CREATE INDEX xml_index_idx1 ON xml_index (path);

CREATE SEQUENCE xml_relation_id_seq;

CREATE TABLE xml_relation (

	relationid    INT8 default nextval('xml_relation_id_seq')  PRIMARY KEY, -- unique id

	docid         VARCHAR(250) ,         -- the docid of the package file

DROP SEQUENCE xml_relation_id_seq;

DROP SEQUENCE xml_replication_id_seq;

DROP SEQUENCE accnum_uniqueid_seq;

DROP TRIGGER xml_revisions_before_insert;

DROP TRIGGER xml_catalog_before_insert;

);

/* 

 * Index of <docid,doctype> in xml_document

 */

CREATE INDEX xml_documents_idx1 ON xml_documents (docid, doctype);

 */

CREATE INDEX xml_index_idx1 ON xml_index (path);

CREATE TABLE xml_relation (

	relationid    NUMBER(20) PRIMARY KEY, -- unique id

	docid         VARCHAR2(250),          -- the docid of the package file