DotNetNuke Register form with minimal fields.

Provided by core Register form (adminSecurityRegister.ascx.vb) shows many fields, including address details and adminsitrator can make them optional, but not hide them.  
I was requested to show only minimal (Firstname/surname/username/email/passwords) and hide other fields from register screen, but leave them visible when  user profile is opened.

The changes I’ve done are posted here.

DotNetNuke Register form with minimal fields.

Provided by core Register form (adminSecurityRegister.ascx.vb) shows many fields, including address details and Adminsitrator can make them optional, but not hide them.  
I was requested to show only minimal (Firstname/surname/username/email/passwords) and hide others from register screen, but leave them visible when open in user profile.

The change in adminSecurityRegister.ascx.vb BindData() function is in the end of new user registration section

If Services = 1 Then
………….

Else
…..
              If Request.IsAuthenticated Then
…….

Else ‘new user registration
…….

                    ‘MNF 30/3/2006 added
                    ‘No UI to set it at the moment
                    Dim htSitSettings As Hashtable = Entities.Portals.PortalSettings.GetSiteSettings(PortalSettings.PortalId)
                    Dim bMinimalRegistrationFields As Boolean = FSHelperLib.DataHelper.Nz(htSitSettings(“MinimalRegistrationFields”), False)
                    If (bMinimalRegistrationFields = True) Then
                        Me.addressUser.Visible = False
                        Me.userControl.WebSiteVisible = False
                        Me.userControl.IMVisible = False
                    End If
                    ‘MNF 30/3/2006 added end
              End If
End If

I also had to make public properties userControl.WebSiteVisible and userControl.IMVisible in DNNLibraryControlsUser.vb

        ‘MNF 30/3/2006 added to hide not important fields
‘*
‘* Property WebSiteVisible (boolean)
‘*
Public Property WebSiteVisible() As boolean
    Get
                Return txtWebsite.Visible
    End Get
    Set(Byval Value As boolean)
                txtWebsite.Visible = Value
                plWebsite.Visible = Value
    End Set
        End Property
        ‘*
        ‘* Property IMVisible (boolean)
        ‘*
        Public Property IMVisible() As boolean
            Get
                Return txtIM.Visible
            End Get
            Set(Byval Value As boolean)
                txtIM.Visible = Value
                plIM.Visible = Value
            End Set
        End Property
        ‘MNF 30/3/2006 added end

Because I didn’t create user interface to setup the MinimalRegistrationFields flag, the following SQL can be used to insert row/change the value.

declare @SiteSettingsModuleId int

select @SiteSettingsModuleId=dbo.dnn_Modules.ModuleID

FROM dnn_Modules INNER JOIN

dnn_ModuleDefinitions ON dnn_Modules.ModuleDefID = dnn_ModuleDefinitions.ModuleDefID INNER JOIN

dnn_DesktopModules ON dnn_ModuleDefinitions.DesktopModuleID = dnn_DesktopModules.DesktopModuleID

WHERE (dnn_DesktopModules.FriendlyName = N’Site Settings’)

if NOT exists (select * from dbo.dnn_ModuleSettings WHERE (dnn_ModuleSettings.SettingName = N’MinimalRegistrationFields’) AND dnn_ModuleSettings.ModuleID =@SiteSettingsModuleId )

INSERT INTO dnn_ModuleSettings (ModuleID,SettingName,SettingValue)

values(@SiteSettingsModuleId,N’MinimalRegistrationFields’,‘true’)

else

update dnn_ModuleSettings

set SettingValue=‘true’

FROM dnn_ModuleSettings

WHERE (dnn_ModuleSettings.SettingName = N’MinimalRegistrationFields’) AND dnn_ModuleSettings.ModuleID =@SiteSettingsModuleId

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). I decided to use UnInstall.SqlDataProvider script file from ProvidersDataProvidersSqlDataProvider DNN 4.0.2 installation.

However there were a lot of errors when running the script.

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

List of errors and additional SQL commands I’ve posted here.

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 ProvidersDataProvidersSqlDataProvider 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

 

 

FreeTextBox editor requires IE permission “Allow Paste Operation via script” to support Paste with Control-V.

Many sites including DotNetNuke are using FreeTextBox ASP.NET HTML Editor. I’ve noticed that on my Windows Server 2003 machine running IE I am not able to do Control-V to paste text to the editor, even if I can right-mouse click and select “Paste” . It was quite annoying.

Accidentally I found that   IE permission “Allow Paste Operation via script” is disabled on this machine.

