From 32fe29c7f3afeca1dc83b0c4347e9145849574e0 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Mon, 13 Aug 2007 02:38:10 +0000
Subject: [PATCH] MDL-10821, making configdata nullable

---
 blocks/db/install.xml |  7 +++++--
 blocks/db/upgrade.php | 14 ++++++++++++++
 blocks/version.php    |  2 +-
 3 files changed, 20 insertions(+), 3 deletions(-)

diff --git a/blocks/db/install.xml b/blocks/db/install.xml
index b231f37fc6..ec2fbc3284 100644
--- a/blocks/db/install.xml
+++ b/blocks/db/install.xml
@@ -1,5 +1,8 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="blocks/db" VERSION="20060809" COMMENT="XMLDB file for Moodle block tables">
+<XMLDB PATH="blocks/db" VERSION="20070813" COMMENT="XMLDB file for Moodle block tables"
+    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd"
+>
   <TABLES>
     <TABLE NAME="block" COMMENT="to store installed blocks" NEXT="block_instance">
       <FIELDS>
@@ -24,7 +27,7 @@
         <FIELD NAME="position" TYPE="char" LENGTH="10" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="pagetype" NEXT="weight"/>
         <FIELD NAME="weight" TYPE="int" LENGTH="3" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="position" NEXT="visible"/>
         <FIELD NAME="visible" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="weight" NEXT="configdata"/>
-        <FIELD NAME="configdata" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="visible"/>
+        <FIELD NAME="configdata" TYPE="text" LENGTH="small" NOTNULL="false" SEQUENCE="false" ENUM="false" PREVIOUS="visible"/>
       </FIELDS>
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="blockid"/>
diff --git a/blocks/db/upgrade.php b/blocks/db/upgrade.php
index 9891ea3a99..a92117124b 100644
--- a/blocks/db/upgrade.php
+++ b/blocks/db/upgrade.php
@@ -32,7 +32,21 @@ function xmldb_blocks_upgrade($oldversion=0) {
 ///     $result = result of "/lib/ddllib.php" function calls
 /// }
 
+    if ($result && $oldversion < 2007081300) {
+
+    /// Changing nullability of field configdata on table block_instance to null
+        $table = new XMLDBTable('block_instance');
+        $field = new XMLDBField('configdata');
+        $field->setAttributes(XMLDB_TYPE_TEXT, 'small', null, null, null, null, null, null, 'visible');
+
+    /// Launch change of nullability for field configdata
+        $result = $result && change_field_notnull($table, $field);
+    }
+
+
     return $result;
 }
 
+
+
 ?>
diff --git a/blocks/version.php b/blocks/version.php
index 2483818935..20c50fa7a9 100644
--- a/blocks/version.php
+++ b/blocks/version.php
@@ -5,4 +5,4 @@
 // database (blocks_version) to determine whether upgrades should
 // be performed (see db/backup_*.php)
 
-$blocks_version = 2005090201;   // The current version is a date (YYYYMMDDXX)
+$blocks_version = 2007081300;   // The current version is a date (YYYYMMDDXX)
-- 
2.39.5