Index: openacs-4/packages/dotlrn/sql/postgresql/site-templates-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/site-templates-create.sql,v diff -u -N -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/dotlrn/sql/postgresql/site-templates-create.sql 13 Dec 2005 15:32:35 -0000 1.1.2.1 +++ openacs-4/packages/dotlrn/sql/postgresql/site-templates-create.sql 18 Apr 2006 23:48:39 -0000 1.1.2.2 @@ -71,20 +71,6 @@ v_site_template_id dotlrn_site_templates.site_template_id%TYPE; v_theme_id portal_element_themes.theme_id%TYPE; begin - select theme_id into v_theme_id - from portal_element_themes - where name = ''#new-portal.kelp_theme_name#''; - - select acs_object_id_seq.nextval - into v_site_template_id - from dual; - - insert into dotlrn_site_templates - (site_template_id, pretty_name, site_master, portal_theme_id ) - values - (v_site_template_id, ''#new-portal.kelp_theme_name#'',''/packages/dotlrn/www/dotlrn-master-kelp'', v_theme_id); - - select theme_id into v_theme_id from portal_element_themes where name = ''#new-portal.sloan_theme_name#'';