01.00.08.sqldataprovider

SharpNuke源代码

/************************************************************/
/*****              Upgrade Script 1.0.8                *****/
/************************************************************/

/* drop all stored procedures */

if exists (select * from dbo.sysobjects where id = object_id(N'AddAnnouncement') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddAnnouncement
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddBanner') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddBanner
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddContact') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddContact
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddDocument') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddDocument
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddFAQ') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddFAQ
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddFile') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddFile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddLink') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddLink
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddMessage') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddMessage
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddModule') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddModule
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddModuleDefinition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddModuleDefinition
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddModuleEvent') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddModuleEvent
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddPortalInfo') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddPortalInfo
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddRole') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddRole
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddSearch') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddSearch
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddSiteLog') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddSiteLog
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddTab') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddTab
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddUser') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddUser
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddUserDefinedField') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddUserDefinedField
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddUserDefinedRow') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddUserDefinedRow
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddUserRole') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddUserRole
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddVendor') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddVendor
GO

if exists (select * from dbo.sysobjects where id = object_id(N'AddVendorClassification') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure AddVendorClassification
GO

if exists (select * from dbo.sysobjects where id = object_id(N'CopyTab') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure CopyTab
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteAnnouncement') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteAnnouncement
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteBanner') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteBanner
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteContact') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteContact
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteDocument') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteDocument
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteFAQ') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteFAQ
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteFile') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteFile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteFiles') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteFiles
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteLink') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteLink
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteMessage') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteMessage
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteModule') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteModule
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteModuleDefinition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteModuleDefinition
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteModuleEvent') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteModuleEvent
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeletePortalInfo') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeletePortalInfo
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteRole') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteRole
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteSearch') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteSearch
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteTab') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteTab
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteUser') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteUser
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteUserDefinedField') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteUserDefinedField
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteUserDefinedRow') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteUserDefinedRow
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteUserRole') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteUserRole
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteVendor') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteVendor
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteVendorClassifications') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteVendorClassifications
GO

if exists (select * from dbo.sysobjects where id = object_id(N'DeleteVendorFeedback') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure DeleteVendorFeedback
GO

if exists (select * from dbo.sysobjects where id = object_id(N'FindBanners') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure FindBanners
GO

if exists (select * from dbo.sysobjects where id = object_id(N'FindVendors') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure FindVendors
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetAnnouncements') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetAnnouncements
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetAuthRoles') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetAuthRoles
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetBannerClickThrough') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetBannerClickThrough
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetBannerLog') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetBannerLog
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetBannerTypes') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetBannerTypes
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetBanners') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetBanners
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetBillingFrequencyCode') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetBillingFrequencyCode
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetBillingFrequencyCodes') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetBillingFrequencyCodes
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetClicks') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetClicks
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetContacts') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetContacts
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetCountryCodes') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetCountryCodes
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetCurrencies') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetCurrencies
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetDocuments') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetDocuments
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetFAQs') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetFAQs
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetFiles') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetFiles
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetHostSetting') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetHostSetting
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetHostSettings') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetHostSettings
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetHtmlText') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetHtmlText
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetLinks') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetLinks
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetModule') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetModule
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetModuleDefinitions') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetModuleDefinitions
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetModuleEvents') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetModuleEvents
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetModuleSettings') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetModuleSettings
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetPortalByAlias') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetPortalByAlias
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetPortalByTab') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetPortalByTab
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetPortalModuleDefinitionFee') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetPortalModuleDefinitionFee
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetPortalModuleDefinitions') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetPortalModuleDefinitions
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetPortalRoles') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetPortalRoles
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetPortalSettings') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetPortalSettings
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetPortalSpaceUsed') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetPortalSpaceUsed
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetPortals') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetPortals
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetProcessorCodes') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetProcessorCodes
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetRegionCodes') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetRegionCodes
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetRoleMembership') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetRoleMembership
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetRolesByUser') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetRolesByUser
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSearch') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSearch
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetServices') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetServices
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetServicesByUser') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetServicesByUser
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleAnnouncement') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleAnnouncement
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleBanner') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleBanner
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleContact') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleContact
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleCountry') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleCountry
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleDocument') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleDocument
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleFAQ') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleFAQ
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleFile') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleFile
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleLink') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleLink
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleMessage') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleMessage
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleModuleDefinition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleModuleDefinition
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleModuleDefinitionByName') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleModuleDefinitionByName
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleModuleEvent') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleModuleEvent
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSinglePortal') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSinglePortal
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleRegion') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleRegion
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleRole') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleRole
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleSearch') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleSearch
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleUser') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleUser
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleUserByUsername') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleUserByUsername
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleUserDefinedField') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleUserDefinedField
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleUserDefinedRow') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleUserDefinedRow
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleUserRole') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleUserRole
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleVendor') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleVendor
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSingleVendorFeedback') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSingleVendorFeedback
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSiteLog') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSiteLog
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSiteLogReports') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSiteLogReports
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetSiteModule') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetSiteModule
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetTabById') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetTabById
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetTabByName') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetTabByName
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetTabs') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetTabs
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetTabsByParentId') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetTabsByParentId
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetThreadMessages') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetThreadMessages
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetTopLevelMessages') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetTopLevelMessages
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetUserDefinedFields') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetUserDefinedFields
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetUserDefinedRows') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetUserDefinedRows
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetUsers') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetUsers
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetVendorClassifications') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetVendorClassifications
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetVendorClickThrough') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetVendorClickThrough
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetVendorFeedback') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetVendorFeedback
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetVendorLog') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetVendorLog
GO

if exists (select * from dbo.sysobjects where id = object_id(N'GetVendors') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetVendors
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateAnnouncement') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateAnnouncement
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateBanner') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateBanner
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateClicks') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateClicks
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateContact') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateContact
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateDocument') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateDocument
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateFAQ') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateFAQ
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateHostSetting') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateHostSetting
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateHtmlText') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateHtmlText
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateImage') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateImage
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateLink') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateLink
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateMessage') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure UpdateMessage
GO

if exists (select * from dbo.sysobjects where id = object_id(N'UpdateModule') and OBJECTPROPERTY(id, N'IsProcedure') = 1)