From ec75a182db02fbdf391c58ce67491f140b13c4ae Mon Sep 17 00:00:00 2001
From: ikawhero <ikawhero>
Date: Wed, 2 May 2007 06:50:28 +0000
Subject: [PATCH] New field for category themes

---
 lib/db/install.xml |  5 +++--
 lib/db/upgrade.php | 11 +++++++++++
 version.php        |  2 +-
 3 files changed, 15 insertions(+), 3 deletions(-)

diff --git a/lib/db/install.xml b/lib/db/install.xml
index b11d398b13..cce42d062a 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -94,7 +94,8 @@
         <FIELD NAME="visible" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="false" DEFAULT="1" SEQUENCE="false" ENUM="false" PREVIOUS="coursecount" NEXT="timemodified"/>
         <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="visible" NEXT="depth"/>
         <FIELD NAME="depth" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="timemodified" NEXT="path"/>
-        <FIELD NAME="path" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="depth"/>
+        <FIELD NAME="path" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="depth" NEXT="theme"/>
+        <FIELD NAME="theme" TYPE="char" LENGTH="50" NOTNULL="false" SEQUENCE="false" ENUM="false" COMMENT="Theme for the category" PREVIOUS="path"/>
       </FIELDS>
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for course_categories" NEXT="parent"/>
@@ -1423,4 +1424,4 @@
       </SENTENCES>
     </STATEMENT>
   </STATEMENTS>
-</XMLDB>
\ No newline at end of file
+</XMLDB>
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 712aed56b0..6840ef82dd 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -1141,6 +1141,17 @@ function xmldb_main_upgrade($oldversion=0) {
         $result = $result && add_field($table, $field);
     }
 
+    if ($result && $oldversion < 2007050201) {
+
+    /// Define field theme to be added to course_categories
+        $table = new XMLDBTable('course_categories');
+        $field = new XMLDBField('theme');
+        $field->setAttributes(XMLDB_TYPE_CHAR, '50', null, null, null, null, null, null, 'path');
+
+    /// Launch add field theme
+        $result = $result && add_field($table, $field);
+    }
+
     return $result;
 
 }
diff --git a/version.php b/version.php
index c6fe687a31..244b6b9795 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 = 2007050200;  // YYYYMMDD = date
+   $version = 2007050201;  // YYYYMMDD = date
                            //       XY = increments within a single day
 
    $release = '1.9 dev';    // Human-friendly version name
-- 
2.39.5