<< Change NullValue behavior for generated Typed Datasets in Visual Studio 2005. | Home | DotNetNuke NavigateURL() returns FriendlyUrls, which is not always suitable. >>

Uninstall DotNetNuke SQL database changes

I wanted to delete DotNetNuke related tables from my database, which were created during accidental instalation of DotNetNuke.(I accidentally provide connection to the wrong database) and decided to use UnInstall.SqlDataProvider script file from Providers\DataProviders\SqlDataProvider DNN 4.0.2 installation.

However there were a lot of errors when running the script, like the following

Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.dnn_Announcements' because this table does not exist in database 'FILMSDSQL'.
Server: Msg 3728, Level 16, State 1, Line 1
'FK_dnn_Links_dnn_Modules' is not a constraint.
Server: Msg 3727, Level 16, State 1, Line 1
Could not drop constraint. See previous errors.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.dnn_Discussion' because this table does not exist in database 'FILMSDSQL'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.dnn_Events' because this table does not exist in database 'FILMSDSQL'.
.....

There were also  a few objects that I had to delete manually using Enterprise Manager (They probably were created by individual modules).

So I've re-generate the DROP script using SQL Management Studio to delete DNN tables and Stored Procedures.Additionally I had to delete ASPNET_ membership tables,Views and SPs (see SQL script below) .
Update: I've updated the SQL with th 4.4.1 new tables and also raised DNN issue to make UnInstall.SqlDataProvider.sql up-to-date.

/************************************************************/

