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 -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 Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.7.0d2-5.7.0d3.sql'. Fisheye: No comparison available. Pass `N' to diff? 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 -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 -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;