Index: openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql	10 Feb 2005 21:25:50 -0000	1.3
+++ openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql	14 Feb 2005 14:34:45 -0000	1.4
@@ -144,6 +144,7 @@
 	delete from as_action_params where action_id=del__action_id;
 	
 	delete from as_actions where action_id = del__action_id;
+
         PERFORM acs_object__delete (del__action_id);	
 	return del__action_id;	
 
@@ -191,13 +192,13 @@
 	new__package_id
 	);
 
-v_parameter_id:= nextval(''as_action_params_parameter_id'');
+v_parameter_id:= nextval(''as_action_params_parameter_id'')+6;
 insert into as_action_params (parameter_id, action_id,type, varname, description) values (v_parameter_id,v_action_id,''n'',''first_names'',''First Names of the User'');
-v_parameter_id:= nextval(''as_action_params_parameter_id'');
+v_parameter_id:= nextval(''as_action_params_parameter_id'')+6;
 insert into as_action_params (parameter_id, action_id,type, varname, description) values (v_parameter_id,v_action_id,''n'',''last_name'',''Last Name of the User'');
-v_parameter_id:= nextval(''as_action_params_parameter_id'');
+v_parameter_id:= nextval(''as_action_params_parameter_id'')+6;
 insert into as_action_params (parameter_id, action_id,type, varname, description) values (v_parameter_id,v_action_id,''n'',''email'',''Email of the User'');
-v_parameter_id:= nextval(''as_action_params_parameter_id'');
+v_parameter_id:= nextval(''as_action_params_parameter_id'')+6;
 insert into as_action_params (parameter_id, action_id,type, varname, description) values (v_parameter_id,v_action_id,''n'',''user_name'',''User name of the User'');
 
 v_action_id:= as_action__new (
@@ -211,7 +212,7 @@
 	new__package_id
 	);
 
-v_parameter_id:= nextval(''as_action_params_parameter_id'');
+v_parameter_id:= nextval(''as_action_params_parameter_id'')+6;
 insert into as_action_params (parameter_id, action_id,type, varname, description,query) values (v_parameter_id,v_action_id,''q'',''event_id'',''Event to add the user'', ''select event_id,event_id from acs_events'');
 
 v_action_id:= as_action__new (
@@ -227,7 +228,7 @@
 	new__package_id
 	);
 
-v_parameter_id:= nextval(''as_action_params_parameter_id'');
+v_parameter_id:= nextval(''as_action_params_parameter_id'')+6;
 insert into as_action_params (parameter_id, action_id,type, varname, description,query) values (v_parameter_id,v_action_id,''q'',''community_id'',''Community to add the user'', ''select pretty_name,community_id from dotlrn_communities'');
 
 	return v_action_id;