/*
Script created by SQL Compare version 5.3.0.44 from Red Gate Software Ltd at 13/10/2008 10:58:16
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_EntryPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryPermissions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_EntryPermissions_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Notifications]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Notifications] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Notifications_{objectQualifier}DMX_Log]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Attributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Attributes] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Attributes_{objectQualifier}DMX_Addons],
CONSTRAINT [FK_{objectQualifier}DMX_Attributes_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Permissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Permissions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Permissions_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_PermissionPermissions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_PermissionPermissions_{objectQualifier}DMX_Permissions]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_EntryAttributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryAttributes] DROP
CONSTRAINT [FK_{objectQualifier}DMX_EntryAttributes_{objectQualifier}DMX_Attributes],
CONSTRAINT [FK_{objectQualifier}DMX_EntryAttributes_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Extensions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Extensions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Extensions_{objectQualifier}DMX_Addons],
CONSTRAINT [FK_{objectQualifier}DMX_Extensions_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes] DROP
CONSTRAINT [FK_{objectQualifier}DMX_PermissionEntrytypes_{objectQualifier}DMX_Permissions]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Log]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Log] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Log_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Entries] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Entries_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Categories]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Categories] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Categories_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Subscriptions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Subscriptions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Subscriptions_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_EntryCategories]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryCategories] DROP
CONSTRAINT [FK_{objectQualifier}DMX_EntryCategories_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Log]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Log] DROP CONSTRAINT [PK_{objectQualifier}DMX_Log]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_LogTypes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_LogTypes] DROP CONSTRAINT [PK_{objectQualifier}DMX_LogTypes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Addons]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Addons] DROP CONSTRAINT [PK_{objectQualifier}DMX_Addons]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_EntryAttributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryAttributes] DROP CONSTRAINT [PK_{objectQualifier}DMX_EntryAttributes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_EntryCategories]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryCategories] DROP CONSTRAINT [PK_{objectQualifier}DMX_EntryCategories]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Categories]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Categories] DROP CONSTRAINT [PK_{objectQualifier}DMX_Categories]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Extensions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Extensions] DROP CONSTRAINT [PK_{objectQualifier}DMX_Extensions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Attributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Attributes] DROP CONSTRAINT [PK_{objectQualifier}DMX_Attributes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_LongTexts]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_LongTexts] DROP CONSTRAINT [PK_{objectQualifier}DMX_LongTexts]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Entries] DROP CONSTRAINT [PK_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Permissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Permissions] DROP CONSTRAINT [PK_{objectQualifier}DMX_Permissions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_ShortTexts]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_ShortTexts] DROP CONSTRAINT [PK_{objectQualifier}DMX_ShortTexts]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes] DROP CONSTRAINT [PK_{objectQualifier}DMX_PermissionEntrytypes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Subscriptions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Subscriptions] DROP CONSTRAINT [PK_{objectQualifier}DMX_Subscriptions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_EntryPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryPermissions] DROP CONSTRAINT [PK_{objectQualifier}DMX_EntryPermissions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_PermissionPermissions] DROP CONSTRAINT [PK_{objectQualifier}DMX_PermissionPermissions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMXDAV_Numbers]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMXDAV_Numbers] DROP CONSTRAINT [Index_Numbers]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Notifications]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Notifications] DROP CONSTRAINT [PK_{objectQualifier}DMX_Notifications]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetDeleteRecursive]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetDeleteRecursive]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SearchResults]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_SearchResults]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUsersToNotify]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUsersToNotify]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UnifyRemovePermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UnifyRemovePermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ResetPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_ResetPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogsByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogsByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UnifyPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UnifyPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogByTime]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogByTime]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionPermissionsByPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionPermissionsByPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCategoriesByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCategoriesByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_RemoveDeadPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_RemoveDeadPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogsByUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogsByUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryPermissionsByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryPermissionsByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogsByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogsByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMXDAV_GetPath]'
GO
DROP FUNCTION {databaseOwner}[{objectQualifier}DMXDAV_GetPath]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUserPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUserPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMXDAV_GetExtension]'
GO
DROP FUNCTION {databaseOwner}[{objectQualifier}DMXDAV_GetExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteShortText]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteShortText]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionPermissionsByRole]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionPermissionsByRole]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddLogType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddLogType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteExtension]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUnsentNotifications]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUnsentNotifications]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetShortText]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetShortText]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMXDAV_URLEncode]'
GO
DROP FUNCTION {databaseOwner}[{objectQualifier}DMXDAV_URLEncode]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMXDAV_Numbers]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMXDAV_Numbers]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetExtensionsByAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetExtensionsByAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddShortText]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddShortText]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetNotification]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetNotification]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddLongText]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddLongText]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetShortTexts]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetShortTexts]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddExtension]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsByUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsByUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddPermissionPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddPermissionPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAddonsWithFeature]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAddonsWithFeature]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddPermissionEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddPermissionEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogTypes]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogTypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateExtension]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdatePaths]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdatePaths]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_FindAttributeByName]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_FindAttributeByName]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdatePermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdatePermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetExtensionsByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetExtensionsByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateSubscription]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateSubscription]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryCategoriesByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryCategoriesByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteLongText]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteLongText]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeletePermissionEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeletePermissionEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteSubscription]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteSubscription]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_FindEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_FindEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_ActiveUserRoles]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_ActiveUserRoles]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionsByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionsByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateShortText]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateShortText]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionEntrytypesByPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionEntrytypesByPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_RenameEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_RenameEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryCategoriesByCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryCategoriesByCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddEntryCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddEntryCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLongText]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLongText]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryAttributesByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryAttributesByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetExtension]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_IsEntryPermissionByAdmin]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_IsEntryPermissionByAdmin]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeletePermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeletePermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetApprovedEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetApprovedEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributesByAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributesByAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntriesByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntriesByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddEntryAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddEntryAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteNotification]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteNotification]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntriesByUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntriesByUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeletePermissionPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeletePermissionPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddEntryPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddEntryPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateLongText]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateLongText]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_FindAddonByName]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_FindAddonByName]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Categories]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Categories]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateEntryAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateEntryAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UnifySetPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UnifySetPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddSubscription]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddSubscription]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributesByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributesByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateLogType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateLogType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_MoveAllEntries]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_MoveAllEntries]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntryPermissions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_EntryPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_MoveEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_MoveEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntryCategories]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_EntryCategories]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetParentChain]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetParentChain]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Log]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Log]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_LongTexts]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_LongTexts]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntryAttributes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_EntryAttributes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ShortTexts]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_ShortTexts]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddNotification]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddNotification]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetLastModified]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetLastModified]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteLogType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteLogType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_LogTypes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_LogTypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Permissions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Permissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Extensions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Extensions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Attributes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Attributes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Addons]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Addons]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSubscription]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSubscription]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Subscriptions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Subscriptions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateNotification]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateNotification]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Notifications]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Notifications]
GO
DELETE FROM {databaseOwner}[{objectQualifier}Schedule] 
WHERE [TypeFullName]='Bring2mind.DNN.Modules.DMX.Services.Schedule.Maintenance, BRING2MIND.DNN.MODULES.DMX.CORE'
GO
DELETE FROM {databaseOwner}[{objectQualifier}Schedule] 
WHERE [TypeFullName]='Bring2mind.DNN.Modules.DMX.Services.Schedule.ScheduledTask, BRING2MIND.DNN.MODULES.DMX.CORE'
GO
