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.10 -r1.11
--- openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	29 Jun 2004 10:18:29 -0000	1.10
+++ openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	12 Jul 2004 14:49:59 -0000	1.11
@@ -31,6 +31,8 @@
     state                           varchar(100)
                                     constraint forum_mess_state_ck
                                     check (state in ('pending','approved','rejected')),
+    format                          varchar(30)
+                                    default 'text/plain',
     -- Hierarchy of messages
     parent_id                       integer
                                     constraint forum_mess_parent_id_fk
@@ -56,19 +58,19 @@
 create index forums_messages_parent_id_idx on forums_messages(parent_id);
 create index forum_messages_date_idx on forums_messages (forum_id, posting_date);
 
-create view forums_messages_approved
+create or replace view forums_messages_approved
 as
     select *
     from forums_messages
     where state = 'approved';
 
-create view forums_messages_pending
+create or replace view forums_messages_pending
 as
     select *
     from forums_messages
     where state= 'pending';
 
-create function inline_0 ()
+create or replace function inline_0 ()
 returns integer as '
 begin
     perform acs_object_type__create_type(
