Index: openacs-4/packages/acs-subsite/sql/postgresql/host-node-map-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/host-node-map-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/sql/postgresql/host-node-map-create.sql	10 Oct 2001 18:04:35 -0000	1.1
+++ openacs-4/packages/acs-subsite/sql/postgresql/host-node-map-create.sql	24 Oct 2002 21:34:07 -0000	1.2
@@ -1,8 +1,10 @@
 -- @author Mark Dettinger (mdettinger@arsdigita.com)
+-- @author Eric Lorenzo (eric@openforce.net)
 
 create table host_node_map (
-   host                 varchar(200),
-   node_id              integer 
-			constraint host_node_map_pk primary key
-			constraint host_node_map_fk references acs_objects (object_id)
+   host         varchar(200)
+                constraint host_node_map_pk primary key,
+   node_id      integer not null
+                constraint host_node_map_fk
+                           references acs_objects (object_id)
 );
