Proyectos de Subversion Moodle

Once generated you can copy such statements and execute them safely with your favourite SQL interface (don\'t forget to backup your data before doing that).

Once generated you can copy such statements and execute them safely with your favourite SQL interface (don\'t forget to backup your data before doing that).

It\'s highly recommended to be running the latest (+ version) available of your Moodle release before executing the search of missing indexes.

It\'s highly recommended to be running the latest (+ version) available of your Moodle release before executing the search of missing indexes.

This functionality doesn\'t perform any action against the DB (just reads from it), so can be safely executed at any moment.';

This functionality doesn\'t perform any action against the DB (just reads from it), so can be safely executed at any moment.';

$string['confirmrevertchanges'] = 'Are you absolutely sure that you want to revert changes performed over:';

$string['confirmrevertchanges'] = 'Are you absolutely sure that you want to revert changes performed over:';

$string['create'] = 'Create';

$string['create'] = 'Create';

$string['createtable'] = 'Create table:';

$string['createtable'] = 'Create table:';

$string['check_defaults'] = 'Look for inconsistent default values';

$string['check_defaults'] = 'Look for inconsistent default values';

$string['checkforeignkeys'] = 'Check foreign keys';

$string['checkforeignkeys'] = 'Check foreign keys';

$string['check_foreign_keys'] = 'Look for foreign key violations';

$string['check_foreign_keys'] = 'Look for foreign key violations';

$string['checkindexes'] = 'Check indexes';

$string['checkindexes'] = 'Check indexes';

$string['check_indexes'] = 'Look for missing DB indexes';

$string['check_indexes'] = 'Look for missing DB indexes';

$string['duplicateindexname'] = 'Duplicate index name';

$string['duplicateindexname'] = 'Duplicate index name';

$string['incorrectfieldname'] = 'Incorrect name';

$string['incorrectfieldname'] = 'Incorrect name';

$string['index'] = 'Index';

$string['index'] = 'Index';

$string['indexes'] = 'Indexes';

$string['indexes'] = 'Indexes';

$string['indexnameempty'] = 'Index name is empty';

$string['indexnameempty'] = 'Index name is empty';

$string['noreffieldsspecified'] = 'No reference fields specified';

$string['noreffieldsspecified'] = 'No reference fields specified';

$string['noreftablespecified'] = 'Specified reference table not found';

$string['noreftablespecified'] = 'Specified reference table not found';

$string['noviolatedforeignkeysfound'] = 'No violated foreign keys found';

$string['noviolatedforeignkeysfound'] = 'No violated foreign keys found';

$string['nowrongdefaultsfound'] = 'No inconsistent default values have been found, your DB does not need further actions.';

$string['nowrongdefaultsfound'] = 'No inconsistent default values have been found, your DB does not need further actions.';

$string['nowrongintsfound'] = 'No wrong integers have been found, your DB doesn\'t need further actions.';

$string['nowrongintsfound'] = 'No wrong integers have been found, your DB doesn\'t need further actions.';

$string['numberincorrectdecimals'] = 'Incorrect number of decimals for number field';

$string['numberincorrectdecimals'] = 'Incorrect number of decimals for number field';

$string['numberincorrectlength'] = 'Incorrect length for number field';

$string['numberincorrectlength'] = 'Incorrect length for number field';

$string['numberincorrectwholepart'] = 'Too big whole number part for number field';

$string['numberincorrectwholepart'] = 'Too big whole number part for number field';

$string['pendingchanges'] = 'Note: You have performed changes to this file. They can be saved at any moment.';

$string['pendingchanges'] = 'Note: You have performed changes to this file. They can be saved at any moment.';

$string['pendingchangescannotbesaved'] = 'There are changes in this file but they cannot be saved! Please verify that both the directory and the "install.xml" within it have write permissions for the web server.';

$string['pendingchangescannotbesaved'] = 'There are changes in this file but they cannot be saved! Please verify that both the directory and the "install.xml" within it have write permissions for the web server.';

$string['wrongdefaults'] = 'Wrong defaults found';

$string['wrongdefaults'] = 'Wrong defaults found';

$string['wrongints'] = 'Wrong integers found';

$string['wrongints'] = 'Wrong integers found';

$string['wronglengthforenum'] = 'Incorrect length for enum field';

$string['wronglengthforenum'] = 'Incorrect length for enum field';

$string['wrongnumberofreffields'] = 'Wrong number of reference fields';

$string['wrongnumberofreffields'] = 'Wrong number of reference fields';

$string['wrongreservedwords'] = 'Currently used reserved words<br />(note that table names aren\'t important if using $CFG->prefix)';

$string['wrongreservedwords'] = 'Currently used reserved words<br />(note that table names aren\'t important if using $CFG->prefix)';

$string['yesextraindexesfound'] = 'The following additional indexes were found.';

$string['yesextraindexesfound'] = 'The following additional indexes were found.';

$string['yesmissingindexesfound'] = '<p>Some missing indexes have been found in your DB. Here are their details and the needed SQL statements to be executed with your favourite SQL interface to create all of them. Remember to backup your data first!</p>

$string['yesmissingindexesfound'] = '<p>Some missing indexes have been found in your DB. Here are their details and the needed SQL statements to be executed with your favourite SQL interface to create all of them. Remember to backup your data first!</p>

<p>After doing that, it\'s highly recommended to execute this utility again to check that no more missing indexes are found.</p>';

<p>After doing that, it\'s highly recommended to execute this utility again to check that no more missing indexes are found.</p>';

$string['yeswrongdefaultsfound'] = '<p>Some inconsistent defaults have been found in your DB. Here are their details and the needed SQL statements to be executed with your favourite SQL interface to fix them all. Remember to backup your data first!</p>

$string['yeswrongdefaultsfound'] = '<p>Some inconsistent defaults have been found in your DB. Here are their details and the needed SQL statements to be executed with your favourite SQL interface to fix them all. Remember to backup your data first!</p>

<p>After doing that, it\'s highly recommended to execute this utility again to check that no more inconsistent defaults are found.</p>';

<p>After doing that, it\'s highly recommended to execute this utility again to check that no more inconsistent defaults are found.</p>';

$string['yeswrongintsfound'] = '<p>Some wrong integers have been found in your DB. Here are their details and the needed SQL statements to be executed with your favourite SQL interface to fix them. Remember to backup your data first!</p>

$string['yeswrongintsfound'] = '<p>Some wrong integers have been found in your DB. Here are their details and the needed SQL statements to be executed with your favourite SQL interface to fix them. Remember to backup your data first!</p>

<p>After fixing them, it is highly recommended to execute this utility again to check that no more wrong integers are found.</p>';

<p>After fixing them, it is highly recommended to execute this utility again to check that no more wrong integers are found.</p>';

$string['privacy:metadata'] = 'The XMLDB editor plugin does not store any personal data.';

$string['privacy:metadata'] = 'The XMLDB editor plugin does not store any personal data.';