insert into dotlrn_site_templates (site_template_id, pretty_name, site_master, portal_theme_id ) values (:site_template_id, '#dotlrn-bootstrap3-theme.bootstrap3-theme#', '/packages/dotlrn-bootstrap3-theme/resources/masters/dotlrn-master', :theme_id) DELETE from portal_layouts WHERE name='#dotlrn-bootstrap3-theme.bootstrap-1column#'; DELETE from portal_layouts WHERE name='#dotlrn-bootstrap3-theme.bootstrap-2column#'; DELETE from portal_layouts WHERE name='#dotlrn-bootstrap3-theme.bootstrap-3column#' DELETE FROM portal_supported_regions AS psr USING portal_layouts AS pl where (pl.layout_id = psr.layout_id) AND pl.filename='../../dotlrn-bootstrap3-theme/lib/layouts/bootstrap-1column' DELETE FROM portal_supported_regions AS psr USING portal_layouts AS pl where (pl.layout_id = psr.layout_id) AND pl.filename='../../dotlrn-bootstrap3-theme/lib/layouts/bootstrap-2column' DELETE FROM portal_supported_regions AS psr USING portal_layouts AS pl where (pl.layout_id = psr.layout_id) AND pl.filename='../../dotlrn-bootstrap3-theme/lib/layouts/bootstrap-3column' DELETE from dotlrn_site_templates WHERE pretty_name='#dotlrn-bootstrap3-theme.bootstrap3-theme#' DELETE from portal_element_themes WHERE name='#dotlrn-bootstrap3-theme.bootstrap3-theme#'