See Release Notes
Long Term Support Release
<?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 $DB; $dbman = $DB->get_manager(); // Loads ddl manager and xmldb classes. // Automatically generated Moodle v3.9.0 release upgrade line. // Put any upgrade step following this. // 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. $table = new xmldb_table('data_records'); $key = new xmldb_key('userid', XMLDB_KEY_FOREIGN, ['userid'], 'user', ['id']); // Launch add key userid. $dbman->add_key($table, $key); // Data savepoint reached. upgrade_mod_savepoint(true, 2022081600, 'data'); } // Automatically generated Moodle v4.1.0 release upgrade line. // Put any upgrade step following this.< if ($oldversion < 2022112801) {> // Automatically generated Moodle v4.2.0 release upgrade line. > // Put any upgrade step following this. > > if ($oldversion < 2023042401) {// 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, 2022112801, 'data');> upgrade_mod_savepoint(true, 2023042401, 'data');} return true; }