Metacat

/*

 * xmltables.sql -- Create or replace tables for storing XML in the db

 *

 *      Purpose: creates tables needed for XML database

 * 

 *      Created: 12 September 1999

 *       Author: Matt Jones

 * Organization: National Center for Ecological Analysis and Synthesis

 *      Version: '$Id$'

 *

 */

/* 

 * Document -- table to store XML document catalog

 */

DROP TABLE document;

CREATE TABLE document (

	docid		NUMBER(20),

	docname		VARCHAR2(1000),

	date_created	DATE,

	date_updated	DATE,

   PRIMARY KEY document_pk (docid)

);

/*

 * xmltables.sql -- Create or replace tables for storing XML in the db

 *

 *      Purpose: creates tables needed for XML database

 * 

 *      Created: 12 September 1999

 *       Author: Matt Jones

 * Organization: National Center for Ecological Analysis and Synthesis

 *      Version: '$Id$'

 *

 */

/* 

 * Document -- table to store XML document catalog

 */

DROP TABLE document;

CREATE TABLE document (

	docid		NUMBER(20),

	docname		VARCHAR2(1000),

	date_created	DATE,

	date_updated	DATE,

   PRIMARY KEY document_pk (docid)

);