⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 sms2db.sql

📁 简单的cmpp3.0网关实现代码 简单的cmpp3.0网关实现代码
💻 SQL
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMPP3_GETMESSAGE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMPP3_GETMESSAGE]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[CMPP_Deliver] (
	[ID] [int] IDENTITY (1, 1) NOT 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] [smallint] NULL ,
	[TP_udhi] [smallint] NULL ,
	[Msg_Fmt] [smallint] NULL ,
	[Src_terminal_Id] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Src_terminal_type] [smallint] NULL ,
	[Registered_Delivery] [smallint] NULL ,
	[Msg_Length] [smallint] NULL ,
	[Msg_Content] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MO_Date] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CMPP_Report] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Msg_Id] [bigint] NULL ,
	[Stat] [varchar] (7) 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] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[SMSC_sequence] [int] NULL ,
	[MO_Date] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CMPP_Submit] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MT_SequenceID] [bigint] NULL ,
	[MT_SendCount] [int] NULL ,
	[MT_BaseFetchFlag] [smallint] NULL ,
	[MT_Date] [datetime] NULL ,
	[Msg_Id] [bigint] NULL ,
	[Pk_total] [smallint] NULL ,
	[Pk_number] [smallint] NULL ,
	[Registered_Delivery] [smallint] NULL ,
	[Msg_level] [smallint] NULL ,
	[Service_Id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fee_UserType] [smallint] NULL ,
	[Fee_terminal_Id] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fee_terminal_type] [smallint] NULL ,
	[TP_pId] [smallint] NULL ,
	[TP_udhi] [smallint] NULL ,
	[Msg_Fmt] [smallint] 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] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_terminal_type] [smallint] NULL ,
	[Msg_Content] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CMPP_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 ,
	[Msg_Id] [bigint] NULL ,
	[Pk_total] [smallint] NULL ,
	[Pk_number] [smallint] NULL ,
	[Registered_Delivery] [smallint] NULL ,
	[Msg_level] [smallint] NULL ,
	[Service_Id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fee_UserType] [smallint] NULL ,
	[Fee_terminal_Id] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fee_terminal_type] [smallint] NULL ,
	[TP_pId] [smallint] NULL ,
	[TP_udhi] [smallint] NULL ,
	[Msg_Fmt] [smallint] 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] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_terminal_type] [smallint] NULL ,
	[Msg_Content] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (20) 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].[CMPP_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 ,
	[Msg_Id] [bigint] NULL ,
	[Pk_total] [smallint] NULL ,
	[Pk_number] [smallint] NULL ,
	[Registered_Delivery] [smallint] NULL ,
	[Msg_level] [smallint] NULL ,
	[Service_Id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fee_UserType] [smallint] NULL ,
	[Fee_terminal_Id] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fee_terminal_type] [smallint] NULL ,
	[TP_pId] [smallint] NULL ,
	[TP_udhi] [smallint] NULL ,
	[Msg_Fmt] [smallint] 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] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_terminal_type] [smallint] NULL ,
	[Msg_Content] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MobileOrderRelation] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Mobile] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[SPNumber] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[ServiceID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[CMD] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MSG] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[MO_Date] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SGIP_Deliver] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[SPNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[TP_pid] [int] NULL ,
	[TP_udhi] [int] NULL ,
	[MessageCoding] [int] NULL ,
	[MessageLength] [int] NULL ,
	[MessageContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[MO_Date] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SGIP_Report] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SequenceNumber1] [int] NULL ,
	[SequenceNumber2] [int] NULL ,
	[SequenceNumber3] [int] NULL ,
	[ReportType] [int] NULL ,
	[UserNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL ,
	[ErrorCode] [int] NULL ,
	[LinkID] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[MO_Date] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SGIP_Submit] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MT_SendCount] [int] NULL ,
	[MT_BaseFetchFlag] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[MT_Date] [datetime] NULL ,
	[SPNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChargeNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserNumber] [varchar] (21) 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) COLLATE Chinese_PRC_CI_AS NULL ,
	[AgentFlag] [int] NULL ,
	[MorelatetoMTFlag] [int] NULL ,
	[Priority] [int] NULL ,
	[ExpireTime] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[ScheduleTime] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReportFlag] [int] NULL ,
	[TP_pid] [int] NULL ,
	[TP_udhi] [int] NULL ,
	[MessageCoding] [int] NULL ,
	[MessageType] [int] NULL ,
	[MessageContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SGIP_Submit_Error] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SequenceNumber1] [int] NULL ,
	[SequenceNumber2] [int] NULL ,
	[SequenceNumber3] [int] NULL ,
	[ResponseResult] [int] NULL ,
	[MT_SendCount] [int] NULL ,
	[MT_BaseFetchFlag] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[MT_Date] [datetime] NULL ,
	[SPNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChargeNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserNumber] [varchar] (21) 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) COLLATE Chinese_PRC_CI_AS NULL ,
	[AgentFlag] [int] NULL ,
	[MorelatetoMTFlag] [int] NULL ,
	[Priority] [int] NULL ,
	[ExpireTime] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[ScheduleTime] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReportFlag] [int] NULL ,
	[TP_pid] [int] NULL ,
	[TP_udhi] [int] NULL ,
	[MessageCoding] [int] NULL ,
	[MessageType] [int] NULL ,
	[MessageContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[ErrorCode] [int] NULL ,
	[ErrorInfo] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SGIP_Submit_History] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SequenceNumber1] [int] NULL ,
	[SequenceNumber2] [int] NULL ,
	[SequenceNumber3] [int] NULL ,
	[ResponseResult] [int] NULL ,
	[MT_SendCount] [int] NULL ,
	[MT_BaseFetchFlag] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[MT_Date] [datetime] NULL ,
	[SPNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChargeNumber] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserNumber] [varchar] (21) 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) COLLATE Chinese_PRC_CI_AS NULL ,
	[AgentFlag] [int] NULL ,
	[MorelatetoMTFlag] [int] NULL ,
	[Priority] [int] NULL ,
	[ExpireTime] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[ScheduleTime] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReportFlag] [int] NULL ,
	[TP_pid] [int] NULL ,
	[TP_udhi] [int] NULL ,
	[MessageCoding] [int] NULL ,
	[MessageType] [int] NULL ,
	[MessageContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SMGP_Deliver] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MO_Date] [datetime] NULL ,
	[MsgID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsReport] [smallint] NULL ,
	[MsgFormat] [smallint] NULL ,
	[RecvTime] [varchar] (14) COLLATE Chinese_PRC_CI_AS NULL ,
	[SrcTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[DestTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgLength] [smallint] NULL ,
	[MsgContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reserve] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SMGP_Report] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MO_Date] [datetime] NULL ,
	[MsgID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[sub] [varchar] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[dlvrd] [varchar] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[Submit_date] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[done_date] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stat] [varchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[Err] [varchar] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[Txt] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgContent] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SMGP_Submit] (
	[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 ,
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -