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)