Index: openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql,v
diff -u -r1.2.2.1 -r1.2.2.2
--- openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql	28 Dec 2005 17:55:43 -0000	1.2.2.1
+++ openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql	4 Jan 2006 16:48:04 -0000	1.2.2.2
@@ -37,6 +37,7 @@
         aggregator_bottom       integer
 );
 
+create index na_aggregators_package_id_idx on na_aggregators(package_id);
 
 select acs_object_type__create_type (
     'na_aggregator',                  -- object_type
@@ -143,6 +144,8 @@
        constraint na_saved_items_pk primary key(item_id, aggregator_id)
 );
 
+create index na_saved_items_aggregator_id_idx on na_saved_items(aggregator_id);
+
 create table na_purges (
        purge_id	       integer
 		       constraint na_purges_pk
@@ -163,8 +166,8 @@
 );
 
 create sequence na_purges_seq;
+create index na_purges_aggregator_id_idx on na_purges(aggregator_id);
 
-
 ----------------
 --
 -- Subscriptions
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.6b-0.9.7.sql'.
Fisheye: No comparison available.  Pass `N' to diff?