1
|
/*
|
2
|
* xmltables.sql -- Create or replace tables for storing XML in the db
|
3
|
*
|
4
|
* Purpose: creates tables needed for XML database
|
5
|
*
|
6
|
* Created: 12 September 1999
|
7
|
* Author: Matt Jones
|
8
|
* Organization: National Center for Ecological Analysis and Synthesis
|
9
|
* Version: '$Id: xmltables.sql 2 1999-09-12 19:56:30Z jones $'
|
10
|
*
|
11
|
*/
|
12
|
|
13
|
/*
|
14
|
* Document -- table to store XML document catalog
|
15
|
*/
|
16
|
DROP TABLE document;
|
17
|
CREATE TABLE document (
|
18
|
docid NUMBER(20),
|
19
|
docname VARCHAR2(1000),
|
20
|
date_created DATE,
|
21
|
date_updated DATE,
|
22
|
PRIMARY KEY document_pk (docid)
|
23
|
);
|