cmpp2 sql.txt

短信网关接口

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InBox]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[InBox]
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

CREATE TABLE [dbo].[InBox] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[sMsgId] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sDestid] [nvarchar] (21) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sServiceid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cTpPid] [int] NOT NULL ,
	[cTpUdhi] [int] NOT NULL ,
	[cMsgFmt] [int] NOT NULL ,
	[sSrcTerminalid] [nvarchar] (21) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sMsgContent] [image] NOT NULL ,
	[Arrivedate] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ArriveTime] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sMsgContent_] [varchar] (160) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OutBox] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[cRegisteredDelivery] [int] NULL ,
	[sServiceId] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cFeeUsrType] [int] NULL ,
	[sFeeTerminalId] [nvarchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[cTpPid] [int] NULL ,
	[cTpUdhi] [int] NULL ,
	[cMsgFmt] [int] NULL ,
	[sMsgSrc] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sFeeType] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sFeeCode] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sSrcId] [nvarchar] (21) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cDstUsrTl] [tinyint] NULL ,
	[sDstTerminalId] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sMsgContent] [image] NULL ,
	[sendflag] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sMsgContent_] [varchar] (160) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sSrcSender] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[regtime] [smalldatetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO