select count(*)
from lang_message_keys
where package_key = :package_key
and message_key = :message_key
select count(*)
from lang_messages
where package_key = :package_key
and message_key = :message_key
insert into lang_message_keys
(message_key, package_key, upgrade_status)
values
(:message_key, :package_key, :key_upgrade_status)
update lang_messages
set message = null,
upgrade_status = :message_upgrade_status
where locale = :locale
and package_key = :package_key
and message_key = :message_key
select locale, package_key, message_key, message
from lang_messages