短信平台预付费系统（含设计文档）

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sysUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[sysUser] 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].[ClientItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ClientItem] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MsgDraft]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MsgDraft] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MsgLib]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MsgLib] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MsgLibGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MsgLibGroup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MsgReceived]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MsgReceived] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MsgSend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MsgSend] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OutBox]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[OutBox] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PortInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[PortInfo] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bannerData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[bannerData] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[clientGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[clientGroup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[userPsw]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[userPsw] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[userPurview]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[userPurview] GO CREATE TABLE [dbo].[sysUser] ( [userID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [FirstName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [LastName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [status] [bit] NULL , [Dept] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [Mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [Addr] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL , [Remark] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Client] ( [Name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [Mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [sex] [bit] NULL , [status] [bit] NULL , [company] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Dept] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Business] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Tel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [Birthday] [datetime] NULL , [Addr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [updateTime] [datetime] NULL , [userID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [Remark] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [share] [bit] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ClientItem] ( [Mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [GroupID] [numeric](18, 0) NOT NULL , [userID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MsgDraft] ( [draftID] [nume