C:/xampp/htdocs/moodle/mod/feedback/db/upgrade.php

Go to the documentation of this file.

<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

// This file keeps track of upgrades to
// the feedback module
//
// Sometimes, changes between versions involve
// alterations to database structures and other
// major things that may break installations.
//
// The upgrade function in this file will attempt
// to perform all the necessary actions to upgrade
// your older installation to the current version.
//
// If there's something it cannot do itself, it
// will tell you what you need to do.
//
// The commands in here will all be database-neutral,
// using the methods of database_manager class
//
// Please do not forget to use upgrade_set_timeout()
// before any action that may take longer time to finish.

function xmldb_feedback_upgrade($oldversion) {
    global $CFG, $DB;

    $dbman = $DB->get_manager();

    if ($oldversion < 2007012310) {

        //create a new table feedback_completedtmp and the field-definition
        $table = new xmldb_table('feedback_completedtmp');

        $field = new xmldb_field('id');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, true, null, null);
        $table->addField($field);

        $field = new xmldb_field('feedback');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, false, '0', null);
        $table->addField($field);

        $field = new xmldb_field('userid');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, false, '0', null);
        $table->addField($field);

        $field = new xmldb_field('guestid');
        $field->set_attributes(XMLDB_TYPE_CHAR, '255', null, null, false, '', null);
        $table->addField($field);

        $field = new xmldb_field('timemodified');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, false, '0', null);
        $table->addField($field);

        $key = new xmldb_key('PRIMARY');
        $key->set_attributes(XMLDB_KEY_PRIMARY, array('id'));
        $table->addKey($key);

        $key = new xmldb_key('feedback');
        $key->set_attributes(XMLDB_KEY_FOREIGN, array('feedback'), 'feedback', 'id');
        $table->addKey($key);

        $dbman->create_table($table);
        //create a new table feedback_valuetmp and the field-definition
        $table = new xmldb_table('feedback_valuetmp');

        $field = new xmldb_field('id');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, true, null, null);
        $table->addField($field);

        $field = new xmldb_field('course_id');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, false, '0', null);
        $table->addField($field);

        $field = new xmldb_field('item');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, false, '0', null);
        $table->addField($field);

        $field = new xmldb_field('completed');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, false, '0', null);
        $table->addField($field);

        $field = new xmldb_field('tmp_completed');
        $field->set_attributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED,
                                XMLDB_NOTNULL, false, '0', null);
        $table->addField($field);

        $field = new xmldb_field('value');
        $field->set_attributes(XMLDB_TYPE_TEXT, null, null, null, false, '', null);
        $table->addField($field);

        $key = new xmldb_key('PRIMARY');
        $key->set_attributes(XMLDB_KEY_PRIMARY, array('id'));
        $table->addKey($key);

        $key = new xmldb_key('feedback');
        $key->set_attributes(XMLDB_KEY_FOREIGN, array('item'), 'feedback_item', 'id');
        $table->addKey($key);

        $dbman->create_table($table);
        upgrade_mod_savepoint(true, 2007012310, 'feedback');
    }

    if ($oldversion < 2007050504) {

        $table = new xmldb_table('feedback_completed');
        $field = new xmldb_field('random_response', XMLDB_TYPE_INTEGER, '10',
                                    XMLDB_UNSIGNED, XMLDB_NOTNULL, false, '0', null);
        $dbman->add_field($table, $field);

        $table = new xmldb_table('feedback_completed');
        $field = new xmldb_field('anonymous_response', XMLDB_TYPE_INTEGER, '1',
                                    XMLDB_UNSIGNED, XMLDB_NOTNULL, false, '1', null);
        $dbman->add_field($table, $field);

        $table = new xmldb_table('feedback_completedtmp');
        $field = new xmldb_field('random_response', XMLDB_TYPE_INTEGER, '10',
                                    XMLDB_UNSIGNED, XMLDB_NOTNULL, false, '0', null);
        $dbman->add_field($table, $field);

        $table = new xmldb_table('feedback_completedtmp');
        $field = new xmldb_field('anonymous_response', XMLDB_TYPE_INTEGER, '1',
                                    XMLDB_UNSIGNED, XMLDB_NOTNULL, false, '1', null);
        $dbman->add_field($table, $field);

        upgrade_mod_savepoint(true, 2007050504, 'feedback');
    }

    if ($oldversion < 2007102600) {
        // public is a reserved word on Oracle

        $table = new xmldb_table('feedback_template');
        $field = new xmldb_field('ispublic', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED,
                                    XMLDB_NOTNULL, false, '1', null);
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }
        upgrade_mod_savepoint(true, 2007102600, 'feedback');
    }

    if ($oldversion < 2008042400) { //New version in version.php
        if ($all_nonanonymous_feedbacks = $DB->get_records('feedback', array('anonymous'=>2))) {
            $update_sql = 'UPDATE {feedback_completed}
                            SET anonymous_response = 2
                            WHERE feedback = ';
            foreach ($all_nonanonymous_feedbacks as $fb) {
                $DB->execute($update_sql.$fb->id);
            }
        }
        upgrade_mod_savepoint(true, 2008042400, 'feedback');
    }

    if ($oldversion < 2008042401) { //New version in version.php
        $concat_radio    = $DB->sql_concat("'r>>>>>'", 'presentation');
        $concat_check    = $DB->sql_concat("'c>>>>>'", 'presentation');
        $concat_dropdown = $DB->sql_concat("'d>>>>>'", 'presentation');

        $update_sql1 = "UPDATE {feedback_item}
                        SET presentation = ".$concat_radio."
                        WHERE typ IN('radio','radiorated')";

        $update_sql2 = "UPDATE {feedback_item}
                        SET presentation = ".$concat_dropdown."
                        WHERE typ IN('dropdown','dropdownrated')";

        $update_sql3 = "UPDATE {feedback_item}
                        SET presentation = ".$concat_check."
                        WHERE typ = 'check'";

        $DB->execute($update_sql1);
        $DB->execute($update_sql2);
        $DB->execute($update_sql3);

        $update_sql1 = "UPDATE {feedback_item}
                        SET typ = 'multichoice'
                        WHERE typ IN('radio','check','dropdown')";

        $update_sql2 = "UPDATE {feedback_item}
                        SET typ = 'multichoicerated'
                        WHERE typ IN('radiorated','dropdownrated')";

        $DB->execute($update_sql1);
        $DB->execute($update_sql2);

        upgrade_mod_savepoint(true, 2008042401, 'feedback');
    }

    if ($oldversion < 2008042900) {
        $table = new xmldb_table('feedback');
        $field = new xmldb_field('autonumbering', XMLDB_TYPE_INTEGER, '1',
                                    XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '1', 'multiple_submit');
        $dbman->add_field($table, $field);

        upgrade_mod_savepoint(true, 2008042900, 'feedback');
    }

    if ($oldversion < 2008050104) {
        $table = new xmldb_table('feedback');
        $field = new xmldb_field('site_after_submit', XMLDB_TYPE_CHAR, '255',
                                    null, null, false, '', 'autonumbering');
        $dbman->add_field($table, $field);

        upgrade_mod_savepoint(true, 2008050104, 'feedback');
    }

    if ($oldversion < 2008050105) {
        //field count is not more needed
        $table = new xmldb_table('feedback_tracking');
        $field = new xmldb_field('count');
        $dbman->drop_field($table, $field);

        upgrade_mod_savepoint(true, 2008050105, 'feedback');
    }

    if ($oldversion < 2008073002) {
        $update_sql = "UPDATE {feedback_item}
                        SET presentation = '-|-'
                        WHERE " . $DB->sql_compare_text('presentation') . " = '0|0' AND
                            typ = 'numeric'";

        $DB->execute($update_sql);

        upgrade_mod_savepoint(true, 2008073002, 'feedback');
    }

    if ($oldversion < 2009031301) {
        $table = new xmldb_table('feedback_item');
        $field = new xmldb_field('label', XMLDB_TYPE_CHAR, '255', null, null, false, '', 'name');
        $dbman->add_field($table, $field);

        upgrade_mod_savepoint(true, 2009031301, 'feedback');
    }

    if ($oldversion < 2009042000) {

        $table = new xmldb_table('feedback');
        $field = new xmldb_field('summary', XMLDB_TYPE_TEXT, 'small', null,
                                    XMLDB_NOTNULL, null, null, 'name');

        $dbman->rename_field($table, $field, 'intro');

        upgrade_mod_savepoint(true, 2009042000, 'feedback');
    }

    if ($oldversion < 2009042001) {

        $table = new xmldb_table('feedback');
        $field = new xmldb_field('introformat', XMLDB_TYPE_INTEGER, '4',
                                    XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'intro');

        $dbman->add_field($table, $field);

        upgrade_mod_savepoint(true, 2009042001, 'feedback');
    }

    if ($oldversion < 2009112000) {
        $table = new xmldb_table('feedback');
        $field = new xmldb_field('page_after_submitformat', XMLDB_TYPE_INTEGER, '2',
                                    XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'page_after_submit');

        if (!$dbman->field_exists($table, $field)) {
            // Launch add field page_after_submitformat
            $dbman->add_field($table, $field);
        }

        // feedback savepoint reached
        upgrade_mod_savepoint(true, 2009112000, 'feedback');
    }

    if ($oldversion < 2010051101) {
        $table = new xmldb_table('feedback_item');
        $field = new xmldb_field('options', XMLDB_TYPE_CHAR, '255',
                                    null, null, false, '', 'required');
        $dbman->add_field($table, $field);

        upgrade_mod_savepoint(true, 2010051101, 'feedback');
    }

    if ($oldversion < 2010051600) {
        $table = new xmldb_table('feedback_item');
        $field = new xmldb_field('dependitem', XMLDB_TYPE_INTEGER, '10',
                                    XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'required');
        $dbman->add_field($table, $field);

        upgrade_mod_savepoint(true, 2010051600, 'feedback');
    }

    if ($oldversion < 2010051601) {
        $table = new xmldb_table('feedback_item');
        $field = new xmldb_field('dependvalue', XMLDB_TYPE_CHAR, '255',
                                    null, null, false, '', 'dependitem');
        $dbman->add_field($table, $field);

        upgrade_mod_savepoint(true, 2010051601, 'feedback');
    }

    if ($oldversion < 2010102300) {

        // Define field completionsubmit to be added to feedback
        $table = new xmldb_table('feedback');
        $field = new xmldb_field('completionsubmit', XMLDB_TYPE_INTEGER, '1',
                                    null, XMLDB_NOTNULL, null, '0', 'timemodified');

        // Conditionally launch add field completionsubmit
        if (!$dbman->field_exists($table, $field)) {
            $dbman->add_field($table, $field);
        }

        // feedback savepoint reached
        upgrade_mod_savepoint(true, 2010102300, 'feedback');
    }

    // Moodle v2.1.0 release upgrade line
    // Put any upgrade step following this

    // Moodle v2.2.0 release upgrade line
    // Put any upgrade step following this

    return true;
}