/*****           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 = OBJECT_ID(N'[dbo].[dnn_DeleteSkin]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSkin]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSurvey]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSurvey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSurvey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSurveyOption]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSurveyOption]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSurveyOption]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSystemMessage]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSystemMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSystemMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTab]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTab]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabModule]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabModuleSetting]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabModuleSettings]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabModuleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabModuleSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabPermission]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabPermissionsByTabID]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabPermissionsByTabID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabPermissionsByTabID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUrl]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUrl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUrl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUrlTracking]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUrlTracking]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUrlTracking]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUser]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserDefinedData]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserDefinedData]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserDefinedData]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserDefinedField]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserDefinedField]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserDefinedField]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserDefinedRow]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserDefinedRow]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserDefinedRow]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserPortal]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserRole]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUsersOnline]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUsersOnline]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUsersOnline]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteVendor]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteVendor]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteVendor]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteVendorClassifications]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteVendorClassifications]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteVendorClassifications]

GO

/****** Object:  StoredProcedure [dbo].[dnn_FindBanners]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_FindBanners]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_FindBanners]

GO

/****** Object:  StoredProcedure [dbo].[dnn_FindDatabaseVersion]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_FindDatabaseVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_FindDatabaseVersion]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAffiliate]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAffiliate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAffiliate]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAffiliates]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAffiliates]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAffiliates]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllFiles]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllFiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllFiles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllModules]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllProfiles]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllProfiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllProfiles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllTabs]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllTabs]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllTabs]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllTabsModules]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllTabsModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllTabsModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAnnouncement]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAnnouncement]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAnnouncement]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAnnouncements]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAnnouncements]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAnnouncements]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetBanner]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetBanner]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetBanner]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetBanners]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetBanners]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetBanners]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetContact]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetContact]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetContact]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetContacts]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetContacts]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetContacts]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetCurrencies]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetCurrencies]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetCurrencies]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDatabaseVersion]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDatabaseVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDatabaseVersion]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDefaultLanguageByModule]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDefaultLanguageByModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDefaultLanguageByModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModule]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModuleByFriendlyName]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModuleByFriendlyName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModuleByFriendlyName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModuleByModuleName]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModuleByModuleName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModuleByModuleName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModules]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModulesByPortal]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModulesByPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModulesByPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDocument]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDocument]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDocument]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDocuments]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDocuments]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDocuments]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEvent]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEvent]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLog]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogByLogGUID]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogByLogGUID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogByLogGUID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogConfig]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogConfig]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogPendingNotif]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogPendingNotif]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogPendingNotif]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogPendingNotifConfig]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogPendingNotifConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogPendingNotifConfig]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogType]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogType]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogType]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEvents]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEvents]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEvents]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventsByDate]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventsByDate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventsByDate]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFAQ]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFAQ]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFAQ]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFAQs]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFAQs]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFAQs]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFile]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFileById]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFileById]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFileById]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFiles]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFiles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFolderPermission]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFolderPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFolderPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFolderPermissionsByFolderPath]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFolderPermissionsByFolderPath]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFolderPermissionsByFolderPath]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFolders]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFolders]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFolders]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetHostSetting]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetHostSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetHostSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetHostSettings]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetHostSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetHostSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetHtmlText]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetHtmlText]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetHtmlText]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetLink]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetLink]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetLink]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetLinks]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetLinks]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetLinks]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetList]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetList]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetList]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetListEntries]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetListEntries]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetListEntries]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetMessage]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetMessageByParentId]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetMessageByParentId]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetMessageByParentId]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModule]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleByDefinition]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleByDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleByDefinition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleControl]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleControl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleControl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleControlByKeyAndSrc]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleControlByKeyAndSrc]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleControlByKeyAndSrc]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleControls]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleControls]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleControls]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleControlsByKey]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleControlsByKey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleControlsByKey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleDefinition]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleDefinition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleDefinitionByName]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleDefinitionByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleDefinitionByName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleDefinitions]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleDefinitions]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleDefinitions]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModulePermission]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModulePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModulePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModulePermissionsByModuleID]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModulePermissionsByModuleID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModulePermissionsByModuleID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModulePermissionsByPortal]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModulePermissionsByPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModulePermissionsByPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModules]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleSetting]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleSettings]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetOnlineUsers]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetOnlineUsers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetOnlineUsers]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetOnlineUserStatistics]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetOnlineUserStatistics]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetOnlineUserStatistics]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermission]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermissionByCodeAndKey]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermissionByCodeAndKey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermissionByCodeAndKey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermissionsByFolderPath]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermissionsByFolderPath]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermissionsByFolderPath]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermissionsByModuleID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermissionsByModuleID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermissionsByModuleID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermissionsByTabID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermissionsByTabID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermissionsByTabID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortal]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalAlias]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalAlias]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalAliasByPortalAliasID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalAliasByPortalAliasID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalAliasByPortalAliasID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalAliasByPortalID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalAliasByPortalID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalAliasByPortalID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalByAlias]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalByAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalByAlias]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalByPortalAliasID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalByPortalAliasID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalByPortalAliasID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalByTab]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalByTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalByTab]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalDesktopModules]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalDesktopModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalDesktopModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalRoles]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalRoles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalRoles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortals]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortals]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortals]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalSpaceUsed]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalSpaceUsed]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalSpaceUsed]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalTabModules]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalTabModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalTabModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetProfile]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetProfile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetProfile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetRole]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetRoleByName]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetRoleByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetRoleByName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetRoles]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetRoles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetRoles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetRolesByUser]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetRolesByUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetRolesByUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSchedule]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSchedule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSchedule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleByEvent]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleByEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleByEvent]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleByScheduleID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleByScheduleID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleByScheduleID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleByTypeFullName]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleByTypeFullName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleByTypeFullName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleHistory]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleHistory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleHistory]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleItemSettings]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleItemSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleItemSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleNextTask]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleNextTask]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleNextTask]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchCommonWordByID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchCommonWordByID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchCommonWordByID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchCommonWordsByLocale]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchCommonWordsByLocale]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchCommonWordsByLocale]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchIndexers]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchIndexers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchIndexers]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItem]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItems]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItems]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItems]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWord]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWordBySearchItem]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWordBySearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWordBySearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWordBySearchWord]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWordBySearchWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWordBySearchWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWordPosition]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWordPosition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWordPositionBySearchItemWord]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWordPositionBySearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWordPositionBySearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchModules]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchResultModules]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchResultModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchResultModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchResults]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchResults]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchResults]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchSettings]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchWordByID]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchWordByID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchWordByID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchWords]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchWords]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchWords]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetServices]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetServices]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetServices]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog1]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog1]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog1]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog12]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog12]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog12]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog2]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog2]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog2]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog3]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog3]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog3]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog4]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog4]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog4]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog5]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog5]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog5]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog6]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog6]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog6]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog7]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog7]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog7]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog8]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog8]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog8]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog9]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog9]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog9]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSkin]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSkin]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSkin]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSuperUsers]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSuperUsers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSuperUsers]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSurvey]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSurvey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSurvey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSurveyOptions]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSurveyOptions]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSurveyOptions]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSurveys]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSurveys]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSurveys]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSystemMessage]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSystemMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSystemMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSystemMessages]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSystemMessages]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSystemMessages]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTab]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTab]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabByName]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabByName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTables]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTables]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTables]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabModuleOrder]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabModuleOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabModuleOrder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabModuleSetting]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabModuleSettings]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabModuleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabModuleSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabPanes]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabPanes]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabPanes]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabPermission]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabPermissionsByPortal]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabPermissionsByPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabPermissionsByPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabPermissionsByTabID]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabPermissionsByTabID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabPermissionsByTabID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabs]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabs]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabs]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabsByParentId]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabsByParentId]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabsByParentId]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetThreadMessages]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetThreadMessages]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetThreadMessages]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTopLevelMessages]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTopLevelMessages]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTopLevelMessages]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUrl]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUrl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUrl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUrlLog]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUrlLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUrlLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUrls]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUrls]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUrls]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUrlTracking]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUrlTracking]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUrlTracking]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUser]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserByUsername]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserByUsername]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserByUsername]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedData]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedData]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedData]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedField]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedField]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedField]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedFields]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedFields]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedFields]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedRow]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedRow]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedRow]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedRows]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedRows]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedRows]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserRole]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserRolesByUsername]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserRolesByUsername]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserRolesByUsername]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUsers]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUsers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUsers]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendor]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendor]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendor]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendorClassifications]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendorClassifications]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendorClassifications]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendors]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendors]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendors]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendorsByEmail]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendorsByEmail]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendorsByEmail]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendorsByName]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendorsByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendorsByName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_IsUserInRole]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_IsUserInRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_IsUserInRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_ListSearchItem]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ListSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_ListSearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_ListSearchItemWord]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ListSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_ListSearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_ListSearchItemWordPosition]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ListSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_ListSearchItemWordPosition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_PurgeEventLog]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_PurgeEventLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_PurgeEventLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_PurgeScheduleHistory]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_PurgeScheduleHistory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_PurgeScheduleHistory]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateAffiliate]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateAffiliate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateAffiliate]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateAffiliateStats]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateAffiliateStats]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateAffiliateStats]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateAnnouncement]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateAnnouncement]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateAnnouncement]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateAnonymousUser]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateAnonymousUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateAnonymousUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateBanner]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateBanner]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateBanner]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateBannerClickThrough]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateBannerClickThrough]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateBannerClickThrough]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateBannerViews]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateBannerViews]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateBannerViews]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateContact]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateContact]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateContact]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateDatabaseVersion]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateDatabaseVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateDatabaseVersion]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateDesktopModule]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateDesktopModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateDocument]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateDocument]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateDocument]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateEvent]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateEvent]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateEventLogConfig]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateEventLogConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateEventLogConfig]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateEventLogPendingNotif]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateEventLogPendingNotif]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateEventLogPendingNotif]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateEventLogType]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateEventLogType]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateEventLogType]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateFAQ]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateFAQ]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateFAQ]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateFile]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateFile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateFile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateFolder]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateFolder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateFolder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateFolderPermission]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateFolderPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateFolderPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateHostSetting]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateHostSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateHostSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateHtmlText]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateHtmlText]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateHtmlText]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateLink]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateLink]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateLink]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateListEntry]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateListEntry]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateListEntry]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateListSortOrder]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateListSortOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateListSortOrder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateMessage]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModule]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModuleControl]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModuleControl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModuleControl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModuleDefinition]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModuleDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModuleDefinition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModuleOrder]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModuleOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModuleOrder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModulePermission]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModulePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModulePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModuleSetting]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateOnlineUser]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateOnlineUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateOnlineUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePermission]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePortalAlias]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePortalAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePortalAlias]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePortalAliasOnInstall]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePortalAliasOnInstall]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePortalAliasOnInstall]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePortalInfo]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePortalInfo]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePortalInfo]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePortalSetup]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePortalSetup]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePortalSetup]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateProfile]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateProfile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateProfile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateRole]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSchedule]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSchedule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSchedule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateScheduleHistory]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateScheduleHistory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateScheduleHistory]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchCommonWord]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchCommonWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchCommonWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchItem]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchItemWord]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchItemWordPosition]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchItemWordPosition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchWord]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSurvey]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSurvey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSurvey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSurveyOption]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSurveyOption]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSurveyOption]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSystemMessage]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSystemMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSystemMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateTab]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateTab]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateTabModule]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateTabModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateTabModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateTabModuleSetting]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateTabModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateTabModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateTabOrder]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateTabOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateTabOrder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateTabPermission]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateTabPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateTabPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateUrlTracking]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateUrlTracking]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateUrlTracking]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateUrlTrackingStats]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateUrlTrackingStats]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateUrlTrackingStats]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateUser]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateUserDefinedData]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateUserDefinedData]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateUserDefinedData]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateUserDefinedField]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateUserDefinedField]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateUserDefinedField]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateUserDefinedFieldOrder]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateUserDefinedFieldOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateUserDefinedFieldOrder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateUserRole]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateUserRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateUserRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateVendor]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateVendor]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateVendor]

GO

/****** Object:  StoredProcedure [dbo].[dnn_User_SetSuperUser]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_User_SetSuperUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_User_SetSuperUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_VerifyPortal]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_VerifyPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_VerifyPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_VerifyPortalTab]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_VerifyPortalTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_VerifyPortalTab]

 

/** Remove AspNet Data **/

 

