From e53c030b7a668922d460ffc2b3d1ec5649c913bd Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 28 Dec 2004 08:56:20 +0000
Subject: [PATCH] Added format field for messages

---
 lib/db/mysql.php     | 5 +++++
 lib/db/mysql.sql     | 2 ++
 lib/db/postgres7.php | 5 +++++
 lib/db/postgres7.sql | 2 ++
 version.php          | 2 +-
 5 files changed, 15 insertions(+), 1 deletion(-)

diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index 0879b42699..bb7b299d70 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -1081,6 +1081,11 @@ function main_upgrade($oldversion=0) {
         modify_database('', "INSERT INTO prefix_log_display VALUES ('message', 'read', 'user', 'CONCAT(firstname,\" \",lastname)'); ");
     }
 
+    if ($oldversion < 2004122801) {
+        table_column('message', '', 'format', 'integer', '4', 'unsigned', '0', 'not null', 'message');
+        table_column('message_read', '', 'format', 'integer', '4', 'unsigned', '0', 'not null', 'message');
+    }
+
     return $result;
 
 }
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 3bc9254cb7..80f3a40fb0 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -309,6 +309,7 @@ CREATE TABLE `prefix_message` (
   `useridfrom` int(10) NOT NULL default '0',
   `useridto` int(10) NOT NULL default '0',
   `message` text NOT NULL,
+  `format` int(4) unsigned NOT NULL default '0',
   `timecreated` int(10) NOT NULL default '0',
   `messagetype` varchar(50) NOT NULL default '',
   PRIMARY KEY  (`id`),
@@ -326,6 +327,7 @@ CREATE TABLE `prefix_message_read` (
   `useridfrom` int(10) NOT NULL default '0',
   `useridto` int(10) NOT NULL default '0',
   `message` text NOT NULL,
+  `format` int(4) unsigned NOT NULL default '0',
   `timecreated` int(10) NOT NULL default '0',
   `timeread` int(10) NOT NULL default '0',
   `messagetype` varchar(50) NOT NULL default '',
diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php
index f023853372..fa2e276ddd 100644
--- a/lib/db/postgres7.php
+++ b/lib/db/postgres7.php
@@ -853,6 +853,11 @@ function main_upgrade($oldversion=0) {
                             INSERT INTO prefix_log_display VALUES ('message', 'read', 'user', 'firstname||\' \'||lastname');
                             ");
     }
+
+    if ($oldversion < 2004122801) {
+        table_column('message', '', 'format', 'integer', '4', 'unsigned', '0', 'not null', 'message');
+        table_column('message_read', '', 'format', 'integer', '4', 'unsigned', '0', 'not null', 'message');
+    }
        
                                 
     return $result;
diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index 22de7fb9e0..7d53ae5aaf 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -187,6 +187,7 @@ CREATE TABLE prefix_message (
    useridfrom integer NOT NULL default '0',
    useridto integer NOT NULL default '0',
    message text,
+   format integer NOT NULL default '0',
    timecreated integer NOT NULL default '0',
    messagetype varchar(50) NOT NULL default ''
 );
@@ -199,6 +200,7 @@ CREATE TABLE prefix_message_read (
    useridfrom integer NOT NULL default '0',
    useridto integer NOT NULL default '0',
    message text,
+   format integer NOT NULL default '0',
    timecreated integer NOT NULL default '0',
    timeread integer NOT NULL default '0',
    messagetype varchar(50) NOT NULL default '',
diff --git a/version.php b/version.php
index f1a3dd0609..5587576ae8 100644
--- a/version.php
+++ b/version.php
@@ -6,7 +6,7 @@
 // This is compared against the values stored in the database to determine 
 // whether upgrades should be performed (see lib/db/*.php)
 
-   $version = 2004122800;  // YYYYMMDD = date of first major branch release 1.4
+   $version = 2004122801;  // YYYYMMDD = date of first major branch release 1.4
                            //       XY = increments within a single day
 
    $release = '1.5 UNSTABLE DEVELOPMENT';    // Human-friendly version name
-- 
2.39.5