Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	29 Mar 2001 01:21:03 -0000	1.3
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	29 Mar 2001 02:46:30 -0000	1.4
@@ -43,11 +43,11 @@
 --------------------------------------------------------------
 
 create table cr_mime_types (
-  label			varchar(200),
+  label			varchar(200) default '' not null,
   mime_type	        varchar(200)
 			constraint cr_mime_types_pk
 			primary key,
-  file_extension        varchar(200)
+  file_extension        varchar(200) default '' not null
 );
 
 
@@ -100,8 +100,8 @@
   nls_language		varchar(30)
                         constraint cr_locale_nls_lang_nil
 			not null,
-  nls_territory		varchar(30),
-  nls_charset		varchar(30)
+  nls_territory		varchar(30) default '' not null,
+  nls_charset		varchar(30) default '' not null
 );
 
 comment on table cr_locales is '
@@ -128,7 +128,7 @@
   child_type    varchar(100)
 		constraint cr_type_children_child_fk
 		references acs_object_types,
-  relation_tag  varchar(100),
+  relation_tag  varchar(100) default '' not null,
   min_n         integer,
   max_n         integer,
   constraint cr_type_children_pk
@@ -147,7 +147,7 @@
   target_type   varchar(100)
 		constraint cr_type_relations_child_fk
 		references acs_object_types,
-  relation_tag  varchar(100),
+  relation_tag  varchar(100) default '' not null,
   min_n         integer,
   max_n         integer,
   constraint cr_type_relations_pk
@@ -225,7 +225,7 @@
   child_id           integer
                      constraint cr_child_rels_child_nil
                      not null,
-  relation_tag       varchar(100),
+  relation_tag       varchar(100) default '' not null,
   order_n            integer
 );
 
@@ -250,7 +250,7 @@
   related_object_id  integer
                      constraint cr_item_rels_rel_obj__fk
                      references acs_objects,
-  relation_tag       varchar(100),
+  relation_tag       varchar(100) default '' not null,
   order_n            integer
 );
 
@@ -290,16 +290,16 @@
                   constraint cr_revisions_item_id_fk references
 		  cr_items on delete cascade,
   title		  varchar(1000) default '' not null,
-  description	  text,
+  description	  text default '' not null,
   publish_date	  timestamp,
   mime_type	  varchar(200) default 'text/plain'
 		  constraint cr_revisions_mime_type_ref
 		  references cr_mime_types,
-  nls_language    varchar(50),
+  nls_language    varchar(50) default '' not null,
   -- use Don's postgresql lob hack for now.
   storage_type    varchar(10) default 'lob'
                   constraint cr_revisions_storage_type
-                  check (storage_type in ('lob','text')),
+                  check (storage_type in ('lob','text','file')),
   lob             integer,
   content	  text default '' not null,
   content_length  integer
@@ -335,7 +335,7 @@
                  primary key
                  constraint cr_revision_attributes_fk
                  references cr_revisions,
-  attributes     text
+  attributes     text default '' not null
 );
 
 comment on column cr_revision_attributes.attributes is '
@@ -373,8 +373,8 @@
   new_revision       integer
                      constraint cr_item_pub_audit_new_rev_fk
                      references cr_revisions, 
-  old_status         varchar(40),
-  new_status         varchar(40),
+  old_status         varchar(40) default '' not null,
+  new_status         varchar(40) default '' not null,
   publish_date       timestamp
                      constraint cr_item_publish_audit_date_nil
                      not null
@@ -402,7 +402,7 @@
   items_released   integer not null,
   items_expired    integer not null,
   err_num          integer,
-  err_msg          varchar(500)
+  err_msg          varchar(500) default '' not null
 );
 
 comment on table cr_scheduled_release_log is '
@@ -574,7 +574,7 @@
 		  references cr_items
 		  constraint cr_symlink_target_id_nil
 		  not null,
-  label		  varchar(1000)
+  label		  varchar(1000) default '' not null
 );
 
 create index cr_symlinks_by_target_id on cr_symlinks(target_id);
@@ -621,7 +621,7 @@
   heading		 varchar(600)
 			 constraint cr_keywords_name_nil
 			 not null,
-  description            text,
+  description            text default '' not null,
   has_children           boolean
 );
 
@@ -663,7 +663,7 @@
 --------------------------------------------------------------
 
 create table cr_text (
-  text text default '' not null
+  text_data  text
 );
 
 comment on table cr_text is '
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql	29 Mar 2001 01:21:03 -0000	1.3
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql	29 Mar 2001 02:46:30 -0000	1.4
@@ -436,7 +436,7 @@
   register_content_type__folder_id              alias for $1;  
   register_content_type__content_type           alias for $2;  
   register_content_type__include_subtypes       alias for $3;  
-  v_is_registered                               varchar(100);  
+  v_is_registered                               varchar;  
 begin
 
   if register_content_type__include_subtypes = ''f'' then
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	29 Mar 2001 01:21:03 -0000	1.4
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	29 Mar 2001 02:46:30 -0000	1.5
@@ -101,7 +101,7 @@
   drop_type__drop_children_p        alias for $2;  
   drop_type__drop_table_p           alias for $3;  
   table_exists                      boolean;       
-  v_table_name                      varchar(50);   
+  v_table_name                      varchar;   
   is_subclassed_p                   boolean;      
   child_rec                         record;    
   attr_row                          record;
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.3 -r1.4
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql	29 Mar 2001 01:21:03 -0000	1.3
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql	29 Mar 2001 02:46:30 -0000	1.4
@@ -183,7 +183,7 @@
 	items_released   integer not null,
 	items_expired    integer not null,
 	err_num          integer,
-	err_msg          varchar(500)
+	err_msg          varchar(500) default \\\'\\\' not null
       )'';
 
   end if;
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-xml.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-xml.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-xml.sql	25 Mar 2001 01:22:49 -0000	1.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-xml.sql	29 Mar 2001 02:46:30 -0000	1.2
@@ -22,7 +22,7 @@
 
 create table cr_xml_docs (
     doc_id        integer primary key,
-    doc           text
+    doc           text default '' not null
 );
 
 comment on table cr_xml_docs is '