/** Delete Profile **/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Profile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

      DELETE      dbo.aspnet_Profile

      FROM  dbo.aspnet_Applications

                  INNER JOIN dbo.aspnet_Users ON dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId

                  INNER JOIN dbo.aspnet_Profile ON dbo.aspnet_Users.UserId = dbo.aspnet_Profile.UserId

      WHERE   (dbo.aspnet_Applications.ApplicationName LIKE N'dnn_%')

GO

 

/** Delete Membership **/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Membership]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

DELETE      dbo.aspnet_Membership

FROM    dbo.aspnet_Applications

            INNER JOIN dbo.aspnet_Membership ON dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Membership.ApplicationId

WHERE     (dbo.aspnet_Applications.ApplicationName LIKE N'dnn_%')

GO

 

/** Delete UsersInRoles **/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_UsersInRoles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

      DELETE      dbo.aspnet_UsersInRoles

      FROM    dbo.aspnet_Applications

                  INNER JOIN dbo.aspnet_Users ON dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId

                  INNER JOIN dbo.aspnet_UsersInRoles ON dbo.aspnet_Users.UserId = dbo.aspnet_UsersInRoles.UserId

      WHERE   (dbo.aspnet_Applications.ApplicationName LIKE N'dnn_%')

GO

 

/** Delete Users **/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

 and exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Applications]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

      DELETE      dbo.aspnet_Users

      FROM    dbo.aspnet_Applications

                  INNER JOIN dbo.aspnet_Users ON dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Users.ApplicationId

      WHERE   (dbo.aspnet_Applications.ApplicationName LIKE N'dnn_%')

