smpp_sql.txt

来自「SMS网关程序 SMS网关程序 SMS网关程序」· 文本 代码 · 共 40 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[smpp_acknowledgment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[smpp_acknowledgment]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[smpp_send]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[smpp_send]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[smpp_sendhistory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[smpp_sendhistory]
GO

CREATE TABLE [dbo].[smpp_acknowledgment] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[usernumber] [char] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[messagecontent] [char] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[spnumber] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[datetime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[smpp_send] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[spnumber] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[messagecontent] [char] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[usernumber] [char] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[datetime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[smpp_sendhistory] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[usernumber] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[messagecontent] [char] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[spnumber] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[datetime] [datetime] NULL 
) ON [PRIMARY]
GO