From a13936c57c055584629aa20fa15e7b6e0b93f595 Mon Sep 17 00:00:00 2001 From: skodak Date: Sun, 11 May 2008 18:55:00 +0000 Subject: [PATCH] MDL-14451 removed pre 1.9 upgrade code --- blocks/search/db/upgrade.php | 132 +---------------------------------- 1 file changed, 2 insertions(+), 130 deletions(-) diff --git a/blocks/search/db/upgrade.php b/blocks/search/db/upgrade.php index 642d5199fd..ca78ec8321 100644 --- a/blocks/search/db/upgrade.php +++ b/blocks/search/db/upgrade.php @@ -31,138 +31,10 @@ function xmldb_block_search_upgrade($oldversion=0) { /// if ($result && $oldversion < YYYYMMDD00) { //New version in version.php /// $result = result of "/lib/ddllib.php" function calls /// } - if ($result && $oldversion < 2007071302) { - /// Define table search_documents to be created - $table = new XMLDBTable('search_documents'); +//===== 1.9.0 upgrade line ======// - /// Drop it if it existed before - - drop_table($table, true, false); - - /// Adding fields to table search_documents - $table->addFieldInfo('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null, null, null); - $table->addFieldInfo('docid', XMLDB_TYPE_CHAR, '32', null, XMLDB_NOTNULL, null, null, null, null); - $table->addFieldInfo('doctype', XMLDB_TYPE_CHAR, '32', null, XMLDB_NOTNULL, null, null, null, 'none'); - $table->addFieldInfo('itemtype', XMLDB_TYPE_CHAR, '32', null, XMLDB_NOTNULL, null, null, null, 'standard'); - $table->addFieldInfo('title', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, null); - $table->addFieldInfo('url', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, null); - $table->addFieldInfo('docdate', XMLDB_TYPE_DATETIME, null, null, XMLDB_NOTNULL, null, null, null); - $table->addFieldInfo('updated', XMLDB_TYPE_DATETIME, null, null, XMLDB_NOTNULL, null, null, null); - $table->addFieldInfo('courseid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0'); - $table->addFieldInfo('groupid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0'); - - /// Adding keys to table search_documents - $table->addKeyInfo('primary', XMLDB_KEY_PRIMARY, array('id')); - - /// Adding indexes to table search_documents - $table->addIndexInfo('mdl_search_docid', XMLDB_INDEX_NOTUNIQUE, array('docid')); - $table->addIndexInfo('mdl_search_doctype', XMLDB_INDEX_NOTUNIQUE, array('doctype')); - $table->addIndexInfo('mdl_search_itemtype', XMLDB_INDEX_NOTUNIQUE, array('itemtype')); - - /// Launch create table for search_documents - $result = $result && create_table($table); - } - -/// Rename table search_documents to block_search_documents and -/// fix some defaults (MDL-10572) - if ($result && $oldversion < 2007081100) { - - /// Define table search_documents to be renamed to block_search_documents - $table = new XMLDBTable('search_documents'); - - /// Launch rename table for block_search_documents - $result = $result && rename_table($table, 'block_search_documents'); - - /// Changing the default of field doctype on table block_search_documents to none - $table = new XMLDBTable('block_search_documents'); - $field = new XMLDBField('doctype'); - $field->setAttributes(XMLDB_TYPE_CHAR, '32', null, XMLDB_NOTNULL, null, null, null, 'none', 'docid'); - - /// Launch change of default for field doctype - $result = $result && change_field_default($table, $field); - - /// Changing the default of field itemtype on table block_search_documents to standard - $table = new XMLDBTable('block_search_documents'); - $field = new XMLDBField('itemtype'); - $field->setAttributes(XMLDB_TYPE_CHAR, '32', null, XMLDB_NOTNULL, null, null, null, 'standard', 'doctype'); - - /// Launch change of default for field itemtype - $result = $result && change_field_default($table, $field); - - /// Changing the default of field title on table block_search_documents to drop it - $table = new XMLDBTable('block_search_documents'); - $field = new XMLDBField('title'); - $field->setAttributes(XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, null, null, 'itemtype'); - - /// Launch change of default for field title - $result = $result && change_field_default($table, $field); - - /// Changing the default of field url on table block_search_documents to drop it - $table = new XMLDBTable('block_search_documents'); - $field = new XMLDBField('url'); - $field->setAttributes(XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, null, null, 'title'); - - /// Launch change of default for field url - $result = $result && change_field_default($table, $field); - } - - if ($result && $oldversion < 2007112700) { - - /* - /// Truncate the block_search_documents table - execute_sql("TRUNCATE TABLE {$CFG->prefix}block_search_documents", true); - - /// Changing type of field docdate on table block_search_documents to int - $table = new XMLDBTable('block_search_documents'); - $field = new XMLDBField('docdate'); - $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'url'); - - /// Launch change of type for field docdate - $result = $result && change_field_type($table, $field); - - /// Changing type of field updated on table block_search_documents to int - $table = new XMLDBTable('block_search_documents'); - $field = new XMLDBField('updated'); - $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'docdate'); - - /// Launch change of type for field updated - $result = $result && change_field_type($table, $field); - */ - - - /// MDL-12352, postgres can not cope with change_field_type(), so dropping the fields and adding again - - /// Define field docdate to be dropped from block_search_documents - $table = new XMLDBTable('block_search_documents'); - $field = new XMLDBField('docdate'); - - /// Launch drop field docdate - $result = $result && drop_field($table, $field); - - /// Define field updated to be dropped from block_search_documents - $field = new XMLDBField('updated'); - - /// Launch drop field updated - $result = $result && drop_field($table, $field); - - /// Define field docdate to be added to block_search_documents - $field = new XMLDBField('docdate'); - $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'url'); - - /// Launch add field docdate - $result = $result && add_field($table, $field); - - /// Define field updated to be added to block_search_documents - $field = new XMLDBField('updated'); - $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'docdate'); - - /// Launch add field updated - $result = $result && add_field($table, $field); - - } - return $result; } -?> \ No newline at end of file +?> -- 2.39.5