From 156df4ed3f258a38f63fc7c7bbc4118e15862563 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Wed, 27 Feb 2008 04:38:39 +0000
Subject: [PATCH] Merged MDL-90 partial patch for the new webdav_locks table
 from Martin Langhoff

---
 lib/db/install.xml | 22 ++++++++++++++++++++++
 lib/db/upgrade.php | 33 +++++++++++++++++++++++++++++++++
 version.php        |  8 ++++----
 3 files changed, 59 insertions(+), 4 deletions(-)

diff --git a/lib/db/install.xml b/lib/db/install.xml
index 35c6a378dc..6192d12460 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -1652,6 +1652,28 @@
         <INDEX NAME="courseid-name" UNIQUE="true" FIELDS="courseid, name"/>
       </INDEXES>
     </TABLE>
+   <TABLE NAME="webdav_locks" COMMENT="Resource locks for WebDAV users" PREVIOUS="grade_settings">
+      <FIELDS>
+        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" NEXT="token"/>
+        <FIELD NAME="token" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="path"/>
+        <FIELD NAME="path" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="token" NEXT="expires"/>
+        <FIELD NAME="expiry" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="path" NEXT="userid"/>
+        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="expiry" NEXT="recursive"/>
+        <FIELD NAME="recursive" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="userid" NEXT="exclusivelock"/>
+        <FIELD NAME="exclusivelock" TYPE="int" LENGTH="1" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="recursive" NEXT="created"/>
+        <FIELD NAME="created" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="exclusivelock" NEXT="modified"/>
+        <FIELD NAME="modified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="created" NEXT="owner"/>
+        <FIELD NAME="owner" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false" ENUM="false" PREVIOUS="modified"/>
+      </FIELDS>
+      <KEYS>
+        <KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="token"/>
+        <KEY NAME="token" TYPE="unique" FIELDS="token" PREVIOUS="primary"/>
+      </KEYS>
+      <INDEXES>
+        <INDEX NAME="path" UNIQUE="false" FIELDS="path" NEXT="expiry"/>
+        <INDEX NAME="expiry" UNIQUE="false" FIELDS="expiry" PREVIOUS="path"/>
+      </INDEXES>
+    </TABLE>
   </TABLES>
   <STATEMENTS>
     <STATEMENT NAME="insert mnet_application" TYPE="insert" TABLE="mnet_application" COMMENT="Initial insert of records on table mnet_application" NEXT="insert log_display">
diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index b921c92f02..f97ef022c7 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -2889,6 +2889,39 @@ function xmldb_main_upgrade($oldversion=0) {
         upgrade_main_savepoint($result, 2007101508.06);
     }
 
+    if ($result && $oldversion < 2007101508.07) {
+
+    /// Define table webdav_locks to be created
+        $table = new XMLDBTable('webdav_locks');
+
+    /// Adding fields to table webdav_locks
+        $table->addFieldInfo('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null, null, null);
+        $table->addFieldInfo('token', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, null, null);
+        $table->addFieldInfo('path', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, null, null);
+        $table->addFieldInfo('expiry', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0');
+        $table->addFieldInfo('userid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0');
+        $table->addFieldInfo('recursive', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0');
+        $table->addFieldInfo('exclusivelock', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0');
+        $table->addFieldInfo('created', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0');
+        $table->addFieldInfo('modified', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0');
+        $table->addFieldInfo('owner', XMLDB_TYPE_CHAR, '255', null, null, null, null, null, null);
+
+    /// Adding keys to table webdav_locks
+        $table->addKeyInfo('primary', XMLDB_KEY_PRIMARY, array('id'));
+        $table->addKeyInfo('token', XMLDB_KEY_UNIQUE, array('token'));
+
+    /// Adding indexes to table webdav_locks
+        $table->addIndexInfo('path', XMLDB_INDEX_NOTUNIQUE, array('path'));
+        $table->addIndexInfo('expiry', XMLDB_INDEX_NOTUNIQUE, array('expiry'));
+
+    /// Launch create table for webdav_locks
+        $result = $result && create_table($table);
+
+    /// Main savepoint reached
+        upgrade_main_savepoint($result, 2007101508.07);
+    }
+
+
 
     return $result;
 }
diff --git a/version.php b/version.php
index 76a5d4bacd..a50787ef11 100644
--- a/version.php
+++ b/version.php
@@ -6,10 +6,10 @@
 // This is compared against the values stored in the database to determine
 // whether upgrades should be performed (see lib/db/*.php)
 
-    $version = 2007101508.06;  // YYYYMMDD   = date of the 1.9 branch (don't change)
-                            //         X  = release number 1.9.[0,1,2,3...]
-                            //          Y = micro-increments between releases
+    $version = 2007101508.07;  // YYYYMMDD      = date of the 1.9 branch (don't change)
+                               //         X     = release number 1.9.[0,1,2,3...]
+                               //          Y.YY = micro-increments between releases
 
-    $release = '2.0 dev';   // Human-friendly version name
+    $release = '2.0 dev';      // Human-friendly version name
 
 ?>
-- 
2.39.5