Merge branch 'wip-mdl-35047-m23' of git://github.com/rajeshtaneja/moodle into MOODLE_...
[moodle.git] / admin / tool / xmldb / lang / en / tool_xmldb.php
CommitLineData
30c8dd34 1<?php
30c8dd34
DM
2// This file is part of Moodle - http://moodle.org/
3//
4// Moodle is free software: you can redistribute it and/or modify
5// it under the terms of the GNU General Public License as published by
6// the Free Software Foundation, either version 3 of the License, or
7// (at your option) any later version.
8//
9// Moodle is distributed in the hope that it will be useful,
10// but WITHOUT ANY WARRANTY; without even the implied warranty of
11// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12// GNU General Public License for more details.
13//
14// You should have received a copy of the GNU General Public License
15// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
16
17/**
b007a5d0 18 * Strings for component 'tool_xmldb', language 'en', branch 'MOODLE_22_STABLE'
30c8dd34 19 *
85d6dd38 20 * @package tool_xmldb
b007a5d0
PS
21 * @copyright 1999 onwards Martin Dougiamas {@link http://moodle.com}
22 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
30c8dd34 23 */
304d08f0 24
ac1dc984 25$string['actual'] = 'Actual';
1973cf9b 26$string['aftertable'] = 'After table:';
84039175 27$string['back'] = 'Back';
1973cf9b 28$string['backtomainview'] = 'Back to main';
30c8dd34 29$string['cannotuseidfield'] = 'Cannot insert the "id" field. It is an autonumeric column';
060bbac9 30$string['completelogbelow'] = '(see the complete log of the search below)';
30c8dd34
DM
31$string['confirmdeletefield'] = 'Are you absolutely sure that you want to delete the field:';
32$string['confirmdeleteindex'] = 'Are you absolutely sure that you want to delete the index:';
33$string['confirmdeletekey'] = 'Are you absolutely sure that you want to delete the key:';
30c8dd34
DM
34$string['confirmdeletetable'] = 'Are you absolutely sure that you want to delete the table:';
35$string['confirmdeletexmlfile'] = 'Are you absolutely sure that you want to delete the file:';
36$string['confirmcheckbigints'] = 'This functionality will search for <a href="http://tracker.moodle.org/browse/MDL-11038">potential wrong integer fields</a> in your Moodle server, generating (but not executing!) automatically the needed SQL statements to have all the integers in your DB properly defined.<br /><br />
fc405175 37Once 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).<br /><br />
61829e2c 38It\'s highly recommended to be running the latest (+ version) available of your Moodle release (1.8, 1.9, 2.x ...) before executing the search of wrong integers.<br /><br />
fc405175 39This functionality doesn\'t perform any action against the DB (just reads from it), so can be safely executed at any moment.';
dfac8649 40$string['confirmcheckdefaults'] = 'This functionality will search for inconsistent default values in your Moodle server, generating (but not executing!) the needed SQL statements to have all the default values properly defined.<br /><br />
41Once 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).<br /><br />
cc27a59d 42It\'s highly recommended to be running the latest (+ version) available of your Moodle release (1.8, 1.9, 2.x ...) before executing the search of inconsistent default values.<br /><br />
dfac8649 43This functionality doesn\'t perform any action against the DB (just reads from it), so can be safely executed at any moment.';
e9aa2473 44$string['confirmcheckforeignkeys'] = 'This functionality will search for potential violations of the foreign keys defined in the install.xml definitions. (Moodle does not currently generate actual foreign key constraints in the database, which is why invalid data may be present.)<br /><br />
5e8d809b 45It\'s highly recommended to be running the latest (+ version) available of your Moodle release (1.8, 1.9, 2.x ...) before executing the search of missing indexes.<br /><br />
46This functionality doesn\'t perform any action against the DB (just reads from it), so can be safely executed at any moment.';
fc405175 47$string['confirmcheckindexes'] = 'This functionality will search for potential missing indexes in your Moodle server, generating (but not executing!) automatically the needed SQL statements to keep everything updated.<br /><br />
48Once 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).<br /><br />
060bbac9 49It\'s highly recommended to be running the latest (+ version) available of your Moodle release (1.8, 1.9, 2.x ...) before executing the search of missing indexes.<br /><br />
50This functionality doesn\'t perform any action against the DB (just reads from it), so can be safely executed at any moment.';
1c08c1fa
EL
51$string['confirmcheckoraclesemantics'] = 'This functionality will search for <a href="http://tracker.moodle.org/browse/MDL-29322">Oracle varchar2 columns using BYTE semantics</a> in your Moodle server, generating (but not executing!) automatically the needed SQL statements to have all the columns converted to use CHAR semantics instead (better for cross-db compatibility and increased contents max. length).<br /><br />
52Once 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).<br /><br />
53It\'s highly recommended to be running the latest (+ version) available of your Moodle release (2.2, 2.3, 2.x ...) before executing the search of BYTE semantics.<br /><br />
54This functionality doesn\'t perform any action against the DB (just reads from it), so can be safely executed at any moment.';
3fa69925 55$string['confirmrevertchanges'] = 'Are you absolutely sure that you want to revert changes performed over:';
84039175 56$string['create'] = 'Create';
1973cf9b 57$string['createtable'] = 'Create table:';
1a1f4966 58$string['defaultincorrect'] = 'Incorrect default';
84039175 59$string['delete'] = 'Delete';
1973cf9b
HF
60$string['delete_field'] = 'Delete field';
61$string['delete_index'] = 'Delete index';
62$string['delete_key'] = 'Delete key';
63$string['delete_table'] = 'Delete table';
64$string['delete_xml_file'] = 'Delete XML file';
6c59c9c7 65$string['doc'] = 'Doc';
1973cf9b 66$string['docindex'] = 'Documentation index:';
30c8dd34 67$string['documentationintro'] = 'This documentation is generated automatically from the XMLDB database definition. It is available only in English.';
84039175 68$string['down'] = 'Down';
69$string['duplicate'] = 'Duplicate';
70$string['duplicatefieldname'] = 'Another field with that name exists';
ae116318 71$string['duplicatefieldsused'] = 'Duplicate fields used';
1f0e4921 72$string['duplicatekeyname'] = 'Another key with that name exists';
7a66fb6d 73$string['duplicatetablename'] = 'Another table with that name exists';
84039175 74$string['edit'] = 'Edit';
1973cf9b
HF
75$string['edit_field'] = 'Edit field';
76$string['edit_field_save'] = 'Save field';
77$string['edit_index'] = 'Edit index';
78$string['edit_index_save'] = 'Save index';
79$string['edit_key'] = 'Edit key';
80$string['edit_key_save'] = 'Save key';
81$string['edit_table'] = 'Edit table';
82$string['edit_table_save'] = 'Save table';
83$string['edit_xml_file'] = 'Edit XML file';
84039175 84$string['enumvaluesincorrect'] = 'Incorrect values for enum field';
ac1dc984 85$string['expected'] = 'Expected';
30c8dd34 86$string['extensionrequired'] = 'Sorry - the PHP extension \'{$a}\' is required for this action. Please install the extension if you want to use this feature.';
84039175 87$string['field'] = 'Field';
88$string['fieldnameempty'] = 'Name field empty';
89$string['fields'] = 'Fields';
30c8dd34 90$string['fieldsnotintable'] = 'Field doesn\'t exist in table';
ae116318 91$string['fieldsusedinindex'] = 'This field is used as index';
aecb02e5 92$string['fieldsusedinkey'] = 'This field is used as key.';
7128d8fc 93$string['filemodifiedoutfromeditor'] = 'Warning: File locally modified while using the XMLDB Editor. Saving will overwrite local changes.';
2813c04b 94$string['filenotwriteable'] = 'File not writeable';
30c8dd34 95$string['fkviolationdetails'] = 'Foreign key {$a->keyname} on table {$a->tablename} is violated by {$a->numviolations} out of {$a->numrows} rows.';
84039175 96$string['floatincorrectdecimals'] = 'Incorrect number of decimals for float field';
97$string['floatincorrectlength'] = 'Incorrect length for float field';
30c8dd34 98$string['float2numbernote'] = 'Notice: Although "float" fields are 100% supported by XMLDB, it\'s recommended to migrate to "number" fields instead.';
1973cf9b 99$string['generate_all_documentation'] = 'All the documentation';
30c8dd34 100$string['generate_documentation'] = 'Documentation';
304d08f0 101$string['gotolastused'] = 'Go to last used file';
30c8dd34
DM
102$string['change'] = 'Change';
103$string['charincorrectlength'] = 'Incorrect length for char field';
104$string['checkbigints'] = 'Check bigints';
105$string['check_bigints'] = 'Look for incorrect DB integers';
106$string['checkdefaults'] = 'Check defaults';
107$string['check_defaults'] = 'Look for inconsistent default values';
108$string['checkforeignkeys'] = 'Check foreign keys';
109$string['check_foreign_keys'] = 'Look for foreign key violations';
110$string['checkindexes'] = 'Check indexes';
111$string['check_indexes'] = 'Look for missing DB indexes';
1c08c1fa
EL
112$string['checkoraclesemantics'] = 'Check semantics';
113$string['check_oracle_semantics'] = 'Look for incorrect length semantics';
08363c5c 114$string['duplicateindexname'] = 'Duplicate index name';
84039175 115$string['incorrectfieldname'] = 'Incorrect name';
060bbac9 116$string['index'] = 'Index';
84039175 117$string['indexes'] = 'Indexes';
08363c5c 118$string['indexnameempty'] = 'Index name is empty';
84039175 119$string['integerincorrectlength'] = 'Incorrect length for integer field';
08363c5c 120$string['incorrectindexname'] = 'Incorrect index name';
ae116318 121$string['incorrectkeyname'] = 'Incorrect key name';
7a66fb6d 122$string['incorrecttablename'] = 'Incorrect table name';
060bbac9 123$string['key'] = 'Key';
ae116318 124$string['keynameempty'] = 'The key name cannot be empty';
84039175 125$string['keys'] = 'Keys';
30c8dd34 126$string['listreservedwords'] = 'List of Reserved Words<br />(used to keep <a href="http://docs.moodle.org/en/XMLDB_reserved_words" target="_blank">XMLDB_reserved_words</a> updated)';
84039175 127$string['load'] = 'Load';
1973cf9b 128$string['main_view'] = 'Main view';
3fa69925 129$string['masterprimaryuniqueordernomatch'] = 'The fields in your foreign key must be listed in the same order as they are listed in the UNIQUE KEY on the referenced table.';
060bbac9 130$string['missing'] = 'Missing';
1973cf9b 131$string['missingindexes'] = 'Missing indexes found';
6caa705d 132$string['mustselectonefield'] = 'You must select one field to see field related actions!';
133$string['mustselectoneindex'] = 'You must select one index to see index related actions!';
59e3e962 134$string['mustselectonekey'] = 'You must select one key to see key related actions!';
1973cf9b
HF
135$string['newfield'] = 'New field';
136$string['newindex'] = 'New index';
137$string['newkey'] = 'New key';
138$string['newtable'] = 'New table';
139$string['newtablefrommysql'] = 'New table from MySQL';
140$string['new_table_from_mysql'] = 'New table from MySQL';
ae116318 141$string['nofieldsspecified'] = 'No fields specified';
54cb131f 142$string['nomasterprimaryuniquefound'] = 'The column(s) that you foreign key references must be included in a primary or unique KEY in the referenced table. Note, the column being in a UNIQUE INDEX is not good enough.';
060bbac9 143$string['nomissingindexesfound'] = 'No missing indexes have been found, your DB doesn\'t need further actions.';
ae116318
RL
144$string['noreffieldsspecified'] = 'No reference fields specified';
145$string['noreftablespecified'] = 'Specified reference table not found';
5e8d809b 146$string['noviolatedforeignkeysfound'] = 'No violated foreign keys found';
25b05ce5 147$string['nowrongdefaultsfound'] = 'No inconsistent default values have been found, your DB does not need further actions.';
fc405175 148$string['nowrongintsfound'] = 'No wrong integers have been found, your DB doesn\'t need further actions.';
1c08c1fa 149$string['nowrongoraclesemanticsfound'] = 'No Oracle columns using BYTE semantics have been found, your DB doesn\'t need further actions.';
84039175 150$string['numberincorrectdecimals'] = 'Incorrect number of decimals for number field';
151$string['numberincorrectlength'] = 'Incorrect length for number field';
024b7605 152$string['pendingchanges'] = 'Note: You have performed changes to this file. They can be saved at any moment.';
30c8dd34
DM
153$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.';
154$string['pendingchangescannotbesavedreload'] = '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. Then reload this page and you should be able to save those changes.';
b007a5d0 155$string['pluginname'] = 'XMLDB editor';
ae116318 156$string['primarykeyonlyallownotnullfields'] = 'Primary keys cannot be null';
84039175 157$string['reserved'] = 'Reserved';
5e8d809b 158$string['reservedwords'] = 'Reserved words';
84039175 159$string['revert'] = 'Revert';
1973cf9b 160$string['revert_changes'] = 'Revert changes';
84039175 161$string['save'] = 'Save';
1973cf9b
HF
162$string['searchresults'] = 'Search results';
163$string['selectaction'] = 'Select action:';
164$string['selectdb'] = 'Select database:';
165$string['selectfieldkeyindex'] = 'Select field/key/index:';
166$string['selectonecommand'] = 'Please select one action from the list to view PHP code';
167$string['selectonefieldkeyindex'] = 'Please select one field/key/index from the list to view the PHP code';
168$string['selecttable'] = 'Select table:';
84039175 169$string['table'] = 'Table';
7a66fb6d 170$string['tablenameempty'] = 'The table name cannot be empty';
84039175 171$string['tables'] = 'Tables';
84039175 172$string['unload'] = 'Unload';
173$string['up'] = 'Up';
5f705395 174$string['view'] = 'View';
1973cf9b
HF
175$string['viewedited'] = 'View edited';
176$string['vieworiginal'] = 'View original';
177$string['viewphpcode'] = 'View PHP code';
178$string['view_reserved_words'] = 'View reserved words';
179$string['viewsqlcode'] = 'View SQL code';
180$string['view_structure_php'] = 'View structure PHP';
181$string['view_structure_sql'] = 'View structure SQL';
182$string['view_table_php'] = 'View table PHP';
183$string['view_table_sql'] = 'View table SQL';
17fe4b1f 184$string['viewxml'] = 'XML';
5e8d809b 185$string['violatedforeignkeys'] = 'Violated foreign keys';
186$string['violatedforeignkeysfound'] = 'Violated foreign keys found';
187$string['violations'] = 'Violations';
fc405175 188$string['wrong'] = 'Wrong';
1973cf9b
HF
189$string['wrongdefaults'] = 'Wrong defaults found';
190$string['wrongints'] = 'Wrong integers found';
84039175 191$string['wronglengthforenum'] = 'Incorrect length for enum field';
ae116318 192$string['wrongnumberofreffields'] = 'Wrong number of reference fields';
1973cf9b 193$string['wrongreservedwords'] = 'Currently used reserved words<br />(note that table names aren\'t important if using $CFG->prefix)';
1c08c1fa 194$string['wrongoraclesemantics'] = 'Wrong Oracle BYTE semantics found';
25b05ce5 195$string['yesmissingindexesfound'] = '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 them (don\'t forget to backup your data before doing that).<br /><br />After doing that, it\'s highly recommended to execute this utility again to check that no more missing indexes are found.';
1973cf9b 196$string['yeswrongdefaultsfound'] = '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 (don\'t forget to backup your data before doing that).<br /><br />After doing that, it\'s highly recommended to execute this utility again to check that no more inconsistent defaults are found.';
25b05ce5 197$string['yeswrongintsfound'] = '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 create all them (don\'t forget to backup your data before doing that).<br /><br />After doing that, it\'s highly recommended to execute this utility again to check that no more wrong integers are found.';
1c08c1fa 198$string['yeswrongoraclesemanticsfound'] = 'Some Oracle columns using BYTE semantics 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 them (don\'t forget to backup your data before doing that).<br /><br />After doing that, it\'s highly recommended to execute this utility again to check that no more wrong semantics are found.';