C#联通短信网关开发指南 含数据库部分 - 副本unicomm-sgip.docVIP

联通短信网关(SGIP 1.2) 数据库设计脚本 -- 表生成 if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[sgip_Deliver]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[sgip_Deliver] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[sgip_Report]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[sgip_Report] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[sgip_bill]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[sgip_bill] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[sgip_submit]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[sgip_submit] GO CREATE TABLE [dbo].[sgip_Deliver] ( [id] [int] IDENTITY (1, 1) NOT NULL , [phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [spNumber] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [MessageCoding] [int] NULL , [MessageLength] [int] NULL , [MessageContent] [varchar] (512) COLLATE Chinese_PRC_CI_AS NULL , [linkID] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [add_time] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[sgip_Report] ( [id] [int] IDENTITY (1, 1) NOT NULL , [SequenceNumber] [int] NULL , [SequenceNumber1] [int] NULL , [SequenceNumber2] [int] NULL , [ReportType] [int] NULL , [phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [State] [int] NULL , [ErrorCode] [int] NULL , [Reserve] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [add_time] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[sgip_bill] ( [id] [int] NOT NULL , [spNumber] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [ChargeNumber] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [UserNumber] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [UserCount] [int] NULL , [CorpId] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [ServiceType] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [FeeType] [int] NULL , [FeeValue] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL , [GivenValue] [varchar] (6) CO