select module_id from cm_modules
where key = :module_name
and package_id =
(select package_id from cms_subsite_package_map
where subsite_id = :subsite_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
select root_key from cm_modules
where key = 'templates'
and package_id =
(select package_id from cms_subsite_package_map
where subsite_id = :subsite_id)
select root_key from cm_modules
where key = 'sitemap'
and package_id =
(select package_id from cms_subsite_package_map
where subsite_id = :subsite_id)
update acs_objects set context_id = :package_id where object_id = :module_id
insert into cms_subsite_package_map
(subsite_id,package_id)
values
(:subsite_id,:package_id)
select module_id from cm_modules
where package_id =
(select package_id from cms_subsite_package_map
where subsite_id = :subsite_id)