Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 3.9.x will end* 10 May 2021 (12 months).
  • Bug fixes for security issues in 3.9.x will end* 8 May 2023 (36 months).
  • PHP version: minimum PHP 7.2.0 Note: minimum PHP version has increased since Moodle 3.8. PHP 7.3.x and 7.4.x are supported too.
<?php
// This file keeps track of upgrades to
// the data 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.

defined('MOODLE_INTERNAL') || die();

function xmldb_data_upgrade($oldversion) {
< global $CFG, $DB;
> global $DB;
< // Automatically generated Moodle v3.5.0 release upgrade line. < // Put any upgrade step following this.
> $dbman = $DB->get_manager(); // Loads ddl manager and xmldb classes.
< // Automatically generated Moodle v3.6.0 release upgrade line.
> // Automatically generated Moodle v3.9.0 release upgrade line.
// Put any upgrade step following this.
< // Automatically generated Moodle v3.7.0 release upgrade line.
> // Automatically generated Moodle v4.0.0 release upgrade line.
// Put any upgrade step following this.
> if ($oldversion < 2022081600) { > // Define key userid (foreign) to be added to data_records. if ($oldversion < 2019052001) { > $table = new xmldb_table('data_records'); > $key = new xmldb_key('userid', XMLDB_KEY_FOREIGN, ['userid'], 'user', ['id']); $columns = $DB->get_columns('data'); > // Launch add key userid. > $dbman->add_key($table, $key);
< if ($oldversion < 2019052001) {
> // Data savepoint reached. > upgrade_mod_savepoint(true, 2022081600, 'data'); > }
< $columns = $DB->get_columns('data');
> // Automatically generated Moodle v4.1.0 release upgrade line. > // Put any upgrade step following this.
< $oldclass = "mod-data-default-template ##approvalstatus##"; < $newclass = "mod-data-default-template ##approvalstatusclass##";
> // Automatically generated Moodle v4.2.0 release upgrade line. > // Put any upgrade step following this.
< // Update existing classes. < $DB->replace_all_text('data', $columns['singletemplate'], $oldclass, $newclass); < $DB->replace_all_text('data', $columns['listtemplate'], $oldclass, $newclass); < $DB->replace_all_text('data', $columns['addtemplate'], $oldclass, $newclass); < $DB->replace_all_text('data', $columns['rsstemplate'], $oldclass, $newclass); < $DB->replace_all_text('data', $columns['asearchtemplate'], $oldclass, $newclass);
> if ($oldversion < 2023061300) { > // Clean orphan data_records. > $sql = "SELECT d.id FROM {data} d > LEFT JOIN {data_fields} f ON d.id = f.dataid > WHERE f.id IS NULL"; > $emptydatas = $DB->get_records_sql($sql); > if (!empty($emptydatas)) { > $dataids = array_keys($emptydatas); > list($datainsql, $dataparams) = $DB->get_in_or_equal($dataids, SQL_PARAMS_NAMED, 'data'); > $DB->delete_records_select('data_records', "dataid $datainsql", $dataparams); > }
// Data savepoint reached.
< upgrade_mod_savepoint(true, 2019052001, 'data');
> upgrade_mod_savepoint(true, 2023061300, 'data');
}
< // Automatically generated Moodle v3.8.0 release upgrade line. < // Put any upgrade step following this.
< // Automatically generated Moodle v3.9.0 release upgrade line.
> // Automatically generated Moodle v4.3.0 release upgrade line.
// Put any upgrade step following this. return true; }