📄 isag_ismg.sql

📁 电信ISMG网关程序,为电信综合业务网关,20090102发布.小
💻 SQL
📖 第 1 页 / 共 2 页
字号:
12 下一页
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_notifyManagementInfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_notifyManagementInfo]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[notifyManagementInfo] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[streamingNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IDType] [int] NULL ,
	[status] [int] NULL ,
	[moDate] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[notifySmsDeliveryReceipt] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[spRevId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[spRevpassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[spId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SAN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[transactionId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[linkId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[correlator] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[deliveryStatus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[moDate] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[notifySmsReception] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[spRevId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[spRevpassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[spId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SAN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[transactionId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[linkId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[registrationIdentifier] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[senderAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[smsServiceActivationNumber] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[moDate] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[orderRelationUpdateNotifyReq] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[streamingNo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[productID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[packageID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userIDType] [int] NULL ,
	[OPType] [int] NULL ,
	[moDate] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[sendPush] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[mtDate] [datetime] NULL ,
	[mtHashCode] [bigint] NULL ,
	[mtSendCount] [smallint] NULL ,
	[SH_productId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_SAN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_transactionId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_transEnd] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_linkID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_OA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_FA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[addresses] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[senderAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[targetURL] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_endpoint] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_interfaceName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_correlator] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[sendPushHistory] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[mtDate] [datetime] NULL ,
	[mtHashCode] [bigint] NULL ,
	[mtSendCount] [smallint] NULL ,
	[SH_productId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_SAN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_transactionId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_transEnd] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_linkID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_OA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_FA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[addresses] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[senderAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[targetURL] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[subject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_endpoint] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_interfaceName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_correlator] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mtResult] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mtMessageId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mtText] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[sendSms] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[mtDate] [datetime] NULL ,
	[mtHashCode] [bigint] NULL ,
	[mtSendCount] [smallint] NULL ,
	[SH_productId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_SAN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_transactionId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_transEnd] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_linkID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_OA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_FA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[addresses] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[senderName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CI_description] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CI_currency] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CI_amount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CI_code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_endpoint] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_interfaceName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_correlator] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[sendSmsHistory] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[mtDate] [datetime] NULL ,
	[mtHashCode] [bigint] NULL ,
	[mtSendCount] [smallint] NULL ,
	[SH_productId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_SAN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_transactionId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_transEnd] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_linkID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_OA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SH_FA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[addresses] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[senderName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CI_description] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CI_currency] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CI_amount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CI_code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_endpoint] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_interfaceName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SR_correlator] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mtResult] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mtMessageId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mtText] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[serviceConsumeNotifyReq] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[streamingNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userIDType] [int] NULL ,
	[productID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[linkID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[featureStr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[moDate] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[systemBadWord] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[Badword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[systemBlackList] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[Address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[notifyManagementInfo] WITH NOCHECK ADD 
	CONSTRAINT [PK_notifyManagementInfo] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[notifySmsDeliveryReceipt] WITH NOCHECK ADD 
	CONSTRAINT [PK_notifySmsDeliveryReceipt] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[notifySmsReception] WITH NOCHECK ADD 
	CONSTRAINT [PK_notifySmsReception] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[orderRelationUpdateNotifyReq] WITH NOCHECK ADD 
	CONSTRAINT [PK_orderRelationUpdateNotifyReq] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[sendPush] WITH NOCHECK ADD 
	CONSTRAINT [PK_sendPush] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[sendPushHistory] WITH NOCHECK ADD 
	CONSTRAINT [PK_sendPushHistory] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[sendSms] WITH NOCHECK ADD 
	CONSTRAINT [PK_sendSms] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[sendSmsHistory] WITH NOCHECK ADD 
	CONSTRAINT [PK_sendSmsHistroy] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[serviceConsumeNotifyReq] WITH NOCHECK ADD 
	CONSTRAINT [PK_serviceConsumeNotifyReq] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[systemBadWord] WITH NOCHECK ADD 
	CONSTRAINT [PK_systemBadWord] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[systemBlackList] WITH NOCHECK ADD 
	CONSTRAINT [PK_systemBlackList] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO
12 下一页
💿 文件大小 440 K
👤 上传用户 fq335288450
📂 所属分类 *行业应用
🏷️ 相关标签

#20090102 #ISMG #电信 #业务网关
⌨️ 快捷键说明

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