From c13edeca6a8a4d7f2e8b152ead9fb28005a30db3 Mon Sep 17 00:00:00 2001
From: paca70 <paca70>
Date: Sat, 27 Mar 2004 13:08:21 +0000
Subject: [PATCH] Added default values

---
 mod/chat/db/postgres7.sql     | 4 ++--
 mod/dialogue/db/postgres7.sql | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/mod/chat/db/postgres7.sql b/mod/chat/db/postgres7.sql
index 7b54e6749e..bbdca03d58 100644
--- a/mod/chat/db/postgres7.sql
+++ b/mod/chat/db/postgres7.sql
@@ -6,7 +6,7 @@ CREATE TABLE prefix_chat (
   id SERIAL,
   course INTEGER NOT NULL default '0',
   name varchar(255) NOT NULL default '',
-  intro text NOT NULL,
+  intro text NOT NULL default '',
   keepdays INTEGER NOT NULL default '0',
   studentlogs INTEGER NOT NULL default '0',
   chattime INTEGER NOT NULL default '0',
@@ -26,7 +26,7 @@ CREATE TABLE prefix_chat_messages (
   userid integer NOT NULL default '0',
   groupid integer NOT NULL default '0',
   system integer NOT NULL default '0',
-  message text NOT NULL,
+  message text NOT NULL default '',
   timestamp integer NOT NULL default '0',
   PRIMARY KEY  (id)
 );
diff --git a/mod/dialogue/db/postgres7.sql b/mod/dialogue/db/postgres7.sql
index 494bb89ae5..6a8bcbf526 100644
--- a/mod/dialogue/db/postgres7.sql
+++ b/mod/dialogue/db/postgres7.sql
@@ -64,7 +64,7 @@ CREATE TABLE prefix_dialogue_entries (
   userid INT8  NOT NULL default '0',
   timecreated INT8  NOT NULL default '0',
   mailed INT2  NOT NULL default '0',
-  text text NOT NULL
+  text text NOT NULL default ''
 ) ;
 CREATE INDEX prefix_dialogue_entries_conversationid_idx ON prefix_dialogue_entries  (conversationid) ;
 
-- 
2.39.5