Index: openacs-4/packages/categories/categories.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/categories.info,v
diff -u -N -r1.21.2.8 -r1.21.2.9
--- openacs-4/packages/categories/categories.info	17 Aug 2022 10:32:05 -0000	1.21.2.8
+++ openacs-4/packages/categories/categories.info	6 Oct 2022 16:34:33 -0000	1.21.2.9
@@ -10,7 +10,7 @@
     <inherit-templates-p>t</inherit-templates-p>
     <auto-mount>categories</auto-mount>
 
-    <version name="1.1.5d5" url="http://openacs.org/repository/apm/packages/categories-1.1.5d5">
+    <version name="1.1.5d6" url="http://openacs.org/repository/apm/packages/categories-1.1.5d6">
         <owner url="mailto:timo@timohentschel.de">timo@timohentschel.de</owner>
         <summary>Manage categories in category trees and let users map objects to categories.</summary>
         <release-date>2021-09-15</release-date>
@@ -19,7 +19,7 @@
         <license>GPL</license>
         <maturity>1</maturity>
 
-        <provides url="categories" version="1.1.5d5"/>
+        <provides url="categories" version="1.1.5d6"/>
         <requires url="acs-kernel" version="5.10.0"/>
 	<requires url="acs-tcl" version="5.10.1d16"/>
 
Index: openacs-4/packages/categories/sql/postgresql/categories-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/categories-create.sql,v
diff -u -N -r1.12 -r1.12.2.1
--- openacs-4/packages/categories/sql/postgresql/categories-create.sql	7 Aug 2017 23:48:05 -0000	1.12
+++ openacs-4/packages/categories/sql/postgresql/categories-create.sql	6 Oct 2022 16:34:33 -0000	1.12.2.1
@@ -209,6 +209,10 @@
 
 create unique index cat_object_map_ix on category_object_map(object_id, category_id);
 
+-- create indices on FK constraints
+create index category_object_map_object_id_idx on category_object_map(object_id);
+create index category_object_map_category_id_idx on category_object_map(category_id);
+
 comment on table category_object_map is '
   Maps categories to objects and thus categorizes and object.
 ';
Index: openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-1.1.5d5-1.1.5d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/upgrade/Attic/upgrade-1.1.5d5-1.1.5d6.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-1.1.5d5-1.1.5d6.sql	6 Oct 2022 16:34:33 -0000	1.1.2.1
@@ -0,0 +1,4 @@
+
+-- create indices on FK constraints
+create index IF NOT EXISTS category_object_map_object_id_idx on category_object_map(object_id);
+create index IF NOT EXISTS category_object_map_category_id_idx on category_object_map(category_id);