Файловый менеджер

Файловый менеджер - Редактировать - /home/harasnat/www/learning/mod/data/db/upgrade.php

Назад
<?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. // Automatically generated Moodle v4.2.0 release upgrade line. // Put any upgrade step following this. 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, 2023061300, 'data'); } return true; }

| ver. 1.4 | Github | .