Project

General

Profile

1 1564 tao
/*
2
 * reviseformetacat13_postgres.sql -- Add three columns to xml_access tables
3
 * and create a new table in Production Metacat
4
 *
5
 *      Created: 07/14/2002
6
 *       Author: Jing Tao
7
 * Organization: National Center for Ecological Analysis and Synthesis
8
 *    Copyright: 2000 Regents of the University of California and the
9
 *               National Center for Ecological Analysis and Synthesis
10
 *  For Details: http://www.nceas.ucsb.edu/
11
 *    File Info: '$Id$'
12
 *
13
 */
14
15
16
/*
17
 * Add tow columns - datareplicate and hub to xml_access
18
 */
19
ALTER TABLE xml_access ADD subtreeid VARCHAR(32);
20
ALTER TABLE xml_access ADD startnodeid INT8;
21
ALTER TABLE xml_access ADD endnodeid INT8;
22
23
/*
24
 * accessSubtree -- table to store access subtree info
25
 */
26
CREATE TABLE xml_accesssubtree (
27
        docid           VARCHAR(250),   -- the document id #
28
  rev           INT8 default 1, --the revision number of the docume
29
  controllevel VARCHAR(50), -- the level it control -- document or subtree
30
  subtreeid VARCHAR(250), -- the subtree id
31
        startnodeid     INT8,   -- the start node id of access subtree
32
  endnodeid INT8 -- the end node if of access subtree
33
);