﻿drop function sq_cbf001sy.f_cid

if object_id('sq_cbf001sy.admin_g_s1','p')>0 --判断是否存在
  drop proc sq_cbf001sy.admin_g_s1 --如果存在先删除


if object_id('sq_cbf001sy.adminmovieall','p')>0 
  drop proc sq_cbf001sy.adminmovieall 

if object_id('sq_cbf001sy.vod2008newurl','p')>0 
  drop proc sq_cbf001sy.vod2008newurl 

if object_id('sq_cbf001sy.adminmovieall2','p')>0
  drop proc sq_cbf001sy.adminmovieall2

if object_id('sq_cbf001sy.movietop4','p')>0
  drop proc sq_cbf001sy.movietop4


if object_id('sq_cbf001sy.adminmovieall3','p')>0
  drop proc sq_cbf001sy.adminmovieall3


if object_id('sq_cbf001sy.cai1','p')>0
  drop proc sq_cbf001sy.cai1


if object_id('sq_cbf001sy.cai2','p')>0
  drop proc sq_cbf001sy.cai2


if object_id('sq_cbf001sy.cai3','p')>0
  drop proc sq_cbf001sy.cai3


if object_id('sq_cbf001sy.cbftype1','p')>0
  drop proc sq_cbf001sy.cbftype1



if object_id('sq_cbf001sy.cbftype2','p')>0
  drop proc sq_cbf001sy.cbftype2



if object_id('sq_cbf001sy.cbftype3','p')>0
  drop proc sq_cbf001sy.cbftype3




if object_id('sq_cbf001sy.cai3','p')>0
  drop proc sq_cbf001sy.cai3



if object_id('sq_cbf001sy.cbftype4','p')>0
  drop proc sq_cbf001sy.cbftype4



if object_id('sq_cbf001sy.cbfusers1','p')>0
  drop proc sq_cbf001sy.cbfusers1



if object_id('sq_cbf001sy.cbfusers2','p')>0
  drop proc sq_cbf001sy.cbfusers2



if object_id('sq_cbf001sy.class','p')>0
  drop proc sq_cbf001sy.class



if object_id('sq_cbf001sy.class1','p')>0
  drop proc sq_cbf001sy.class1



if object_id('sq_cbf001sy.movie1','p')>0
  drop proc sq_cbf001sy.movie1



if object_id('sq_cbf001sy.movieSearch','p')>0
  drop proc sq_cbf001sy.movieSearch


if object_id('sq_cbf001sy.movieSearchname','p')>0
  drop proc sq_cbf001sy.movieSearchname



if object_id('sq_cbf001sy.movieSearchstanrting','p')>0
  drop proc sq_cbf001sy.movieSearchstanrting



if object_id('sq_cbf001sy.movieaspurl','p')>0
  drop proc sq_cbf001sy.movieaspurl



if object_id('sq_cbf001sy.moviecid','p')>0
  drop proc sq_cbf001sy.moviecid


if object_id('sq_cbf001sy.moviename','p')>0
  drop proc sq_cbf001sy.moviename


if object_id('sq_cbf001sy.movieserver1','p')>0
  drop proc sq_cbf001sy.movieserver1


if object_id('sq_cbf001sy.movieserver2','p')>0
  drop proc sq_cbf001sy.movieserver2


if object_id('sq_cbf001sy.moviesourl','p')>0
  drop proc sq_cbf001sy.moviesourl


if object_id('sq_cbf001sy.movietop14','p')>0
  drop proc sq_cbf001sy.movietop14


if object_id('sq_cbf001sy.movieurl1','p')>0
  drop proc sq_cbf001sy.movieurl1


if object_id('sq_cbf001sy.movieurl2','p')>0
  drop proc sq_cbf001sy.movieurl2


if object_id('sq_cbf001sy.movieurl3','p')>0
  drop proc sq_cbf001sy.movieurl3


if object_id('sq_cbf001sy.play1','p')>0
  drop proc sq_cbf001sy.play1


