uninstall.sqldataprovider

完整的商业模板和强大的后台管理功能

GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddSearchItem]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetPermission]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}PurgeScheduleHistory]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteEvent]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSearchItemWordPosition]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddTabPermission]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetModuleSettings]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateModuleControl]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateSystemMessage]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSystemMessages]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetScheduleByTypeFullName]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetFileById]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteSearchWord]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteSkin]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddUrlLog]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSearchItemWordPositionBySearchItemWord]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteFiles]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteModuleControl]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteSearchItems]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSiteLog4]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddAnnouncement]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetFiles]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateSearchWord]
GO
DROP TABLE {databaseOwner}[{objectQualifier}ScheduleItemSettings]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetAllProfiles]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}ListSearchItem]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateLink]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateFolder]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddAffiliate]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddUserDefinedData]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSiteLog8]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSearchWords]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateContact]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteSearchItem]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Announcements]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateSearchItemWord]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteFAQ]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetScheduleByScheduleID]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteUrl]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Urls]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSearchItemWordBySearchItem]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}FindDatabaseVersion]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetTabModuleSettings]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddSchedule]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddTabModuleSetting]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateSearchItemWordPosition]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteMessage]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSiteLog5]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetTables]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetTabModuleSetting]
GO
DROP TABLE {databaseOwner}[{objectQualifier}TabModuleSettings]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetDatabaseVersion]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Version]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddUserRole]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Profile]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetFile]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSearchItemWordBySearchWord]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddSystemMessage]
GO
DROP TABLE {databaseOwner}[{objectQualifier}SystemMessages]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Links]
GO
DROP TABLE {databaseOwner}[{objectQualifier}VendorClassification]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateTabPermission]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteSearchCommonWord]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateSearchCommonWord]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetTabPermission]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteModulePermissionsByModuleID]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeletePermission]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddSiteLog]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddDocument]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Documents]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSearchWordByID]
GO
DROP TABLE {databaseOwner}[{objectQualifier}SearchWord]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetFAQs]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetContacts]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateEvent]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Events]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddUserDefinedRow]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSiteLog1]
GO
DROP TABLE {databaseOwner}[{objectQualifier}SiteLog]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateSchedule]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdateAffiliateStats]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Affiliates]
GO
DROP TABLE {databaseOwner}[{objectQualifier}ModuleControls]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteSchedule]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetPortalAliasByPortalAliasID]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddFolder]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Folders]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Permission]
GO
DROP TABLE {databaseOwner}[{objectQualifier}ModulePermission]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddSearchCommonWord]
GO
DROP TABLE {databaseOwner}[{objectQualifier}SearchCommonWords]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddMessage]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Discussion]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Files]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetScheduleNextTask]
GO
DROP TABLE {databaseOwner}[{objectQualifier}ScheduleHistory]
GO
DROP TABLE {databaseOwner}[{objectQualifier}UserDefinedRows]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteContact]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Contacts]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Schedule]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddModuleSetting]
GO
DROP TABLE {databaseOwner}[{objectQualifier}ModuleSettings]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetPortalAlias]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteTabPermission]
GO
DROP TABLE {databaseOwner}[{objectQualifier}TabPermission]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}ListSearchItemWordPosition]
GO
DROP TABLE {databaseOwner}[{objectQualifier}SearchItemWordPosition]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSearchIndexers]
GO
DROP TABLE {databaseOwner}[{objectQualifier}SearchIndexer]
GO
DROP TABLE {databaseOwner}[{objectQualifier}UrlLog]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}AddFolderPermission]
GO
DROP TABLE {databaseOwner}[{objectQualifier}PortalDesktopModules]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteUserDefinedData]
GO
DROP TABLE {databaseOwner}[{objectQualifier}UserDefinedData]
GO
DROP TABLE {databaseOwner}[{objectQualifier}FolderPermission]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSkin]
GO
DROP TABLE {databaseOwner}[{objectQualifier}Skins]
GO
DROP TABLE {databaseOwner}[{objectQualifier}SearchItem]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DeleteUserRole]
GO
DROP TABLE {databaseOwner}[{objectQualifier}UserRoles]
GO
DROP TABLE {databaseOwner}[{objectQualifier}FAQs]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}GetSearchItemWord]
GO
DROP TABLE {databaseOwner}[{objectQualifier}SearchItemWord]
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}UpdatePortalAliasOnInstall]
GO
DROP TABLE {databaseOwner}[{objectQualifier}PortalAlias]
GO

/** Remove AspNet Data **/

/** Delete Profile **/
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'{objectQualifier}%')
GO

/** Delete Membership **/
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'{objectQualifier}%')
GO

/** Delete UsersInRoles **/
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'{objectQualifier}%')
GO

/** Delete Users **/
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'{objectQualifier}%')
GO

/** Delete Roles **/
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'{objectQualifier}%')
GO

/** Delete Applications **/
DELETE	dbo.aspnet_Applications
WHERE   (ApplicationName LIKE N'{objectQualifier}%')
GO

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