select pretty_name, site_master, portal_theme_id from dotlrn_site_templates where site_template_id = :site_template_id insert into dotlrn_site_templates(site_template_id, pretty_name, site_master, portal_theme_id) values (:site_template_id,:pretty_name, :site_master, :portal_theme_id) update dotlrn_site_templates set pretty_name = :pretty_name, site_master=:site_master, portal_theme_id = :portal_theme_id where site_template_id = :site_template_id select name || '( ' || description || ' )', theme_id from portal_element_themes