select package_key
from apm_package_types
where exists (select 1
from apm_package_versions
where installed_p = 't'
and enabled_p = 't')
and not exists (select 1
from lang_message_keys
where package_key = apm_package_types.package_key)
select distinct locale
from lang_messages
where package_key = :package_key
select message_key, message
from lang_messages
where package_key = :package_key
and locale = :locale
and not exists (select 1 from lang_message_keys
where message_key = lang_messages.message_key
and package_key = lang_messages.package_key
and upgrade_status = 'deleted'
)
select message_key,
package_key,
message
from lang_messages lm1
where locale = :default_locale
and not exists (select message_key, package_key
from lang_messages lm2
where locale != :default_locale
and lm1.message_key = lm2.message_key
and lm1.package_key = lm2.package_key)
update lang_message_keys
set upgrade_status = 'no_upgrade'
where package_key = :package_key
update lang_messages
set upgrade_status = 'no_upgrade'
where package_key = :package_key
and locale = :locale
update lang_messages
set upgrade_status = 'deleted'
where package_key = :package_key
and message_key = :message_key
and locale = :locale