if object_id('sq_cbf001sy.play2','p')>0
  drop proc sq_cbf001sy.play2


if object_id('sq_cbf001sy.rssclassid','p')>0
  drop proc sq_cbf001sy.rssclassid



if object_id('sq_cbf001sy.rssclassidm','p')>0
  drop proc sq_cbf001sy.rssclassidm



if object_id('sq_cbf001sy.rsss','p')>0
  drop proc sq_cbf001sy.rsss



if object_id('sq_cbf001sy.toptype','p')>0
  drop proc sq_cbf001sy.toptype



if object_id('sq_cbf001sy.vipcaigvod1','p')>0
  drop proc sq_cbf001sy.vipcaigvod1


if object_id('sq_cbf001sy.vipcaigvod2','p')>0
  drop proc sq_cbf001sy.vipcaigvod2


if object_id('sq_cbf001sy.vipcaimovie1','p')>0
  drop proc sq_cbf001sy.vipcaimovie1


if object_id('sq_cbf001sy.vipmoviename','p')>0
  drop proc sq_cbf001sy.vipmoviename


if object_id('sq_cbf001sy.vipmovieurl','p')>0
  drop proc sq_cbf001sy.vipmovieurl


if object_id('sq_cbf001sy.vipnewmovie','p')>0
  drop proc sq_cbf001sy.vipnewmovie


if object_id('sq_cbf001sy.vod2008classcyte1','p')>0
  drop proc sq_cbf001sy.vod2008classcyte1


if object_id('sq_cbf001sy.vod2008classtop10','p')>0
  drop proc sq_cbf001sy.vod2008classtop10


if object_id('sq_cbf001sy.vod2008classtopnwe10','p')>0
  drop proc sq_cbf001sy.vod2008classtopnwe10


if object_id('sq_cbf001sy.vod2008ctye2','p')>0
  drop proc sq_cbf001sy.vod2008ctye2


if object_id('sq_cbf001sy.vod2008hits24','p')>0
  drop proc sq_cbf001sy.vod2008hits24


if object_id('sq_cbf001sy.vod2008home','p')>0
  drop proc sq_cbf001sy.vod2008home


if object_id('sq_cbf001sy.vod2008htm3','p')>0
  drop proc sq_cbf001sy.vod2008htm3


if object_id('sq_cbf001sy.vod2008index20','p')>0
  drop proc sq_cbf001sy.vod2008index20


if object_id('sq_cbf001sy.vod2008indexctye','p')>0
  drop proc sq_cbf001sy.vod2008indexctye


if object_id('sq_cbf001sy.vod2008indexctye4','p')>0
  drop proc sq_cbf001sy.vod2008indexctye4


if object_id('sq_cbf001sy.vod2008indexnew4','p')>0
  drop proc sq_cbf001sy.vod2008indexnew4


if object_id('sq_cbf001sy.vod2008indexnew9','p')>0
  drop proc sq_cbf001sy.vod2008indexnew9


if object_id('sq_cbf001sy.vod2008indexto4','p')>0
  drop proc sq_cbf001sy.vod2008indexto4


if object_id('sq_cbf001sy.vod2008indextop11','p')>0
  drop proc sq_cbf001sy.vod2008indextop11


if object_id('sq_cbf001sy.vod2008movie1','p')>0
  drop proc sq_cbf001sy.vod2008movie1


if object_id('sq_cbf001sy.vod2008piltype','p')>0
  drop proc sq_cbf001sy.vod2008piltype


if object_id('sq_cbf001sy.vod2008play','p')>0
  drop proc sq_cbf001sy.vod2008play


if object_id('sq_cbf001sy.vod2008playid','p')>0
  drop proc sq_cbf001sy.vod2008playid


if object_id('sq_cbf001sy.vod2008typecid','p')>0
  drop proc sq_cbf001sy.vod2008typecid



if object_id('sq_cbf001sy.vod2008vodasp','p')>0
  drop proc sq_cbf001sy.vod2008vodasp
