Index: openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql,v
diff -u -r1.9.4.1 -r1.9.4.2
--- openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	22 Jun 2004 16:53:43 -0000	1.9.4.1
+++ openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	30 Jun 2004 20:24:10 -0000	1.9.4.2
@@ -31,6 +31,8 @@
     state                           varchar(100)
                                     constraint forum_mess_state_ck
                                     check (state in ('pending','approved','rejected')),
+    format                          varchar2(30)
+                                    default 'text/plain',
     -- Hierarchy of messages
     parent_id                       integer
                                     constraint forum_mess_parent_id_fk
Index: openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.0d4-1.0.1d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.0d4-1.0.1d2.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.0d4-1.0.1d2.sql	22 Jun 2004 16:53:43 -0000	1.1.2.1
+++ openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.0d4-1.0.1d2.sql	30 Jun 2004 20:24:10 -0000	1.1.2.2
@@ -1,5 +1,9 @@
-alter table forums_messages add format varchar2(30) default 'text/plain';
+alter table forums_messages add format varchar(30);
+alter table forums_messages alter column format set default 'text/plain';
 
+alter table forums_messages add constraint forums_mess_format_ck check (format in ('text/enhanced', 'text/plain', 'text/fixed-width', 'text/html'));
+alter table forums_messages drop column html_p;
+
 update forums_messages
 set format = 'text/html'
 where html_p = 't';