Index: openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0a11-5.1.0a12.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0a11-5.1.0a12.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0a11-5.1.0a12.sql	13 Dec 2004 16:33:53 -0000	1.1.2.1
@@ -0,0 +1,38 @@
+-- @author Andrew Grumet (aegrumet@alum.mit.edu)
+-- @creation-date 7 Dec 2004
+
+-- RSS feeds are assigned on a per-folder basis.  fs_rss_subscrs is an
+-- extension table for rss_gen_subscrs, storing additional parameters
+-- governing how the RSS feed for each folder will be generated.
+create table fs_rss_subscrs (
+    -- This points back to rss_gen_subscrs but we're going to
+    -- leave out the referential integrity to avoid requiring that
+    -- RSS support be installed.
+    subscr_id                     integer
+                                  constraint fs_rss_subscrs_pk
+                                  primary key,
+    folder_id                     integer
+                                  constraint fs_rss_subscrs_fldr_nn
+                                  not null
+                                  constraint fs_rss_subscrs_fldr_fk
+                                  references cr_folders(folder_id),
+    -- To be displayed next to the XML button on the folder view page.
+    short_name                    varchar(80)
+                                  constraint fs_rss_subscrs_short_nn
+                                  not null,
+    feed_title                    varchar(200)
+                                  constraint fs_rss_subscrs_title_nn
+                                  not null,
+    max_items                     integer default 15
+                                  constraint fs_rss_subscrs_mx_nn
+                                  not null,
+    descend_p                     boolean default 't'
+                                  constraint fs_rss_subscrs_desc_nn
+                                  not null,
+    include_revisions_p           boolean default 'f'
+                                  constraint fs_rss_subscrs_incl_nn
+                                  not null,
+    -- Add an enclosure if the filename matches one of these patterns.
+    -- Leave empty for no enclosures, set to * for all files.
+    enclosure_match_patterns      varchar(200)
+);
