Project

General

Profile

« Previous | Next » 

Revision 1419

Added by Jing Tao over 21 years ago

Script for postgres to modify access table.

View differences:

src/modifyxmlaccess_postgres.sql
1
/*
2
 * xmlreplicationtables_postgres.sql -- Add two columns to xml_replication tables 
3
 * 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_replication 
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

  
0 23

  

Also available in: Unified diff