Proyectos de Subversion Moodle

    // Put any upgrade step following this.

    if ($oldversion < 2024070500.01) {

        // Remove the site_contactable config of the hub plugin from config plugin table.

        unset_config('site_contactable', 'hub');

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024070500.01);

    }

    if ($oldversion < 2024071900.01) {

        // Define table stored_progress to be created.

        $table = new xmldb_table('stored_progress');

        // Adding fields to table stored_progress.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('idnumber', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null);

        $table->add_field('timestart', XMLDB_TYPE_INTEGER, '20', null, null, null, null);

        $table->add_field('lastupdate', XMLDB_TYPE_INTEGER, '20', null, null, null, null);

        $table->add_field('percentcompleted', XMLDB_TYPE_NUMBER, '5, 2', null, null, null, '0');

        $table->add_field('message', XMLDB_TYPE_CHAR, '255', null, null, null, null);

        $table->add_field('haserrored', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0');

        // Adding keys to table stored_progress.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        // Adding indexes to table stored_progress.

        $table->add_index('uid_index', XMLDB_INDEX_NOTUNIQUE, ['idnumber']);

        // Conditionally launch create table for stored_progress.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024071900.01);

    if ($oldversion < 2024072600.01) {

        // If tool_innodb is no longer present, remove it.

        if (!file_exists($CFG->dirroot . '/admin/tool/innodb/version.php')) {

            // Delete tool_innodb.

            uninstall_plugin('tool', 'innodb');

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024072600.01);

    }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024080500.00);

    }

    if ($oldversion < 2024082900.01) {

        // If filter_tidy is no longer present, remove it.

        if (!file_exists($CFG->dirroot . '/filter/tidy/version.php')) {

            // Clean config.

            uninstall_plugin('filter', 'tidy');

        }

        upgrade_main_savepoint(true, 2024082900.01);

    }

    if ($oldversion < 2024091000.01) {

        // Define table ai_policy_register to be created.

        $table = new xmldb_table('ai_policy_register');

        // Adding fields to table ai_policy_register.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('userid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        $table->add_field('contextid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        $table->add_field('timeaccepted', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        // Adding keys to table ai_policy_register.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        $table->add_key('userid', XMLDB_KEY_FOREIGN_UNIQUE, ['userid'], 'user', ['id']);

        // Conditionally launch create table for ai_policy_register.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Define table ai_action_generate_image to be created.

        $table = new xmldb_table('ai_action_generate_image');

        // Adding fields to table ai_action_generate_image.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('prompt', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('numberimages', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        $table->add_field('quality', XMLDB_TYPE_CHAR, '21', null, XMLDB_NOTNULL, null, null);

        $table->add_field('aspectratio', XMLDB_TYPE_CHAR, '20', null, null, null, null);

        $table->add_field('style', XMLDB_TYPE_CHAR, '20', null, null, null, null);

        $table->add_field('sourceurl', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('revisedprompt', XMLDB_TYPE_TEXT, null, null, null, null, null);

        // Adding keys to table ai_action_generate_image.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        // Conditionally launch create table for ai_action_generate_image.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Define table ai_action_register to be created.

        $table = new xmldb_table('ai_action_register');

        // Adding fields to table ai_action_register.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('actionname', XMLDB_TYPE_CHAR, '100', null, XMLDB_NOTNULL, null, null);

        $table->add_field('actionid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        $table->add_field('success', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0');

        $table->add_field('userid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        $table->add_field('contextid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        $table->add_field('provider', XMLDB_TYPE_CHAR, '100', null, XMLDB_NOTNULL, null, null);

        $table->add_field('errorcode', XMLDB_TYPE_INTEGER, '4', null, null, null, null);

        $table->add_field('errormessage', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('timecreated', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        $table->add_field('timecompleted', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        // Adding keys to table ai_action_register.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        $table->add_key('userid', XMLDB_KEY_FOREIGN, ['userid'], 'user', ['id']);

        // Adding indexes to table ai_action_register.

        $table->add_index('action', XMLDB_INDEX_UNIQUE, ['actionname', 'actionid']);

        $table->add_index('provider', XMLDB_INDEX_NOTUNIQUE, ['actionname', 'provider']);

        // Conditionally launch create table for ai_action_register.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Define table ai_action_generate_text to be created.

        $table = new xmldb_table('ai_action_generate_text');

        // Adding fields to table ai_action_generate_text.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('prompt', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('responseid', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('fingerprint', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('generatedcontent', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('finishreason', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('prompttokens', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        $table->add_field('completiontoken', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        // Adding keys to table ai_action_generate_text.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        // Conditionally launch create table for ai_action_generate_text.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Define table ai_action_summarise_text to be created.

        $table = new xmldb_table('ai_action_summarise_text');

        // Adding fields to table ai_action_summarise_text.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('prompt', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('responseid', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('fingerprint', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('generatedcontent', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('finishreason', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('prompttokens', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        $table->add_field('completiontoken', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        // Adding keys to table ai_action_summarise_text.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        // Conditionally launch create table for ai_action_summarise_text.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024091000.01);

    }

    if ($oldversion < 2024091700.01) {

        // Convert the ai_action_register.success column to an integer, if necessary.

        upgrade_change_binary_column_to_int('ai_action_register', 'success', XMLDB_NOTNULL, 'actionid');

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024091700.01);

    }

    if ($oldversion < 2024092000.01) {

        // Define table sms_messages to be created.

        $table = new xmldb_table('sms_messages');

        // Adding fields to table sms_messages.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('recipientnumber', XMLDB_TYPE_CHAR, '30', null, XMLDB_NOTNULL, null, null);

        $table->add_field('content', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('component', XMLDB_TYPE_CHAR, '100', null, XMLDB_NOTNULL, null, null);

        $table->add_field('messagetype', XMLDB_TYPE_CHAR, '100', null, XMLDB_NOTNULL, null, null);

        $table->add_field('recipientuserid', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        $table->add_field('issensitive', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '0');

        $table->add_field('gatewayid', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        $table->add_field('status', XMLDB_TYPE_CHAR, '100', null, null, null, null);

        $table->add_field('timecreated', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);

        // Adding keys to table sms_messages.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        $table->add_key('gateway', XMLDB_KEY_FOREIGN, ['gatewayid'], 'sms_gateways', ['id']);

        // Conditionally launch create table for sms_messages.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Define table sms_gateways to be created.

        $table = new xmldb_table('sms_gateways');

        // Adding fields to table sms_gateways.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('name', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null);

        $table->add_field('gateway', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null);

        $table->add_field('enabled', XMLDB_TYPE_INTEGER, '2', null, XMLDB_NOTNULL, null, '1');

        $table->add_field('config', XMLDB_TYPE_TEXT, null, null, XMLDB_NOTNULL, null, null);

        // Adding keys to table sms_gateways.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        // Conditionally launch create table for sms_gateways.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024092000.01);

    }

    if ($oldversion < 2024092600.00) {

        // If h5plib_v126 is no longer present, remove it.

        if (!file_exists($CFG->dirroot . '/h5p/h5plib/v126/version.php')) {

            // Clean config.

            uninstall_plugin('h5plib', 'v126');

        }

        // If h5plib_v127 is present, set it as the default one.

        if (file_exists($CFG->dirroot . '/h5p/h5plib/v127/version.php')) {

            set_config('h5plibraryhandler', 'h5plib_v127');

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024092600.00);

    }

    if ($oldversion < 2024100100.02) {

        upgrade_store_relative_url_sitehomepage();

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024100100.02);

    }

    // Automatically generated Moodle v4.5.0 release upgrade line.

    // Put any upgrade step following this.

    if ($oldversion < 2024110400.00) {

        // Define field model to be added to ai_action_register.

        $table = new xmldb_table('ai_action_register');

        $field = new xmldb_field('model', XMLDB_TYPE_CHAR, '50', null, null, null, null, null);

        // Conditionally launch add field model.

        if (!$dbman->field_exists($table, $field)) {

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

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024110400.00);

    }

    if ($oldversion < 2024110800.00) {

        // Delete settings that were removed from code.

        $settings = ['backup_general_questionbank', 'backup_import_questionbank', 'backup_auto_questionbank'];

        array_walk($settings, static fn($setting) => unset_config($setting, 'backup'));

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024110800.00);

    }

    if ($oldversion < 2024110800.02) {

        // Changing type of field value on table user_preferences to text.

        $table = new xmldb_table('user_preferences');

        $field = new xmldb_field('value', XMLDB_TYPE_TEXT, null, null, XMLDB_NOTNULL, null, null, 'name');

        // Launch change of type for field value.

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

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024110800.02);

    }

    if ($oldversion < 2024111500.00) {

        // Changing precision of field fullname on table course to (1333).

        $table = new xmldb_table('course');

        $field = new xmldb_field('fullname', XMLDB_TYPE_CHAR, '1333', null, XMLDB_NOTNULL, null, null, 'sortorder');

        // Launch change of precision for field fullname.

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

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024111500.00);

    }

    if ($oldversion < 2024111500.01) {

        // Changing precision of field fullname on table course_request to (1333).

        $table = new xmldb_table('course_request');

        $field = new xmldb_field('fullname', XMLDB_TYPE_CHAR, '1333', null, XMLDB_NOTNULL, null, null, 'id');

        // Launch change of precision for field fullname.

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

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024111500.01);

    }

    // Now we want to change the precision of course_request.shortname.

    // To do this, we need to first drop the index, then re-create it.

    if ($oldversion < 2024111500.02) {

        // Define index shortname (not unique) to be dropped form course_request.

        $table = new xmldb_table('course_request');

        $index = new xmldb_index('shortname', XMLDB_INDEX_NOTUNIQUE, ['shortname']);

        // Conditionally launch drop index shortname.

        if ($dbman->index_exists($table, $index)) {

            $dbman->drop_index($table, $index);

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024111500.02);

    }

    if ($oldversion < 2024111500.03) {

        // Changing precision of field shortname on table course_request to (255).

        $table = new xmldb_table('course_request');

        $field = new xmldb_field('shortname', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null, 'fullname');

        // Launch change of precision for field shortname.

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

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024111500.03);

    }

    if ($oldversion < 2024111500.04) {

        // Define index shortname (not unique) to be added to course_request.

        $table = new xmldb_table('course_request');

        $index = new xmldb_index('shortname', XMLDB_INDEX_NOTUNIQUE, ['shortname']);

        // Conditionally launch add index shortname.

        if (!$dbman->index_exists($table, $index)) {

            $dbman->add_index($table, $index);

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024111500.04);

    }

    if ($oldversion < 2024112900.01) {

        // Define table reportbuilder_user_filter to be created.

        $table = new xmldb_table('reportbuilder_user_filter');

        // Adding fields to table reportbuilder_user_filter.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('reportid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');

        $table->add_field('filterdata', XMLDB_TYPE_TEXT, null, null, XMLDB_NOTNULL, null, null);

        $table->add_field('usercreated', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');

        $table->add_field('usermodified', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');

        $table->add_field('timecreated', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');

        $table->add_field('timemodified', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');

        // Adding keys to table reportbuilder_user_filter.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        $table->add_key('reportid', XMLDB_KEY_FOREIGN, ['reportid'], 'reportbuilder_report', ['id']);

        $table->add_key('usercreated', XMLDB_KEY_FOREIGN, ['usercreated'], 'user', ['id']);

        $table->add_key('usermodified', XMLDB_KEY_FOREIGN, ['usermodified'], 'user', ['id']);

        // Adding indexes to table reportbuilder_user_filter.

        $table->add_index('report-user', XMLDB_INDEX_UNIQUE, ['reportid', 'usercreated']);

        // Conditionally launch create table for reportbuilder_user_filter.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024112900.01);

    }

    if ($oldversion < 2024112900.02) {

        // Structure to collect current user filter preferences.

        $userfilterdata = [];

        $select = $DB->sql_like('name', '?');

        $params = [$DB->sql_like_escape('reportbuilder-report-') . '%'];

        $preferences = $DB->get_records_select('user_preferences', $select, $params, 'userid, name');

        foreach ($preferences as $preference) {

            preg_match('/^reportbuilder-report-(?<reportid>\d+)-/', $preference->name, $matches);

            $userfilterdata[$preference->userid][$matches['reportid']][] = $preference->value;

        }

        // Migrate user filter preferences to new schema (combining previously chunked values due to size limitation).

        foreach ($userfilterdata as $userid => $reportfilterdata) {

            foreach ($reportfilterdata as $reportid => $filterdata) {

                $DB->insert_record('reportbuilder_user_filter', (object) [

                    'reportid' => $reportid,

                    'filterdata' => implode('', $filterdata),

                    'usercreated' => $userid,

                    'usermodified' => $userid,

                    'timecreated' => time(),

                    'timemodified' => time(),

                ]);

            }

        }

        // Clean up old user filter preferences.

        $DB->delete_records_select('user_preferences', $select, $params);

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024112900.02);

    }

    // Moodle 5.0 Upgrade.

    if ($oldversion < 2024121800.00) {

        $smsgateways = $DB->get_records('sms_gateways');

        foreach ($smsgateways as $gateway) {

            $newconfig = json_decode($gateway->config);

            // Continue only if either the `returnurl` OR the `saveandreturn` property exists.

            if (property_exists($newconfig, "returnurl") || property_exists($newconfig, "saveandreturn")) {

                // Remove unnecessary data in the config.

                unset($newconfig->returnurl, $newconfig->saveandreturn);

                // Update the record with the new config.

                $gateway->config = json_encode($newconfig);

                $DB->update_record('sms_gateways', $gateway);

            }

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024121800.00);

    }

    if ($oldversion < 2024121900.01) {

        // Enable mod_subsection unless 'keepsubsectiondisabled' is set.

        if ((empty($CFG->keepsubsectiondisabled) || !$CFG->keepsubsectiondisabled)

                && $DB->get_record('modules', ['name' => 'subsection'])) {

            $manager = \core_plugin_manager::resolve_plugininfo_class('mod');

            $manager::enable_plugin('subsection', 1);

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2024121900.01);

    }

    if ($oldversion < 2025011700.02) {

        // Define table ai_providers to be created.

        $table = new xmldb_table('ai_providers');

        // Adding fields to table ai_providers.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('name', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null);

        $table->add_field('provider', XMLDB_TYPE_CHAR, '255', null, XMLDB_NOTNULL, null, null);

        $table->add_field('enabled', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '1');

        $table->add_field('config', XMLDB_TYPE_TEXT, null, null, XMLDB_NOTNULL, null, null);

        $table->add_field('actionconfig', XMLDB_TYPE_TEXT, null, null, null, null, null);

        // Adding keys to table ai_provider.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        // Adding indexes to table ai_provider.

        $table->add_index('provider', XMLDB_INDEX_NOTUNIQUE, ['provider']);

        // Conditionally launch create table for ai_provider.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Now the instance table exists, migrate the existing providers.

        upgrade_convert_ai_providers_to_instances();

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025011700.02);

    }

    if ($oldversion < 2025012400.01) {

        // Remove the default value for the apiversion field.

        $table = new xmldb_table('badge_external_backpack');

        $apiversionfield = new xmldb_field('apiversion', XMLDB_TYPE_CHAR, '12', null, XMLDB_NOTNULL, null, null);

        $dbman->change_field_default($table, $apiversionfield);

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025012400.01);

    }

    if ($oldversion < 2025013100.01) {

        // Remove imageauthorname, imageauthoremail and imageauthorurl fields for badges.

        $table = new xmldb_table('badge');

        $fields = [

            'imageauthorname',

            'imageauthoremail',

            'imageauthorurl',

        ];

        foreach ($fields as $field) {

            $field = new xmldb_field($field);

            if ($dbman->field_exists($table, $field)) {

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

            }

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025013100.01);

    }

    if ($oldversion < 2025022100.01) {

        // Define table ai_action_explain_text to be created.

        $table = new xmldb_table('ai_action_explain_text');

        // Adding fields to table ai_action_explain_text.

        $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);

        $table->add_field('prompt', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('responseid', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('fingerprint', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('generatedcontent', XMLDB_TYPE_TEXT, null, null, null, null, null);

        $table->add_field('finishreason', XMLDB_TYPE_CHAR, '128', null, null, null, null);

        $table->add_field('prompttokens', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        $table->add_field('completiontoken', XMLDB_TYPE_INTEGER, '10', null, null, null, null);

        // Adding keys to table ai_action_explain_text.

        $table->add_key('primary', XMLDB_KEY_PRIMARY, ['id']);

        // Conditionally launch create table for ai_action_explain_text.

        if (!$dbman->table_exists($table)) {

            $dbman->create_table($table);

        }

        // Add explain action config to the AI providers.

        upgrade_add_explain_action_to_ai_providers();

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025022100.01);

    }

    if ($oldversion < 2025022100.02) {

        // Due to a code restriction on the upgrade, invoking any core functions is not permitted.

        // Thus, to acquire the list of provider plugins,

        // we should extract them from the `config_plugins` database table.

        $condition = $DB->sql_like('plugin', ':pattern');

        $params = ['pattern' => 'aiprovider_%', 'name' => 'version'];

        $sql = "SELECT plugin FROM {config_plugins} WHERE {$condition} AND name = :name";

        $providers = $DB->get_fieldset_sql($sql, $params);

        foreach ($providers as $provider) {

            // Replace the provider's language string with the provider component's name.

            if (get_string_manager()->string_exists('pluginname', $provider)) {

                $providername = get_string('pluginname', $provider);

                $sql = 'UPDATE {ai_action_register}

                        SET provider = :provider

                        WHERE LOWER(provider) = :providername';

                $DB->execute($sql, ['provider' => $provider, 'providername' => strtolower($providername)]);

            }

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025022100.02);

    }

    // Uninstall auth_cas and remove dependencies.

    if ($oldversion < 2025030500.00) {

        if (!file_exists($CFG->dirroot . "/auth/cas/version.php")) {

            uninstall_plugin('auth', 'cas');

            // Remove the sensiblesettings config for auth_cas.

            $sensiblesettingsraw = explode(',', get_config('adminpresets', 'sensiblesettings'));

            $sensiblesettings = array_map('trim', $sensiblesettingsraw);

            if (($key = array_search('bind_pw@@auth_cas', $sensiblesettings)) !== false) {

                unset($sensiblesettings[$key]);

            }

            $sensiblesettings = implode(', ', $sensiblesettings);

            set_config('sensiblesettings', $sensiblesettings, 'adminpresets');

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025030500.00);

    }

    if ($oldversion < 2025030500.01) {

        // If atto is no longer present, remove it.

        if (!file_exists("{$CFG->dirroot}/lib/editor/atto/version.php")) {

            // Remove each of the subplugins first. These are no longer on disk so the standard `uninstall_plugin` approach

            // on atto itself will not remove them.

            $plugins = array_keys(core_plugin_manager::instance()->get_plugins_of_type('atto'));

            // Now remove each.

            foreach ($plugins as $pluginname) {

                uninstall_plugin('atto', $pluginname);

            }

            // Finally uninstall the actual plugin.

            uninstall_plugin('editor', 'atto');

        }

        upgrade_main_savepoint(true, 2025030500.01);

    }

    // Remove portfolio_mahara.

    if ($oldversion < 2025030600.02) {

        if (!file_exists($CFG->dirroot . "/portfolio/mahara/version.php")) {

            uninstall_plugin('portfolio', 'mahara');

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025030600.02);

    }

    // Remove enrol_mnet.

    if ($oldversion < 2025030600.03) {

        if (!file_exists($CFG->dirroot . "/enrol/mnet/version.php")) {

            uninstall_plugin('enrol', 'mnet');

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025030600.03);

    }

    // Remove block_mnet_hosts.

    if ($oldversion < 2025030600.04) {

        if (!file_exists($CFG->dirroot . "/blocks/mnet_hosts/version.php")) {

            uninstall_plugin('block', 'mnet_hosts');

            // Delete all the admin preset plugin states concerning mnet_hosts in adminpresets_plug table.

            $DB->delete_records('adminpresets_plug', ['name' => 'mnet_hosts']);

        }

        // Main savepoint reached.

        upgrade_main_savepoint(true, 2025030600.04);

    }