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.1.2.1
--- 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	3 Mar 2006 12:39:49 -0000	1.1.2.1
@@ -1 +1,24 @@
-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
+
+-- 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
+	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'
+	);
+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
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/theme-selva/sql/oracle/theme-selva-drop.sql'.
Fisheye: No comparison available.  Pass `N' to diff?