metacat / src / upgrade-db-to-1.2-oracle.sql @ 6435
| 1 |
/*
|
|---|---|
| 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: upgrade-db-to-1.2-oracle.sql 4104 2008-07-11 17:04:49Z daigle $'
|
| 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) ); |
| 20 |
|