Index: openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql,v
diff -u -r1.3 -r1.3.18.1
--- openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql	18 Jul 2002 18:51:37 -0000	1.3
+++ openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql	6 Feb 2008 08:46:01 -0000	1.3.18.1
@@ -9,13 +9,15 @@
     object_id                       integer
                                     constraint snom_object_id_fk
                                     references acs_objects (object_id)
+                                    on update cascade on delete cascade
                                     constraint snom_object_id_nn
                                     not null
                                     constraint site_node_object_mappings_pk
                                     primary key,
     node_id                         integer
                                     constraint snom_node_id_fk
                                     references site_nodes (node_id)
+                                    on update cascade on delete cascade
                                     constraint snom_node_id_nn
                                     not null
 );