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