Index: openacs-4/packages/acs-subsite/sql/oracle/host-node-map-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/host-node-map-create.sql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-subsite/sql/oracle/host-node-map-create.sql	10 Oct 2001 17:51:55 -0000	1.1
+++ openacs-4/packages/acs-subsite/sql/oracle/host-node-map-create.sql	6 Jan 2003 20:18:31 -0000	1.1.4.1
@@ -1,10 +1,10 @@
 -- @author Mark Dettinger (mdettinger@arsdigita.com)
+-- $Id$
 
 create table host_node_map (
-   host                 varchar(200),
+   host                 varchar(200) 
+	constraint host_node_map_host_pk primary key 
+	constraint host_node_map_host_nn not null,
    node_id              integer 
-			constraint host_node_map_node_id_fk
-                        references acs_objects (object_id)
-                        constraint host_node_map_node_id_pk
-                        primary key
+	constraint host_node_map_node_id_fk references site_nodes
 );
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.1.4.1
--- 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	6 Jan 2003 20:19:01 -0000	1.1.4.1
@@ -1,8 +1,10 @@
 -- @author Mark Dettinger (mdettinger@arsdigita.com)
+-- $Id$
 
 create table host_node_map (
-   host                 varchar(200),
+   host                 varchar(200) 
+	constraint host_node_map_host_pk primary key 
+	constraint host_node_map_host_nn not null,
    node_id              integer 
-			constraint host_node_map_pk primary key
-			constraint host_node_map_fk references acs_objects (object_id)
+	constraint host_node_map_node_id_fk references site_nodes
 );