CMPP2网关程序、中国移动网关程序、短信群发系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_GETMESSAGE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CMPP2_GETMESSAGE] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_RECEIVEMESSAGE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CMPP2_RECEIVEMESSAGE] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_RECEIVEREPORT]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CMPP2_RECEIVEREPORT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_SUBMITHISTORY]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CMPP2_SUBMITHISTORY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_SUBMIT_PROC]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CMPP2_SUBMIT_PROC] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_UPDATESUBMIT]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CMPP2_UPDATESUBMIT] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_Deliver]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CMPP2_Deliver] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_Report]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CMPP2_Report] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_Submit]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CMPP2_Submit] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_Submit_Error]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CMPP2_Submit_Error] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP2_Submit_History]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CMPP2_Submit_History] GO CREATE TABLE [dbo].[CMPP2_Deliver] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [MO_Date] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Msg_Id] [bigint] NULL , [Dest_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Service_Id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [TP_pid] [int] NULL , [TP_udhi] [int] NULL , [Msg_Fmt] [int] NULL , [Src_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Registered_Delivery] [int] NULL , [Msg_Length] [int] NULL , [Msg_Content] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CMPP2_Report] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [MO_Date] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Msg_Id] [bigint] NULL , [Dest_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Service_Id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [TP_pid] [int] NULL , [TP_udhi] [int] NULL , [Msg_Fmt] [int] NULL , [Src_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Registered_Delivery] [int] NULL , [Msg_Length] [int] NULL , [MT_Msg_Id] [bigint] NULL , [Stat] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [Submit_time] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [Done_time] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [Dest_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [SMSC_sequence] [bigint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CMPP2_Submit] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [MT_SequenceID] [bigint] NULL , [MT_SendCount] [int] NULL , [MT_BaseFetchFlag] [int] NULL , [MT_Date] [datetime] NULL , [Msg_Id] [bigint] NULL , [Pk_total] [int] NULL , [Pk_number] [int] NULL , [Registered_Delivery] [int] NULL , [Msg_level] [int] NULL , [Service_Id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [Fee_UserType] [int] NULL , [Fee_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [TP_pId] [int] NULL , [TP_udhi] [int] NULL , [Msg_Fmt] [int] NULL , [Msg_src] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL , [FeeType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL , [FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL , [ValId_Time] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL , [At_Time] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL , [Src_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Dest_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Msg_Content] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CMPP2_Submit_Error] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [MT_SequenceID] [bigint] NULL , [MT_SendCount] [int] NULL , [MT_BaseFetchFlag] [int] NULL , [MT_Date] [datetime] NULL , [Msg_Id] [bigint] NULL , [Pk_total] [int] NULL , [Pk_number] [int] NULL , [Registered_Delivery] [int] NULL , [Msg_level] [int] NULL , [Service_Id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [Fee_UserType] [int] NULL , [Fee_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [TP_pId] [int] NULL , [TP_udhi] [int] NULL , [Msg_Fmt] [int] NULL , [Msg_src] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL , [FeeType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL , [FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL , [ValId_Time] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL , [At_Time] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL , [Src_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Dest_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Msg_Content] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [ErrorCode] [int] NULL , [ErrorInfo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [ErrorDate] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CMPP2_Submit_History] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [MT_SequenceID] [bigint] NULL , [MT_SendCount] [int] NULL , [MT_BaseFetchFlag] [int] NULL , [MT_Date] [datetime] NULL , [Msg_Id] [bigint] NULL , [Pk_total] [int] NULL , [Pk_number] [int] NULL , [Registered_Delivery] [int] NULL , [Msg_level] [int] NULL , [Service_Id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [Fee_UserType] [int] NULL , [Fee_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [TP_pId] [int] NULL , [TP_udhi] [int] NULL , [Msg_Fmt] [int] NULL , [Msg_src] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL , [FeeType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL , [FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL , [ValId_Time] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL , [At_Time] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL , [Src_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Dest_terminal_Id] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL , [Msg_Content] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CMPP2_Deliver] ADD CONSTRAINT [DF_CMPP2_Deliver_MO_Date] DEFAULT (getdate()) FOR [MO_Date], CONSTRAINT [PK_CMPP_Deliver] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CMPP2_Report] ADD CONSTRAINT [DF_CMPP2_Report_MO_Date] DEFAULT (getdate()) FOR [MO_Date], CONSTRAINT [PK_CMPP2_Report] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CMPP2_Submit] ADD CONSTRAINT [DF_CMPP2_Submit_MT_SequenceID] DEFAULT ((-1)) FOR [MT_SequenceID], CONSTRAINT [DF_CMPP2_Submit_MT_SendCount] DEFAULT (0) FOR [MT_SendCount], CONSTRAINT [DF_CMPP2_Submit_MT_BaseFetchFlag] DEFAULT (1) FOR [MT_BaseFetchFlag], CONSTRAINT [DF_CMPP2_Submit_MT_Date] DEFAULT (getdate()) FOR [MT_Date], CONSTRAINT [PK_CMPP2_Submit] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CMPP2_Submit_Error] ADD CONSTRAINT [DF_CMPP2_Submit_Error_MT_SequenceID] DEFAULT ((-1)) FOR [MT_SequenceID], CONSTRAINT [DF_CMPP2_Submit_Error_MT_SendCount] DEFAULT (0) FOR [MT_SendCount], CONSTRAINT [DF_CMPP2_Submit_Error_MT_BaseFetchFlag] DEFAULT (1) FOR [MT_BaseFetchFlag],