SwissChecklist

Checklist: Remove the 2Sexy Content Module completely

While deinstalling 2Sexy Content, a few tables in the database will not be removed. To manually remove them, this checklist will help you.
  • Deinstall the module

    Show Details Show Substeps Show Substeps Show Substeps
  • If you haven't already, deinstall the module through the Extensions page

    Show Details Show Substeps Show Substeps Show Substeps
  • Remove the DB tables (works for v6+ only!)

    Show Details Show Substeps Show Substeps Show Substeps
  • To remove the tables, run this SQL script

    Show Details Show Substeps Show Substeps Show Substeps
    BEGIN TRANSACTION SexyContentUninstaller

    -- Remove Tables

    DROP TABLE [dbo].[ToSIC_EAV_EntityRelationships]
    GO

    DROP TABLE [dbo].[ToSIC_SexyContent_ContentGroupItems]
    GO

    DROP TABLE [dbo].[ToSIC_SexyContent_Templates]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_ValuesDimensions]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_Dimensions]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_Values]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_Entities]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_DataTimeline]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_AttributesInSets]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_Attributes]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_AttributeTypes]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_AttributeGroups]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_AttributeSets]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_Attachments]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_AssignmentObjectTypes]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_Apps]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_Zones]
    GO

    DROP TABLE [dbo].[ToSIC_EAV_ChangeLog]
    GO


    -- Remove Stored Procedures

    DROP PROCEDURE [dbo].[ToSIC_EAV_DeleteApp]
    GO

    DROP PROCEDURE [dbo].[ToSIC_EAV_ChangeLogAdd]
    GO

    DROP PROCEDURE [dbo].[ToSIC_EAV_ChangeLogSet]
    GO

    DROP PROCEDURE [dbo].[ToSIC_EAV_LogToTimeline]
    GO


    -- Remove PortalSettings

    DELETE FROM PortalSettings
    WHERE (SettingName = N'ToSIC_SexyContent_ZoneID')

    COMMIT TRANSACTION SexyContentUninstaller
  • Done!

    Show Details Show Substeps Show Substeps Show Substeps
  • New Step

    Show Details Show Substeps Show Substeps Show Substeps
Use this Checklist

Preview/Print

Use

Change

Sort