Index: openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql	24 Nov 2010 15:21:43 -0000	1.7
+++ openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql	24 Nov 2010 18:58:45 -0000	1.8
@@ -28,7 +28,7 @@
                         primary key,
         parent_id       constraint site_nodes_parent_id_fk
                         references site_nodes (node_id),
-        name            varchar2(100) constraint site_nodes_name_nn null
+        name            varchar2(100)
                         constraint site_nodes_name_ck
                         check (name not like '%/%'),
         constraint site_nodes_un
Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.7.0d2-5.7.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/Attic/upgrade-5.7.0d2-5.7.0d3.sql,v
diff -u -N
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.7.0d2-5.7.0d3.sql	24 Nov 2010 15:21:43 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,9 +0,0 @@
--- 
--- 
--- 
--- @author Victor Guerra (vguerra@gmail.com)
--- @creation-date 2010-11-15
--- @cvs-id $Id: upgrade-5.7.0d2-5.7.0d3.sql,v 1.1 2010/11/24 15:21:43 victorg Exp $
---
-
-alter table site_nodes modify (name not null);
Index: openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql,v
diff -u -N -r1.23 -r1.24
--- openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql	24 Nov 2010 15:21:43 -0000	1.23
+++ openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql	24 Nov 2010 18:58:45 -0000	1.24
@@ -44,7 +44,6 @@
         parent_id       integer constraint site_nodes_parent_id_fk
                         references site_nodes (node_id),
         name            varchar(100) 
-                        constraint site_nodes_name_nn not null
                         constraint site_nodes_name_ck
                         check (name not like '%/%'),
         constraint site_nodes_un
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d2-5.7.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d2-5.7.0d3.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d2-5.7.0d3.sql	24 Nov 2010 15:21:43 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d2-5.7.0d3.sql	24 Nov 2010 18:58:45 -0000	1.2
@@ -79,4 +79,3 @@
 
 end;' language 'plpgsql';
 
-alter table site_nodes alter column name set not null;