1<?php
2/**
3 * English language file for simplemysqlclient plugin
4 *
5 * @author Heiko Heinz <heiko.heinz@soft2c.de>
6 */
7
8$lang['menu'] = 'Simple MySQL-Client';
9
10$lang['submit_button'] = 'Execute Query and Commit';
11
12$lang['shortcutslabel'] = 'MySQL Helper:';
13
14$lang['shortcut.1.text'] = 'MySQL-Keywords';
15$lang['shortcut.1.sql'] = 'SELECT name FROM mysql.help_keyword ORDER BY name';
16
17$lang['shortcut.2.text'] = 'List of Tables';
18$lang['shortcut.2.sql'] = 'SELECT DISTINCT TABLE_NAME FROM information_schema.columns WHERE table_schema = \\\'#DATABASENAME#\\\'';
19
20$lang['shortcut.3.text'] = 'Columns';
21$lang['shortcut.3.sql'] = 'SELECT COLUMN_NAME,COLUMN_DEFAULT,COLUMN_KEY, COLUMN_TYPE, IS_NULLABLE,DATA_TYPE, ORDINAL_POSITION FROM information_schema.columns WHERE table_schema = \\\'#DATABASENAME#\\\' and TABLE_NAME= \\\'___YOUR_TABLE__\\\'';
22
23$lang['shortcut.4.text'] = 'Table states';
24$lang['shortcut.4.sql'] = 'SELECT * FROM information_schema.INNODB_SYS_TABLESTATS WHERE name like \\\'#DATABASENAME#%\\\'';
25
26$lang['shortcut.5.text'] = 'Table infos';
27$lang['shortcut.5.sql'] = 'SELECT * FROM information_schema.INNODB_SYS_TABLES WHERE name like \\\'#DATABASENAME#%\\\'';
28
29$lang['shortcut.6.text'] = 'Prozesses';
30$lang['shortcut.6.sql'] = 'SELECT * FROM information_schema.PROCESSLIST';
31
32$lang['shortcut.7.text'] = 'Sessions';
33$lang['shortcut.7.sql'] = 'SELECT * FROM information_schema.SESSION_STATUS';
34
35$lang['templatesLabel'] = 'SQL-Templates:';
36$lang['template.1.text'] = 'Select';
37$lang['template.1.sql'] = 'SELECT * FROM <tablename> WHERE <column>=<value>';
38$lang['template.2.text'] = 'Update';
39$lang['template.2.sql'] = 'UPDATE <tablename> SET <column1>=<value1>,<column2>=<value2> WHERE <column3>=<value3>';
40$lang['template.3.text'] = 'Delete';
41$lang['template.3.sql'] = 'DELETE FROM <tablename> WHERE <column>=<value>';
42$lang['template.4.text'] = 'Insert';
43$lang['template.4.sql'] = 'INSERT INTO <tableName> ( <column1>,<column2>,<column3> ) VALUES ( <value1>,<value2>,<value2> )';
44
45$lang['emptyresult'] = 'Query successfully executed -> empty result';
46$lang['queryexecuted'] ='SQL was executed and data was changed: ';
47$lang['queriesnotexecuted'] = 'SQL(s) was not executed!';
48$lang['errordbconnection'] ='Cancel: no database connection available!';
49$lang['yes'] ='yes';
50$lang['no'] ='no';
51$lang['nextresult'] = 'Next result:';
52$lang['firstresult'] = 'Result:';
53$lang['missingpermission'] ='No permissions, access denied!';
54
55//Setup VIM: ex: et ts=4 :
56