| 1 |
1418
|
tao
|
/*
|
| 2 |
|
|
* xmlreplicationtables.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 VARCHAR2(32), startnodeid NUMBER(20), endnodeid NUMBER(20) );
|