I’ve enabled it and now I can use Control-V to paste.

I am not sure which security risks are envolved with enabling this option. 

DotnetNuke Changes to Promote User to SuperUser

I implemented mixed Authentication for DotNetNuke ( Use Windows Integrated Authentication for seamless logon intranet logon and use Forms authentication for users unable to use Windows Integrated authentication), similar to as I did it before for my ASP.NET application . See my previous post about some problems that I had.

It is also required to promote imported from Active Directory Administrator user to SuperUser. The current DNN core doesn’t support this.It only allows to create a new SuperUser.

I had to add a new link button “Make SuperUser” to ManagedUsers.ascx. More…

DotnetNuke Changes to Promote User to SuperUser

I implemented mixed Authentication for DotNetNuke ( Use Windows Integrated Authentication for seamless logon intranet logon and use Forms authentication for users unable to use Windows Integrated authentication), similar to as I did it before for my ASP.NET application . See my previous post about some problems that I had.

It is also required to promote imported from Active Directory Administrator user to SuperUser. The current DNN core doesn’t support this.It only allows to create a new SuperUser.

I had to add a new link button “Make SuperUser” to ManagedUsers.ascx.
Some code was added to hide the button according to user permissions(set Visible=false for a new button in the same places where cmdManageRoles.visible=false)

In Click event I’ve added call to add user to Asp.NET membersip (“dnn-1“ application for SuperUser) and update dnn_user table to set SuperUser=1. The current UserController.UpdateUser method doesn’t allow to change SuperUser flag, so new Stored Procedure and method has to be created.

        Protected Sub cmdSuperUser_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdSuperUser.Click

            ‘ update the user record in the database

            If Not UserInfo.IsSuperUser Then Exit Sub ‘Only SuperUser can make another SuperUser

            Dim objUsers As New UserController

            Dim ObjUser As UserInfo

            ObjUser = objUsers.GetUser(PortalId, UserId)

 

            If Not ObjUser Is Nothing AndAlso ObjUser.IsSuperUser = False Then

‘Required to force load from AspNetSecurity.Membership.GetUser ‘see http://geekswithblogs.net/mnf/archive/2006/03/15/72324.aspx
Dim userMembership As Entities.Users.UserMembership = ObjUser.Membership

                ObjUser.PortalID = -1

                ObjUser.IsSuperUser = True

                Dim objStatus As AspNetSecurity.MembershipCreateStatus = UserController.CreateInMembershipProvider(ObjUser)

                Select Case objStatus

                    Case MembershipCreateStatus.Success, MembershipCreateStatus.DuplicateUserName

                        ‘Update User doesn’t update IsSuperUser flag

                        SetSuperUser(ObjUser)

                    Case Else

                        UI.Skins.Skin.AddModuleMessage(Me, objUsers.GetRegistrationStatus(objStatus), UI.Skins.Controls.ModuleMessage.ModuleMessageType.YellowWarning)

                End Select

 

            End If

        End Sub

        ‘Should be a part of UserController

        Public Sub SetSuperUser(ByVal objUser As UserInfo)

            Dim objSecurity As New PortalSecurity

            Dim objUserController As New UserController

            ‘HACK, should be methods in DataProvider and SQlDataProvider,

            ‘SP with DatabaseOwner & ObjectQualifier

            ‘DataProvider.Instance.SetSuperUser(objUser.UserID,ObjUser.IsSuperUser )

            Dim sSQL As String = “exec dbo.dnn_User_SetSuperUser ” & objUser.UserID & ” , ” & Convert.ToInt16(objUser.IsSuperUser)

            Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(DotNetNuke.Common.Utilities.Config.GetConnectionString(), CommandType.Text, sSQL)

 

        End Sub

 

I’ve also re-factor UserController class to separate function CreateInMembershipProvider that was a part of AddUser Function.

        ‘mnf 16/3/2006 added to call from SetAsSuperUser

        Public Shared Function CreateInMembershipProvider(ByVal objUser As UserInfo) As AspNetSecurity.MembershipCreateStatus

            ‘Dim UserId As Integer = -1

            ‘Dim Status As UserRegistrationStatus

 

            Dim objSecurity As New PortalSecurity

            Dim objStatus As AspNetSecurity.MembershipCreateStatus = AspNetSecurity.MembershipCreateStatus.Success

            If objUser.IsSuperUser Then

                Common.Globals.SetApplicationName(Common.Globals.glbSuperUserAppName)

            Else

                Common.Globals.SetApplicationName(objUser.PortalID)

            End If

 

            Dim objMembershipUser As AspNetSecurity.MembershipUser

            objMembershipUser = AspNetSecurity.Membership.CreateUser(objSecurity.InputFilter(objUser.Membership.Username, PortalSecurity.FilterFlag.NoScripting Or PortalSecurity.FilterFlag.NoMarkup), objUser.Membership.Password, objSecurity.InputFilter(objUser.Membership.Email, PortalSecurity.FilterFlag.NoScripting Or PortalSecurity.FilterFlag.NoMarkup), Nothing, Nothing, objUser.Membership.Approved, objStatus)

            Return objStatus

        End Function

