1 |
2276
|
jones
|
/*
|
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_replication ADD COLUMN datareplicate INT8;
|
20 |
|
|
ALTER TABLE xml_replication ADD COLUMN hub INT8;
|