Index: openacs-4/packages/new-portal/sql/oracle/portal-node-mapping-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/Attic/portal-node-mapping-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/new-portal/sql/oracle/portal-node-mapping-create.sql	13 Apr 2002 00:08:08 -0000	1.1
+++ openacs-4/packages/new-portal/sql/oracle/portal-node-mapping-create.sql	19 Apr 2002 19:40:39 -0000	1.2
@@ -25,14 +25,16 @@
 
 
 create table portal_node_mappings (
-       object_id                integer not null
-                                constraint portal_node_map_obj_id_fk
+       object_id                constraint portal_node_map_obj_id_fk
                                 references acs_objects(object_id)
+                                on delete cascade
                                 constraint portal_node_map_obj_id_pk
                                 primary key,
-       node_id                  integer not null
-                                constraint portal_node_map_node_id_fk
+       node_id                  constraint portal_node_map_node_id_fk
                                 references site_nodes(node_id)
+                                on delete cascade
+                                constraint portal_node_map_node_id_nn
+                                not null
 );
 
 
