Index: openacs-4/packages/curriculum-central/sql/postgresql/stream-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/sql/postgresql/stream-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/curriculum-central/sql/postgresql/stream-create.sql	22 Jan 2006 08:43:15 -0000	1.2
+++ openacs-4/packages/curriculum-central/sql/postgresql/stream-create.sql	2 Feb 2006 11:45:49 -0000	1.3
@@ -46,7 +46,6 @@
 			constraint cc_stream_stream_name_un unique,
 	stream_code 	varchar(256),
 	year_ids	varchar(256),
-	semester_ids	varchar(256),
 	department_id	integer
 			constraint cc_stream_department_id_fk
 			references cc_department(department_id)
@@ -103,10 +102,20 @@
 drop function inline_1 ();
 
 
-select define_function_args('cc_stream__new', 'stream_id,coordinator_id,object_type,stream_name,stream_code,year_ids,semester_ids,department_id,creation_user,creation_ip,package_id');
+select define_function_args('cc_stream__new', 'stream_id,coordinator_id,object_type,stream_name,stream_code,year_ids,department_id,creation_user,creation_ip,package_id');
 
-create function cc_stream__new(integer, integer, varchar, varchar, varchar, varchar, varchar, integer, integer, varchar, integer)
-returns integer as'
+create function cc_stream__new(
+	integer,	-- stream_id
+	integer,	-- coordinator_id
+	varchar,	-- object_type
+	varchar,	-- stream_name
+	varchar,	-- stream_code
+	varchar,	-- year_ids
+	integer,	-- department_id
+	integer,	-- creation_user
+	varchar,	-- creation_ip
+	integer		-- package_id
+) returns integer as'
 
 declare
 
@@ -116,11 +125,10 @@
 	p_stream_name		alias for $4;
 	p_stream_code		alias for $5;
 	p_year_ids		alias for $6;
-	p_semester_ids		alias for $7;
-	p_department_id		alias for $8;
-	p_creation_user		alias for $9;
-	p_creation_ip		alias for $10;
-	p_package_id		alias for $11;
+	p_department_id		alias for $7;
+	p_creation_user		alias for $8;
+	p_creation_ip		alias for $9;
+	p_package_id		alias for $10;
 
 	v_stream_id		cc_stream.stream_id%TYPE;
 begin
@@ -134,7 +142,7 @@
 			p_package_id
 		);
 
-	insert into cc_stream values(v_stream_id, p_coordinator_id, p_stream_name, p_stream_code, p_year_ids, p_semester_ids, p_department_id,  p_package_id);
+	insert into cc_stream values(v_stream_id, p_coordinator_id, p_stream_name, p_stream_code, p_year_ids, p_department_id,  p_package_id);
 	
 	PERFORM acs_permission__grant_permission(
           v_stream_id,
