Upgraded phpmyadmin to 4.0.4 (All Languages) - No modifications yet
[openemr.git] / phpmyadmin / libraries / config.default.php
blob0b2512641a537902d6e7f015bbd5d063dfdb2722
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
4 * <code>
5 * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !!
6 * NN N O O !! D D O O NN N O O T E D D I T !!
7 * N N N O O !! D D O O N N N O O T EEEE D D I T !!
8 * N NN O O D D O O N NN O O T E D D I T
9 * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !!
10 * </code>
12 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
14 * phpMyAdmin default configuration, you can copy values from here to your
15 * config.inc.php
17 * All directives are explained in the documentation
19 * @package PhpMyAdmin
22 /**
23 * Your phpMyAdmin URL.
25 * Complete the variable below with the full URL ie
26 * http://www.your_web.net/path_to_your_phpMyAdmin_directory/
28 * It must contain characters that are valid for a URL, and the path is
29 * case sensitive on some Web servers, for example Unix-based servers.
31 * In most cases you can leave this variable empty, as the correct value
32 * will be detected automatically. However, we recommend that you do
33 * test to see that the auto-detection code works in your system. A good
34 * test is to browse a table, then edit a row and save it. There will be
35 * an error message if phpMyAdmin cannot auto-detect the correct value.
37 * @global string $cfg['PmaAbsoluteUri']
39 $cfg['PmaAbsoluteUri'] = '';
41 /**
42 * Disable the default warning that is displayed on the DB Details Structure page if
43 * any of the required Tables for the configuration storage could not be found
45 * @global boolean $cfg['PmaNoRelation_DisableWarning']
47 $cfg['PmaNoRelation_DisableWarning'] = false;
49 /**
50 * Disable the default warning that is displayed if Suhosin is detected
52 * @global boolean $cfg['SuhosinDisableWarning']
54 $cfg['SuhosinDisableWarning'] = false;
56 /**
57 * Disable the default warning that is displayed if mcrypt is missing for
58 * cookie authentication.
60 * @global boolean $cfg['McryptDisableWarning']
62 $cfg['McryptDisableWarning'] = false;
64 /**
65 * Disable the default warning that is displayed if a diffrence between
66 * the MySQL library and server is detected.
68 * @global boolean $cfg['['ServerLibraryDifference_DisableWarning']']
70 $cfg['ServerLibraryDifference_DisableWarning'] = false;
72 /**
73 * Disable the default warning about MySQL reserved words in column names
75 * @global boolean $cfg['ReservedWordDisableWarning']
77 $cfg['ReservedWordDisableWarning'] = false;
79 /**
80 * Show warning about incomplete translations on certain threshold.
82 * @global boolean $cfg['TranslationWarningThreshold']
84 $cfg['TranslationWarningThreshold'] = 80;
86 /**
87 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
88 * at least one server configuration uses 'cookie' auth_type, enter here a
89 * pass phrase that will be used by blowfish. The maximum length seems to be 46
90 * characters.
92 * @global string $cfg['blowfish_secret']
94 $cfg['blowfish_secret'] = '';
97 /*******************************************************************************
98 * Server(s) configuration
100 * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
101 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
102 * to ''. If you want more than one server, just copy following section
103 * (including $i incrementation) several times. There is no need to define
104 * full server array, just define values you need to change.
106 * @global array $cfg['Servers']
108 $cfg['Servers'] = array();
110 $i = 1;
113 * MySQL hostname or IP address
115 * @global string $cfg['Servers'][$i]['host']
117 $cfg['Servers'][$i]['host'] = 'localhost';
120 * MySQL port - leave blank for default port
122 * @global string $cfg['Servers'][$i]['port']
124 $cfg['Servers'][$i]['port'] = '';
127 * Path to the socket - leave blank for default socket
129 * @global string $cfg['Servers'][$i]['socket']
131 $cfg['Servers'][$i]['socket'] = '';
134 * Use SSL for connecting to MySQL server?
136 * @global boolean $cfg['Servers'][$i]['ssl']
138 $cfg['Servers'][$i]['ssl'] = false;
141 * How to connect to MySQL server ('tcp' or 'socket')
143 * @global string $cfg['Servers'][$i]['connect_type']
145 $cfg['Servers'][$i]['connect_type'] = 'tcp';
148 * The PHP MySQL extension to use ('mysql' or 'mysqli')
150 * @global string $cfg['Servers'][$i]['extension']
152 $cfg['Servers'][$i]['extension'] = 'mysqli';
155 * Use compressed protocol for the MySQL connection
157 * @global boolean $cfg['Servers'][$i]['compress']
159 $cfg['Servers'][$i]['compress'] = false;
162 * MySQL control host. This permits to use a host different than the
163 * main host, for the phpMyAdmin configuration storage. If left empty,
164 * $cfg['Servers'][$i]['host'] is used instead.
166 * @global string $cfg['Servers'][$i]['controlhost']
168 $cfg['Servers'][$i]['controlhost'] = '';
171 * MySQL control user settings (this user must have read-only
172 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
173 * used for all relational features (pmadb)
175 * @global string $cfg['Servers'][$i]['controluser']
177 $cfg['Servers'][$i]['controluser'] = '';
180 * MySQL control user settings (this user must have read-only
181 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
182 * used for all relational features (pmadb)
184 * @global string $cfg['Servers'][$i]['controlpass']
186 $cfg['Servers'][$i]['controlpass'] = '';
189 * Authentication method (valid choices: config, http, signon or cookie)
191 * @global string $cfg['Servers'][$i]['auth_type']
193 $cfg['Servers'][$i]['auth_type'] = 'cookie';
196 * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
198 * @global string $cfg['Servers'][$i]['auth_http_realm']
200 $cfg['Servers'][$i]['auth_http_realm'] = '';
203 * File containing Swekey ids and login names (see /contrib);
204 * leave empty to deactivate Swekey hardware authentication
206 * @global string $cfg['Servers'][$i]['auth_swekey_config']
208 $cfg['Servers'][$i]['auth_swekey_config'] = '';
211 * MySQL user
213 * @global string $cfg['Servers'][$i]['user']
215 $cfg['Servers'][$i]['user'] = 'root';
218 * MySQL password (only needed with 'config' auth_type)
220 * @global string $cfg['Servers'][$i]['password']
222 $cfg['Servers'][$i]['password'] = '';
225 * Session to use for 'signon' authentication method
227 * @global string $cfg['Servers'][$i]['SignonSession']
229 $cfg['Servers'][$i]['SignonSession'] = '';
232 * PHP script to use for 'signon' authentication method
234 * @global string $cfg['Servers'][$i]['SignonScript']
236 $cfg['Servers'][$i]['SignonScript'] = '';
239 * URL where to redirect user to login for 'signon' authentication method
241 * @global string $cfg['Servers'][$i]['SignonURL']
243 $cfg['Servers'][$i]['SignonURL'] = '';
246 * URL where to redirect user after logout
248 * @global string $cfg['Servers'][$i]['LogoutURL']
250 $cfg['Servers'][$i]['LogoutURL'] = '';
253 * Whether to try to connect without password
255 * @global boolean $cfg['Servers'][$i]['nopassword']
257 $cfg['Servers'][$i]['nopassword'] = false;
260 * If set to a db-name, only this db is displayed in navigation panel
261 * It may also be an array of db-names
263 * @global string $cfg['Servers'][$i]['only_db']
265 $cfg['Servers'][$i]['only_db'] = '';
268 * Database name to be hidden from listings
270 * @global string $cfg['Servers'][$i]['hide_db']
272 $cfg['Servers'][$i]['hide_db'] = '';
275 * Verbose name for this host - leave blank to show the hostname
276 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
278 * @global string $cfg['Servers'][$i]['verbose']
280 $cfg['Servers'][$i]['verbose'] = '';
283 * Database used for Relation, Bookmark and PDF Features
284 * (see examples/create_tables.sql)
285 * - leave blank for no support
286 * SUGGESTED: 'phpmyadmin'
288 * @global string $cfg['Servers'][$i]['pmadb']
290 $cfg['Servers'][$i]['pmadb'] = '';
293 * Bookmark table
294 * - leave blank for no bookmark support
295 * SUGGESTED: 'pma__bookmark'
297 * @global string $cfg['Servers'][$i]['bookmarktable']
299 $cfg['Servers'][$i]['bookmarktable'] = '';
302 * table to describe the relation between links (see doc)
303 * - leave blank for no relation-links support
304 * SUGGESTED: 'pma__relation'
306 * @global string $cfg['Servers'][$i]['relation']
308 $cfg['Servers'][$i]['relation'] = '';
311 * table to describe the display fields
312 * - leave blank for no display fields support
313 * SUGGESTED: 'pma__table_info'
315 * @global string $cfg['Servers'][$i]['table_info']
317 $cfg['Servers'][$i]['table_info'] = '';
320 * table to describe the tables position for the PDF schema
321 * - leave blank for no PDF schema support
322 * SUGGESTED: 'pma__table_coords'
324 * @global string $cfg['Servers'][$i]['table_coords']
326 $cfg['Servers'][$i]['table_coords'] = '';
329 * table to describe pages of relationpdf
330 * - leave blank if you don't want to use this
331 * SUGGESTED: 'pma__pdf_pages'
333 * @global string $cfg['Servers'][$i]['pdf_pages']
335 $cfg['Servers'][$i]['pdf_pages'] = '';
338 * table to store column information
339 * - leave blank for no column comments/mime types
340 * SUGGESTED: 'pma__column_info'
342 * @global string $cfg['Servers'][$i]['column_info']
344 $cfg['Servers'][$i]['column_info'] = '';
347 * table to store SQL history
348 * - leave blank for no SQL query history
349 * SUGGESTED: 'pma__history'
351 * @global string $cfg['Servers'][$i]['history']
353 $cfg['Servers'][$i]['history'] = '';
356 * table to store the coordinates for Designer
357 * - leave blank for no Designer feature
358 * SUGGESTED: 'pma__designer_coords'
360 * @global string $cfg['Servers'][$i]['designer_coords']
362 $cfg['Servers'][$i]['designer_coords'] = '';
365 * table to store recently used tables
366 * - leave blank for no "persistent" recently used tables
367 * SUGGESTED: 'pma__recent'
369 $cfg['Servers'][$i]['recent'] = '';
372 * table to store UI preferences for tables
373 * - leave blank for no "persistent" UI preferences
374 * SUGGESTED: 'pma__table_uiprefs'
376 $cfg['Servers'][$i]['table_uiprefs'] = '';
379 * table to store SQL tracking
380 * - leave blank for no SQL tracking
381 * SUGGESTED: 'pma__tracking'
383 * @global string $cfg['Servers'][$i]['tracking']
385 $cfg['Servers'][$i]['tracking'] = '';
388 * table to store user preferences
389 * - leave blank to disable server storage
390 * SUGGESTED: 'pma__userconfig'
392 * @global string $cfg['Servers'][$i]['userconfig']
394 $cfg['Servers'][$i]['userconfig'] = '';
397 * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
399 * In case where tables in databases is modified (e.g. dropped or renamed),
400 * table_uiprefs may contains invalid data (referring to tables which are not
401 * exist anymore).
402 * This configuration make sure that we only keep N (N = MaxTableUiprefs)
403 * newest record in table_uiprefs and automatically delete older records.
405 * @global integer $cfg['Servers'][$i]['userconfig'] = '';
407 $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
410 * whether to allow root login
412 * @global boolean $cfg['Servers'][$i]['AllowRoot']
414 $cfg['Servers'][$i]['AllowRoot'] = true;
417 * whether to allow login of any user without a password
419 * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
421 $cfg['Servers'][$i]['AllowNoPassword'] = false;
424 * Host authentication order, leave blank to not use
426 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
428 $cfg['Servers'][$i]['AllowDeny']['order'] = '';
431 * Host authentication rules, leave blank for defaults
433 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
435 $cfg['Servers'][$i]['AllowDeny']['rules'] = array();
438 * Disable use of INFORMATION_SCHEMA. Is always 'false' for Drizzle.
440 * @see https://sourceforge.net/p/phpmyadmin/bugs/2606/
441 * @see http://bugs.mysql.com/19588
442 * @global boolean $cfg['Servers'][$i]['DisableIS']
444 $cfg['Servers'][$i]['DisableIS'] = true;
447 * SQL command to fetch available databases
449 * by default most user will be fine with SHOW DATABASES,
450 * for servers with a huge amount of databases it is possible to
451 * define a command which executes faster but with less information
453 * especially when accessing database servers from ISPs changing this command
454 * can result in a great speed improvement
456 * false will disable fetching databases from the server, only databases in
457 * $cfg['Servers'][$i]['only_db'] will be displayed
459 * #user# will be replaced by current user
461 * examples:
462 * 'SHOW DATABASES'
463 * "SHOW DATABASES LIKE '#user#\_%'"
464 * 'SELECT DISTINCT TABLE_SCHEMA FROM information_schema.SCHEMA_PRIVILEGES'
465 * 'SELECT SCHEMA_NAME FROM information_schema.SCHEMATA'
466 * false
468 * @global array $cfg['Servers'][$i]['ShowDatabasesCommand']
470 $cfg['Servers'][$i]['ShowDatabasesCommand'] = 'SHOW DATABASES';
473 * Whether the tracking mechanism creates
474 * versions for tables and views automatically.
476 * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
479 $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
482 * Defines the list of statements
483 * the auto-creation uses for new versions.
485 * @global string $cfg['Servers'][$i]['tracking_default_statements']
488 $cfg['Servers'][$i]['tracking_default_statements']
489 = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
490 'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
491 'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
494 * Whether a DROP VIEW IF EXISTS statement will be added
495 * as first line to the log when creating a view.
497 * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
500 $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
503 * Whether a DROP TABLE IF EXISTS statement will be added
504 * as first line to the log when creating a table.
506 * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
509 $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
512 * Whether a DROP DATABASE IF EXISTS statement will be added
513 * as first line to the log when creating a database.
515 * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
518 $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
521 * Enables caching of TABLE STATUS outputs for specific databases on this server
522 * (in some cases TABLE STATUS can be very slow, so you may want to cache it).
523 * APC is used (if the PHP extension is available, if not, this setting is ignored
524 * silently). You have to provide StatusCacheLifetime.
525 * Takes effect only if DisableIS is true.
527 * @global array $cfg['Servers'][$i]['StatusCacheDatabases']
529 $cfg['Servers'][$i]['StatusCacheDatabases'] = array();
532 * Lifetime in seconds of the TABLE STATUS cache if StatusCacheDatabases is used
534 * @global integer $cfg['Servers'][$i]['StatusCacheLifetime']
536 $cfg['Servers'][$i]['StatusCacheLifetime'] = 0;
539 * Default server (0 = no default server)
541 * If you have more than one server configured, you can set $cfg['ServerDefault']
542 * to any one of them to auto-connect to that server when phpMyAdmin is started,
543 * or set it to 0 to be given a list of servers without logging in
544 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
545 * set to that server.
547 * @global integer $cfg['ServerDefault']
549 $cfg['ServerDefault'] = 1;
552 * Other core phpMyAdmin settings
556 * whether version check is active
558 * @global boolean $cfg['VersionCheck']
560 $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
563 * maximum number of db's displayed in database list
565 * @global integer $cfg['MaxDbList']
567 $cfg['MaxDbList'] = 100;
570 * maximum number of items displayed in navigation panel
572 * @global integer $cfg['MaxDbList']
574 $cfg['MaxNavigationItems'] = 25;
577 * maximum number of tables displayed in table list
579 * @global integer $cfg['MaxTableList']
581 $cfg['MaxTableList'] = 250;
584 * whether to show hint or not
586 * @global boolean $cfg['ShowHint']
588 $cfg['ShowHint'] = true;
591 * maximum number of characters when a SQL query is displayed
593 * @global integer $cfg['MaxCharactersInDisplayedSQL']
595 $cfg['MaxCharactersInDisplayedSQL'] = 1000;
598 * use GZIP output buffering if possible (true|false|'auto')
600 * @global string $cfg['OBGzip']
602 $cfg['OBGzip'] = 'auto';
605 * use persistent connections to MySQL database
607 * @global boolean $cfg['PersistentConnections']
609 $cfg['PersistentConnections'] = false;
612 * whether to force using HTTPS
614 * @global boolean $cfg['ForceSSL']
616 $cfg['ForceSSL'] = false;
619 * maximum execution time in seconds (0 for no limit)
621 * @global integer $cfg['ExecTimeLimit']
623 $cfg['ExecTimeLimit'] = 300;
626 * Path for storing session data (session_save_path PHP parameter).
628 * @global integer $cfg['SessionSavePath']
630 $cfg['SessionSavePath'] = '';
633 * maximum allocated bytes ('0' for no limit)
634 * this is a string because '16M' is a valid value; we must put here
635 * a string as the default value so that /setup accepts strings
637 * @global string $cfg['MemoryLimit']
639 $cfg['MemoryLimit'] = '0';
642 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
643 * Is ignored for Drizzle.
645 * @global boolean $cfg['SkipLockedTables']
647 $cfg['SkipLockedTables'] = false;
650 * show SQL queries as run
652 * @global boolean $cfg['ShowSQL']
654 $cfg['ShowSQL'] = true;
657 * retain SQL input on Ajax execute
659 * @global boolean $cfg['RetainQueryEditor']
661 $cfg['RetainQueryBox'] = false;
664 * use CodeMirror syntax highlighting for editing SQL
666 * @global boolean $cfg['CodemirrorEnable']
668 $cfg['CodemirrorEnable'] = true;
671 * show a 'Drop database' link to normal users
673 * @global boolean $cfg['AllowUserDropDatabase']
675 $cfg['AllowUserDropDatabase'] = false;
678 * confirm some commands that can result in loss of data
679 * (see "need_confirm" in the parser)
681 * @global boolean $cfg['Confirm']
683 $cfg['Confirm'] = true;
686 * recall previous login in cookie authentication mode or not
688 * @global boolean $cfg['LoginCookieRecall']
690 $cfg['LoginCookieRecall'] = true;
693 * validity of cookie login (in seconds; 1440 matches php.ini's
694 * session.gc_maxlifetime)
696 * @global integer $cfg['LoginCookieValidity']
698 $cfg['LoginCookieValidity'] = 1440;
701 * how long login cookie should be stored (in seconds)
703 * @global integer $cfg['LoginCookieStore']
705 $cfg['LoginCookieStore'] = 0;
708 * whether to delete all login cookies on logout
710 * @global boolean $cfg['LoginCookieDeleteAll']
712 $cfg['LoginCookieDeleteAll'] = true;
715 * whether to enable the "database search" feature or not
717 * @global boolean $cfg['UseDbSearch']
719 $cfg['UseDbSearch'] = true;
722 * if set to true, PMA continues computing multiple-statement queries
723 * even if one of the queries failed
725 * @global boolean $cfg['IgnoreMultiSubmitErrors']
727 $cfg['IgnoreMultiSubmitErrors'] = false;
730 * allow login to any user entered server in cookie based authentication
732 * @global boolean $cfg['AllowArbitraryServer']
734 $cfg['AllowArbitraryServer'] = false;
737 /*******************************************************************************
738 * Error handler configuration
740 * this configures phpMyAdmin's own error handler, it is used to avoid information
741 * disclosure, gather errors for logging, reporting and displaying
743 * @global array $cfg['Error_Handler']
745 $cfg['Error_Handler'] = array();
748 * whether to display errors or not
750 * this does not affect errors of type E_USER_*
752 * @global boolean $cfg['Error_Handler']['display']
754 $cfg['Error_Handler']['display'] = false;
757 * (NOT IMPLEMENTED YET)
758 * where to log errors, false or empty to disable
760 * <code>
761 * // EXAMPLE log to std PHP error log
762 * $cfg['Error_Handler']['log'] = array(0);
763 * // EXAMPLE mail errors
764 * $cfg['Error_Handler']['log'] = array(1, 'admin@example.org');
765 * // EXAMPLE append to specific file
766 * $cfg['Error_Handler']['log'] = array(3, '/var/log/phpmyadmin_error.log');
767 * </code>
769 * @see http://php.net/error_log
770 * @global string $cfg['Error_Handler']['log']
772 //$cfg['Error_Handler']['log'] = false;
775 * gather all errors in session to be displayed on a error reporting page
776 * for viewing and/or sending to phpMyAdmin developer team
778 * @global boolean $cfg['Error_Handler']['gather']
780 $cfg['Error_Handler']['gather'] = false;
783 /*******************************************************************************
784 * Navigation panel setup
788 * turn the select-based light menu into a tree
790 * @global boolean $cfg['NavigationTreeEnableGrouping']
792 $cfg['NavigationTreeEnableGrouping'] = true;
795 * the separator to sub-tree the select-based light menu tree
797 * @global string $cfg['NavigationTreeDbSeparator']
799 $cfg['NavigationTreeDbSeparator'] = '_';
802 * Which string will be used to generate table prefixes
803 * to split/nest tables into multiple categories
805 * @global string $cfg['NavigationTreeTableSeparator']
807 $cfg['NavigationTreeTableSeparator'] = '__';
810 * How many sublevels should be displayed when splitting up tables
811 * by the above Separator
813 * @global integer $cfg['NavigationTreeTableLevel']
815 $cfg['NavigationTreeTableLevel'] = 1;
818 * display table comment as tooltip in navigation panel
820 * @global boolean $cfg['ShowTooltip']
822 $cfg['ShowTooltip'] = true;
825 * display logo at top of navigation panel
827 * @global boolean $cfg['NavigationDisplayLogo']
829 $cfg['NavigationDisplayLogo'] = true;
832 * where should logo link point to (can also contain an external URL)
834 * @global string $cfg['NavigationLogoLink']
836 $cfg['NavigationLogoLink'] = 'index.php';
839 * whether to open the linked page in the main window ('main') or
840 * in a new window ('new')
842 * @global string $cfg['NavigationLogoLinkWindow']
844 $cfg['NavigationLogoLinkWindow'] = 'main';
847 * number of recently used tables displayed in the navigation panel
849 * @global integer $cfg['NumRecentTables']
851 $cfg['NumRecentTables'] = 10;
854 * display a JavaScript table filter in the navigation panel
855 * when more then x tables are present
857 * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
859 $cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
862 * display server choice at top of navigation panel
864 * @global boolean $cfg['NavigationDisplayServers']
866 $cfg['NavigationDisplayServers'] = true;
869 * server choice as links
871 * @global boolean $cfg['DisplayServersList']
873 $cfg['DisplayServersList'] = false;
876 * display a JavaScript database filter in the navigation panel
877 * when more then x databases are present
879 * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
881 $cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
884 * target of the navigation panel quick access icon
886 * Possible values:
887 * 'tbl_structure.php' = fields list
888 * 'tbl_sql.php' = SQL form
889 * 'tbl_select.php' = search page
890 * 'tbl_change.php' = insert row page
891 * 'sql.php' = browse page
893 * @global string $cfg['NavigationTreeDefaultTabTable']
895 $cfg['NavigationTreeDefaultTabTable'] = 'tbl_structure.php';
898 /*******************************************************************************
899 * In the main panel, at startup...
903 * allow to display statistics and space usage in the pages about database
904 * details and table properties
906 * @global boolean $cfg['ShowStats']
908 $cfg['ShowStats'] = true;
911 * show PHP info link
913 * @global boolean $cfg['ShowPhpInfo']
915 $cfg['ShowPhpInfo'] = false;
918 * show MySQL server and web server information
920 * @global boolean $cfg['ShowServerInfo']
922 $cfg['ShowServerInfo'] = true;
925 * show change password link
927 * @global boolean $cfg['ShowChgPassword']
929 $cfg['ShowChgPassword'] = true;
932 * show create database form
934 * @global boolean $cfg['ShowCreateDb']
936 $cfg['ShowCreateDb'] = true;
939 /*******************************************************************************
940 * Database structure
944 * show creation timestamp column in database structure (true|false)?
946 * @global boolean $cfg['ShowDbStructureCreation']
948 $cfg['ShowDbStructureCreation'] = false;
951 * show last update timestamp column in database structure (true|false)?
953 * @global boolean $cfg['ShowDbStructureLastUpdate']
955 $cfg['ShowDbStructureLastUpdate'] = false;
958 * show last check timestamp column in database structure (true|false)?
960 * @global boolean $cfg['ShowDbStructureLastCheck']
962 $cfg['ShowDbStructureLastCheck'] = false;
965 * allow hide action columns to drop down menu in database structure (true|false)?
967 * @global boolean $cfg['HideStructureActions']
969 $cfg['HideStructureActions'] = true;
972 /*******************************************************************************
973 * In browse mode...
977 * Use icons instead of text for the navigation bar buttons
978 * and on right panel top menu (server db table) (true|false|'both')
980 * @global string $cfg['NavigationBarIconic']
982 $cfg['NavigationBarIconic'] = true;
985 * Defines whether a user should be displayed a "show all (records)"
986 * button in browse mode or not.
988 * @global boolean $cfg['ShowAll']
990 $cfg['ShowAll'] = false;
993 * Number of rows displayed when browsing a result set. If the result
994 * set contains more rows, "Previous" and "Next".
996 * @global integer $cfg['MaxRows']
998 $cfg['MaxRows'] = 30;
1001 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
1002 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
1003 * ascending order else-)
1005 * @global string $cfg['Order']
1007 $cfg['Order'] = 'SMART';
1010 * default for 'Show binary contents as HEX'
1012 * @global string $cfg['DisplayBinaryAsHex']
1014 $cfg['DisplayBinaryAsHex'] = true;
1017 * grid editing: save edited cell(s) in browse-mode at once
1019 * @global boolean $cfg['SaveCellsAtOnce']
1022 $cfg['SaveCellsAtOnce'] = false;
1025 * grid editing: which action triggers it, or completely disable the feature
1027 * Possible values:
1028 * 'click'
1029 * 'double-click'
1030 * 'disabled'
1032 * @global string $cfg['GridEditing']
1034 $cfg['GridEditing'] ='double-click';
1037 /*******************************************************************************
1038 * In edit mode...
1042 * disallow editing of binary fields
1043 * valid values are:
1044 * false allow editing
1045 * 'blob' allow editing except for BLOB fields
1046 * 'noblob' disallow editing except for BLOB fields
1047 * 'all' disallow editing
1049 * @global string $cfg['ProtectBinary']
1051 $cfg['ProtectBinary'] = 'blob';
1054 * Display the function fields in edit/insert mode
1056 * @global boolean $cfg['ShowFunctionFields']
1058 $cfg['ShowFunctionFields'] = true;
1061 * Display the type fields in edit/insert mode
1063 * @global boolean $cfg['ShowFieldTypesInDataEditView']
1065 $cfg['ShowFieldTypesInDataEditView'] = true;
1068 * Which editor should be used for CHAR/VARCHAR fields:
1069 * input - allows limiting of input length
1070 * textarea - allows newlines in fields
1072 * @global string $cfg['CharEditing']
1074 $cfg['CharEditing'] = 'input';
1077 * The minimum size for character input fields
1079 * @global integer $cfg['MinSizeForInputField']
1081 $cfg['MinSizeForInputField'] = 4;
1084 * The maximum size for character input fields
1086 * @global integer $cfg['MinSizeForInputField']
1088 $cfg['MaxSizeForInputField'] = 60;
1091 * How many rows can be inserted at one time
1093 * @global integer $cfg['InsertRows']
1095 $cfg['InsertRows'] = 2;
1098 * Sort order for items in a foreign-key drop-down list.
1099 * 'content' is the referenced data, 'id' is the key value.
1101 * @global array $cfg['ForeignKeyDropdownOrder']
1103 $cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
1106 * A drop-down list will be used if fewer items are present
1108 * @global integer $cfg['ForeignKeyMaxLimit']
1110 $cfg['ForeignKeyMaxLimit'] = 100;
1113 /*******************************************************************************
1114 * For the export features...
1118 * Allow for the use of zip compression (requires zip support to be enabled)
1120 * @global boolean $cfg['ZipDump']
1122 $cfg['ZipDump'] = true;
1125 * Allow for the use of gzip compression (requires zlib)
1127 * @global boolean $cfg['GZipDump']
1129 $cfg['GZipDump'] = true;
1132 * Allow for the use of bzip2 compression (requires bz2 extension)
1134 * @global boolean $cfg['BZipDump']
1136 $cfg['BZipDump'] = true;
1139 * Will compress gzip/bzip2 exports on the fly without the need for much memory.
1140 * If you encounter problems with created gzip/bzip2 files disable this feature.
1142 * @global boolean $cfg['CompressOnFly']
1144 $cfg['CompressOnFly'] = true;
1147 /*******************************************************************************
1148 * Tabs display settings
1152 * Use icons instead of text for the table display of a database (true|false|'both')
1154 * @global boolean $cfg['PropertiesIconic']
1156 $cfg['PropertiesIconic'] = 'both';
1159 * How many columns should be used for table display of a database?
1160 * (a value larger than 1 results in some information being hidden)
1162 * @global integer $cfg['PropertiesNumColumns']
1164 $cfg['PropertiesNumColumns'] = 1;
1167 * Possible values:
1168 * 'index.php' = the welcome page
1169 * (recommended for multiuser setups)
1170 * 'server_databases.php' = list of databases
1171 * 'server_status.php' = runtime information
1172 * 'server_variables.php' = MySQL server variables
1173 * 'server_privileges.php' = user management
1175 * @global string $cfg['DefaultTabServer']
1177 $cfg['DefaultTabServer'] = 'index.php';
1180 * Possible values:
1181 * 'db_structure.php' = tables list
1182 * 'db_sql.php' = SQL form
1183 * 'db_search.php' = search query
1184 * 'db_operations.php' = operations on database
1186 * @global string $cfg['DefaultTabDatabase']
1188 $cfg['DefaultTabDatabase'] = 'db_structure.php';
1191 * Possible values:
1192 * 'tbl_structure.php' = fields list
1193 * 'tbl_sql.php' = SQL form
1194 * 'tbl_select.php' = search page
1195 * 'tbl_change.php' = insert row page
1196 * 'sql.php' = browse page
1198 * @global string $cfg['DefaultTabTable']
1200 $cfg['DefaultTabTable'] = 'sql.php';
1202 /*******************************************************************************
1203 * Export defaults
1205 $cfg['Export'] = array();
1208 * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xls/xml/yaml
1210 * @global string $cfg['Export']['format']
1212 $cfg['Export']['format'] = 'sql';
1215 * quick/custom/custom-no-form
1217 * @global string $cfg['Export']['format']
1219 $cfg['Export']['method'] = 'quick';
1222 * none/zip/gzip/bzip2
1224 * @global string $cfg['Export']['compression']
1226 $cfg['Export']['compression'] = 'none';
1231 * @global boolean $cfg['Export']['asfile']
1233 $cfg['Export']['asfile'] = true;
1238 * @global string $cfg['Export']['charset']
1240 $cfg['Export']['charset'] = '';
1245 * @global boolean $cfg['Export']['onserver']
1247 $cfg['Export']['onserver'] = false;
1252 * @global boolean $cfg['Export']['onserver_overwrite']
1254 $cfg['Export']['onserver_overwrite'] = false;
1259 * @global boolean $cfg['Export']['quick_export_onserver']
1261 $cfg['Export']['quick_export_onserver'] = false;
1266 * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
1268 $cfg['Export']['quick_export_onserver_overwrite'] = false;
1273 * @global boolean $cfg['Export']['remember_file_template']
1275 $cfg['Export']['remember_file_template'] = true;
1280 * @global string $cfg['Export']['file_template_table']
1282 $cfg['Export']['file_template_table'] = '@TABLE@';
1287 * @global string $cfg['Export']['file_template_database']
1289 $cfg['Export']['file_template_database'] = '@DATABASE@';
1294 * @global string $cfg['Export']['file_template_server']
1296 $cfg['Export']['file_template_server'] = '@SERVER@';
1301 * @global string $cfg['Export']['codegen_structure_or_data']
1303 $cfg['Export']['codegen_structure_or_data'] = 'data';
1308 * @global $cfg['Export']['codegen_format']
1310 $cfg['Export']['codegen_format'] = 0;
1315 * @global boolean $cfg['Export']['ods_columns']
1317 $cfg['Export']['ods_columns'] = false;
1322 * @global string $cfg['Export']['ods_null']
1324 $cfg['Export']['ods_null'] = 'NULL';
1329 * @global string $cfg['Export']['odt_structure_or_data']
1331 $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
1336 * @global boolean $cfg['Export']['odt_columns']
1338 $cfg['Export']['odt_columns'] = true;
1343 * @global boolean $cfg['Export']['odt_relation']
1345 $cfg['Export']['odt_relation'] = true;
1350 * @global boolean $cfg['Export']['odt_comments']
1352 $cfg['Export']['odt_comments'] = true;
1357 * @global boolean $cfg['Export']['odt_mime']
1359 $cfg['Export']['odt_mime'] = true;
1364 * @global string $cfg['Export']['odt_null']
1366 $cfg['Export']['odt_null'] = 'NULL';
1371 * @global boolean $cfg['Export']['htmlword_structure_or_data']
1373 $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
1378 * @global boolean $cfg['Export']['htmlword_columns']
1380 $cfg['Export']['htmlword_columns'] = false;
1385 * @global string $cfg['Export']['htmlword_null']
1387 $cfg['Export']['htmlword_null'] = 'NULL';
1392 * @global string $cfg['Export']['texytext_structure_or_data']
1394 $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
1399 * @global boolean $cfg['Export']['texytext_columns']
1401 $cfg['Export']['texytext_columns'] = false;
1406 * @global string $cfg['Export']['texytext_null']
1408 $cfg['Export']['texytext_null'] = 'NULL';
1413 * @global boolean $cfg['Export']['xls_columns']
1415 $cfg['Export']['xls_columns'] = false;
1420 * @global string $cfg['Export']['xls_structure_or_data']
1422 $cfg['Export']['xls_structure_or_data'] = 'data';
1427 * @global string $cfg['Export']['xls_null']
1429 $cfg['Export']['xls_null'] = 'NULL';
1434 * @global boolean $cfg['Export']['xlsx_columns']
1436 $cfg['Export']['xlsx_columns'] = false;
1441 * @global string $cfg['Export']['xlsx_structure_or_data']
1443 $cfg['Export']['xlsx_structure_or_data'] = 'data';
1448 * @global string $cfg['Export']['xlsx_null']
1450 $cfg['Export']['xlsx_null'] = 'NULL';
1455 * @global boolean $cfg['Export']['csv_columns']
1457 $cfg['Export']['csv_columns'] = false;
1462 * @global string $cfg['Export']['csv_structure_or_data']
1464 $cfg['Export']['csv_structure_or_data'] = 'data';
1469 * @global string $cfg['Export']['csv_null']
1471 $cfg['Export']['csv_null'] = 'NULL';
1476 * @global string $cfg['Export']['csv_separator']
1478 $cfg['Export']['csv_separator'] = ',';
1483 * @global string $cfg['Export']['csv_enclosed']
1485 $cfg['Export']['csv_enclosed'] = '"';
1490 * @global string $cfg['Export']['csv_escaped']
1492 $cfg['Export']['csv_escaped'] = '"';
1497 * @global string $cfg['Export']['csv_terminated']
1499 $cfg['Export']['csv_terminated'] = 'AUTO';
1504 * @global string $cfg['Export']['csv_removeCRLF']
1506 $cfg['Export']['csv_removeCRLF'] = false;
1511 * @global boolean $cfg['Export']['excel_columns']
1513 $cfg['Export']['excel_columns'] = false;
1518 * @global string $cfg['Export']['excel_null']
1520 $cfg['Export']['excel_null'] = 'NULL';
1523 * win/mac
1525 * @global string $cfg['Export']['excel_edition']
1527 $cfg['Export']['excel_edition'] = 'win';
1532 * @global string $cfg['Export']['excel_removeCRLF']
1534 $cfg['Export']['excel_removeCRLF'] = false;
1539 * @global string $cfg['Export']['excel_structure_or_data']
1541 $cfg['Export']['excel_structure_or_data'] = 'data';
1546 * @global string $cfg['Export']['latex_structure_or_data']
1548 $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
1553 * @global boolean $cfg['Export']['latex_columns']
1555 $cfg['Export']['latex_columns'] = true;
1560 * @global boolean $cfg['Export']['latex_relation']
1562 $cfg['Export']['latex_relation'] = true;
1567 * @global boolean $cfg['Export']['latex_comments']
1569 $cfg['Export']['latex_comments'] = true;
1574 * @global boolean $cfg['Export']['latex_mime']
1576 $cfg['Export']['latex_mime'] = true;
1581 * @global string $cfg['Export']['latex_null']
1583 $cfg['Export']['latex_null'] = '\textit{NULL}';
1588 * @global boolean $cfg['Export']['latex_caption']
1590 $cfg['Export']['latex_caption'] = true;
1595 * @global string $cfg['Export']['latex_structure_caption']
1597 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1602 * @global string $cfg['Export']['latex_structure_continued_caption']
1604 $cfg['Export']['latex_structure_continued_caption']
1605 = 'strLatexStructure strLatexContinued';
1610 * @global string $cfg['Export']['latex_data_caption']
1612 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
1617 * @global string $cfg['Export']['latex_data_continued_caption']
1619 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1624 * @global string $cfg['Export']['latex_data_label']
1626 $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
1631 * @global string $cfg['Export']['latex_structure_label']
1633 $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
1638 * @global string $cfg['Export']['mediawiki_structure_or_data']
1640 $cfg['Export']['mediawiki_structure_or_data'] = 'data';
1645 * @global boolean $cfg['Export']['mediawiki_caption']
1648 $cfg['Export']['mediawiki_caption'] = true;
1652 * @global boolean $cfg['Export']['mediawiki_headers']
1654 $cfg['Export']['mediawiki_headers'] = true;
1659 * @global string $cfg['Export']['ods_structure_or_data']
1661 $cfg['Export']['ods_structure_or_data'] = 'data';
1666 * @global string $cfg['Export']['pdf_structure_or_data']
1668 $cfg['Export']['pdf_structure_or_data'] = 'data';
1673 * @global string $cfg['Export']['phparray_structure_or_data']
1675 $cfg['Export']['phparray_structure_or_data'] = 'data';
1680 * @global string $cfg['Export']['json_structure_or_data']
1682 $cfg['Export']['json_structure_or_data'] = 'data';
1687 * @global string $cfg['Export']['sql_structure_or_data']
1689 $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
1694 * @global string $cfg['Export']['sql_compatibility']
1696 $cfg['Export']['sql_compatibility'] = 'NONE';
1699 * Whether to include comments in SQL export.
1701 * @global string $cfg['Export']['sql_include_comments']
1703 $cfg['Export']['sql_include_comments'] = true;
1708 * @global boolean $cfg['Export']['sql_disable_fk']
1710 $cfg['Export']['sql_disable_fk'] = false;
1715 * @global boolean $cfg['Export']['sql_use_transaction']
1717 $cfg['Export']['sql_use_transaction'] = false;
1722 * @global boolean $cfg['Export']['sql_drop_database']
1724 $cfg['Export']['sql_drop_database'] = false;
1729 * @global boolean $cfg['Export']['sql_drop_table']
1731 $cfg['Export']['sql_drop_table'] = false;
1736 * true by default for correct behavior when dealing with exporting
1737 * of VIEWs and the stand-in table
1738 * @global boolean $cfg['Export']['sql_if_not_exists']
1740 $cfg['Export']['sql_if_not_exists'] = true;
1745 * @global boolean $cfg['Export']['sql_procedure_function']
1747 $cfg['Export']['sql_procedure_function'] = true;
1752 * @global boolean $cfg['Export']['sql_auto_increment']
1754 $cfg['Export']['sql_auto_increment'] = true;
1759 * @global boolean $cfg['Export']['sql_backquotes']
1761 $cfg['Export']['sql_backquotes'] = true;
1766 * @global boolean $cfg['Export']['sql_dates']
1768 $cfg['Export']['sql_dates'] = false;
1773 * @global boolean $cfg['Export']['sql_relation']
1775 $cfg['Export']['sql_relation'] = false;
1780 * @global boolean $cfg['Export']['sql_truncate']
1782 $cfg['Export']['sql_truncate'] = false;
1787 * @global boolean $cfg['Export']['sql_delayed']
1789 $cfg['Export']['sql_delayed'] = false;
1794 * @global boolean $cfg['Export']['sql_ignore']
1796 $cfg['Export']['sql_ignore'] = false;
1799 * Export time in UTC.
1801 * @global boolean $cfg['Export']['sql_utc_time']
1803 $cfg['Export']['sql_utc_time'] = true;
1808 * @global boolean $cfg['Export']['sql_hex_for_blob']
1810 $cfg['Export']['sql_hex_for_blob'] = true;
1813 * insert/update/replace
1815 * @global string $cfg['Export']['sql_type']
1817 $cfg['Export']['sql_type'] = 'INSERT';
1822 * @global integer $cfg['Export']['sql_max_query_size']
1824 $cfg['Export']['sql_max_query_size'] = 50000;
1829 * @global boolean $cfg['Export']['sql_comments']
1831 $cfg['Export']['sql_comments'] = false;
1836 * @global boolean $cfg['Export']['sql_mime']
1838 $cfg['Export']['sql_mime'] = false;
1841 * \n is replaced by new line
1843 * @global string $cfg['Export']['sql_header_comment']
1845 $cfg['Export']['sql_header_comment'] = '';
1850 * @global boolean $cfg['Export']['sql_create_table_statements']
1852 $cfg['Export']['sql_create_table_statements'] = true;
1855 * Whether to use complete inserts, extended inserts, both, or neither
1857 * @global string $cfg['Export']['sql_insert_syntax']
1859 $cfg['Export']['sql_insert_syntax'] = 'both';
1864 * @global string $cfg['Export']['pdf_report_title']
1866 $cfg['Export']['pdf_report_title'] = '';
1871 *@global string $cfg['Export']['xml_structure_or_data']
1873 $cfg['Export']['xml_structure_or_data'] = 'data';
1876 * Export schema for each structure
1878 * @global string $cfg['Export']['xml_export_struc']
1880 $cfg['Export']['xml_export_struc'] = true;
1883 * Export functions
1885 * @global string $cfg['Export']['xml_export_functions']
1887 $cfg['Export']['xml_export_functions'] = true;
1890 * Export procedures
1892 * @global string $cfg['Export']['xml_export_procedures']
1894 $cfg['Export']['xml_export_procedures'] = true;
1897 * Export schema for each table
1899 * @global string $cfg['Export']['xml_export_tables']
1901 $cfg['Export']['xml_export_tables'] = true;
1904 * Export triggers
1906 * @global string $cfg['Export']['xml_export_triggers']
1908 $cfg['Export']['xml_export_triggers'] = true;
1911 * Export views
1913 * @global string $cfg['Export']['xml_export_views']
1915 $cfg['Export']['xml_export_views'] = true;
1918 * Export contents data
1920 * @global string $cfg['Export']['xml_export_contents']
1922 $cfg['Export']['xml_export_contents'] = true;
1927 * @global string $cfg['Export']['yaml_structure_or_data']
1929 $cfg['Export']['yaml_structure_or_data'] = 'data';
1931 /*******************************************************************************
1932 * Import defaults
1934 $cfg['Import'] = array();
1939 * @global string $cfg['Import']['format']
1941 $cfg['Import']['format'] = 'sql';
1944 * Default charset for import.
1946 * @global string $cfg['Import']['charset']
1948 $cfg['Import']['charset'] = '';
1953 * @global boolean $cfg['Import']['allow_interrupt']
1955 $cfg['Import']['allow_interrupt'] = true;
1960 * @global integer $cfg['Import']['skip_queries']
1962 $cfg['Import']['skip_queries'] = 0;
1967 * @global string $cfg['Import']['sql_compatibility']
1969 $cfg['Import']['sql_compatibility'] = 'NONE';
1974 * @global string $cfg['Import']['sql_no_auto_value_on_zero']
1976 $cfg['Import']['sql_no_auto_value_on_zero'] = true;
1981 * @global boolean $cfg['Import']['csv_replace']
1983 $cfg['Import']['csv_replace'] = false;
1988 * @global boolean $cfg['Import']['csv_ignore']
1990 $cfg['Import']['csv_ignore'] = false;
1995 * @global string $cfg['Import']['csv_terminated']
1997 $cfg['Import']['csv_terminated'] = ',';
2002 * @global string $cfg['Import']['csv_enclosed']
2004 $cfg['Import']['csv_enclosed'] = '"';
2009 * @global string $cfg['Import']['csv_escaped']
2011 $cfg['Import']['csv_escaped'] = '"';
2016 * @global string $cfg['Import']['csv_new_line']
2018 $cfg['Import']['csv_new_line'] = 'auto';
2023 * @global string $cfg['Import']['csv_columns']
2025 $cfg['Import']['csv_columns'] = '';
2030 * @global string $cfg['Import']['csv_col_names']
2032 $cfg['Import']['csv_col_names'] = false;
2037 * @global boolean $cfg['Import']['ldi_replace']
2039 $cfg['Import']['ldi_replace'] = false;
2044 * @global boolean $cfg['Import']['ldi_ignore']
2046 $cfg['Import']['ldi_ignore'] = false;
2051 * @global string $cfg['Import']['ldi_terminated']
2053 $cfg['Import']['ldi_terminated'] = ';';
2058 * @global string $cfg['Import']['ldi_enclosed']
2060 $cfg['Import']['ldi_enclosed'] = '"';
2065 * @global string $cfg['Import']['ldi_escaped']
2067 $cfg['Import']['ldi_escaped'] = '\\';
2072 * @global string $cfg['Import']['ldi_new_line']
2074 $cfg['Import']['ldi_new_line'] = 'auto';
2079 * @global string $cfg['Import']['ldi_columns']
2081 $cfg['Import']['ldi_columns'] = '';
2084 * 'auto' for auto-detection, true or false for forcing
2086 * @global string $cfg['Import']['ldi_local_option']
2088 $cfg['Import']['ldi_local_option'] = 'auto';
2093 * @global string $cfg['Import']['ods_col_names']
2095 $cfg['Import']['ods_col_names'] = false;
2100 * @global string $cfg['Import']['ods_empty_rows']
2102 $cfg['Import']['ods_empty_rows'] = true;
2107 * @global string $cfg['Import']['ods_recognize_percentages']
2109 $cfg['Import']['ods_recognize_percentages'] = true;
2114 * @global string $cfg['Import']['ods_recognize_currency']
2116 $cfg['Import']['ods_recognize_currency'] = true;
2121 * @global string $cfg['Import']['xml_col_names']
2123 $cfg['Import']['xls_col_names'] = false;
2128 * @global string $cfg['Import']['xml_empty_rows']
2130 $cfg['Import']['xls_empty_rows'] = true;
2135 * @global string $cfg['Import']['xlsx_col_names']
2137 $cfg['Import']['xlsx_col_names'] = false;
2140 * Link to the official MySQL documentation.
2141 * Be sure to include no trailing slash on the path.
2142 * See http://dev.mysql.com/doc/ for more information
2143 * about MySQL manuals and their types.
2145 * @global string $cfg['MySQLManualBase']
2147 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
2150 * Type of MySQL documentation:
2151 * viewable - "viewable online", current one used on MySQL website
2152 * searchable - "Searchable, with user comments"
2153 * chapters - "HTML, one page per chapter"
2154 * chapters_old - "HTML, one page per chapter",
2155 * format used prior to MySQL 5.0 release
2156 * big - "HTML, all on one page"
2157 * old - old style used in phpMyAdmin 2.3.0 and sooner
2158 * none - do not show documentation links
2160 * @global string $cfg['MySQLManualType']
2162 $cfg['MySQLManualType'] = 'viewable';
2165 /*******************************************************************************
2166 * PDF options
2172 * @global array $cfg['PDFPageSizes']
2174 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
2179 * @global string $cfg['PDFDefaultPageSize']
2181 $cfg['PDFDefaultPageSize'] = 'A4';
2184 /*******************************************************************************
2185 * Language and character set conversion settings
2189 * Default language to use, if not browser-defined or user-defined
2191 * @global string $cfg['DefaultLang']
2193 $cfg['DefaultLang'] = 'en';
2196 * Default connection collation
2198 * @global string $cfg['DefaultConnectionCollation']
2200 $cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
2203 * Force: always use this language
2204 * $cfg['Lang'] = 'en';
2206 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
2207 * English only
2209 * @global string $cfg['FilterLanguages']
2211 $cfg['FilterLanguages'] = '';
2214 * You can select here which functions will be used for character set conversion.
2215 * Possible values are:
2216 * auto - automatically use available one (first is tested iconv, then
2217 * recode)
2218 * iconv - use iconv or libiconv functions
2219 * recode - use recode_string function
2220 * none - disable encoding conversion
2222 * @global string $cfg['RecodingEngine']
2224 $cfg['RecodingEngine'] = 'auto';
2227 * Specify some parameters for iconv used in character set conversion. See iconv
2228 * documentation for details:
2229 * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
2231 * @global string $cfg['IconvExtraParams']
2233 $cfg['IconvExtraParams'] = '//TRANSLIT';
2236 * Available character sets for MySQL conversion. currently contains all which could
2237 * be found in lang/* files and few more.
2238 * Character sets will be shown in same order as here listed, so if you frequently
2239 * use some of these move them to the top.
2241 * @global array $cfg['AvailableCharsets']
2243 $cfg['AvailableCharsets'] = array(
2244 'iso-8859-1',
2245 'iso-8859-2',
2246 'iso-8859-3',
2247 'iso-8859-4',
2248 'iso-8859-5',
2249 'iso-8859-6',
2250 'iso-8859-7',
2251 'iso-8859-8',
2252 'iso-8859-9',
2253 'iso-8859-10',
2254 'iso-8859-11',
2255 'iso-8859-12',
2256 'iso-8859-13',
2257 'iso-8859-14',
2258 'iso-8859-15',
2259 'windows-1250',
2260 'windows-1251',
2261 'windows-1252',
2262 'windows-1256',
2263 'windows-1257',
2264 'koi8-r',
2265 'big5',
2266 'gb2312',
2267 'utf-16',
2268 'utf-8',
2269 'utf-7',
2270 'x-user-defined',
2271 'euc-jp',
2272 'ks_c_5601-1987',
2273 'tis-620',
2274 'SHIFT_JIS'
2278 /*******************************************************************************
2279 * Customization & design
2281 * The graphical settings are now located in themes/theme-name/layout.inc.php
2285 * enable the left panel pointer
2286 * see also LeftPointerColor
2287 * in layout.inc.php
2289 * @global boolean $cfg['NavigationTreePointerEnable']
2291 $cfg['NavigationTreePointerEnable'] = true;
2294 * enable the browse pointer
2295 * see also BrowsePointerColor
2296 * in layout.inc.php
2298 * @global boolean $cfg['BrowsePointerEnable']
2300 $cfg['BrowsePointerEnable'] = true;
2303 * enable the browse marker
2304 * see also BrowseMarkerColor
2305 * in layout.inc.php
2307 * @global boolean $cfg['BrowseMarkerEnable']
2309 $cfg['BrowseMarkerEnable'] = true;
2312 * textarea size (columns) in edit mode
2313 * (this value will be emphasized (*2) for SQL
2314 * query textareas and (*1.25) for query window)
2316 * @global integer $cfg['TextareaCols']
2318 $cfg['TextareaCols'] = 40;
2321 * textarea size (rows) in edit mode
2323 * @global integer $cfg['TextareaRows']
2325 $cfg['TextareaRows'] = 15;
2328 * double size of textarea size for LONGTEXT columns
2330 * @global boolean $cfg['LongtextDoubleTextarea']
2332 $cfg['LongtextDoubleTextarea'] = true;
2335 * auto-select when clicking in the textarea of the query-box
2337 * @global boolean $cfg['TextareaAutoSelect']
2339 $cfg['TextareaAutoSelect'] = false;
2342 * textarea size (columns) for CHAR/VARCHAR
2344 * @global integer $cfg['CharTextareaCols']
2346 $cfg['CharTextareaCols'] = 40;
2349 * textarea size (rows) for CHAR/VARCHAR
2351 * @global integer $cfg['CharTextareaRows']
2353 $cfg['CharTextareaRows'] = 2;
2356 * Max field data length in browse mode for all non-numeric fields
2358 * @global integer $cfg['LimitChars']
2360 $cfg['LimitChars'] = 50;
2363 * Where to show the edit/copy/delete links in browse mode
2364 * Possible values are 'left', 'right', 'both' and 'none';
2365 * which will be interpreted as 'top', 'bottom', 'both' and 'none'
2366 * respectively for vertical display mode
2368 * @global string $cfg['RowActionLinks']
2370 $cfg['RowActionLinks'] = 'left';
2373 * default display direction (horizontal|vertical|horizontalflipped)
2375 * @global string $cfg['DefaultDisplay']
2377 $cfg['DefaultDisplay'] = 'horizontal';
2380 * remember the last way a table sorted
2382 * @global string $cfg['RememberSorting']
2384 $cfg['RememberSorting'] = true;
2387 * table-header rotation via faking or CSS? (css|fake|auto)
2388 * NOTE: CSS only works in IE browsers!
2390 * @global string $cfg['HeaderFlipType']
2392 $cfg['HeaderFlipType'] = 'auto';
2395 * shows stored relation-comments in 'browse' mode.
2397 * @global boolean $cfg['ShowBrowseComments']
2399 $cfg['ShowBrowseComments'] = true;
2402 * shows stored relation-comments in 'table property' mode.
2404 * @global boolean $cfg['ShowPropertyComments']
2406 $cfg['ShowPropertyComments']= true;
2409 * shows table display direction.
2411 $cfg['ShowDisplayDirection'] = false;
2414 * repeat header names every X cells? (0 = deactivate)
2416 * @global integer $cfg['RepeatCells']
2418 $cfg['RepeatCells'] = 100;
2421 * Set to true if Edit link should open the query to edit in the query window
2422 * and to false if we should edit in the right panel
2424 * @global boolean $cfg['EditInWindow']
2426 $cfg['EditInWindow'] = true;
2429 * Width of Query window
2431 * @global integer $cfg['QueryWindowWidth']
2433 $cfg['QueryWindowWidth'] = 550;
2436 * Height of Query window
2438 * @global integer $cfg['QueryWindowHeight']
2440 $cfg['QueryWindowHeight'] = 310;
2443 * Set to true if you want DB-based query history.If false, this utilizes
2444 * JS-routines to display query history (lost by window close)
2446 * @global boolean $cfg['QueryHistoryDB']
2448 $cfg['QueryHistoryDB'] = false;
2451 * which tab to display in the querywindow on startup
2452 * (sql|files|history|full)
2454 * @global string $cfg['QueryWindowDefTab']
2456 $cfg['QueryWindowDefTab'] = 'sql';
2459 * When using DB-based query history, how many entries should be kept?
2461 * @global integer $cfg['QueryHistoryMax']
2463 $cfg['QueryHistoryMax'] = 25;
2466 * Use MIME-Types (stored in column comments table) for
2468 * @global boolean $cfg['BrowseMIME']
2470 $cfg['BrowseMIME'] = true;
2473 * When approximate count < this, PMA will get exact count for table rows.
2475 * @global integer $cfg['MaxExactCount']
2477 $cfg['MaxExactCount'] = 0;
2480 * Zero means that no row count is done for views; see the doc
2482 * @global integer $cfg['MaxExactCountViews']
2484 $cfg['MaxExactCountViews'] = 0;
2487 * Sort table and database in natural order
2489 * @global boolean $cfg['NaturalOrder']
2491 $cfg['NaturalOrder'] = true;
2494 * Initial state for sliders
2495 * (open | closed | disabled)
2497 * @global string $cfg['InitialSlidersState']
2499 $cfg['InitialSlidersState'] = 'closed';
2502 * User preferences: disallow these settings
2503 * For possible setting names look in libraries/config/user_preferences.forms.php
2505 * @global array $cfg['UserprefsDisallow']
2507 $cfg['UserprefsDisallow'] = array();
2510 * User preferences: enable the Developer tab
2512 $cfg['UserprefsDeveloperTab'] = false;
2514 /*******************************************************************************
2515 * Window title settings
2519 * title of browser window when a table is selected
2521 * @global string $cfg['TitleTable']
2523 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
2526 * title of browser window when a database is selected
2528 * @global string $cfg['TitleDatabase']
2530 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
2533 * title of browser window when a server is selected
2535 * @global string $cfg['TitleServer']
2537 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
2540 * title of browser window when nothing is selected
2541 * @global string $cfg['TitleDefault']
2543 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
2546 /*******************************************************************************
2547 * theme manager
2551 * using themes manager please set up here the path to 'themes' else leave empty
2553 * @global string $cfg['ThemePath']
2555 $cfg['ThemePath'] = './themes';
2558 * if you want to use selectable themes and if ThemesPath not empty
2559 * set it to true, else set it to false (default is false);
2561 * @global boolean $cfg['ThemeManager']
2563 $cfg['ThemeManager'] = true;
2566 * set up default theme, if ThemePath not empty you can set up here an valid
2567 * path to themes or 'original' for the original pma-theme
2569 * @global string $cfg['ThemeDefault']
2571 $cfg['ThemeDefault'] = 'pmahomme';
2574 * allow different theme for each configured server
2576 * @global boolean $cfg['ThemePerServer']
2578 $cfg['ThemePerServer'] = false;
2581 /*******************************************************************************
2586 * Default query for table
2588 * @global string $cfg['DefaultQueryTable']
2590 $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
2593 * Default query for database
2595 * @global string $cfg['DefaultQueryDatabase']
2597 $cfg['DefaultQueryDatabase'] = '';
2600 /*******************************************************************************
2601 * SQL Query box settings
2602 * These are the links display in all of the SQL Query boxes
2604 * @global array $cfg['SQLQuery']
2606 $cfg['SQLQuery'] = array();
2609 * Edit link to change a query
2611 * @global boolean $cfg['SQLQuery']['Edit']
2613 $cfg['SQLQuery']['Edit'] = true;
2616 * EXPLAIN on SELECT queries
2618 * @global boolean $cfg['SQLQuery']['Explain']
2620 $cfg['SQLQuery']['Explain'] = true;
2623 * Wrap a query in PHP
2625 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2627 $cfg['SQLQuery']['ShowAsPHP'] = true;
2630 * Validate a query (see $cfg['SQLValidator'] as well)
2632 * @global boolean $cfg['SQLQuery']['Validate']
2634 $cfg['SQLQuery']['Validate'] = false;
2637 * Refresh the results page
2639 * @global boolean $cfg['SQLQuery']['Refresh']
2641 $cfg['SQLQuery']['Refresh'] = true;
2644 /*******************************************************************************
2645 * Web server upload/save/import directories
2649 * Directory for uploaded files that can be executed by phpMyAdmin.
2650 * For example './upload'. Leave empty for no upload directory support.
2651 * Use %u for username inclusion.
2653 * @global string $cfg['UploadDir']
2655 $cfg['UploadDir'] = '';
2658 * Directory where phpMyAdmin can save exported data on server.
2659 * For example './save'. Leave empty for no save directory support.
2660 * Use %u for username inclusion.
2662 * @global string $cfg['SaveDir']
2664 $cfg['SaveDir'] = '';
2667 * Directory where phpMyAdmin can save temporary files.
2669 * @global string $cfg['TempDir']
2671 $cfg['TempDir'] = '';
2675 * Misc. settings
2679 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2680 * which is the only safe way to determine GD version.
2682 * @global string $cfg['GD2Available']
2684 $cfg['GD2Available'] = 'auto';
2687 * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
2689 * @global array $cfg['TrustedProxies']
2691 $cfg['TrustedProxies'] = array();
2694 * We normally check the permissions on the configuration file to ensure
2695 * it's not world writable. However, phpMyAdmin could be installed on
2696 * a NTFS filesystem mounted on a non-Windows server, in which case the
2697 * permissions seems wrong but in fact cannot be detected. In this case
2698 * a sysadmin would set the following to false.
2700 $cfg['CheckConfigurationPermissions'] = true;
2703 * Limit for length of URL in links. When length would be above this limit, it
2704 * is replaced by form with button.
2705 * This is required as some web servers (IIS) have problems with long URLs.
2706 * The recommended limit is 2000
2707 * (see http://www.boutell.com/newfaq/misc/urllength.html) but we put
2708 * 1000 to accommodate Suhosin, see bug #3358750.
2710 $cfg['LinkLengthLimit'] = 1000;
2713 * Additional string to allow in CSP headers.
2715 $cfg['CSPAllow'] = '';
2718 * Disable the table maintenance mass operations, like optimizing or
2719 * repairing the selected tables of a database. An accidental execution
2720 * of such a maintenance task can enormously slow down a bigger database.
2722 $cfg['DisableMultiTableMaintenance'] = false;
2724 /*******************************************************************************
2725 * SQL Parser Settings
2727 * @global array $cfg['SQP']
2729 $cfg['SQP'] = array();
2732 * Pretty-printing style to use on queries (html, text, none)
2734 * @global string $cfg['SQP']['fmtType']
2736 $cfg['SQP']['fmtType'] = 'html';
2739 * Amount to indent each level (floats are valid)
2741 * @global integer $cfg['SQP']['fmtInd']
2743 $cfg['SQP']['fmtInd'] = '1';
2746 * Units for indenting each level (CSS Types - {em, px, pt})
2748 * @global string $cfg['SQP']['fmtIndUnit']
2750 $cfg['SQP']['fmtIndUnit'] = 'em';
2753 /*******************************************************************************
2754 * If you wish to use the SQL Validator service, you should be aware of the
2755 * following:
2756 * All SQL statements are stored anonymously for statistical purposes.
2757 * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
2758 * All rights reserved.
2760 * @global array $cfg['SQLValidator']
2762 $cfg['SQLValidator'] = array();
2765 * Make the SQL Validator available
2767 * @global boolean $cfg['SQLValidator']['use']
2769 $cfg['SQLValidator']['use'] = false;
2772 * If you have a custom username, specify it here (defaults to anonymous)
2774 * @global string $cfg['SQLValidator']['username']
2776 $cfg['SQLValidator']['username'] = '';
2779 * Password for username
2781 * @global string $cfg['SQLValidator']['password']
2783 $cfg['SQLValidator']['password'] = '';
2786 /*******************************************************************************
2787 * Developers ONLY!
2789 * @global array $cfg['DBG']
2791 $cfg['DBG'] = array();
2794 * Output executed queries and their execution times
2796 * @global boolean $cfg['DBG']['sql']
2798 $cfg['DBG']['sql'] = false;
2801 /*******************************************************************************
2802 * MySQL settings
2806 * Default functions for above defined groups
2808 * @global array $cfg['DefaultFunctions']
2810 $cfg['DefaultFunctions'] = array(
2811 'FUNC_CHAR' => '',
2812 'FUNC_DATE' => '',
2813 'FUNC_NUMBER' => '',
2814 'FUNC_SPATIAL' => 'GeomFromText',
2815 'FUNC_UUID' => 'UUID',
2816 'first_timestamp' => 'NOW',
2820 * Max rows retreived for zoom search
2822 $cfg['maxRowPlotLimit'] = 500;