From 54dc87b8451e037295e9d3a0449e9ab51e9f1955 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Wed, 22 Nov 2006 06:50:27 +0000
Subject: [PATCH] adding 2 new fields 1) field for alt tag for user image, 2)
 field for a flag to tell moodle whehter the user uses a screen reader

---
 lib/db/install.xml |  6 ++++--
 lib/db/upgrade.php | 18 ++++++++++++++++++
 version.php        |  2 +-
 3 files changed, 23 insertions(+), 3 deletions(-)

diff --git a/lib/db/install.xml b/lib/db/install.xml
index 0ba18ccce3..d49122367b 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="lib/db" VERSION="20061120" COMMENT="XMLDB file for core Moodle tables"
+<XMLDB PATH="lib/db" VERSION="20061122" COMMENT="XMLDB file for core Moodle tables"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd"
 >
@@ -599,7 +599,9 @@
         <FIELD NAME="autosubscribe" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="true" DEFAULT="1" SEQUENCE="false" ENUM="false" PREVIOUS="ajax" NEXT="trackforums"/>
         <FIELD NAME="trackforums" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="autosubscribe" NEXT="timemodified"/>
         <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="trackforums" NEXT="trustbitmask"/>
-        <FIELD NAME="trustbitmask" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="timemodified"/>
+        <FIELD NAME="trustbitmask" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="timemodified" NEXT="imagealt"/>
+        <FIELD NAME="imagealt" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false" ENUM="false" COMMENT="alt tag for user uploaded image" PREVIOUS="trustbitmask" NEXT="screenreader"/>
+        <FIELD NAME="screenreader" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" COMMENT="flag for determining whehter the user uses a screenreader." PREVIOUS="imagealt"/>
       </FIELDS>
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for user"/>
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index a4823f05c7..c0e34de977 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -92,6 +92,24 @@ function xmldb_main_upgrade($oldversion=0) {
     /// Launch add field attachment
         $result = $result && add_field($table, $field);
     }
+    
+    if ($result && $oldversion < 2006112200) {
+
+    /// Define field imagealt to be added to user
+        $table = new XMLDBTable('user');
+        $field = new XMLDBField('imagealt');
+        $field->setAttributes(XMLDB_TYPE_CHAR, '255', null, null, null, null, null, null, 'trustbitmask');
+
+    /// Launch add field imagealt
+        $result = $result && add_field($table, $field);
+        
+        $table = new XMLDBTable('user');
+        $field = new XMLDBField('screenreader');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, null, null, '0', 'imagealt');
+
+    /// Launch add field screenreader
+        $result = $result && add_field($table, $field);
+    }
 
     return $result;
 
diff --git a/version.php b/version.php
index 5bc6592021..5e6e0c2ee8 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 = 2006112000;  // YYYYMMDD = date
+   $version = 2006112200;  // YYYYMMDD = date
                            //       XY = increments within a single day
 
    $release = '1.8 dev';    // Human-friendly version name
-- 
2.39.5