sms2db.sql

简单的cmpp3.0网关实现代码 简单的cmpp3.0网关实现代码

	[FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[FixedFee] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgFormat] [smallint] NULL ,
	[ValidTime] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL ,
	[AtTime] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL ,
	[SrcTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChargeTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[DestTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SMGP_Submit_Error] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MT_SequenceID] [bigint] NULL ,
	[MT_SendCount] [int] NULL ,
	[MT_BaseFetchFlag] [smallint] NULL ,
	[MT_Date] [datetime] NULL ,
	[MsgType] [smallint] NULL ,
	[NeedReport] [smallint] NULL ,
	[Priority] [smallint] NULL ,
	[ServiceID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[FixedFee] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgFormat] [smallint] NULL ,
	[ValidTime] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL ,
	[AtTime] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL ,
	[SrcTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChargeTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[DestTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[ErrorDate] [datetime] NULL ,
	[ErrorCode] [int] NULL ,
	[ErrorInfo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SMGP_Submit_History] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MT_SequenceID] [bigint] NULL ,
	[MT_SendCount] [int] NULL ,
	[MT_BaseFetchFlag] [smallint] NULL ,
	[MT_Date] [datetime] NULL ,
	[MsgType] [smallint] NULL ,
	[NeedReport] [smallint] NULL ,
	[Priority] [smallint] NULL ,
	[ServiceID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[FixedFee] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgFormat] [smallint] NULL ,
	[ValidTime] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL ,
	[AtTime] [varchar] (17) COLLATE Chinese_PRC_CI_AS NULL ,
	[SrcTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChargeTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[DestTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[RespDate] [datetime] NULL ,
	[RespMsgID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[RespStatus] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SubscribeServiceReq] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MsgType] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[TransactionID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Version] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Send_Address_DeviceType] [int] NULL ,
	[Send_Address_DeviceID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_Address_DeviceType] [int] NULL ,
	[Dest_Address_DeviceID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeUser_ID_UserIDType] [int] NULL ,
	[FeeUser_ID_MSISDN] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeUser_ID_PseudoCode] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[DestUser_ID_UserIDType] [int] NULL ,
	[DestUser_ID_MSISDN] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[DestUser_ID_PseudoCode] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[Service_ID_ServiceIDType] [int] NULL ,
	[Service_ID_SPID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Service_ID_SPServiceID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Service_ID_AccessNo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Service_ID_FeatureStr] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[FeatureStr] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[MT_Date] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[SubscribeServiceResp] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MsgType] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[TransactionID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Version] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[hRet] [int] NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MO_Date] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SyncOrderRelationReq] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MsgType] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[TransactionID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Version] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Send_Address_DeviceType] [int] NULL ,
	[Send_Address_DeviceID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_Address_DeviceType] [int] NULL ,
	[Dest_Address_DeviceID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeUser_ID_UserIDType] [int] NULL ,
	[FeeUser_ID_MSISDN] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeUser_ID_PseudoCode] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[DestUser_ID_UserIDType] [int] NULL ,
	[DestUser_ID_MSISDN] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[DestUser_ID_PseudoCode] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ActionID] [int] NULL ,
	[ActionReasonID] [int] NULL ,
	[SPID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SPServiceID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[AccessMode] [int] NULL ,
	[FeatureStr] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[MO_Date] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[UnSubscribeServiceReq] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MsgType] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[TransactionID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Version] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Send_Address_DeviceType] [int] NULL ,
	[Send_Address_DeviceID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_Address_DeviceType] [int] NULL ,
	[Dest_Address_DeviceID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeUser_ID_UserIDType] [int] NULL ,
	[FeeUser_ID_MSISDN] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeUser_ID_PseudoCode] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[DestUser_ID_UserIDType] [int] NULL ,
	[DestUser_ID_MSISDN] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[DestUser_ID_PseudoCode] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[Service_ID_ServiceIDType] [int] NULL ,
	[Service_ID_SPID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Service_ID_SPServiceID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Service_ID_AccessNo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Service_ID_FeatureStr] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[MT_Date] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[UnSubscribeServiceResp] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MsgType] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[TransactionID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Version] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[hRet] [int] NULL ,
	[MO_Date] [datetime] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CMPP_Deliver] ADD 
	CONSTRAINT [DF_Deliver_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_Deliver] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CMPP_Report] ADD 
	CONSTRAINT [DF_Report_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_Report] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CMPP_Submit] ADD 
	CONSTRAINT [DF_Submit_MT_SequenceID] DEFAULT ((-1)) FOR [MT_SequenceID],
	CONSTRAINT [DF_Submit_MT_SendCount] DEFAULT (0) FOR [MT_SendCount],
	CONSTRAINT [DF_Submit_MT_BaseFetchFlag] DEFAULT (1) FOR [MT_BaseFetchFlag],
	CONSTRAINT [DF_Submit_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [DF_Submit_Msg_Id] DEFAULT (0) FOR [Msg_Id],
	CONSTRAINT [DF_Submit_Pk_total] DEFAULT (1) FOR [Pk_total],
	CONSTRAINT [DF_Submit_Pk_number] DEFAULT (1) FOR [Pk_number],
	CONSTRAINT [DF_Submit_Registered_Delivery] DEFAULT (0) FOR [Registered_Delivery],
	CONSTRAINT [DF_Submit_Msg_level] DEFAULT (7) FOR [Msg_level],
	CONSTRAINT [DF_Submit_Fee_UserType] DEFAULT (0) FOR [Fee_UserType],
	CONSTRAINT [DF_Submit_Fee_terminal_type] DEFAULT (0) FOR [Fee_terminal_type],
	CONSTRAINT [DF_Submit_TP_pId] DEFAULT (0) FOR [TP_pId],
	CONSTRAINT [DF_Submit_TP_udhi] DEFAULT (0) FOR [TP_udhi],
	CONSTRAINT [DF_Submit_Msg_Fmt] DEFAULT (15) FOR [Msg_Fmt],
	CONSTRAINT [DF_Submit_FeeCode] DEFAULT (0) FOR [FeeCode],
	CONSTRAINT [DF_Submit_ValId_Time] DEFAULT (0) FOR [ValId_Time],
	CONSTRAINT [DF_Submit_At_Time] DEFAULT (0) FOR [At_Time],
	CONSTRAINT [DF_Submit_Dest_terminal_type] DEFAULT (0) FOR [Dest_terminal_type],
	CONSTRAINT [PK_Submit] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CMPP_Submit_Error] ADD 
	CONSTRAINT [DF_Submit_Error_MT_SequenceID] DEFAULT ((-1)) FOR [MT_SequenceID],
	CONSTRAINT [DF_Submit_Error_MT_SendCount] DEFAULT (0) FOR [MT_SendCount],
	CONSTRAINT [DF_Submit_Error_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [DF_Submit_Error_Msg_Id] DEFAULT (0) FOR [Msg_Id],
	CONSTRAINT [DF_Submit_Error_Pk_total] DEFAULT (1) FOR [Pk_total],
	CONSTRAINT [DF_Submit_Error_Pk_number] DEFAULT (1) FOR [Pk_number],
	CONSTRAINT [DF_Submit_Error_Registered_Delivery] DEFAULT (0) FOR [Registered_Delivery],
	CONSTRAINT [DF_Submit_Error_Msg_level] DEFAULT (7) FOR [Msg_level],
	CONSTRAINT [DF_Submit_Error_Fee_UserType] DEFAULT (0) FOR [Fee_UserType],
	CONSTRAINT [DF_Submit_Error_Fee_terminal_type] DEFAULT (0) FOR [Fee_terminal_type],
	CONSTRAINT [DF_Submit_Error_TP_pId] DEFAULT (0) FOR [TP_pId],
	CONSTRAINT [DF_Submit_Error_TP_udhi] DEFAULT (0) FOR [TP_udhi],
	CONSTRAINT [DF_Submit_Error_Msg_Fmt] DEFAULT (15) FOR [Msg_Fmt],
	CONSTRAINT [DF_Submit_Error_FeeCode] DEFAULT (0) FOR [FeeCode],
	CONSTRAINT [DF_Submit_Error_ValId_Time] DEFAULT (0) FOR [ValId_Time],
	CONSTRAINT [DF_Submit_Error_At_Time] DEFAULT (0) FOR [At_Time],
	CONSTRAINT [DF_Submit_Error_Dest_terminal_type] DEFAULT (0) FOR [Dest_terminal_type],
	CONSTRAINT [DF_Submit_Error_ErrorDate] DEFAULT (getdate()) FOR [ErrorDate],
	CONSTRAINT [PK_Submit_Error] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CMPP_Submit_History] ADD 
	CONSTRAINT [DF_Submit_History_MT_SequenceID] DEFAULT ((-1)) FOR [MT_SequenceID],
	CONSTRAINT [DF_Submit_History_MT_SendCount] DEFAULT (0) FOR [MT_SendCount],
	CONSTRAINT [DF_Submit_History_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [DF_Submit_History_Msg_Id] DEFAULT (0) FOR [Msg_Id],
	CONSTRAINT [DF_Submit_History_Pk_total] DEFAULT (1) FOR [Pk_total],
	CONSTRAINT [DF_Submit_History_Pk_number] DEFAULT (1) FOR [Pk_number],
	CONSTRAINT [DF_Submit_History_Registered_Delivery] DEFAULT (0) FOR [Registered_Delivery],
	CONSTRAINT [DF_Submit_History_Msg_level] DEFAULT (7) FOR [Msg_level],
	CONSTRAINT [DF_Submit_History_Fee_UserType] DEFAULT (0) FOR [Fee_UserType],
	CONSTRAINT [DF_Submit_History_Fee_terminal_type] DEFAULT (0) FOR [Fee_terminal_type],
	CONSTRAINT [DF_Submit_History_TP_pId] DEFAULT (0) FOR [TP_pId],
	CONSTRAINT [DF_Submit_History_TP_udhi] DEFAULT (0) FOR [TP_udhi],
	CONSTRAINT [DF_Submit_History_Msg_Fmt] DEFAULT (15) FOR [Msg_Fmt],
	CONSTRAINT [DF_Submit_History_FeeCode] DEFAULT (0) FOR [FeeCode],
	CONSTRAINT [DF_Submit_History_ValId_Time] DEFAULT (0) FOR [ValId_Time],
	CONSTRAINT [DF_Submit_History_At_Time] DEFAULT (0) FOR [At_Time],
	CONSTRAINT [DF_Submit_History_Dest_terminal_type] DEFAULT (0) FOR [Dest_terminal_type],
	CONSTRAINT [PK_Submit_History] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[MobileOrderRelation] ADD 
	CONSTRAINT [DF_MobileOrderRelation_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_OrderRelationCommand] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SGIP_Deliver] ADD 
	CONSTRAINT [DF_SGIP_Deliver_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_SGIP_Deliver] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SGIP_Report] ADD 
	CONSTRAINT [DF_SGIP_Report_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_SGIP_Report] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SGIP_Submit] ADD 
	CONSTRAINT [DF_SGIP_Submit_MT_SendCount] DEFAULT (0) FOR [MT_SendCount],
	CONSTRAINT [DF_SGIP_Submit_BaseFetchFlag] DEFAULT (1) FOR [MT_BaseFetchFlag],
	CONSTRAINT [DF_SGIP_Submit_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [DF_SGIP_Submit_FeeValue] DEFAULT (0) FOR [FeeValue],
	CONSTRAINT [DF_SGIP_Submit_GivenValue] DEFAULT (0) FOR [GivenValue],
	CONSTRAINT [DF_SGIP_Submit_MorelatetoMTFlag] DEFAULT (2) FOR [MorelatetoMTFlag],
	CONSTRAINT [DF_SGIP_Submit_TP_pid] DEFAULT (0) FOR [TP_pid],
	CONSTRAINT [DF_SGIP_Submit_TP_udhi] DEFAULT (0) FOR [TP_udhi],
	CONSTRAINT [DF_SGIP_Submit_MessageCoding] DEFAULT (15) FOR [MessageCoding],
	CONSTRAINT [PK_SGIP_Submit] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SGIP_Submit_Error] ADD 
	CONSTRAINT [DF_SGIP_Submit_Error_ReportState] DEFAULT ((-1)) FOR [ResponseResult],
	CONSTRAINT [DF_SGIP_Submit_Error_MT_BaseFetchFlag] DEFAULT (1) FOR [MT_BaseFetchFlag],
	CONSTRAINT [DF_SGIP_Submit_Error_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [PK_SGIP_Submit_Error] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SGIP_Submit_History] ADD 
	CONSTRAINT [DF_SGIP_Submit_History_ReportState] DEFAULT ((-1)) FOR [ResponseResult],
	CONSTRAINT [DF_SGIP_Submit_History_MT_BaseFetchFlag] DEFAULT (1) FOR [MT_BaseFetchFlag],
	CONSTRAINT [DF_SGIP_Submit_History_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [PK_SGIP_Submit_History] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SMGP_Deliver] ADD 
	CONSTRAINT [DF_SMGP_Deliver_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_SMGP_Deliver] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SMGP_Report] ADD 
	CONSTRAINT [PK_SMGP_Report] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SMGP_Submit] ADD 
	CONSTRAINT [DF_SMGP_Submit_MT_SequenceID] DEFAULT ((-1)) FOR [MT_SequenceID],
	CONSTRAINT [DF_SMGP_Submit_MT_SendCount] DEFAULT (0) FOR [MT_SendCount],
	CONSTRAINT [DF_SMGP_Submit_MT_BaseFetchFlag] DEFAULT (1) FOR [MT_BaseFetchFlag],
	CONSTRAINT [DF_SMGP_Submit_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [DF_SMGP_Submit_NeedReport] DEFAULT (0) FOR [NeedReport],
	CONSTRAINT [DF_SMGP_Submit_Priority] DEFAULT (5) FOR [Priority],
	CONSTRAINT [DF_SMGP_Submit_FeeCode] DEFAULT (0) FOR [FeeCode],
	CONSTRAINT [DF_SMGP_Submit_FixedFee] DEFAULT (0) FOR [FixedFee],
	CONSTRAINT [DF_SMGP_Submit_MsgFormat] DEFAULT (15) FOR [MsgFormat],
	CONSTRAINT [PK_SMGP_Submit] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SMGP_Submit_Error] ADD 
	CONSTRAINT [DF_SMGP_Submit_Error_MT_SequenceID] DEFAULT ((-1)) FOR [MT_SequenceID],
	CONSTRAINT [DF_SMGP_Submit_Error_MT_SendCount] DEFAULT (0) FOR [MT_SendCount],
	CONSTRAINT [DF_SMGP_Submit_Error_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [PK_SMGP_Submit_Error] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SMGP_Submit_History] ADD 
	CONSTRAINT [DF_SMGP_Submit_History_RespDate] DEFAULT (getdate()) FOR [RespDate],
	CONSTRAINT [PK_SMGP_Submit_History] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SubscribeServiceReq] ADD 
	CONSTRAINT [DF_SubscribeServiceReq_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [PK_SubscribeServiceReq] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SubscribeServiceResp] ADD 
	CONSTRAINT [DF_SubscribeServiceResp_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_SubscribeServiceResp] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SyncOrderRelationReq] ADD 
	CONSTRAINT [DF_SyncOrderRelationReq_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_SyncOrderRelationReq] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[UnSubscribeServiceReq] ADD 
	CONSTRAINT [DF_UnSubscribeServiceReq_MT_Date] DEFAULT (getdate()) FOR [MT_Date],
	CONSTRAINT [PK_UnSubscribeServiceReq] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[UnSubscribeServiceResp] ADD 
	CONSTRAINT [DF_UnSubscribeServiceResp_MO_Date] DEFAULT (getdate()) FOR [MO_Date],
	CONSTRAINT [PK_UnSubscribeServiceResp] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO





CREATE   PROC CMPP3_GETMESSAGE
  @MT_BaseFetchFlag  int
AS


  SELECT 
    * 
  FROM 
    CMPP_SUBMIT
  WHERE 
    MT_BaseFetchFlag = @MT_BaseFetchFlag  AND
    MT_SendCount = 0





GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO














CREATE PROC CMPP3_MobileOrderRelation
  @Mobile VarChar(32),
  @SPNumber VarChar(32),
  @ServiceID VarChar(10),