Incorrectly defined unique key in auth/lti/upgrade.php

Note: You'll need to be able to run and upgrade sites on both mssql, oracle and either maria or pgsql to test this one properly. You'll need a clone of integration to do this. An easy way to do this is via https://github.com/moodlehq/moodle-docker . Oracle Requirement: This issue testing requires MDL-74143 to be already integrated. Create a site running MOODLE_39_STABLE Install Checkout integration master Upgrade Verify upgrade runs without errors (if you're doing this via web browser, you may need to refresh the page a few times as it's super slow) Mssql Create a site running MOODLE_39_STABLE Install Checkout integration master Upgrade Verify upgrade runs without errors Pgsql/Maria Create a site running MOODLE_39_STABLE Install Checkout 01eb6d2e9b45 (this doesn't include the patch yet) Run the upgrade and verify it succeeds without errors Now checkout integration master Upgrade Verify upgrade runs without errors Missing index test Using postgres, create a site running MOODLE_39_STABLE Install Checkout 01eb6d2e9b45 (this doesn't include the patch yet) Run the upgrade and verify it succeeds without errors Now manually edit the table via the cli, dropping the index (simulating a case where the index wasn't created but the upgrade did run) psql DATABASENAME \d PREFIX_auth_lti_linked_login <-- get the index name via the indexes list produced by this command. drop index mdl_authltilinklogi_useiss_uix Now checkout integration master Upgrade Verify upgrade runs without errors