Index: openacs-4/contrib/packages/portal/sql/oracle/portal-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/portal/sql/oracle/portal-core-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/contrib/packages/portal/sql/oracle/portal-core-create.sql 3 Jan 2004 01:42:57 -0000 1.2 +++ openacs-4/contrib/packages/portal/sql/oracle/portal-core-create.sql 27 Feb 2004 01:13:15 -0000 1.3 @@ -287,9 +287,7 @@ not null, sort_key integer constraint p_elements_sort_key_nn - not null - constraint p_elements_sort_key_ck - check (sort_key > 0), + not null, state varchar(6) default 'full' constraint p_elements_state_ck