Alfresco SQL scripts for upgrade preparation

clearAllJMXSettings.sql

delete
from
   alf_prop_link
where
   root_prop_id in (
      select
         prop1_id
      from
         alf_prop_unique_ctx ctx
         left join alf_prop_value pvj1 on ctx.value1_prop_id = pvj1.id
         left join alf_prop_string_value psvj1 on psvj1.id = pvj1.long_value
      where
         pvj1.persisted_type = 3
         and psvj1.string_value = '.PropertyBackedBeans'
   );

delete
from
   alf_prop_root
where
   id in (
      select
         prop1_id
      from
         alf_prop_unique_ctx ctx
         left join alf_prop_value pvj1 on ctx.value1_prop_id = pvj1.id
         left join alf_prop_string_value psvj1 on psvj1.id = pvj1.long_value
      where
         pvj1.persisted_type = 3
         and psvj1.string_value = '.PropertyBackedBeans'
   );

delete
from
   alf_prop_unique_ctx
where
   value1_prop_id in (
      select
         pvj1.id
      from
         alf_prop_value pvj1
         left join alf_prop_string_value psvj1 on psvj1.id = pvj1.long_value
      where
         pvj1.persisted_type = 3
         and psvj1.string_value = '.PropertyBackedBeans'
   );

clearClusterMembers.sql

delete
from
   alf_prop_link
where
   root_prop_id in (
      select
         prop1_id
      from
         alf_prop_unique_ctx ctx
         left join alf_prop_value pvj1 on ctx.value1_prop_id = pvj1.id
         left join alf_prop_string_value psvj1 on psvj1.id = pvj1.long_value
      where
         pvj1.persisted_type = 3
         and psvj1.string_value = '.clusterMembers'
   );

delete
from
   alf_prop_root
where
   id in (
      select
         prop1_id
      from
         alf_prop_unique_ctx ctx
         left join alf_prop_value pvj1 on ctx.value1_prop_id = pvj1.id
         left join alf_prop_string_value psvj1 on psvj1.id = pvj1.long_value
      where
         pvj1.persisted_type = 3
         and psvj1.string_value = '.clusterMembers'
   );

delete
from
   alf_prop_unique_ctx
where
   value1_prop_id in (
      select
         pvj1.id
      from
         alf_prop_value pvj1
         left join alf_prop_string_value psvj1 on psvj1.id = pvj1.long_value
      where
         pvj1.persisted_type = 3
         and psvj1.string_value = '.clusterMembers'
   );