The Stored Procedure is created in the following script:

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

create  procedure {databaseOwner}{objectQualifier}User_SetSuperUser
@UserId         int,
@IsSuperUser    bit

as

update {databaseOwner}{objectQualifier}Users
set    IsSuperUser=@IsSuperUser
where  UserId = @UserId

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

ObjectHydrated pattern in DotNetNuke UserInfo is not good

DotNetNuke UserMembership class (as well as some others) hasObjectHydrated property as a flag is object loaded or not.

In my opinion implementation of this pattern is fragile and not reliable.

Get 

Membership Property of  UserInfo tries to load data from UserMembership, which is not good, because Get (read-only) property should not change state of the object.
It can cause different behavior in Debug and Release modes, if any code like Debug.WriteLine(ObjUser.Membership.Email) will be used.

Also assigning any of UserMembership properties (e.g. Email) sets has ObjectHydrated flag to true, even if other properties are not filled.

I’ve noticed a few times that FillUserMembership wasn’t called when expected and properties of UserMembership were null, even if ObjectHydrated flag was true.It caused exceptions, that are not reproducible.

I’ve noticed that DNN support has reports about the issue(see here and here)

Handle duplicate parameters in DotNetNuke UrlRewriteModule.

In my application based on DotNetNuke 4.0.2 I’ve noticed that sometimes I have url with duplicate parameters, e.g “PortalID=0&PortalID=0”

I didn’t  fully investigate why it happens and is it DNN core issue or my custom code, but the current UrlRewriteModule code doesn’t handle it properly. I’ve created the function that will read only the first parameter and ignore the rest. 

        ‘call     PortalId = GetIntFromQueryString(Request, “portalid”, PortalId) ’14/3/2006

        Shared Function GetIntFromQueryString(ByVal Request As HttpRequest, ByVal key As String, ByVal nDefault As Integer) As Integer

            Dim nValue As Integer = nDefault

            Dim sQueryStringValues As String = Request.QueryString(key)

            If Not (sQueryStringValues Is Nothing) Then

                Try

                    nValue = Int32.Parse(sQueryStringValues)

                Catch

                    ‘By some reason (not fully investigated) sometimes QueryString has the same parameter inserted more that once,

                    ‘e.g “PortalID=0&PortalId=0” so QueryString(key) will be “0,0”

                    Dim asValues() As String = sQueryStringValues.Split(“,”c)

                    If asValues.Length > 0 Then

                        nValue = Int32.Parse(asValues(0))

                    End If

                End Try

            End If

            Return nValue

        End Function

I noticed that DNN Support has a few bug reports with exception “Input string was not in a correct format” (here, here, here and here) .May be some of them are caused by the same reason as mine.

 

DotNetNuke Windows Authentication and SuperUser permissions

I’ve tried to work with DotNetNuke Windows Authentication to extend it to work in mixed mode ( Use Windows Integrated Authentication for seamless logon intranet logon and use Forms authentication for users unable to use Windows Integrated authentication), as I did it before for my ASP.NET application .

I found that since I activated Windows Authentication, I can logon only as my domain account user,which does not have DNN portal host or admin roles. So I unable using DNN web interface to administrate DNN.

I had to open Users table in SQL server and changed my domain user record to be SuperUser. After this I was able to see host/admin menu, but my user-name wasn’t shown.

After debugging the problem I recognized that setting 1 to SuperUser column of dnn Users table is not the only change that is required.

Microsoft Membership required to store user per application and SuperUser is stored for application “dnn-1”, which means “for all dnn application” (see discussions here and here). So just changing superUser flag is not enough and make DNN users and aspnet membership entries inconsistent.

I think that way as superUser membership is stored should be re-considered to find a better design solution(no good suggestion at the moment)

The conclusion are:

1.Before switching to Windows Authentication ensure that your LAN acoount has host/administrative permissions for the portal.

2.Use Portal UI to make a user SuperUser, don’t update SQL table directly.