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.4 -r1.5 --- openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql 5 Feb 2008 14:25:39 -0000 1.4 +++ openacs-4/packages/acs-kernel/sql/postgresql/site-node-object-map-create.sql 7 Jun 2008 20:28:52 -0000 1.5 @@ -8,14 +8,16 @@ create table site_node_object_mappings ( object_id integer constraint snom_object_id_fk - references acs_objects (object_id) on update cascade on delete cascade + 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 );