GO

 

/** Delete Roles **/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Roles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

 and exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Applications]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

      DELETE      dbo.aspnet_Roles

      FROM    dbo.aspnet_Applications

                  INNER JOIN dbo.aspnet_Roles ON dbo.aspnet_Applications.ApplicationId = dbo.aspnet_Roles.ApplicationId

      WHERE   (dbo.aspnet_Applications.ApplicationName LIKE N'dnn_%')

GO

 

/** Delete Applications **/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Applications]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

      DELETE      dbo.aspnet_Applications

      WHERE   (ApplicationName LIKE N'dnn_%')

GO

 

/************************************************************/

/*****              SqlDataProvider                     *****/

/************************************************************/

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_dnn_EventLog_dnn_EventLogConfig]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

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 OBJECTPROPERTY(id, N'IsForeignKey') = 1)

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 OBJECTPROPERTY(id, N'IsForeignKey') = 1)

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_Surveys_dnn_Modules]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

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].[dnn_EventLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[dnn_EventLog]

GO

 

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

 

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

 

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:  View [dbo].[vw_aspnet_Applications]    Script Date: 05/02/2006 11:42:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_Applications]') AND OBJECTPROPERTY(id, N'IsView') = 1)

DROP VIEW [dbo].[vw_aspnet_Applications]

GO

