Index: openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql,v
diff -u -r1.3.6.1 -r1.3.6.2
--- openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql	23 Nov 2004 20:01:11 -0000	1.3.6.1
+++ openacs-4/packages/acs-subsite/sql/oracle/acs-subsite-create.sql	8 Mar 2005 19:17:33 -0000	1.3.6.2
@@ -13,7 +13,7 @@
 @@ subsite-callbacks-create
 @@ host-node-map-create
 @@ user-sc-create
-@@ site-node-delection
+@@ site-node-selection
 
 -- This view lets us avoid using acs_object.name to get party_names.
 -- 
Index: openacs-4/packages/acs-subsite/sql/oracle/site-node-selection.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/site-node-selection.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-subsite/sql/oracle/site-node-selection.sql	23 Nov 2004 20:01:11 -0000	1.1.2.1
+++ openacs-4/packages/acs-subsite/sql/oracle/site-node-selection.sql	8 Mar 2005 19:19:46 -0000	1.1.2.2
@@ -11,8 +11,9 @@
                         references acs_objects (object_id)
                         constraint site_node_sel_id_pk
                         primary key,
-	view_p		boolean
-
+	view_p		char(1)
+                constraint site_nodes_sel_view_p_ck
+                check (view_p in ('t','f'))
 );
 
 --show errors
\ No newline at end of file