Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -r1.108 -r1.109
--- openacs-4/packages/acs-kernel/acs-kernel.info	4 Jan 2010 19:54:37 -0000	1.108
+++ openacs-4/packages/acs-kernel/acs-kernel.info	5 Mar 2010 12:22:07 -0000	1.109
@@ -7,15 +7,15 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
     
-    <version name="5.6.0d4" url="http://openacs.org/repository/download/apm/acs-kernel-5.6.0d4.apm">
+    <version name="5.6.0d5" url="http://openacs.org/repository/download/apm/acs-kernel-5.6.0d5.apm">
         <owner url="mailto:oct@openacs.org">OpenACS Core Team</owner>
         <summary>Routines and data models providing the foundation for OpenACS-based Web services.</summary>
         <release-date>2009-06-19</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/html">The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, partiies and the supporting PL/SQL and PL/pgSQL procedures.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.6.0d4"/>
+        <provides url="acs-kernel" version="5.6.0d5"/>
 
         <callbacks>
         </callbacks>
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d4-5.4.0d5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d4-5.4.0d5.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d4-5.4.0d5.sql	7 Jun 2008 20:28:52 -0000	1.2
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.4.0d4-5.4.0d5.sql	5 Mar 2010 12:22:07 -0000	1.3
@@ -3,4 +3,4 @@
 ALTER TABLE site_node_object_mappings ADD CONSTRAINT snom_object_id_fk FOREIGN KEY (object_id) REFERENCES acs_objects (object_id) ON UPDATE CASCADE ON DELETE CASCADE;
 
 ALTER TABLE site_node_object_mappings DROP CONSTRAINT snom_node_id_fk;
-ALTER TABLE site_node_object_mappings ADD CONSTRAINT snom_node_id_fk FOREIGN KEY (object_id) REFERENCES acs_objects (object_id) ON UPDATE CASCADE ON DELETE CASCADE;
+ALTER TABLE site_node_object_mappings ADD CONSTRAINT snom_node_id_fk FOREIGN KEY (node_id) REFERENCES site_nodes (node_id) ON UPDATE CASCADE ON DELETE CASCADE;
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d4-5.6.0d5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d4-5.6.0d5.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d4-5.6.0d5.sql	5 Mar 2010 12:22:07 -0000	1.1
@@ -0,0 +1,3 @@
+-- fixing snom_node_id_fk
+ALTER TABLE site_node_object_mappings DROP CONSTRAINT snom_node_id_fk;
+ALTER TABLE site_node_object_mappings ADD CONSTRAINT snom_node_id_fk FOREIGN KEY (node_id) REFERENCES site_nodes (node_id) ON UPDATE CASCADE ON DELETE CASCADE;