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#'