select distinct locale
from lang_messages
where package_key = :package_key
select lm.message_key,
lm.message,
lmk.description
from lang_messages lm,
lang_message_keys lmk
where lm.message_key = lmk.message_key
and lm.package_key = lmk.package_key
and lm.package_key = :package_key
and lm.locale = :locale
and lmk.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
update lang_message_keys
set upgrade_status = 'deleted'
where package_key = :package_key
and message_key = :message_key