From ac4e96fccda0b96330ff59ae9bfcc826d406056b Mon Sep 17 00:00:00 2001
From: donal72 <donal72>
Date: Tue, 2 Oct 2007 15:43:11 +0000
Subject: [PATCH] New database fields in mnet_host for roaming themes

---
 lib/db/install.xml |  4 ++++
 lib/db/upgrade.php | 19 +++++++++++++++++++
 2 files changed, 23 insertions(+)

diff --git a/lib/db/install.xml b/lib/db/install.xml
index 07db7edca0..b5313dbedb 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -1091,6 +1091,10 @@
         <FIELD NAME="transport" TYPE="int" LENGTH="2" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="public_key_expires" NEXT="portno"/>
         <FIELD NAME="portno" TYPE="int" LENGTH="2" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="transport" NEXT="last_connect_time"/>
         <FIELD NAME="last_connect_time" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="portno" NEXT="last_log_id"/>
+        <FIELD NAME="last_log_id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="last_connect_time" NEXT="force_theme"/>
+        <FIELD NAME="force_theme" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="last_log_id" NEXT="theme"/>
+        <FIELD NAME="theme" TYPE="char" LENGTH="100" NOTNULL="true" UNSIGNED="true" DEFAULT="" SEQUENCE="false" ENUM="false" PREVIOUS="force_theme"/>
+       </FIELDS>
         <FIELD NAME="last_log_id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="last_connect_time" NEXT="applicationid"/>
         <FIELD NAME="applicationid" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="1" SEQUENCE="false" ENUM="false" PREVIOUS="last_log_id"/>
       </FIELDS>
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index b33c07f1ef..281ddf1b7b 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -2299,6 +2299,25 @@ function xmldb_main_upgrade($oldversion=0) {
     }
 */
 
+    if ($oldversion < 2007091300) {
+        //
+        // MNET stuff for roaming theme
+        //
+        $table = new XMLDBTable('mnet_host');
+
+        $field = new XMLDBField('force_theme');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, null, null, '0', 'last_log_id');
+
+        // Launch add field theme
+        $result = $result && add_field($table, $field);
+
+        $field = new XMLDBField('theme');
+        $field->setAttributes(XMLDB_TYPE_CHAR, '100', null, null, null, null, null, null, 'force_theme');
+
+        // Launch add field force_theme
+        $result = $result && add_field($table, $field);
+    }
+
     return $result;
 }
 
-- 
2.39.5