use sypos
go
if (select count(*) from sysobjects where name='tmp_sndlog')>0
   drop table tmp_sndlog
if (select count(*) from sysobjects where name='sndlog')>0
   DROP TABLE sndlog
if (select count(*) from sysobjects where name='SendUpTables')>0
   DROP TABLE SendUpTables
if (select count(*) from sysobjects where name='SendDownTables')>0
   DROP TABLE SendDownTables
if (select count(*) from sysobjects where name='RcvUpTables')>0
   DROP TABLE RcvUpTables
if (select count(*) from sysobjects where name='RcvDownTables')>0
   DROP TABLE RcvDownTables
GO
if (select count(*) from sysobjects where name='rcvoneerror')>0 
   drop table rcvoneerror
go
CREATE TABLE rcvoneerror(
       ret integer,
       errtable varchar(30))
go
if (select count(*) from sysobjects where name='rcverrcode')>0 
   drop table rcverrcode
go
CREATE TABLE rcverrcode(
       code integer,
       tablename varchar(30),
       oper varchar(50),
       time datetime default getdate()
)
go
if (select count(*) from sysobjects where name='rcvlog')>0 
   drop table rcvlog
go
CREATE TABLE rcvlog(
       tablename varchar(30),
       deletes integer,
       updates integer,
       inserts integer,
       time datetime default getdate())
go
if (select count(*) from sysobjects where name='tmp_sndlog')>0 
   drop table tmp_sndlog
go
CREATE TABLE tmp_sndlog(
       DeptNo Varchar(4) null,
       TableName Varchar(30) Not Null,
       DispName Varchar(30) Not Null,
       Row integer,
       SendDate datetime default getdate())
GO
if (select count(*) from sysobjects where name='sndlog')>0 
   drop table sndlog
go
CREATE TABLE sndlog(
       DeptNo Varchar(4) null,
       TableName Varchar(30) Not Null,
       DispName Varchar(30) Not Null,
       Row integer,
       SendDate datetime default getdate())
GO
if (select count(*) from sysobjects where name='SendUpTables')>0 
   drop table SendUpTables
go
CREATE TABLE SendUpTables(
       Ord Int Not NULL,
       TableName Varchar(30) Not Null,
       DispName Varchar(20) Not Null, 
       SearchField Varchar(30) Null,
       FieldType Varchar(20) Null,
       FieldValue Varchar(50) Null,
       SqlStat1 Varchar(255) Null,
       SqlStat2 Varchar(255) Null,
       ApartField Varchar(30) Null,
       DestTable Varchar(30) Null,
       MasterTable Varchar(30) Null,       
       SendFlag Char(1) Default '1',
       SFinWO Varchar(50) Null)
go
if (select count(*) from sysobjects where name='SendDownTables')>0 
   drop table SendDownTables
go
CREATE TABLE SendDownTables(
       Ord Int Not NULL,
       TableName Varchar(30) Not Null,
       DispName Varchar(20) Not Null, 
       SearchField Varchar(30) Null,
       FieldType Varchar(20) Null,
       FieldValue Varchar(50) Null,
       SqlStat1 Varchar(255) Null,
       SqlStat2 Varchar(255) Null,
       ApartField Varchar(30) Null,
       DestTable Varchar(30) Null,
       MasterTable Varchar(30) Null,       
       SendFlag Char(1) Default '1',
       SFinWO Varchar(50) Null)
GO   
CREATE TABLE RcvUpTables(
       Ord Int Not Null,
       DispName Varchar(30) Not Null,
       TableName Varchar(30) Not Null,
       KeyName Varchar(30) Not Null, 
       Sortfmt Varchar(50) Not Null,