--v6.1汾űִݸԽ׶ηv6.1汾ִС
--ĿĬϿʱʾ
insert into bigclassdesign(menuId,cssname,isflag,imageFlag,isnew,imagenew,ishot,imagehot,istop,imagetop,ismore,imagemore,isdept,isclick,istime)
select  pkid,'',0,'./Images/artdesign/itemImage/system_flag.png' ,1,'./images/artdesign/newImage/system_new.gif',0,'./images/artdesign/hotImage/system_hot.gif',0,'./images/artdesign/topImage/system_top.gif',1,'&gt;&gt;',0,0,6
from menu where modeid=4 and pkid not in(select menuid from bigclassDesign)

--²ʹĿģ
update menu set artDesignTemplateId='0' where modeid='4' and artDesignTemplateId='1'

--ʾʱ
update bigClassDesign set isTime='8' where isTime='0'

--ŲʾĿ
update menu set contributesorttype='1' where modeid='4' and contributesorttype='0' and
bigclassid in (
select b.pkid from bigclass b ,template t where b.templateid=t.pkid and t.pkid=28
)

--ûȨޱ
delete groupAssign where menuId not in (select pkId from menu)
go
--ûȨ
delete moduleAssign where menuId not in (select pkId from menu)
go
--Ϣ쳣
update news set passed='1' where passed is null

----------------------------------------------------------------------
--v6.3汾ű
----------------------------------------------------------------------
--Ҫԭбдŵhtmlǩݿеhref=ͷַ
update news set listtitle=left(right(listTitle,len(listTitle)-charindex('href="',listTitle)-5),charindex('"',right(listTitle,len(listTitle)-charindex('href="',listTitle)-5))-1) where charindex('href="',listTitle)>0
go

--ȡĿһŵnew.WidthheightΪmenuĬֵ
update a set width=(select top 1 width from news d where d.bigclassId=a.bigclassid  order by updateTime desc),
height=(select top 1 height from news d where d.bigclassId=a.bigclassid  order by updateTime desc)
from menu a,bigclass b,template c
where a.bigclassid=b.pkid and b.templateId=c.pkid and c.typeId=2 and a.width is null and a.height is null

go


--Ŀ--v6.1汾һΡ˴ظִзֹ©
update template set [name]='վ(ѡ)' where pkid='17'
GO
update template set [name]='Ա¼()' where pkid='18'
GO
update template set [name]='վ(ѡ)' where pkid='17'
GO
update template set [name]='ŵ' where pkid='7'
GO

--޸templateType--v6.1汾һΡ˴ظִзֹ©˴ӰͼĿָĬͼƬߡ
--1.2.ͼ3.4.5.
update templatetype set [name]='news',type='' where pkid='1'
GO
UPDATE templateType SET [name] ='picVedio',type ='ͼ' where pkId='2'
GO
UPDATE templateType SET [name] ='interact',type =''  where pkId='4'
GO
UPDATE templateType SET [name] ='tool' ,type = '' where pkId='5' 
GO
update template set typeId='1' where pkid in (1,5,7,10,13,23,28,36)
GO
update template set typeId='2' where pkid in (6,12,24,25,26,27,43,71)
GO
update template set typeId='3' where pkid='37'
GO
update template set typeId='4' where pkid in (14,22,32,33,45,46,47,48,60,63,65)
GO
update template set typeId='5' where pkid in (9,11,15,16,17,18,19,30,58,65,66,67,69,72,73,74)
GO
update template set typeId='6' where pkid in (49,50,51,52,53,54,55,56,57,62,64,68,70)
GO

--Ȩ:¡û2Ϊ0
update news set gate=0 where gate=2
go

------------------------------------------------------------
--Ա
------------------------------------------------------------
--ʼݽԻظΪͨ
update messageboard set reAudit='1'
go


--ûȨޣ׷ԱʴĿظȨޣĬͨ
update moduleAssign set privilegeset= privilegeset+'|canAuditReply=1|defaultReplyPassed=1' 
where menuid in ( 
select pkid from menu where modeid=4 and bigclassid in (select pkid from bigclass where templateid in (32,63) )) 
and privilegeset not like '%canAuditReply%'
go

--ûȨޣ׷ԱʴĿڻظȨޣĬͨ
update groupAssign set privilegeset= privilegeset+'|canAuditReply=1|defaultReplyPassed=1' 
where menuid in ( 
select pkid from menu where modeid=4 and bigclassid in (select pkid from bigclass where templateid in (32,63) )) 
and privilegeset not like '%canAuditReply%'
go


--ɾվĿȨϢ
delete from templatePrivilege where templateid='14' and privilegeid='8'
go
delete from templatePrivilege where templateid='14' and privilegeid='9'
go
