1 |
2
|
jones
|
/*
|
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$'
|
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 |
|
|
);
|