/************************************************************/
/***** UnInstall.SqlDataProvider.sql *****/
/***** *****/
/***** *****/
/***** Note: The script doesn't use DOtNetNuke parameters
{databaseOwner} and {objectQualifier} *****/
/***** perform a search and replace operation *****/
/***** but hardcoded them to dbo. and dnn_ *****/
/** Remove DotNetNuke Objects **/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Affiliates_dnn_Vendors]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Affiliates] DROP CONSTRAINT [FK_dnn_Affiliates_dnn_Vendors]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Announcements_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Announcements] DROP CONSTRAINT [FK_dnn_Announcements_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_AnonymousUsers_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_AnonymousUsers] DROP CONSTRAINT [FK_dnn_AnonymousUsers_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Banner_dnn_Vendor]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Banners] DROP CONSTRAINT [FK_dnn_Banner_dnn_Vendor]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Classification_dnn_Classification]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Classification] DROP CONSTRAINT [FK_dnn_Classification_dnn_Classification]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Contacts_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Contacts] DROP CONSTRAINT [FK_dnn_Contacts_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Discussion_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Discussion] DROP CONSTRAINT [FK_dnn_Discussion_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Documents_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Documents] DROP CONSTRAINT [FK_dnn_Documents_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventLog_dnn_EventLogConfig]') AND type = 'F')
ALTER TABLE [dbo].[dnn_EventLog] DROP CONSTRAINT [FK_dnn_EventLog_dnn_EventLogConfig]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventLog_dnn_EventLogTypes]') AND type = 'F')
ALTER TABLE [dbo].[dnn_EventLog] DROP CONSTRAINT [FK_dnn_EventLog_dnn_EventLogTypes]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventLogConfig_dnn_EventLogTypes]') AND type = 'F')
ALTER TABLE [dbo].[dnn_EventLogConfig] DROP CONSTRAINT [FK_dnn_EventLogConfig_dnn_EventLogTypes]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Events_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Events] DROP CONSTRAINT [FK_dnn_Events_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_FAQs_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_FAQs] DROP CONSTRAINT [FK_dnn_FAQs_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Files_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Files] DROP CONSTRAINT [FK_dnn_Files_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_FolderPermission_dnn_Folders]') AND type = 'F')
ALTER TABLE [dbo].[dnn_FolderPermission] DROP CONSTRAINT [FK_dnn_FolderPermission_dnn_Folders]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_FolderPermission_dnn_Permission]') AND type = 'F')
ALTER TABLE [dbo].[dnn_FolderPermission] DROP CONSTRAINT [FK_dnn_FolderPermission_dnn_Permission]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Folders_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Folders] DROP CONSTRAINT [FK_dnn_Folders_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_HtmlText_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_HtmlText] DROP CONSTRAINT [FK_dnn_HtmlText_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__dnn_Links__Modul__7712C489]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Links] DROP CONSTRAINT [FK__dnn_Links__Modul__7712C489]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModuleControls_dnn_ModuleDefinitions]') AND type = 'F')
ALTER TABLE [dbo].[dnn_ModuleControls] DROP CONSTRAINT [FK_dnn_ModuleControls_dnn_ModuleDefinitions]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModuleDefinitions_dnn_DesktopModules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_ModuleDefinitions] DROP CONSTRAINT [FK_dnn_ModuleDefinitions_dnn_DesktopModules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModulePermission_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_ModulePermission] DROP CONSTRAINT [FK_dnn_ModulePermission_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModulePermission_dnn_Permission]') AND type = 'F')
ALTER TABLE [dbo].[dnn_ModulePermission] DROP CONSTRAINT [FK_dnn_ModulePermission_dnn_Permission]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Modules_dnn_ModuleDefinitions]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Modules] DROP CONSTRAINT [FK_dnn_Modules_dnn_ModuleDefinitions]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Modules_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Modules] DROP CONSTRAINT [FK_dnn_Modules_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModuleSettings_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_ModuleSettings] DROP CONSTRAINT [FK_dnn_ModuleSettings_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_PortalAlias_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_PortalAlias] DROP CONSTRAINT [FK_dnn_PortalAlias_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_PortalDesktopModules_dnn_DesktopModules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_PortalDesktopModules] DROP CONSTRAINT [FK_dnn_PortalDesktopModules_dnn_DesktopModules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_PortalDesktopModules_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_PortalDesktopModules] DROP CONSTRAINT [FK_dnn_PortalDesktopModules_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Profile_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Profile] DROP CONSTRAINT [FK_dnn_Profile_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Profile_dnn_Users]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Profile] DROP CONSTRAINT [FK_dnn_Profile_dnn_Users]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Roles_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Roles] DROP CONSTRAINT [FK_dnn_Roles_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ScheduleHistory_dnn_Schedule]') AND type = 'F')
ALTER TABLE [dbo].[dnn_ScheduleHistory] DROP CONSTRAINT [FK_dnn_ScheduleHistory_dnn_Schedule]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ScheduleItemSettings_dnn_Schedule]') AND type = 'F')
ALTER TABLE [dbo].[dnn_ScheduleItemSettings] DROP CONSTRAINT [FK_dnn_ScheduleItemSettings_dnn_Schedule]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SearchItem_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_SearchItem] DROP CONSTRAINT [FK_dnn_SearchItem_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SearchItemWord_dnn_SearchItem]') AND type = 'F')
ALTER TABLE [dbo].[dnn_SearchItemWord] DROP CONSTRAINT [FK_dnn_SearchItemWord_dnn_SearchItem]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SearchItemWord_dnn_SearchWord]') AND type = 'F')
ALTER TABLE [dbo].[dnn_SearchItemWord] DROP CONSTRAINT [FK_dnn_SearchItemWord_dnn_SearchWord]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SearchItemWordPosition_dnn_SearchItemWord]') AND type = 'F')
ALTER TABLE [dbo].[dnn_SearchItemWordPosition] DROP CONSTRAINT [FK_dnn_SearchItemWordPosition_dnn_SearchItemWord]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SiteLog_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_SiteLog] DROP CONSTRAINT [FK_dnn_SiteLog_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Skins_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Skins] DROP CONSTRAINT [FK_dnn_Skins_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SurveyOptions_dnn_Surveys]') AND type = 'F')
ALTER TABLE [dbo].[dnn_SurveyOptions] DROP CONSTRAINT [FK_dnn_SurveyOptions_dnn_Surveys]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Surveys_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Surveys] DROP CONSTRAINT [FK_dnn_Surveys_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SystemMessages_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_SystemMessages] DROP CONSTRAINT [FK_dnn_SystemMessages_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabModules_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_TabModules] DROP CONSTRAINT [FK_dnn_TabModules_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabModules_dnn_Tabs]') AND type = 'F')
ALTER TABLE [dbo].[dnn_TabModules] DROP CONSTRAINT [FK_dnn_TabModules_dnn_Tabs]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabModuleSettings_dnn_TabModules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_TabModuleSettings] DROP CONSTRAINT [FK_dnn_TabModuleSettings_dnn_TabModules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabPermission_dnn_Permission]') AND type = 'F')
ALTER TABLE [dbo].[dnn_TabPermission] DROP CONSTRAINT [FK_dnn_TabPermission_dnn_Permission]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabPermission_dnn_Tabs]') AND type = 'F')
ALTER TABLE [dbo].[dnn_TabPermission] DROP CONSTRAINT [FK_dnn_TabPermission_dnn_Tabs]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Tabs_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Tabs] DROP CONSTRAINT [FK_dnn_Tabs_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Tabs_dnn_Tabs]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Tabs] DROP CONSTRAINT [FK_dnn_Tabs_dnn_Tabs]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UrlLog_dnn_UrlTracking]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UrlLog] DROP CONSTRAINT [FK_dnn_UrlLog_dnn_UrlTracking]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Urls_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Urls] DROP CONSTRAINT [FK_dnn_Urls_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UrlTracking_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UrlTracking] DROP CONSTRAINT [FK_dnn_UrlTracking_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserDefinedData_dnn_UserDefinedFields]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserDefinedData] DROP CONSTRAINT [FK_dnn_UserDefinedData_dnn_UserDefinedFields]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserDefinedData_dnn_UserDefinedRows]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserDefinedData] DROP CONSTRAINT [FK_dnn_UserDefinedData_dnn_UserDefinedRows]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserDefinedFields_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserDefinedFields] DROP CONSTRAINT [FK_dnn_UserDefinedFields_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserDefinedRows_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserDefinedRows] DROP CONSTRAINT [FK_dnn_UserDefinedRows_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserPortals_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserPortals] DROP CONSTRAINT [FK_dnn_UserPortals_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserPortals_dnn_Users]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserPortals] DROP CONSTRAINT [FK_dnn_UserPortals_dnn_Users]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserRoles_dnn_Roles]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserRoles] DROP CONSTRAINT [FK_dnn_UserRoles_dnn_Roles]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserRoles_dnn_Users]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserRoles] DROP CONSTRAINT [FK_dnn_UserRoles_dnn_Users]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UsersOnline_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UsersOnline] DROP CONSTRAINT [FK_dnn_UsersOnline_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UsersOnline_dnn_Users]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UsersOnline] DROP CONSTRAINT [FK_dnn_UsersOnline_dnn_Users]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_VendorClassification_dnn_Classification]') AND type = 'F')
ALTER TABLE [dbo].[dnn_VendorClassification] DROP CONSTRAINT [FK_dnn_VendorClassification_dnn_Classification]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_VendorClassification_dnn_Vendors]') AND type = 'F')
ALTER TABLE [dbo].[dnn_VendorClassification] DROP CONSTRAINT [FK_dnn_VendorClassification_dnn_Vendors]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Vendor_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Vendors] DROP CONSTRAINT [FK_dnn_Vendor_dnn_Portals]
GO
/******* Object: Table [dbo].[dnn_Affiliates] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Affiliates]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Affiliates]
GO
/****** Object: Table [dbo].[dnn_Announcements] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Announcements]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Announcements]
GO
/****** Object: Table [dbo].[dnn_AnonymousUsers] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AnonymousUsers]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_AnonymousUsers]
GO
/****** Object: Table [dbo].[dnn_Banners] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Banners]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Banners]
GO
/****** Object: Table [dbo].[dnn_Classification] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Classification]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Classification]
GO
/****** Object: Table [dbo].[dnn_Contacts] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Contacts]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Contacts]
GO
/****** Object: Table [dbo].[dnn_DesktopModules] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DesktopModules]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_DesktopModules]
GO
/****** Object: Table [dbo].[dnn_Discussion] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Discussion]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Discussion]
GO
/****** Object: Table [dbo].[dnn_Documents] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Documents]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Documents]
GO
/****** Object: Table [dbo].[dnn_EventLog] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventLog]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventLog]
GO
/****** Object: Table [dbo].[dnn_EventLogConfig] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventLogConfig]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventLogConfig]
GO
/****** Object: Table [dbo].[dnn_EventLogTypes] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventLogTypes]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventLogTypes]
GO
--Added 12/2/2007 for 4.4.1
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsCategory_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_EventsCategory] DROP CONSTRAINT [FK_dnn_EventsCategory_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsLocation_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_EventsLocation] DROP CONSTRAINT [FK_dnn_EventsLocation_dnn_Portals]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsMaster_dnn_Modules]') AND type = 'F')
ALTER TABLE [dbo].[dnn_EventsMaster] DROP CONSTRAINT [FK_dnn_EventsMaster_dnn_Modules]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsNotification_dnn_Events]') AND type = 'F')
ALTER TABLE [dbo].[dnn_EventsNotification] DROP CONSTRAINT [FK_dnn_EventsNotification_dnn_Events]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsSignups_dnn_Events]') AND type = 'F')
ALTER TABLE [dbo].[dnn_EventsSignups] DROP CONSTRAINT [FK_dnn_EventsSignups_dnn_Events]
GO
/****** Object: Table [dbo].[dnn_EventsCategory] Script Date: 02/12/2007 15:47:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsCategory]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventsCategory]
GO
/****** Object: Table [dbo].[dnn_EventsLocation] Script Date: 02/12/2007 15:47:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsLocation]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventsLocation]
GO
/****** Object: Table [dbo].[dnn_EventsMaster] Script Date: 02/12/2007 15:47:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsMaster]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventsMaster]
GO
/****** Object: Table [dbo].[dnn_EventsNotification] Script Date: 02/12/2007 15:47:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsNotification]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventsNotification]
GO
/****** Object: Table [dbo].[dnn_EventsPPErrorLog] Script Date: 02/12/2007 15:47:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsPPErrorLog]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventsPPErrorLog]
GO
/****** Object: Table [dbo].[dnn_EventsSignups] Script Date: 02/12/2007 15:47:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsSignups]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_EventsSignups]
--Added 12/2/2007 for 4.4.1 end
/****** Object: Table [dbo].[dnn_Events] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Events]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Events]
GO
/****** Object: Table [dbo].[dnn_FAQs] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_FAQs]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_FAQs]
GO
/****** Object: Table [dbo].[dnn_Files] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Files]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Files]
GO
/****** Object: Table [dbo].[dnn_FolderPermission] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_FolderPermission]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_FolderPermission]
GO
/****** Object: Table [dbo].[dnn_Folders] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Folders]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Folders]
GO
/****** Object: Table [dbo].[dnn_HostSettings] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_HostSettings]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_HostSettings]
GO
/****** Object: Table [dbo].[dnn_HtmlText] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_HtmlText]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_HtmlText]
GO
/****** Object: Table [dbo].[dnn_Links] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Links]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Links]
GO
/****** Object: Table [dbo].[dnn_Lists] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Lists]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Lists]
GO
/****** Object: Table [dbo].[dnn_ModuleControls] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ModuleControls]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_ModuleControls]
GO
/****** Object: Table [dbo].[dnn_ModuleDefinitions] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ModuleDefinitions]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_ModuleDefinitions]
GO
/****** Object: Table [dbo].[dnn_ModulePermission] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ModulePermission]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_ModulePermission]
GO
/****** Object: Table [dbo].[dnn_Modules] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Modules]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Modules]
GO
/****** Object: Table [dbo].[dnn_ModuleSettings] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ModuleSettings]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_ModuleSettings]
GO
/****** Object: Table [dbo].[dnn_Permission] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Permission]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Permission]
GO
/****** Object: Table [dbo].[dnn_PortalAlias] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_PortalAlias]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_PortalAlias]
GO
/****** Object: Table [dbo].[dnn_PortalDesktopModules] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_PortalDesktopModules]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_PortalDesktopModules]
GO
--MNF 12/2/2007 begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_Addresses_dnn_Store_Customers]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Store_Addresses] DROP CONSTRAINT [FK_dnn_Store_Addresses_dnn_Store_Customers]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_CartItems_dnn_Store_Cart]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Store_CartItems] DROP CONSTRAINT [FK_dnn_Store_CartItems_dnn_Store_Cart]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_CartItems_dnn_Store_Products]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Store_CartItems] DROP CONSTRAINT [FK_dnn_Store_CartItems_dnn_Store_Products]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_OrderDetails_dnn_Store_Orders]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Store_OrderDetails] DROP CONSTRAINT [FK_dnn_Store_OrderDetails_dnn_Store_Orders]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_Products_dnn_Store_Categories]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Store_Products] DROP CONSTRAINT [FK_dnn_Store_Products_dnn_Store_Categories]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_Reviews_dnn_Store_Products]') AND type = 'F')
ALTER TABLE [dbo].[dnn_Store_Reviews] DROP CONSTRAINT [FK_dnn_Store_Reviews_dnn_Store_Products]
GO
/****** Object: Table [dbo].[dnn_Store_Addresses] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Addresses]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_Addresses]
GO
/****** Object: Table [dbo].[dnn_Store_Administration] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Administration]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_Administration]
GO
/****** Object: Table [dbo].[dnn_Store_Cart] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Cart]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_Cart]
GO
/****** Object: Table [dbo].[dnn_Store_CartItems] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_CartItems]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_CartItems]
GO
/****** Object: Table [dbo].[dnn_Store_Categories] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Categories]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_Categories]
GO
/****** Object: Table [dbo].[dnn_Store_OrderDetails] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_OrderDetails]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_OrderDetails]
GO
/****** Object: Table [dbo].[dnn_Store_Orders] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Orders]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_Orders]
GO
/****** Object: Table [dbo].[dnn_Store_Products] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Products]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_Products]
GO
/****** Object: Table [dbo].[dnn_Store_Reviews] Script Date: 02/12/2007 15:55:28 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Reviews]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Store_Reviews]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserProfile_dnn_ProfilePropertyDefinition]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserProfile] DROP CONSTRAINT [FK_dnn_UserProfile_dnn_ProfilePropertyDefinition]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserProfile_dnn_Users]') AND type = 'F')
ALTER TABLE [dbo].[dnn_UserProfile] DROP CONSTRAINT [FK_dnn_UserProfile_dnn_Users]
GO
/****** Object: Table [dbo].[dnn_UserProfile] Script Date: 02/12/2007 15:56:51 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserProfile]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UserProfile]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ProfilePropertyDefinition_dnn_Portals]') AND type = 'F')
ALTER TABLE [dbo].[dnn_ProfilePropertyDefinition] DROP CONSTRAINT [FK_dnn_ProfilePropertyDefinition_dnn_Portals]
GO
/****** Object: Table [dbo].[dnn_ProfilePropertyDefinition] Script Date: 02/12/2007 16:32:12 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ProfilePropertyDefinition]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_ProfilePropertyDefinition]
GO
/****** Object: Table [dbo].[dnn_RoleGroups] Script Date: 02/12/2007 16:32:12 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_RoleGroups]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_RoleGroups]
GO
--MNF 12/2/2007 end
/****** Object: Table [dbo].[dnn_Portals] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Portals]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Portals]
GO
/****** Object: Table [dbo].[dnn_Profile] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Profile]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Profile]
GO
/****** Object: Table [dbo].[dnn_Roles] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Roles]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Roles]
GO
/****** Object: Table [dbo].[dnn_Schedule] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Schedule]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Schedule]
GO
/****** Object: Table [dbo].[dnn_ScheduleHistory] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ScheduleHistory]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_ScheduleHistory]
GO
/****** Object: Table [dbo].[dnn_ScheduleItemSettings] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ScheduleItemSettings]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_ScheduleItemSettings]
GO
/****** Object: Table [dbo].[dnn_SearchCommonWords] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchCommonWords]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SearchCommonWords]
GO
/****** Object: Table [dbo].[dnn_SearchIndexer] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchIndexer]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SearchIndexer]
GO
/****** Object: Table [dbo].[dnn_SearchItem] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchItem]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SearchItem]
GO
/****** Object: Table [dbo].[dnn_SearchItemWord] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchItemWord]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SearchItemWord]
GO
/****** Object: Table [dbo].[dnn_SearchItemWordPosition] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchItemWordPosition]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SearchItemWordPosition]
GO
/****** Object: Table [dbo].[dnn_SearchWord] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchWord]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SearchWord]
GO
/****** Object: Table [dbo].[dnn_SiteLog] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SiteLog]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SiteLog]
GO
/****** Object: Table [dbo].[dnn_Skins] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Skins]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Skins]
GO
/****** Object: Table [dbo].[dnn_SurveyOptions] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SurveyOptions]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SurveyOptions]
GO
/****** Object: Table [dbo].[dnn_Surveys] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Surveys]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Surveys]
GO
/****** Object: Table [dbo].[dnn_SystemMessages] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SystemMessages]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_SystemMessages]
GO
/****** Object: Table [dbo].[dnn_TabModules] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_TabModules]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_TabModules]
GO
/****** Object: Table [dbo].[dnn_TabModuleSettings] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_TabModuleSettings]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_TabModuleSettings]
GO
/****** Object: Table [dbo].[dnn_TabPermission] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_TabPermission]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_TabPermission]
GO
/****** Object: Table [dbo].[dnn_Tabs] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Tabs]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Tabs]
GO
/****** Object: Table [dbo].[dnn_UrlLog] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UrlLog]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UrlLog]
GO
/****** Object: Table [dbo].[dnn_Urls] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Urls]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Urls]
GO
/****** Object: Table [dbo].[dnn_UrlTracking] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UrlTracking]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UrlTracking]
GO
/****** Object: Table [dbo].[dnn_UserDefinedData] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserDefinedData]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UserDefinedData]
GO
/****** Object: Table [dbo].[dnn_UserDefinedFields] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserDefinedFields]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UserDefinedFields]
GO
/****** Object: Table [dbo].[dnn_UserDefinedRows] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserDefinedRows]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UserDefinedRows]
GO
/****** Object: Table [dbo].[dnn_UserPortals] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserPortals]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UserPortals]
GO
/****** Object: Table [dbo].[dnn_UserRoles] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserRoles]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UserRoles]
GO
/****** Object: Table [dbo].[dnn_Users] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Users]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Users]
GO
/****** Object: Table [dbo].[dnn_UsersOnline] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UsersOnline]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_UsersOnline]
GO
/****** Object: Table [dbo].[dnn_VendorClassification] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_VendorClassification]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_VendorClassification]
GO
/****** Object: Table [dbo].[dnn_Vendors] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Vendors]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Vendors]
GO
/****** Object: Table [dbo].[dnn_Version] Script Date: 06/22/2006 12:48:44 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Version]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[dnn_Version]
/****** Object: StoredProcedure [dbo].[dnn_AddAffiliate] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddAffiliate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddAffiliate]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddAnnouncement] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddAnnouncement]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddAnnouncement]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddBanner] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddBanner]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddBanner]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddContact] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddContact]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddContact]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddDesktopModule] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddDesktopModule]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddDocument] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddDocument]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddDocument]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddEvent] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddEvent]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddEventLog] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddEventLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddEventLog]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddEventLogConfig] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddEventLogConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddEventLogConfig]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddEventLogType] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddEventLogType]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddEventLogType]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddFAQ] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddFAQ]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddFAQ]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddFile] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddFile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddFile]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddFolder] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddFolder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddFolder]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddFolderPermission] Script Date: 06/22/2006 12:53:14 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddFolderPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddFolderPermission]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddHostSetting] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddHostSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddHostSetting]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddHtmlText] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddHtmlText]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddHtmlText]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddLink] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddLink]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddLink]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddListEntry] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddListEntry]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddListEntry]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddMessage] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddMessage]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddModule] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddModule]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddModuleControl] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModuleControl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddModuleControl]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddModuleDefinition] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModuleDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddModuleDefinition]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddModulePermission] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModulePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddModulePermission]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddModuleSetting] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddModuleSetting]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddPermission] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddPermission]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddPortalAlias] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddPortalAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddPortalAlias]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddPortalDesktopModule] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddPortalDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddPortalDesktopModule]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddPortalInfo] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddPortalInfo]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddPortalInfo]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddProfile] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddProfile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddProfile]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddRole] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddRole]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSchedule] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSchedule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSchedule]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddScheduleHistory] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddScheduleHistory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddScheduleHistory]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSearchCommonWord] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchCommonWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSearchCommonWord]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSearchItem] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSearchItem]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSearchItemWord] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSearchItemWord]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSearchItemWordPosition] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSearchItemWordPosition]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSearchWord] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSearchWord]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSiteLog] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSiteLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSiteLog]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSkin] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSkin]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSkin]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSurvey] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSurvey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSurvey]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSurveyOption] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSurveyOption]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSurveyOption]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSurveyResult] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSurveyResult]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSurveyResult]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddSystemMessage] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSystemMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddSystemMessage]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddTab] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddTab]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddTabModule] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddTabModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddTabModule]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddTabModuleSetting] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddTabModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddTabModuleSetting]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddTabPermission] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddTabPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddTabPermission]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddUrl] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUrl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddUrl]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddUrlLog] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUrlLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddUrlLog]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddUrlTracking] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUrlTracking]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddUrlTracking]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddUser] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddUser]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddUserDefinedData] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUserDefinedData]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddUserDefinedData]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddUserDefinedField] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUserDefinedField]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddUserDefinedField]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddUserDefinedRow] Script Date: 06/22/2006 12:53:15 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUserDefinedRow]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddUserDefinedRow]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddUserRole] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUserRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddUserRole]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddVendor] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddVendor]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddVendor]
GO
/****** Object: StoredProcedure [dbo].[dnn_AddVendorClassification] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddVendorClassification]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_AddVendorClassification]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteAffiliate] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteAffiliate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteAffiliate]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteAnnouncement] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteAnnouncement]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteAnnouncement]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteBanner] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteBanner]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteBanner]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteContact] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteContact]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteContact]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteDesktopModule] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteDesktopModule]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteDocument] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteDocument]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteDocument]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteEvent] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteEvent]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteEventLog] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteEventLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteEventLog]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteEventLogConfig] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteEventLogConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteEventLogConfig]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteEventLogType] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteEventLogType]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteEventLogType]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteFAQ] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFAQ]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteFAQ]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteFile] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteFile]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteFiles] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteFiles]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteFolder] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFolder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteFolder]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteFolderPermission] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFolderPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteFolderPermission]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteFolderPermissionsByFolderPath] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFolderPermissionsByFolderPath]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteFolderPermissionsByFolderPath]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteLink] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteLink]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteLink]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteList] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteList]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteList]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteListEntryByID] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteListEntryByID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteListEntryByID]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteMessage] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteMessage]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteModule] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteModule]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteModuleControl] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModuleControl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteModuleControl]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteModuleDefinition] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModuleDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteModuleDefinition]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteModulePermission] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModulePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteModulePermission]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteModulePermissionsByModuleID] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModulePermissionsByModuleID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteModulePermissionsByModuleID]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteModuleSetting] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteModuleSetting]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteModuleSettings] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModuleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteModuleSettings]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeletePermission] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeletePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeletePermission]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeletePortalAlias] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeletePortalAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeletePortalAlias]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeletePortalDesktopModules] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeletePortalDesktopModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeletePortalDesktopModules]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeletePortalInfo] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeletePortalInfo]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeletePortalInfo]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteRole] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteRole]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSchedule] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSchedule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSchedule]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSearchCommonWord] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchCommonWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSearchCommonWord]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSearchItem] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSearchItem]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSearchItems] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItems]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSearchItems]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSearchItemWord] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSearchItemWord]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSearchItemWordPosition] Script Date: 06/22/2006 12:53:16 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSearchItemWordPosition]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSearchItemWords] Script Date: 06/22/2006 12:53:17 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItemWords]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSearchItemWords]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSearchWord] Script Date: 06/22/2006 12:53:17 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSearchWord]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSiteLog] Script Date: 06/22/2006 12:53:17 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSiteLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[dnn_DeleteSiteLog]
GO
/****** Object: StoredProcedure [dbo].[dnn_DeleteSkin] Script Date: 06/22/2006 12:53:17 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id