--DS域模板升级脚本
--升级DS域模板基本信息
insert into PFDB..tbl_R_Qos_Pf_DsDomainInfo(ProfileName)
select distinct b.strName from DmsQosDB..tbl_QosPolicy_TemplBase b,DmsQosDB..tbl_QosPolicy_TemplDsPara p
where b.id=p.iTemplateID
go--升级DS域模板参数信息
if exists (select name from sysobjects where name ='ps_DsDomainTemplDatahandle' and type='P')
drop procedure ps_DsDomainTemplDatahandle
gocreate procedure ps_DsDomainTemplDatahandle
asif exists (select * from dbo.sysobjects where name = 't_tbl_DsDomainPara' and type = 'U')
drop table t_tbl_DsDomainPara
create table t_tbl_DsDomainPara
(
iTemplateID int default '-1' not null,
iPrecedenceType int default '-1' not null,
iPrecedenceValue int default '-1' not null,
iServiceClass int default '-1' not null,
iDirection int default '-1' not null,
iColor int default '-1' not null,
)insert into t_tbl_DsDomainPara
select distinct d.LocalKey,p.iPrecedenceType,p.iPrecedenceValue,p.iServiceClass,p.iDirection,p.iColor
from PFDB..tbl_R_Qos_Pf_DsDomainInfo d,DmsQosDB..tbl_QosPolicy_TemplBase b,DmsQosDB..tbl_QosPolicy_TemplDsPara p
where b.id=p.iTemplateID and d.ProfileName=b.strNamedeclare @i int
set @i = 1declare @col1 int
declare @col2 int
declare @col3 int
declare @col4 int
declare @col5 int
declare @col6 intdeclare cursor_classID cursor for
select * from t_tbl_DsDomainParaopen cursor_classID
fetch next from cursor_classID into @col1,@col2,@col3,@col4,@col5,@col6while @@fetch_status = 0
begin
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iPriorityType',@col2)
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iUserPriorityValue',@col3)
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iCosValue',@col4)
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iDirection',@col5)
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iColor',@col6)
fetch next from cursor_classID into @col1,@col2,@col3,@col4,@col5,@col6
set @i = @i + 1
end close cursor_classID
deallocate cursor_classID
goexec ps_DsDomainTemplDatahandle
godrop procedure ps_DsDomainTemplDatahandle
go
--升级DS域模板基本信息
insert into PFDB..tbl_R_Qos_Pf_DsDomainInfo(ProfileName)
select distinct b.strName from DmsQosDB..tbl_QosPolicy_TemplBase b,DmsQosDB..tbl_QosPolicy_TemplDsPara p
where b.id=p.iTemplateID
go--升级DS域模板参数信息
if exists (select name from sysobjects where name ='ps_DsDomainTemplDatahandle' and type='P')
drop procedure ps_DsDomainTemplDatahandle
gocreate procedure ps_DsDomainTemplDatahandle
asif exists (select * from dbo.sysobjects where name = 't_tbl_DsDomainPara' and type = 'U')
drop table t_tbl_DsDomainPara
create table t_tbl_DsDomainPara
(
iTemplateID int default '-1' not null,
iPrecedenceType int default '-1' not null,
iPrecedenceValue int default '-1' not null,
iServiceClass int default '-1' not null,
iDirection int default '-1' not null,
iColor int default '-1' not null,
)insert into t_tbl_DsDomainPara
select distinct d.LocalKey,p.iPrecedenceType,p.iPrecedenceValue,p.iServiceClass,p.iDirection,p.iColor
from PFDB..tbl_R_Qos_Pf_DsDomainInfo d,DmsQosDB..tbl_QosPolicy_TemplBase b,DmsQosDB..tbl_QosPolicy_TemplDsPara p
where b.id=p.iTemplateID and d.ProfileName=b.strNamedeclare @i int
set @i = 1declare @col1 int
declare @col2 int
declare @col3 int
declare @col4 int
declare @col5 int
declare @col6 intdeclare cursor_classID cursor for
select * from t_tbl_DsDomainParaopen cursor_classID
fetch next from cursor_classID into @col1,@col2,@col3,@col4,@col5,@col6while @@fetch_status = 0
begin
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iPriorityType',@col2)
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iUserPriorityValue',@col3)
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iCosValue',@col4)
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iDirection',@col5)
insert into PFDB..tbl_R_Qos_Pf_DsDomainDetail(LocalKey,IndexEntry,KeyName,KeyValue) values (@col1,@i,'iColor',@col6)
fetch next from cursor_classID into @col1,@col2,@col3,@col4,@col5,@col6
set @i = @i + 1
end close cursor_classID
deallocate cursor_classID
goexec ps_DsDomainTemplDatahandle
godrop procedure ps_DsDomainTemplDatahandle
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货