if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Area]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Area]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CheckUseInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CheckUseInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Client]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Client]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Data]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Data]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Export]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Export]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FlowWork]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FlowWork]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Logs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Logs]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Opright]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Opright]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OtherCost]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OtherCost]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ParamInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ParamInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PayBank]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PayBank]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PayBankErr]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PayBankErr]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PayDetail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PayDetail]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PayMaster]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PayMaster]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Rate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Rate]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SBInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SBInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StopUseInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StopUseInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Worker]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Worker]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ZNJInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ZNJInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[iccz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[iccz]
GO
CREATE TABLE [dbo].[Area] (
[AreaID] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[AreaName] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[AreaMemos] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CheckUseInfo] (
[ChkInfoID] [nvarchar] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[AccountID] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[accountname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChkBeforeNum] [int] NULL ,
[ChkAfterNum] [int] NULL ,
[ChkReason] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[isSuccess] [smallint] NULL ,
[ChkMemos] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Client] (
[UserAccount] [nvarchar] (10) COLLATE Chinese