USP_CMSCACHEITEM_FLUSH_SETTINGS

create procedure dbo.USP_CMSCACHEITEM_FLUSH_SETTINGS
as
begin
    delete [dbo].[CACHEITEMS]
    where [KEY] = 'SettingsTable';

    delete [dbo].[CACHEITEMS]
    where [KEY] like 'SiteSettings%';

    delete [dbo].[CACHEITEMS]
    where [KEY] like 'Site_%';

    delete [dbo].[CACHEITEMS]
    where [KEY] = 'Client_1_0';

     delete [dbo].[CACHEITEMS]
    where [KEY] = 'BackOfficeAppInfo';   

     delete [dbo].[CACHEITEMS]
    where [KEY] = 'ConditionSettingHelper_ConditionSettings';       

     delete [dbo].[CACHEITEMS]
    where [KEY] = 'FEATUREMANAGER_AvailableContentTypes';       

      delete [dbo].[CACHEITEMS]
    where [KEY] = 'InstalledCountry';     

      delete [dbo].[CACHEITEMS]
    where [KEY] = 'PRODUCTFLAGCACHEKEY';     

    delete [dbo].[CACHEITEMS]
    where [KEY] like 'ProductId%';

      delete [dbo].[CACHEITEMS]
    where [KEY] = 'RE7EEInt';    

end