select site_template_id from dotlrn_site_templates where pretty_name = '#theme-zen.Zen_Theme#'
select theme_id from portal_element_themes where name = '#theme-zen.Zen_Theme#'
update portals set theme_id = :theme_id
select layout_id as old_id from portal_layouts where name = :old
select layout_id as new_id from portal_layouts where name = :new
update portal_pages set layout_id = :new_id where layout_id = :old_id