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 -r1.2
--- openacs-4/packages/theme-selva/sql/oracle/theme-selva-create.sql	27 Jul 2005 18:32:02 -0000	1.1
+++ openacs-4/packages/theme-selva/sql/oracle/theme-selva-create.sql	8 Aug 2006 21:27:16 -0000	1.2
@@ -1 +1,22 @@
-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' AND package_key = 'acs-subsite');
+-- packages/theme-selva/sql/oracle/theme-selva-create.sql
+
+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