/*
 * xmlreplicationtables_postgres.sql -- Add two columns to xml_replication tables 
 * in Production Metacat
 * 
 *      Created: 07/14/2002
 *       Author: Jing Tao
 * Organization: National Center for Ecological Analysis and Synthesis
 *    Copyright: 2000 Regents of the University of California and the
 *               National Center for Ecological Analysis and Synthesis
 *  For Details: http://www.nceas.ucsb.edu/
 *    File Info: '$Id: modifyxmlaccess_postgres.sql 1419 2003-02-25 02:31:24Z tao $'
 *
 */


/*
 * Add tow columns - datareplicate and hub to xml_replication 
 */
ALTER TABLE xml_access ADD subtreeid VARCHAR(32);
ALTER TABLE xml_access ADD startnodeid INT8;
ALTER TABLE xml_access ADD endnodeid INT8;

