Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql	28 Mar 2001 02:15:10 -0000	1.2
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql	29 Mar 2001 01:21:03 -0000	1.3
@@ -83,10 +83,8 @@
        on i.item_id = s.symlink_id'';
 
     execute ''alter table cr_folders add
-      has_child_folders char(1)
-			default \\\'\\\'f\\\'\\\'
-			constraint cr_folder_child_chk
-			check (has_child_folders in (\\\'\\\'t\\\'\\\',\\\'\\\'f\\\'\\\'))'';
+      has_child_folders boolean
+			default \\\'\\\'f\\\'\\\''';
 
     execute ''update cr_folders f set has_child_folders =
       coalesce((select \\\'\\\'t\\\'\\\' from dual where exists
@@ -116,7 +114,7 @@
 
     raise NOTICE ''Creating CR_TEXT table for incoming text submissions...'';
 
-    execute ''create table cr_text ( text varchar(4000) )'';
+    execute ''create table cr_text ( text text default \\\'\\\' not null )'';
 
     -- For some reason a simple insert statement throws an error but this works
     execute ''insert into cr_text values (NULL)'';