select site_template_id from dotlrn_site_templates where pretty_name = :default_template_name select default_value from apm_parameters where package_key = 'dotlrn' and parameter_name like '%_csv' update portal_pages set accesskey = :accesskey where pretty_name = :title update acs_object_types set supertype = 'application_group' where object_type = 'dotlrn_community' insert into application_groups (group_id, package_id) select community_id, package_id from dotlrn_communities