/****** Object:  View [dbo].[vw_aspnet_MembershipUsers]    Script Date: 05/02/2006 11:42:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_MembershipUsers]') AND OBJECTPROPERTY(id, N'IsView') = 1)

DROP VIEW [dbo].[vw_aspnet_MembershipUsers]

GO

/****** Object:  View [dbo].[vw_aspnet_Profiles]    Script Date: 05/02/2006 11:42:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_Profiles]') AND OBJECTPROPERTY(id, N'IsView') = 1)

DROP VIEW [dbo].[vw_aspnet_Profiles]

GO

/****** Object:  View [dbo].[vw_aspnet_Roles]    Script Date: 05/02/2006 11:42:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_Roles]') AND OBJECTPROPERTY(id, N'IsView') = 1)

DROP VIEW [dbo].[vw_aspnet_Roles]

GO

/****** Object:  View [dbo].[vw_aspnet_Users]    Script Date: 05/02/2006 11:42:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_Users]') AND OBJECTPROPERTY(id, N'IsView') = 1)

DROP VIEW [dbo].[vw_aspnet_Users]

GO

/****** Object:  View [dbo].[vw_aspnet_UsersInRoles]    Script Date: 05/02/2006 11:42:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[vw_aspnet_UsersInRoles]') AND OBJECTPROPERTY(id, N'IsView') = 1)

DROP VIEW [dbo].[vw_aspnet_UsersInRoles]

 

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Me__Appli__676E2C41]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT FK__aspnet_Me__Appli__676E2C41

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Ro__Appli__06E6D79A]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT FK__aspnet_Ro__Appli__06E6D79A

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Us__Appli__5737C478]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT FK__aspnet_Us__Appli__5737C478

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Us__RoleI__0BAB8CB7]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT FK__aspnet_Us__RoleI__0BAB8CB7

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Me__UserI__6862507A]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT FK__aspnet_Me__UserI__6862507A

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Pr__UserI__7D5D6D60]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[aspnet_Profile] DROP CONSTRAINT FK__aspnet_Pr__UserI__7D5D6D60

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__aspnet_Us__UserI__0AB7687E]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT FK__aspnet_Us__UserI__0AB7687E

GO

 

--31/7/2006 drop UsersInRoles before [aspnet_Roles] and [aspnet_Users]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_UsersInRoles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[aspnet_UsersInRoles]

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Membership]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[aspnet_Membership]

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Profile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[aspnet_Profile]

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Roles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[aspnet_Roles]

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_SchemaVersions]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[aspnet_SchemaVersions]

GO

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[aspnet_Users]

GO

 

--drop [aspnet_Applications] after [aspnet_Users] and [aspnet_Roles]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[aspnet_Applications]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[aspnet_Applications]

GO

 

 

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

drop procedure [dbo].[dnn_DeleteSurvey]

GO

 

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

drop procedure [dbo].[dnn_DeleteSurveyOption]

GO

 

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

drop procedure [dbo].[dnn_DeleteTabModuleSetting]

GO

 

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

drop procedure [dbo].[dnn_DeleteTabModuleSettings]

GO

 

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

drop procedure [dbo].[dnn_DeleteUserPortal]

GO

 

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

drop procedure [dbo].[dnn_GetAllFiles]

GO

 

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

drop procedure [dbo].[dnn_GetEventLog]

GO

 

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

drop procedure [dbo].[dnn_GetEventLogByLogGUID]

GO

 

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

drop procedure [dbo].[dnn_GetEventLogConfig]

GO

 

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

drop procedure [dbo].[dnn_GetEventLogPendingNotif]

GO

 

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

drop procedure [dbo].[dnn_GetEventLogPendingNotifConfig]

GO

 

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

drop procedure [dbo].[dnn_GetEventLogType]

GO

 

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

drop procedure [dbo].[dnn_GetOnlineUserStatistics]

GO

 

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

drop procedure [dbo].[dnn_GetOnlineUsers]

GO

 

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

drop procedure [dbo].[dnn_GetSurvey]

GO

 

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

drop procedure [dbo].[dnn_GetSurveyOptions]

GO

 

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

drop procedure [dbo].[dnn_GetSurveys]

GO

 

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

drop procedure [dbo].[dnn_GetVendorsByEmail]

GO

 

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

drop procedure [dbo].[dnn_GetVendorsByName]

GO

 

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

drop procedure [dbo].[dnn_PurgeEventLog]

GO

 

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

drop procedure [dbo].[dnn_UpdateEventLogConfig]

GO

 

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

drop procedure [dbo].[dnn_UpdateEventLogPendingNotif]

GO

 

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

drop procedure [dbo].[dnn_UpdateEventLogType]

GO

 

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

drop procedure [dbo].[dnn_UpdateSurvey]

GO

 

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

drop procedure [dbo].[dnn_UpdateSurveyOption]

GO

 

 

 

 

 

 

 

 

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

drop procedure [dbo].[aspnet_AnyDataInTables]

GO

 

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

drop procedure [dbo].[aspnet_Applications_CreateApplication]

GO

 

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

drop procedure [dbo].[aspnet_CheckSchemaVersion]

GO

 

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

drop procedure [dbo].[aspnet_GetUtcDate]

GO

 

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

drop procedure [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]

GO

 

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

drop procedure [dbo].[aspnet_Membership_CreateUser]

GO

 

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

drop procedure [dbo].[aspnet_Membership_FindUsersByEmail]

GO

 

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

drop procedure [dbo].[aspnet_Membership_FindUsersByName]

GO

 

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

drop procedure [dbo].[aspnet_Membership_GetAllUsers]

GO

 

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

drop procedure [dbo].[aspnet_Membership_GetNumberOfUsersOnline]

GO

 

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

drop procedure [dbo].[aspnet_Membership_GetPassword]

GO

 

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

drop procedure [dbo].[aspnet_Membership_GetPasswordWithFormat]

GO

 

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

drop procedure [dbo].[aspnet_Membership_GetUserByEmail]

GO

 

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

drop procedure [dbo].[aspnet_Membership_GetUserByName]

GO

 

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

drop procedure [dbo].[aspnet_Membership_GetUserByUserId]

GO

 

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

drop procedure [dbo].[aspnet_Membership_ResetPassword]

GO

 

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

drop procedure [dbo].[aspnet_Membership_SetPassword]

GO

 

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

drop procedure [dbo].[aspnet_Membership_UnlockUser]

GO

 

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

drop procedure [dbo].[aspnet_Membership_UpdateLastLoginAndActivityDates]

GO

 

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

drop procedure [dbo].[aspnet_Membership_UpdateUser]

GO

 

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

drop procedure [dbo].[aspnet_Membership_UpdateUserInfo]

GO

 

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

drop procedure [dbo].[aspnet_Profile_DeleteInactiveProfiles]

GO

 

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

drop procedure [dbo].[aspnet_Profile_DeleteProfiles]

GO

 

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

drop procedure [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]

GO

 

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

drop procedure [dbo].[aspnet_Profile_GetProfiles]

GO

 

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

drop procedure [dbo].[aspnet_Profile_GetProperties]

GO

 

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

drop procedure [dbo].[aspnet_Profile_SetProperties]

GO

 

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

drop procedure [dbo].[aspnet_RegisterSchemaVersion]

GO

 

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

drop procedure [dbo].[aspnet_Roles_CreateRole]

GO

 

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

drop procedure [dbo].[aspnet_Roles_DeleteRole]

GO

 

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

drop procedure [dbo].[aspnet_Roles_GetAllRoles]

GO

 

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

drop procedure [dbo].[aspnet_Roles_RoleExists]

GO

 

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

drop procedure [dbo].[aspnet_Setup_RemoveAllRoleMembers]

GO

 

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

drop procedure [dbo].[aspnet_Setup_RestorePermissions]

GO

 

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

drop procedure [dbo].[aspnet_UnRegisterSchemaVersion]

GO

 

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

drop procedure [dbo].[aspnet_UsersInRoles_AddUsersToRoles]

GO

 

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

drop procedure [dbo].[aspnet_UsersInRoles_FindUsersInRole]

GO

 

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

drop procedure [dbo].[aspnet_UsersInRoles_GetRolesForUser]

GO

 

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

drop procedure [dbo].[aspnet_UsersInRoles_GetUsersInRoles]

GO

 

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

drop procedure [dbo].[aspnet_UsersInRoles_IsUserInRole]

GO

 

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

drop procedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]

GO

 

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

drop procedure [dbo].[aspnet_Users_CreateUser]

GO

 

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

drop procedure [dbo].[aspnet_Users_DeleteUser]

GO

--12/2/2007 begin

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_RoleGroups_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_RoleGroups] DROP CONSTRAINT [FK_dnn_RoleGroups_dnn_Portals]

GO

/****** Object:  Table [dbo].[dnn_Feedback]    Script Date: 02/12/2007 16:05:39 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Feedback]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Feedback]

GO

/****** Object:  Table [dbo].[dnn_Help_Category]    Script Date: 02/12/2007 16:05:39 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Help_Category]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Help_Category]

GO

/****** Object:  Table [dbo].[dnn_Help_TutorialCategory]    Script Date: 02/12/2007 16:05:39 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Help_TutorialCategory]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Help_TutorialCategory]

GO

/****** Object:  Table [dbo].[dnn_Help_Tutorials]    Script Date: 02/12/2007 16:05:39 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Help_Tutorials]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Help_Tutorials]

GO

--12/2/2007 end

 

 
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
posted @ Thursday, March 30, 2006 1:59 PM
Print

Comments on this entry:

No comments posted yet.

Your comment:



(not displayed)


 
 
 
 
 

Live Comment Preview:

 
«February»
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
26272829123
45678910

About
Article Categories
Archives
Post Categories
Links
Syndication:

RSS ATOM