Index: openacs-4/packages/rss-support/sql/postgresql/rss-generation-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/sql/postgresql/rss-generation-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/rss-support/sql/postgresql/rss-generation-create.sql	7 Nov 2001 04:42:15 -0000	1.5
+++ openacs-4/packages/rss-support/sql/postgresql/rss-generation-create.sql	19 Nov 2001 04:02:28 -0000	1.6
@@ -108,11 +108,15 @@
 				  references acs_sc_impls(impl_id),
    summary_context_id		  varchar(100)
 				  constraint rss_gen_subscrs_ctx_nn
-				  not null,
+				  not null
+				  constraint rss_gen_subscrs_ctx_fk
+                                  references acs_objects(object_id),
    timeout			  integer
 				  constraint rss_gen_subscrs_timeout_nn
 				  not null,
-   lastbuild			  timestamp
+   lastbuild			  timestamp,
+   constraint rss_gen_subscrs_impl_con_un
+   unique (impl_id,summary_context_id)
 );
 
 comment on table rss_gen_subscrs is '
@@ -178,6 +182,14 @@
 
 end;' language 'plpgsql';
 
+create function rss_gen_subscr__name (integer)
+returns varchar as '
+declare
+  p_subscr_id				alias for $1;
+begin
+	return ''RSS Generation Subscription #'' || p_subscr_id;
+end;' language 'plpgsql';
+
 create function rss_gen_subscr__delete (integer)
 returns integer as '
 declare
