Replication definitions

These scripts create replication definitions for the salesdetail table at each primary site:

-- Execute this script at Chicago RSCHI.
-- Creates replication definition chi_sales.
create replication definition chi_sales_rep
   with primary at DSCHI.DBCHI
   with all tables named 'salesdetail'
   (stor_id char(4),
    ord_num varchar(20),
    title_id varchar6),
    qty smallint,
    discount float)
   primary key (stor_id, ord_num)
   searchable columns(stor_id, ord_num, title_id)
go
/* end of script */

-- Execute this script at New York RSNY.
-- Creates replication definition ny_sales.
create replication definition ny_sales_rep
   with primary at DSNY.DBNY
   with all tables named 'salesdetail'
   (stor_id char(4),
    ord_num varchar(20),
    title_id varchar6),
    qty smallint,
    discount float)
   primary key (stor_id, ord_num)
   searchable columns(stor_id, ord_num, title_id)
go
/* end of script */

-- Execute this script at San Francisco RSSF.
-- Creates replication definition sf_sales.
create replication definition sf_sales_rep
   with primary at DSSF.DBSF
   with all tables named 'salesdetail'
   (stor_id char(4),
    ord_num varchar(20),
    title_id varchar6),
    qty smallint,
    discount float)
   primary key (stor_id, ord_num)
   searchable columns(stor_id, ord_num, title_id)
go
/* end of script */