110 lines
8.7 KiB
Transact-SQL
110 lines
8.7 KiB
Transact-SQL
USE [MobsetOA]
|
||
GO
|
||
alter table [dbo].[app_td] add [c_isUsed] [int] NULL --是否启用(0启用,1禁用)
|
||
alter table [dbo].[app_td] add [c_corpIdOne] [varchar](50) NULL --平台1企业id
|
||
alter table [dbo].[app_td] add [c_loginNameOne] [varchar](50) NULL --平台1用户名
|
||
alter table [dbo].[app_td] add [c_passwdOne] [varchar](50) NULL --平台1密码
|
||
alter table [dbo].[app_td] add [c_corpIdThree] [varchar](50) NULL --平台3企业ID
|
||
alter table [dbo].[app_td] add [c_loginNameThree] [varchar](50) NULL--平台3用户名
|
||
alter table [dbo].[app_td] add [c_passwdThree] [varchar](50) NULL --平台3密码
|
||
alter table [dbo].[app_td] add [c_channelType] [int] NULL --通道类型(营销/应用)
|
||
alter table [dbo].[app_td] add [c_channelCM] [varchar](50) NULL --移动通道
|
||
alter table [dbo].[app_td] add [c_phoneCM] [varchar](200) NULL --移动通道测试手机号
|
||
alter table [dbo].[app_td] add [c_channelCU] [varchar](50) NULL --联通通道
|
||
alter table [dbo].[app_td] add [c_phoneCU] [varchar](200) NULL --联通通道测试手机号
|
||
alter table [dbo].[app_td] add [c_channelCT] [varchar](50) NULL --电信通道
|
||
alter table [dbo].[app_td] add [c_phoneCT] [varchar](200) NULL --电信通道测试手机号
|
||
alter table [dbo].[app_td] add [c_content] [varchar](500) NULL --测试内容
|
||
alter table [dbo].[app_td] add [c_exceptionType] [int] NULL --异常通知(0表示所有测试结果，1表示异常测试结果)
|
||
alter table [dbo].[app_td] add [c_noticeType] [int] NULL --通知方式(0企业微信,1手机短信)
|
||
alter table [dbo].[app_td] add [c_overtimeThreshold] [int] NULL --超时时间阀值(单位秒)
|
||
alter table [dbo].[app_td] add [c_seriousThreshold] [int] NULL --严重超时阀值(单位秒)
|
||
alter table [dbo].[app_td] add [c_loseThresholde] [int] NULL --丢失时间阀值(单位秒)
|
||
alter table [dbo].[app_td] add [c_startTime] [smalldatetime] NULL --定时发送开始时间
|
||
alter table [dbo].[app_td] add [c_endTime] [smalldatetime] NULL --定时发送结束时间
|
||
alter table [dbo].[app_td] add [c_timeInterval] [int] NULL --时间间隔(单位分钟)
|
||
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否启用(0启用,1禁用)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_isUsed'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'平台1企业id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_corpIdOne'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'平台1用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_loginNameOne'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'平台1密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_passwdOne'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'平台3企业ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_corpIdThree'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'平台3用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_loginNameThree'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'平台3密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_passwdThree'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通道类型(营销/应用)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_channelType'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'移动通道' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_channelCM'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'移动通道测试手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_phoneCM'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联通通道' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_channelCU'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联通通道测试手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_phoneCU'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电信通道' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_channelCT'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电信通道测试手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_phoneCT'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测试内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_content'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常通知(0表示所有测试结果，1表示异常测试结果)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_exceptionType'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通知方式(0企业微信,1手机短信)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_noticeType'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'超时时间阀值(单位秒)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_overtimeThreshold'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'严重超时阀值(单位秒)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_seriousThreshold'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'丢失时间阀值(单位秒)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_loseThresholde'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'定时发送开始时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_startTime'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'定时发送结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_endTime'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间间隔(单位分钟)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td', @level2type=N'COLUMN',@level2name=N'c_timeInterval'
|
||
GO
|
||
|
||
|
||
|
||
USE [MobsetOA]
|
||
GO
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
SET ANSI_PADDING ON
|
||
GO
|
||
CREATE TABLE [dbo].[app_td_noticeInfo](
|
||
[td_id] [int] IDENTITY(1,1) NOT NULL, --id
|
||
[td_name] [varchar](50) NULL, --名称
|
||
[td_wx] [varchar](200) NULL, --微信号
|
||
[td_wxNoticeType] [int] NULL, --微信异常通知类型(0所有通知,1异常通知)
|
||
[td_phone] [varchar](200) NULL, --手机号
|
||
[td_phoneNoticeType] [int] NULL, --手机异常通知类型(0所有通知,1异常通知)
|
||
[td_date] [smalldatetime] NOT NULL, --时间
|
||
CONSTRAINT [PK_app_td_noticeInfo] PRIMARY KEY CLUSTERED
|
||
(
|
||
[td_id] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td_noticeInfo', @level2type=N'COLUMN',@level2name=N'td_wx'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信异常通知类型(0所有通知,1异常通知)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td_noticeInfo', @level2type=N'COLUMN',@level2name=N'td_wxNoticeType'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td_noticeInfo', @level2type=N'COLUMN',@level2name=N'td_phone'
|
||
GO
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机异常通知类型(0所有通知,1异常通知)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_td_noticeInfo', @level2type=N'COLUMN',@level2name=N'td_phoneNoticeType'
|
||
GO
|