Repgen Features
and Benefits
Repgen
Demo Available for download...
-- script name: repcolumns
-- Features: Creates the date_modified and site_id columns for all replicated
tables.
-- This file needs to be run at each master site.
-- Copyright 2002 by .com Solutions Inc.
-- This output file was created by Repgen version 2.2.4 on Fri May 31
13:29:24 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
-- ************** customer_repgroup
-- ########## customers
ALTER TABLE WIDGETS1.CUSTOMERS ADD date_modified DATE NULL;
COMMENT ON COLUMN WIDGETS1.CUSTOMERS.date_modified IS 'Used for replication
conflict resolution.';
ALTER TABLE WIDGETS1.CUSTOMERS ADD site_name VARCHAR2(20) NULL;
COMMENT ON COLUMN WIDGETS1.CUSTOMERS.site_name IS 'Used for replication
conflict resolution. Contains the name of the replication master site
which made the most recent changes to this row.';
-- ########## addresses
ALTER TABLE WIDGETS1.ADDRESSES ADD date_updated DATE NULL;
COMMENT ON COLUMN WIDGETS1.ADDRESSES.date_updated IS 'Used for replication
conflict resolution.';
ALTER TABLE WIDGETS1.ADDRESSES ADD site_id VARCHAR2(20) NULL;
COMMENT ON COLUMN WIDGETS1.ADDRESSES.site_id IS 'Used for replication
conflict resolution. Contains the name of the replication master site
which made the most recent changes to this row.';
-- ************** static_tables_repgroup
-- ########## state_province
ALTER TABLE WIDGETS1.STATE_PROVINCE ADD date_modified DATE NULL;
COMMENT ON COLUMN WIDGETS1.STATE_PROVINCE.date_modified IS 'Used for
replication conflict resolution.';
ALTER TABLE WIDGETS1.STATE_PROVINCE ADD site_name VARCHAR2(20) NULL;
COMMENT ON COLUMN WIDGETS1.STATE_PROVINCE.site_name IS 'Used for replication
conflict resolution. Contains the name of the replication master site
which made the most recent changes to this row.';
-- ########## country
ALTER TABLE WIDGETS1.COUNTRY ADD date_modified DATE NULL;
COMMENT ON COLUMN WIDGETS1.COUNTRY.date_modified IS 'Used for replication
conflict resolution.';
ALTER TABLE WIDGETS1.COUNTRY ADD site_id VARCHAR2(20) NULL;
COMMENT ON COLUMN WIDGETS1.COUNTRY.site_id IS 'Used for replication
conflict resolution. Contains the name of the replication master site
which made the most recent changes to this row.';
