Index: openacs-4/packages/theme-selva/sql/oracle/theme-selva-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/theme-selva/sql/oracle/theme-selva-create.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/theme-selva/sql/oracle/theme-selva-create.sql 3 Mar 2006 12:39:49 -0000 1.1.2.1 +++ openacs-4/packages/theme-selva/sql/oracle/theme-selva-create.sql 10 Mar 2006 11:12:09 -0000 1.1.2.2 @@ -1,24 +1,22 @@ -- packages/theme-selva/sql/oracle/theme-selva-create.sql --- Setting default template to Selva -UPDATE apm_parameter_values - SET attr_value = '/packages/theme-selva/www/selva-master' - WHERE parameter_id IN (SELECT parameter_id FROM apm_parameters WHERE parameter_name='DefaultMaster'); - --- Adding selva as new theme declare v_theme_id portal_element_themes.theme_id%TYPE; begin + -- Adding selva as new theme v_theme_id := portal_element_theme.new ( name => 'selva', description => 'Selva Theme', filename => '../../theme-selva/www/themes/selva-theme', resource_dir => '../../theme-selva/www/themes/selva-theme' ); + + -- Adding Selva to site-templates + insert into dotlrn_site_templates + (site_template_id, pretty_name, site_master, portal_theme_id) + values + (acs_object_id_seq.nextval, 'Selva Theme', '/packages/theme-selva/www/selva-master', v_theme_id); + end; / show errors - --- Setting portals theme to Selva -UPDATE portals - SET theme_id = (SELECT theme_id FROM portal_element_themes WHERE name='selva'); \ No newline at end of file