1 |
4104
|
daigle
|
/*
|
2 |
|
|
* upgrade-db-to-1.2-oracle.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 ( datareplicate NUMBER(1), hub NUMBER(1) );
|