alter  proc spw_dbmediasequenceall
as
BEGIN
	declare @moduleid int  ,@sql nvarchar(2000)
	if OBJECT_ID('MediaSequence') is not null and OBJECT_ID('MediaSequenceType') is not null
	BEGIN
		
		set @moduleid=0
		set @sql='select @moduleid = Modules.Module_ID from Modules where Modules.Module_Type=104 and modules.Module_IsLocal=1'
		exec sp_executesql @sql,N'@moduleid int out',@moduleid out 
		print @moduleid
		exec ('delete MediaSequence where MediaSequence_TypeId in(select MediaSequenceType_Id from MediaSequenceType where MediaSequenceType_IsLocal=1);
		delete from MediaSequenceType where MediaSequenceType_IsLocal=1  ') 
		exec spw_sequencemediaday  @moduleid,'MediaSequence',1,'总排行',1,1,1,200,0,0  --160  
		set @sql= 'select '+CONVERT(nvarchar, @moduleid) +',1,''总排行'',1,1'
		exec('insert into MediaSequenceType '+@sql) 
		exec spw_sequencemediaday  @moduleid,'MediaSequence',2,'国语',2,1,1,200,0,0 --124  
		set @sql= 'select '+CONVERT(nvarchar, @moduleid) +',2,''国语'',2,1'
		exec('insert into MediaSequenceType '+@sql) 
		exec spw_sequencemediaday  @moduleid,'MediaSequence',3,'粤语',3,1,1,200,0,0 --24  
		set @sql= 'select '+CONVERT(nvarchar, @moduleid) +',3,''粤语'',3,1'
		exec('insert into MediaSequenceType '+@sql) 
		exec spw_sequencemediaday  @moduleid,'MediaSequence',4,'闽南语',4,1,1,200,0,0--7  
		set @sql= 'select '+CONVERT(nvarchar, @moduleid) +',4,''闽南语'',4,1'
		exec('insert into MediaSequenceType '+@sql) 
		--exec spw_sequencemediaday  @moduleid,'MediaSequence',5,'英语',5,1,1,200,0,0--5  
		--exec spw_sequencemediaday  @moduleid,'MediaSequence',6,'日语',6,1,1,200,0,0--0  
		--exec spw_sequencemediaday  @moduleid,'MediaSequence',7,'韩语',7,1,1,200,0,0--0  
		--exec spw_sequencemediaday  @moduleid,'MediaSequence',8,'其它',8,1,1,200,0,0--0  
		exec spw_sequencemediaday  @moduleid,'MediaSequence',null,'新歌',9,1,1,200,0,1--41  
		set @sql= 'select '+CONVERT(nvarchar, @moduleid) +',9,''新歌'',9,1'
		exec('insert into MediaSequenceType '+@sql) 
		exec spw_sequencemediaday  @moduleid,'MediaSequence',null,'周',10,1,1,200,7,0--14  
		set @sql= 'select '+CONVERT(nvarchar, @moduleid) +',10,''周'',10,1'
		exec('insert into MediaSequenceType '+@sql) 
		exec spw_sequencemediaday  @moduleid,'MediaSequence',null,'月',11,1,1,200,30,0--23   
		set @sql= 'select '+CONVERT(nvarchar, @moduleid) +',11,''月'',11,1'
		exec('insert into MediaSequenceType '+@sql) 
	END
	if OBJECT_ID('ktvmodule_ranklist') is not null and OBJECT_ID('ktvmodule_rankdata') is not null
	BEGIN   
		set @moduleid=0
		set @sql='select top 1 @moduleid =(case when dataid>0 then dataid else mainid end) from ktvmodule_main where optype=4'
		exec sp_executesql @sql,N'@moduleid int out',@moduleid out 
		print @moduleid
		set @sql='delete ktvmodule_rankdata where rankid in(select id from ktvmodule_ranklist where dataid='+convert(nvarchar,@moduleid)+'); delete ktvmodule_ranklist where dataid='+convert(nvarchar,@moduleid)
		exec (@sql) 
		exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',1,'总排行',1,1,1,200,0,0  --160  
		set @sql= 'select 1,'+CONVERT(nvarchar, @moduleid) +',''总排行'',getdate(),1'
		exec('insert into ktvmodule_ranklist '+@sql) 
		exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',2,'国语',2,1,1,200,0,0 --124  
		set @sql= 'select 2,'+CONVERT(nvarchar, @moduleid) +',''国语'',getdate(),2'
		exec('insert into ktvmodule_ranklist '+@sql) 
		exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',3,'粤语',3,1,1,200,0,0 --24  
		set @sql= 'select 3,'+CONVERT(nvarchar, @moduleid) +',''粤语'',getdate(),3'
		exec('insert into ktvmodule_ranklist '+@sql) 
		exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',4,'闽南语',4,1,1,200,0,0--7  
		set @sql= 'select '+CONVERT(nvarchar, @moduleid) +',4,''闽南语'',getdate(),4'
		exec('insert into ktvmodule_ranklist '+@sql) 
		--exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',5,'英语',5,1,1,200,0,0--5  
		--exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',6,'日语',6,1,1,200,0,0--0  
		--exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',7,'韩语',7,1,1,200,0,0--0  
		--exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',8,'其它',8,1,1,200,0,0--0  
		exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',null,'新歌',9,1,1,200,0,1--41  
		set @sql= 'select 9,'+CONVERT(nvarchar, @moduleid) +',''新歌'',getdate(),9'
		exec('insert into ktvmodule_ranklist '+@sql) 
		exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',null,'周',10,1,1,200,7,0--14  
		set @sql= 'select 10,'+CONVERT(nvarchar, @moduleid) +',''周'',getdate(),10'
		exec('insert into ktvmodule_ranklist '+@sql) 
		exec spw_sequencemediaday  @moduleid,'ktvmodule_rankdata',null,'月',11,1,1,200,30,0--23   
		set @sql= 'select 11,'+CONVERT(nvarchar, @moduleid) +',''月'',getdate(),11'
		exec('insert into ktvmodule_ranklist '+@sql) 
	END
END