select module_id from cm_modules
where key = :module_name
and package_id = :package_id
select
key, name, '' as id,
'' as children, 't' as expandable, 'f' as symlink,
0 as update_time
from cm_modules
order by sort_key
select
:module_name as mount_point,
name, key, '' as children,
'f' as expandable,
'f' as symlink,
0 as update_type
from cm_modules order by sort_key
update acs_objects set context_id = :package_id where object_id = :module_id
select module_id from cm_modules where package_id = :package_id