Translated using Weblate (Bulgarian)
[phpmyadmin.git] / libraries / config.default.php
blob7eef0e071156bdad15bdba6dcde242e2ea709dc1
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
21 declare(strict_types=1);
23 /**
24 * Your phpMyAdmin URL.
26 * Complete the variable below with the full URL ie
27 * https://example.com/path_to_your_phpMyAdmin_directory/
29 * It must contain characters that are valid for a URL, and the path is
30 * case sensitive on some Web servers, for example Unix-based servers.
32 * In most cases you can leave this variable empty, as the correct value
33 * will be detected automatically. However, we recommend that you do
34 * test to see that the auto-detection code works in your system. A good
35 * test is to browse a table, then edit a row and save it. There will be
36 * an error message if phpMyAdmin cannot auto-detect the correct value.
38 * @global string $cfg['PmaAbsoluteUri']
40 $cfg['PmaAbsoluteUri'] = '';
42 /**
43 * Configure authentication logging destination
45 * @global string $cfg['AuthLog']
47 $cfg['AuthLog'] = 'auto';
49 /**
50 * Whether to log successful authentication attempts
52 * @global boolean $cfg['AuthLogSuccess']
54 $cfg['AuthLogSuccess'] = false;
56 /**
57 * Disable the default warning that is displayed on the DB Details Structure page if
58 * any of the required Tables for the configuration storage could not be found
60 * @global boolean $cfg['PmaNoRelation_DisableWarning']
62 $cfg['PmaNoRelation_DisableWarning'] = false;
64 /**
65 * Disable the default warning that is displayed if Suhosin is detected
67 * @global boolean $cfg['SuhosinDisableWarning']
69 $cfg['SuhosinDisableWarning'] = false;
71 /**
72 * Disable the default warning that is displayed if session.gc_maxlifetime
73 * is less than `LoginCookieValidity`
75 * @global boolean $cfg['LoginCookieValidityDisableWarning']
77 $cfg['LoginCookieValidityDisableWarning'] = false;
79 /**
80 * Disable the default warning about MySQL reserved words in column names
82 * @global boolean $cfg['ReservedWordDisableWarning']
84 $cfg['ReservedWordDisableWarning'] = false;
86 /**
87 * Show warning about incomplete translations on certain threshold.
89 * @global boolean $cfg['TranslationWarningThreshold']
91 $cfg['TranslationWarningThreshold'] = 80;
93 /**
94 * Allows phpMyAdmin to be included from a other document in a frame;
95 * setting this to true is a potential security hole. Setting this to
96 * 'sameorigin' prevents phpMyAdmin to be included from another document
97 * in a frame, unless that document belongs to the same domain.
99 * @global boolean|string $cfg['AllowThirdPartyFraming']
101 $cfg['AllowThirdPartyFraming'] = false;
104 * The 'cookie' auth_type uses AES algorithm to encrypt the password. If
105 * at least one server configuration uses 'cookie' auth_type, enter here a
106 * pass phrase that will be used by AES. The maximum length seems to be 46
107 * characters.
109 * @global string $cfg['blowfish_secret']
111 $cfg['blowfish_secret'] = '';
114 /*******************************************************************************
115 * Server(s) configuration
117 * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
118 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
119 * to ''. If you want more than one server, just copy following section
120 * (including $i incrementation) several times. There is no need to define
121 * full server array, just define values you need to change.
123 * @global array $cfg['Servers']
125 $cfg['Servers'] = [];
127 $i = 1;
130 * MySQL hostname or IP address
132 * @global string $cfg['Servers'][$i]['host']
134 $cfg['Servers'][$i]['host'] = 'localhost';
137 * MySQL port - leave blank for default port
139 * @global string $cfg['Servers'][$i]['port']
141 $cfg['Servers'][$i]['port'] = '';
144 * Path to the socket - leave blank for default socket
146 * @global string $cfg['Servers'][$i]['socket']
148 $cfg['Servers'][$i]['socket'] = '';
151 * Use SSL for connecting to MySQL server?
153 * @global boolean $cfg['Servers'][$i]['ssl']
155 $cfg['Servers'][$i]['ssl'] = false;
158 * Path to the key file when using SSL for connecting to the MySQL server
160 * @global string $cfg['Servers'][$i]['ssl_key']
162 $cfg['Servers'][$i]['ssl_key'] = null;
165 * Path to the cert file when using SSL for connecting to the MySQL server
167 * @global string $cfg['Servers'][$i]['ssl_cert']
169 $cfg['Servers'][$i]['ssl_cert'] = null;
172 * Path to the CA file when using SSL for connecting to the MySQL server
174 * @global string $cfg['Servers'][$i]['ssl_ca']
176 $cfg['Servers'][$i]['ssl_ca'] = null;
179 * Directory containing trusted SSL CA certificates in PEM format
181 * @global string $cfg['Servers'][$i]['ssl_ca_path']
183 $cfg['Servers'][$i]['ssl_ca_path'] = null;
186 * List of allowable ciphers for SSL connections to the MySQL server
188 * @global string $cfg['Servers'][$i]['ssl_ciphers']
190 $cfg['Servers'][$i]['ssl_ciphers'] = null;
193 * MySQL 5.6 or later triggers the mysqlnd driver in PHP to validate the
194 * peer_name of the SSL certifcate
195 * For most self-signed certificates this is a problem. Setting this to false
196 * will disable the check and allow the connection (PHP 5.6.16 or later)
198 * @link https://bugs.php.net/68344
199 * @global string $cfg['Servers'][$i]['ssl_verify']
201 $cfg['Servers'][$i]['ssl_verify'] = true;
204 * Use compressed protocol for the MySQL connection
206 * @global boolean $cfg['Servers'][$i]['compress']
208 $cfg['Servers'][$i]['compress'] = false;
211 * MySQL control host. This permits to use a host different than the
212 * main host, for the phpMyAdmin configuration storage. If left empty,
213 * $cfg['Servers'][$i]['host'] is used instead.
215 * @global string $cfg['Servers'][$i]['controlhost']
217 $cfg['Servers'][$i]['controlhost'] = '';
220 * MySQL control port. This permits to use a port different than the
221 * main port, for the phpMyAdmin configuration storage. If left empty,
222 * $cfg['Servers'][$i]['port'] is used instead.
224 * @global string $cfg['Servers'][$i]['controlport']
226 $cfg['Servers'][$i]['controlport'] = '';
229 * MySQL control user settings (this user must have read-only
230 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
231 * used for all relational features (pmadb)
233 * @global string $cfg['Servers'][$i]['controluser']
235 $cfg['Servers'][$i]['controluser'] = '';
238 * MySQL control user settings (this user must have read-only
239 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
240 * used for all relational features (pmadb)
242 * @global string $cfg['Servers'][$i]['controlpass']
244 $cfg['Servers'][$i]['controlpass'] = '';
247 * Authentication method (valid choices: config, http, signon or cookie)
249 * @global string $cfg['Servers'][$i]['auth_type']
251 $cfg['Servers'][$i]['auth_type'] = 'cookie';
254 * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
256 * @global string $cfg['Servers'][$i]['auth_http_realm']
258 $cfg['Servers'][$i]['auth_http_realm'] = '';
261 * MySQL user
263 * @global string $cfg['Servers'][$i]['user']
265 $cfg['Servers'][$i]['user'] = 'root';
268 * MySQL password (only needed with 'config' auth_type)
270 * @global string $cfg['Servers'][$i]['password']
272 $cfg['Servers'][$i]['password'] = '';
275 * Session to use for 'signon' authentication method
277 * @global string $cfg['Servers'][$i]['SignonSession']
279 $cfg['Servers'][$i]['SignonSession'] = '';
282 * Cookie params to match session to use for 'signon' authentication method
283 * It should be an associative array matching result of session_get_cookie_params() in other system
285 * @global array $cfg['Servers'][$i]['SignonCookieParams']
287 $cfg['Servers'][$i]['SignonCookieParams'] = [];
290 * PHP script to use for 'signon' authentication method
292 * @global string $cfg['Servers'][$i]['SignonScript']
294 $cfg['Servers'][$i]['SignonScript'] = '';
297 * URL where to redirect user to login for 'signon' authentication method
299 * @global string $cfg['Servers'][$i]['SignonURL']
301 $cfg['Servers'][$i]['SignonURL'] = '';
304 * URL where to redirect user after logout
306 * @global string $cfg['Servers'][$i]['LogoutURL']
308 $cfg['Servers'][$i]['LogoutURL'] = '';
311 * If set to a db-name, only this db is displayed in navigation panel
312 * It may also be an array of db-names
314 * @global string $cfg['Servers'][$i]['only_db']
316 $cfg['Servers'][$i]['only_db'] = '';
319 * Database name to be hidden from listings
321 * @global string $cfg['Servers'][$i]['hide_db']
323 $cfg['Servers'][$i]['hide_db'] = '';
326 * Verbose name for this host - leave blank to show the hostname
327 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
329 * @global string $cfg['Servers'][$i]['verbose']
331 $cfg['Servers'][$i]['verbose'] = '';
334 * Database used for Relation, Bookmark and PDF Features
335 * (see sql/create_tables.sql)
336 * - leave blank for no support
337 * SUGGESTED: 'phpmyadmin'
339 * @global string $cfg['Servers'][$i]['pmadb']
341 $cfg['Servers'][$i]['pmadb'] = '';
344 * Bookmark table
345 * - leave blank for no bookmark support
346 * SUGGESTED: 'pma__bookmark'
348 * @global string $cfg['Servers'][$i]['bookmarktable']
350 $cfg['Servers'][$i]['bookmarktable'] = '';
353 * table to describe the relation between links (see doc)
354 * - leave blank for no relation-links support
355 * SUGGESTED: 'pma__relation'
357 * @global string $cfg['Servers'][$i]['relation']
359 $cfg['Servers'][$i]['relation'] = '';
362 * table to describe the display fields
363 * - leave blank for no display fields support
364 * SUGGESTED: 'pma__table_info'
366 * @global string $cfg['Servers'][$i]['table_info']
368 $cfg['Servers'][$i]['table_info'] = '';
371 * table to describe the tables position for the designer and PDF schema
372 * - leave blank for no PDF schema support
373 * SUGGESTED: 'pma__table_coords'
375 * @global string $cfg['Servers'][$i]['table_coords']
377 $cfg['Servers'][$i]['table_coords'] = '';
380 * table to describe pages of relationpdf
381 * - leave blank if you don't want to use this
382 * SUGGESTED: 'pma__pdf_pages'
384 * @global string $cfg['Servers'][$i]['pdf_pages']
386 $cfg['Servers'][$i]['pdf_pages'] = '';
389 * table to store column information
390 * - leave blank for no column comments/mime types
391 * SUGGESTED: 'pma__column_info'
393 * @global string $cfg['Servers'][$i]['column_info']
395 $cfg['Servers'][$i]['column_info'] = '';
398 * table to store SQL history
399 * - leave blank for no SQL query history
400 * SUGGESTED: 'pma__history'
402 * @global string $cfg['Servers'][$i]['history']
404 $cfg['Servers'][$i]['history'] = '';
407 * table to store recently used tables
408 * - leave blank for no "persistent" recently used tables
409 * SUGGESTED: 'pma__recent'
411 $cfg['Servers'][$i]['recent'] = '';
414 * table to store favorite tables
415 * - leave blank for no favorite tables
416 * SUGGESTED: 'pma__favorite'
418 $cfg['Servers'][$i]['favorite'] = '';
421 * table to store UI preferences for tables
422 * - leave blank for no "persistent" UI preferences
423 * SUGGESTED: 'pma__table_uiprefs'
425 $cfg['Servers'][$i]['table_uiprefs'] = '';
428 * table to store SQL tracking
429 * - leave blank for no SQL tracking
430 * SUGGESTED: 'pma__tracking'
432 * @global string $cfg['Servers'][$i]['tracking']
434 $cfg['Servers'][$i]['tracking'] = '';
437 * table to store user preferences
438 * - leave blank to disable server storage
439 * SUGGESTED: 'pma__userconfig'
441 * @global string $cfg['Servers'][$i]['userconfig']
443 $cfg['Servers'][$i]['userconfig'] = '';
446 * table to store users and their assignment to user groups
447 * - leave blank to disable configurable menus feature
448 * SUGGESTED: 'pma__users'
450 * @global string $cfg['Servers'][$i]['users']
452 $cfg['Servers'][$i]['users'] = '';
455 * table to store allowed menu items for each user group
456 * - leave blank to disable configurable menus feature
457 * SUGGESTED: 'pma__usergroups'
459 * @global string $cfg['Servers'][$i]['usergroups']
461 $cfg['Servers'][$i]['usergroups'] = '';
464 * table to store information about item hidden from navigation tree
465 * - leave blank to disable hide/show navigation items feature
466 * SUGGESTED: 'pma__navigationhiding'
468 * @global string $cfg['Servers'][$i]['navigationhiding']
470 $cfg['Servers'][$i]['navigationhiding'] = '';
473 * table to store information about saved searches from query-by-example on a db
474 * - leave blank to disable saved searches feature
475 * SUGGESTED: 'pma__savedsearches'
477 * @global string $cfg['Servers'][$i]['savedsearches']
479 $cfg['Servers'][$i]['savedsearches'] = '';
482 * table to store central list of columns per database
483 * - leave blank to disable central list of columns feature
484 * SUGGESTED: 'pma__central_columns'
486 * @global string $cfg['Servers'][$i]['central_columns']
488 $cfg['Servers'][$i]['central_columns'] = '';
491 * table to store designer settings
492 * - leave blank to disable the storage of designer settings
493 * SUGGESTED: 'pma__designer_settings'
495 * @global string $cfg['Servers'][$i]['designer_settings']
497 $cfg['Servers'][$i]['designer_settings'] = '';
500 * table to store export templates
501 * - leave blank to disable saved searches feature
502 * SUGGESTED: 'pma__export_templates'
504 * @global string $cfg['Servers'][$i]['export_templates']
506 $cfg['Servers'][$i]['export_templates'] = '';
509 * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
511 * In case where tables in databases is modified (e.g. dropped or renamed),
512 * table_uiprefs may contains invalid data (referring to tables which are not
513 * exist anymore).
514 * This configuration make sure that we only keep N (N = MaxTableUiprefs)
515 * newest record in table_uiprefs and automatically delete older records.
517 * @global integer $cfg['Servers'][$i]['userconfig'] = '';
519 $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
522 * Sets the time zone used by phpMyAdmin. Possible values are explained at
523 * https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
525 * @global string $cfg['Servers'][$i]['SessionTimeZone'] = ''
527 $cfg['Servers'][$i]['SessionTimeZone'] = '';
530 * whether to allow root login
532 * @global boolean $cfg['Servers'][$i]['AllowRoot']
534 $cfg['Servers'][$i]['AllowRoot'] = true;
537 * whether to allow login of any user without a password
539 * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
541 $cfg['Servers'][$i]['AllowNoPassword'] = false;
544 * Host authentication order, leave blank to not use
546 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
548 $cfg['Servers'][$i]['AllowDeny']['order'] = '';
551 * Host authentication rules, leave blank for defaults
553 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
555 $cfg['Servers'][$i]['AllowDeny']['rules'] = [];
558 * Disable use of INFORMATION_SCHEMA.
560 * @see https://github.com/phpmyadmin/phpmyadmin/issues/8970
561 * @see https://bugs.mysql.com/19588
562 * @global boolean $cfg['Servers'][$i]['DisableIS']
564 $cfg['Servers'][$i]['DisableIS'] = false;
567 * Whether the tracking mechanism creates
568 * versions for tables and views automatically.
570 * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
572 $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
575 * Defines the list of statements
576 * the auto-creation uses for new versions.
578 * @global string $cfg['Servers'][$i]['tracking_default_statements']
580 $cfg['Servers'][$i]['tracking_default_statements']
581 = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
582 'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
583 'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
586 * Whether a DROP VIEW IF EXISTS statement will be added
587 * as first line to the log when creating a view.
589 * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
591 $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
594 * Whether a DROP TABLE IF EXISTS statement will be added
595 * as first line to the log when creating a table.
597 * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
599 $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
602 * Whether a DROP DATABASE IF EXISTS statement will be added
603 * as first line to the log when creating a database.
605 * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
607 $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
610 * Default server (0 = no default server)
612 * If you have more than one server configured, you can set $cfg['ServerDefault']
613 * to any one of them to auto-connect to that server when phpMyAdmin is started,
614 * or set it to 0 to be given a list of servers without logging in
615 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
616 * set to that server.
618 * @global integer $cfg['ServerDefault']
620 $cfg['ServerDefault'] = 1;
623 * Other core phpMyAdmin settings
627 * whether version check is active
629 * @global boolean $cfg['VersionCheck']
631 if (defined('VERSION_CHECK_DEFAULT')) {
632 $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
633 } else {
634 $cfg['VersionCheck'] = true;
638 * The url of the proxy to be used when retrieving the information about
639 * the latest version of phpMyAdmin or error reporting. You need this if
640 * the server where phpMyAdmin is installed does not have direct access to
641 * the internet.
642 * The format is: "hostname:portnumber"
644 * @global string $cfg['ProxyUrl']
646 $cfg['ProxyUrl'] = "";
649 * The username for authenticating with the proxy. By default, no
650 * authentication is performed. If a username is supplied, Basic
651 * Authentication will be performed. No other types of authentication
652 * are currently supported.
654 * @global string $cfg['ProxyUser']
656 $cfg['ProxyUser'] = "";
659 * The password for authenticating with the proxy.
661 * @global string $cfg['ProxyPass']
663 $cfg['ProxyPass'] = "";
666 * maximum number of db's displayed in database list
668 * @global integer $cfg['MaxDbList']
670 $cfg['MaxDbList'] = 100;
673 * maximum number of tables displayed in table list
675 * @global integer $cfg['MaxTableList']
677 $cfg['MaxTableList'] = 250;
680 * whether to show hint or not
682 * @global boolean $cfg['ShowHint']
684 $cfg['ShowHint'] = true;
687 * maximum number of characters when a SQL query is displayed
689 * @global integer $cfg['MaxCharactersInDisplayedSQL']
691 $cfg['MaxCharactersInDisplayedSQL'] = 1000;
694 * use GZIP output buffering if possible (true|false|'auto')
696 * @global string $cfg['OBGzip']
698 $cfg['OBGzip'] = 'auto';
701 * use persistent connections to MySQL database
703 * @global boolean $cfg['PersistentConnections']
705 $cfg['PersistentConnections'] = false;
708 * maximum execution time in seconds (0 for no limit)
710 * @global integer $cfg['ExecTimeLimit']
712 $cfg['ExecTimeLimit'] = 300;
715 * Path for storing session data (session_save_path PHP parameter).
717 * @global integer $cfg['SessionSavePath']
719 $cfg['SessionSavePath'] = '';
722 * maximum allocated bytes ('-1' for no limit, '0' for no change)
723 * this is a string because '16M' is a valid value; we must put here
724 * a string as the default value so that /setup accepts strings
726 * @global string $cfg['MemoryLimit']
728 $cfg['MemoryLimit'] = '-1';
731 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
733 * @global boolean $cfg['SkipLockedTables']
735 $cfg['SkipLockedTables'] = false;
738 * show SQL queries as run
740 * @global boolean $cfg['ShowSQL']
742 $cfg['ShowSQL'] = true;
745 * retain SQL input on Ajax execute
747 * @global boolean $cfg['RetainQueryEditor']
749 $cfg['RetainQueryBox'] = false;
752 * use CodeMirror syntax highlighting for editing SQL
754 * @global boolean $cfg['CodemirrorEnable']
756 $cfg['CodemirrorEnable'] = true;
759 * use the parser to find any errors in the query before executing
761 * @global boolean $cfg['LintEnable']
763 $cfg['LintEnable'] = true;
766 * show a 'Drop database' link to normal users
768 * @global boolean $cfg['AllowUserDropDatabase']
770 $cfg['AllowUserDropDatabase'] = false;
773 * confirm some commands that can result in loss of data
775 * @global boolean $cfg['Confirm']
777 $cfg['Confirm'] = true;
780 * recall previous login in cookie authentication mode or not
782 * @global boolean $cfg['LoginCookieRecall']
784 $cfg['LoginCookieRecall'] = true;
787 * validity of cookie login (in seconds; 1440 matches php.ini's
788 * session.gc_maxlifetime)
790 * @global integer $cfg['LoginCookieValidity']
792 $cfg['LoginCookieValidity'] = 1440;
795 * how long login cookie should be stored (in seconds)
797 * @global integer $cfg['LoginCookieStore']
799 $cfg['LoginCookieStore'] = 0;
802 * whether to delete all login cookies on logout
804 * @global boolean $cfg['LoginCookieDeleteAll']
806 $cfg['LoginCookieDeleteAll'] = true;
809 * whether to enable the "database search" feature or not
811 * @global boolean $cfg['UseDbSearch']
813 $cfg['UseDbSearch'] = true;
816 * if set to true, PMA continues computing multiple-statement queries
817 * even if one of the queries failed
819 * @global boolean $cfg['IgnoreMultiSubmitErrors']
821 $cfg['IgnoreMultiSubmitErrors'] = false;
824 * allow login to any user entered server in cookie based authentication
826 * @global boolean $cfg['AllowArbitraryServer']
828 $cfg['AllowArbitraryServer'] = false;
831 * restrict by IP (with regular expression) the MySQL servers the user can enter
832 * when $cfg['AllowArbitraryServer'] = true
834 * @global string $cfg['ArbitraryServerRegexp']
836 $cfg['ArbitraryServerRegexp'] = '';
839 * To enable reCaptcha v2 checkbox mode if necessary
841 * @global string $cfg['CaptchaMethod']
843 $cfg['CaptchaMethod'] = 'invisible';
846 * if reCaptcha is enabled it needs public key to connect with the service
848 * @global string $cfg['CaptchaLoginPublicKey']
850 $cfg['CaptchaLoginPublicKey'] = '';
853 * if reCaptcha is enabled it needs private key to connect with the service
855 * @global string $cfg['CaptchaLoginPrivateKey']
857 $cfg['CaptchaLoginPrivateKey'] = '';
860 * Enable drag and drop import
861 * @see feature request : https://github.com/phpmyadmin/phpmyadmin/issues/13155
863 * @global bool $cfg['enable_drag_drop_import']
865 $cfg['enable_drag_drop_import'] = true;
867 /*******************************************************************************
868 * Navigation panel setup
872 * In the navigation panel, replaces the database tree with a selector
874 * @global boolean $cfg['ShowDatabasesNavigationAsTree']
876 $cfg['ShowDatabasesNavigationAsTree'] = true;
879 * maximum number of first level databases displayed in navigation panel
881 * @global integer $cfg['FirstLevelNavigationItems']
883 $cfg['FirstLevelNavigationItems'] = 100;
886 * maximum number of items displayed in navigation panel
888 * @global integer $cfg['MaxNavigationItems']
890 $cfg['MaxNavigationItems'] = 50;
893 * turn the select-based light menu into a tree
895 * @global boolean $cfg['NavigationTreeEnableGrouping']
897 $cfg['NavigationTreeEnableGrouping'] = true;
900 * the separator to sub-tree the select-based light menu tree
902 * @global string $cfg['NavigationTreeDbSeparator']
904 $cfg['NavigationTreeDbSeparator'] = '_';
907 * Which string will be used to generate table prefixes
908 * to split/nest tables into multiple categories
910 * @global string $cfg['NavigationTreeTableSeparator']
912 $cfg['NavigationTreeTableSeparator'] = '__';
915 * How many sublevels should be displayed when splitting up tables
916 * by the above Separator
918 * @global integer $cfg['NavigationTreeTableLevel']
920 $cfg['NavigationTreeTableLevel'] = 1;
923 * link with main panel by highlighting the current db/table
925 * @global boolean $cfg['NavigationLinkWithMainPanel']
927 $cfg['NavigationLinkWithMainPanel'] = true;
930 * display logo at top of navigation panel
932 * @global boolean $cfg['NavigationDisplayLogo']
934 $cfg['NavigationDisplayLogo'] = true;
937 * where should logo link point to (can also contain an external URL)
939 * @global string $cfg['NavigationLogoLink']
941 $cfg['NavigationLogoLink'] = 'index.php';
944 * whether to open the linked page in the main window ('main') or
945 * in a new window ('new')
947 * @global string $cfg['NavigationLogoLinkWindow']
949 $cfg['NavigationLogoLinkWindow'] = 'main';
952 * number of recently used tables displayed in the navigation panel
954 * @global integer $cfg['NumRecentTables']
956 $cfg['NumRecentTables'] = 10;
959 * number of favorite tables displayed in the navigation panel
961 * @global integer $cfg['NumFavoriteTables']
963 $cfg['NumFavoriteTables'] = 10;
966 * display a JavaScript table filter in the navigation panel
967 * when more then x tables are present
969 * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
971 $cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
974 * display server choice at top of navigation panel
976 * @global boolean $cfg['NavigationDisplayServers']
978 $cfg['NavigationDisplayServers'] = true;
981 * server choice as links
983 * @global boolean $cfg['DisplayServersList']
985 $cfg['DisplayServersList'] = false;
988 * display a JavaScript database filter in the navigation panel
989 * when more then x databases are present
991 * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
993 $cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
996 * target of the navigation panel quick access icon
998 * Possible values:
999 * 'structure.php' = fields list
1000 * 'sql' = SQL form
1001 * 'search' = search page
1002 * 'insert' = insert row page
1003 * 'browse' = browse page
1005 * @global string $cfg['NavigationTreeDefaultTabTable']
1007 $cfg['NavigationTreeDefaultTabTable'] = 'structure';
1010 * target of the navigation panel quick second access icon
1012 * Possible values:
1013 * 'structure' = fields list
1014 * 'sql' = SQL form
1015 * 'search' = search page
1016 * 'insert' = insert row page
1017 * 'browse' = browse page
1018 * '' = no link
1020 * @global string $cfg['NavigationTreeDefaultTabTable2']
1022 $cfg['NavigationTreeDefaultTabTable2'] = '';
1025 * Enables the possibility of navigation tree expansion
1027 * @global boolean $cfg['NavigationTreeEnableExpansion']
1029 $cfg['NavigationTreeEnableExpansion'] = true;
1032 * Show tables in navigation panel
1034 * @global boolean $cfg['NavigationTreeShowTables']
1036 $cfg['NavigationTreeShowTables'] = true;
1039 * Show views in navigation panel
1041 * @global boolean $cfg['NavigationTreeShowViews']
1043 $cfg['NavigationTreeShowViews'] = true;
1046 * Show functions in navigation panel
1048 * @global boolean $cfg['NavigationTreeShowFunctions']
1050 $cfg['NavigationTreeShowFunctions'] = true;
1053 * Show procedures in navigation panel
1055 * @global boolean $cfg['NavigationTreeShowProcedures']
1057 $cfg['NavigationTreeShowProcedures'] = true;
1060 * Show events in navigation panel
1062 * @global boolean $cfg['NavigationTreeShowEvents']
1064 $cfg['NavigationTreeShowEvents'] = true;
1067 * Width of navigation panel
1069 * @global integer $cfg['NavigationWidth']
1071 $cfg['NavigationWidth'] = 240;
1074 * Automatically expands single database in navigation panel
1076 * @global boolean $cfg['NavigationAutoexpandSingleDb']
1078 $cfg['NavigationTreeAutoexpandSingleDb'] = true;
1080 /*******************************************************************************
1081 * In the main panel, at startup...
1085 * allow to display statistics and space usage in the pages about database
1086 * details and table properties
1088 * @global boolean $cfg['ShowStats']
1090 $cfg['ShowStats'] = true;
1093 * show PHP info link
1095 * @global boolean $cfg['ShowPhpInfo']
1097 $cfg['ShowPhpInfo'] = false;
1100 * show MySQL server and web server information
1102 * @global boolean $cfg['ShowServerInfo']
1104 $cfg['ShowServerInfo'] = true;
1107 * show change password link
1109 * @global boolean $cfg['ShowChgPassword']
1111 $cfg['ShowChgPassword'] = true;
1114 * show create database form
1116 * @global boolean $cfg['ShowCreateDb']
1118 $cfg['ShowCreateDb'] = true;
1121 /*******************************************************************************
1122 * Database structure
1125 /** show charset column in database structure (true|false)?
1127 * @global boolean $cfg['ShowDbStructureCharset']
1129 $cfg['ShowDbStructureCharset'] = false;
1132 * show comment column in database structure (true|false)?
1134 * @global boolean $cfg['ShowDbStructureComment']
1136 $cfg['ShowDbStructureComment'] = false;
1139 * show creation timestamp column in database structure (true|false)?
1141 * @global boolean $cfg['ShowDbStructureCreation']
1143 $cfg['ShowDbStructureCreation'] = false;
1146 * show last update timestamp column in database structure (true|false)?
1148 * @global boolean $cfg['ShowDbStructureLastUpdate']
1150 $cfg['ShowDbStructureLastUpdate'] = false;
1153 * show last check timestamp column in database structure (true|false)?
1155 * @global boolean $cfg['ShowDbStructureLastCheck']
1157 $cfg['ShowDbStructureLastCheck'] = false;
1160 * allow hide action columns to drop down menu in database structure (true|false)?
1162 * @global boolean $cfg['HideStructureActions']
1164 $cfg['HideStructureActions'] = true;
1167 * Show column comments in table structure view (true|false)?
1169 * @global boolean $cfg['ShowColumnComments']
1171 $cfg['ShowColumnComments'] = true;
1174 /*******************************************************************************
1175 * In browse mode...
1179 * Use icons instead of text for the navigation bar buttons (table browse)
1180 * ('text'|'icons'|'both')
1182 * @global string $cfg['TableNavigationLinksMode']
1184 $cfg['TableNavigationLinksMode'] = 'icons';
1187 * Defines whether a user should be displayed a "show all (records)"
1188 * button in browse mode or not.
1190 * @global boolean $cfg['ShowAll']
1192 $cfg['ShowAll'] = false;
1195 * Number of rows displayed when browsing a result set. If the result
1196 * set contains more rows, "Previous" and "Next".
1197 * Possible values: 25,50,100,250,500
1199 * @global integer $cfg['MaxRows']
1201 $cfg['MaxRows'] = 25;
1204 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
1205 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
1206 * ascending order else-)
1208 * @global string $cfg['Order']
1210 $cfg['Order'] = 'SMART';
1213 * grid editing: save edited cell(s) in browse-mode at once
1215 * @global boolean $cfg['SaveCellsAtOnce']
1217 $cfg['SaveCellsAtOnce'] = false;
1220 * grid editing: which action triggers it, or completely disable the feature
1222 * Possible values:
1223 * 'click'
1224 * 'double-click'
1225 * 'disabled'
1227 * @global string $cfg['GridEditing']
1229 $cfg['GridEditing'] = 'double-click';
1232 * Options > Relational display
1234 * Possible values:
1235 * 'K' for key value
1236 * 'D' for display column
1238 * @global string $cfg['RelationalDisplay']
1241 $cfg['RelationalDisplay'] = 'K';
1244 /*******************************************************************************
1245 * In edit mode...
1249 * disallow editing of binary fields
1250 * valid values are:
1251 * false allow editing
1252 * 'blob' allow editing except for BLOB fields
1253 * 'noblob' disallow editing except for BLOB fields
1254 * 'all' disallow editing
1256 * @global string $cfg['ProtectBinary']
1258 $cfg['ProtectBinary'] = 'blob';
1261 * Display the function fields in edit/insert mode
1263 * @global boolean $cfg['ShowFunctionFields']
1265 $cfg['ShowFunctionFields'] = true;
1268 * Display the type fields in edit/insert mode
1270 * @global boolean $cfg['ShowFieldTypesInDataEditView']
1272 $cfg['ShowFieldTypesInDataEditView'] = true;
1275 * Which editor should be used for CHAR/VARCHAR fields:
1276 * input - allows limiting of input length
1277 * textarea - allows newlines in fields
1279 * @global string $cfg['CharEditing']
1281 $cfg['CharEditing'] = 'input';
1284 * The minimum size for character input fields
1286 * @global integer $cfg['MinSizeForInputField']
1288 $cfg['MinSizeForInputField'] = 4;
1291 * The maximum size for character input fields
1293 * @global integer $cfg['MinSizeForInputField']
1295 $cfg['MaxSizeForInputField'] = 60;
1298 * How many rows can be inserted at one time
1300 * @global integer $cfg['InsertRows']
1302 $cfg['InsertRows'] = 2;
1305 * Sort order for items in a foreign-key drop-down list.
1306 * 'content' is the referenced data, 'id' is the key value.
1308 * @global array $cfg['ForeignKeyDropdownOrder']
1310 $cfg['ForeignKeyDropdownOrder'] = [
1311 'content-id',
1312 'id-content',
1316 * A drop-down list will be used if fewer items are present
1318 * @global integer $cfg['ForeignKeyMaxLimit']
1320 $cfg['ForeignKeyMaxLimit'] = 100;
1323 * Whether to disable foreign key checks while importing
1325 * @global boolean $cfg['DefaultForeignKeyChecks']
1327 $cfg['DefaultForeignKeyChecks'] = 'default';
1329 /*******************************************************************************
1330 * For the export features...
1334 * Allow for the use of zip compression (requires zip support to be enabled)
1336 * @global boolean $cfg['ZipDump']
1338 $cfg['ZipDump'] = true;
1341 * Allow for the use of gzip compression (requires zlib)
1343 * @global boolean $cfg['GZipDump']
1345 $cfg['GZipDump'] = true;
1348 * Allow for the use of bzip2 decompression (requires bz2 extension)
1350 * @global boolean $cfg['BZipDump']
1352 $cfg['BZipDump'] = true;
1355 * Will compress gzip exports on the fly without the need for much memory.
1356 * If you encounter problems with created gzip files disable this feature.
1358 * @global boolean $cfg['CompressOnFly']
1360 $cfg['CompressOnFly'] = true;
1363 /*******************************************************************************
1364 * Tabs display settings
1368 * How to display the menu tabs ('icons'|'text'|'both')
1370 * @global boolean $cfg['TabsMode']
1372 $cfg['TabsMode'] = 'both';
1375 * How to display various action links ('icons'|'text'|'both')
1377 * @global boolean $cfg['ActionLinksMode']
1379 $cfg['ActionLinksMode'] = 'both';
1382 * How many columns should be used for table display of a database?
1383 * (a value larger than 1 results in some information being hidden)
1385 * @global integer $cfg['PropertiesNumColumns']
1387 $cfg['PropertiesNumColumns'] = 1;
1390 * Possible values:
1391 * 'welcome' = the welcome page
1392 * (recommended for multiuser setups)
1393 * 'databases' = list of databases
1394 * 'status' = runtime information
1395 * 'variables' = MySQL server variables
1396 * 'privileges' = user management
1398 * @global string $cfg['DefaultTabServer']
1400 $cfg['DefaultTabServer'] = 'welcome';
1403 * Possible values:
1404 * 'structure' = tables list
1405 * 'sql' = SQL form
1406 * 'search' = search query
1407 * 'operations' = operations on database
1409 * @global string $cfg['DefaultTabDatabase']
1411 $cfg['DefaultTabDatabase'] = 'structure';
1414 * Possible values:
1415 * 'structure' = fields list
1416 * 'sql' = SQL form
1417 * 'search' = search page
1418 * 'insert' = insert row page
1419 * 'browse' = browse page
1421 * @global string $cfg['DefaultTabTable']
1423 $cfg['DefaultTabTable'] = 'browse';
1426 * Whether to display image or text or both image and text in table row
1427 * action segment. Value can be either of ``image``, ``text`` or ``both``.
1429 $cfg['RowActionType'] = 'both';
1431 /*******************************************************************************
1432 * Export defaults
1434 $cfg['Export'] = [];
1437 * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xml/yaml
1439 * @global string $cfg['Export']['format']
1441 $cfg['Export']['format'] = 'sql';
1444 * quick/custom/custom-no-form
1446 * @global string $cfg['Export']['format']
1448 $cfg['Export']['method'] = 'quick';
1451 * none/zip/gzip
1453 * @global string $cfg['Export']['compression']
1455 $cfg['Export']['compression'] = 'none';
1458 * Whether to LOCK TABLES before exporting
1460 * @global boolean $cfg['Export']['lock_tables']
1462 $cfg['Export']['lock_tables'] = false;
1465 * Whether to export databases/tables as separate files
1467 * @global boolean $cfg['Export']['as_separate_files']
1469 $cfg['Export']['as_separate_files'] = false;
1474 * @global boolean $cfg['Export']['asfile']
1476 $cfg['Export']['asfile'] = true;
1481 * @global string $cfg['Export']['charset']
1483 $cfg['Export']['charset'] = '';
1488 * @global boolean $cfg['Export']['onserver']
1490 $cfg['Export']['onserver'] = false;
1495 * @global boolean $cfg['Export']['onserver_overwrite']
1497 $cfg['Export']['onserver_overwrite'] = false;
1502 * @global boolean $cfg['Export']['quick_export_onserver']
1504 $cfg['Export']['quick_export_onserver'] = false;
1509 * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
1511 $cfg['Export']['quick_export_onserver_overwrite'] = false;
1516 * @global boolean $cfg['Export']['remember_file_template']
1518 $cfg['Export']['remember_file_template'] = true;
1523 * @global string $cfg['Export']['file_template_table']
1525 $cfg['Export']['file_template_table'] = '@TABLE@';
1530 * @global string $cfg['Export']['file_template_database']
1532 $cfg['Export']['file_template_database'] = '@DATABASE@';
1537 * @global string $cfg['Export']['file_template_server']
1539 $cfg['Export']['file_template_server'] = '@SERVER@';
1544 * @global string $cfg['Export']['codegen_structure_or_data']
1546 $cfg['Export']['codegen_structure_or_data'] = 'data';
1551 * @global $cfg['Export']['codegen_format']
1553 $cfg['Export']['codegen_format'] = 0;
1558 * @global boolean $cfg['Export']['ods_columns']
1560 $cfg['Export']['ods_columns'] = false;
1565 * @global string $cfg['Export']['ods_null']
1567 $cfg['Export']['ods_null'] = 'NULL';
1572 * @global string $cfg['Export']['odt_structure_or_data']
1574 $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
1579 * @global boolean $cfg['Export']['odt_columns']
1581 $cfg['Export']['odt_columns'] = true;
1586 * @global boolean $cfg['Export']['odt_relation']
1588 $cfg['Export']['odt_relation'] = true;
1593 * @global boolean $cfg['Export']['odt_comments']
1595 $cfg['Export']['odt_comments'] = true;
1600 * @global boolean $cfg['Export']['odt_mime']
1602 $cfg['Export']['odt_mime'] = true;
1607 * @global string $cfg['Export']['odt_null']
1609 $cfg['Export']['odt_null'] = 'NULL';
1614 * @global boolean $cfg['Export']['htmlword_structure_or_data']
1616 $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
1621 * @global boolean $cfg['Export']['htmlword_columns']
1623 $cfg['Export']['htmlword_columns'] = false;
1628 * @global string $cfg['Export']['htmlword_null']
1630 $cfg['Export']['htmlword_null'] = 'NULL';
1635 * @global string $cfg['Export']['texytext_structure_or_data']
1637 $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
1642 * @global boolean $cfg['Export']['texytext_columns']
1644 $cfg['Export']['texytext_columns'] = false;
1649 * @global string $cfg['Export']['texytext_null']
1651 $cfg['Export']['texytext_null'] = 'NULL';
1656 * @global boolean $cfg['Export']['csv_columns']
1658 $cfg['Export']['csv_columns'] = false;
1663 * @global string $cfg['Export']['csv_structure_or_data']
1665 $cfg['Export']['csv_structure_or_data'] = 'data';
1670 * @global string $cfg['Export']['csv_null']
1672 $cfg['Export']['csv_null'] = 'NULL';
1677 * @global string $cfg['Export']['csv_separator']
1679 $cfg['Export']['csv_separator'] = ',';
1684 * @global string $cfg['Export']['csv_enclosed']
1686 $cfg['Export']['csv_enclosed'] = '"';
1691 * @global string $cfg['Export']['csv_escaped']
1693 $cfg['Export']['csv_escaped'] = '"';
1698 * @global string $cfg['Export']['csv_terminated']
1700 $cfg['Export']['csv_terminated'] = 'AUTO';
1705 * @global string $cfg['Export']['csv_removeCRLF']
1707 $cfg['Export']['csv_removeCRLF'] = false;
1712 * @global boolean $cfg['Export']['excel_columns']
1714 $cfg['Export']['excel_columns'] = true;
1719 * @global string $cfg['Export']['excel_null']
1721 $cfg['Export']['excel_null'] = 'NULL';
1724 * win/mac
1726 * @global string $cfg['Export']['excel_edition']
1728 $cfg['Export']['excel_edition'] = 'win';
1733 * @global string $cfg['Export']['excel_removeCRLF']
1735 $cfg['Export']['excel_removeCRLF'] = false;
1740 * @global string $cfg['Export']['excel_structure_or_data']
1742 $cfg['Export']['excel_structure_or_data'] = 'data';
1747 * @global string $cfg['Export']['latex_structure_or_data']
1749 $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
1754 * @global boolean $cfg['Export']['latex_columns']
1756 $cfg['Export']['latex_columns'] = true;
1761 * @global boolean $cfg['Export']['latex_relation']
1763 $cfg['Export']['latex_relation'] = true;
1768 * @global boolean $cfg['Export']['latex_comments']
1770 $cfg['Export']['latex_comments'] = true;
1775 * @global boolean $cfg['Export']['latex_mime']
1777 $cfg['Export']['latex_mime'] = true;
1782 * @global string $cfg['Export']['latex_null']
1784 $cfg['Export']['latex_null'] = '\textit{NULL}';
1789 * @global boolean $cfg['Export']['latex_caption']
1791 $cfg['Export']['latex_caption'] = true;
1796 * @global string $cfg['Export']['latex_structure_caption']
1798 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1803 * @global string $cfg['Export']['latex_structure_continued_caption']
1805 $cfg['Export']['latex_structure_continued_caption']
1806 = 'strLatexStructure strLatexContinued';
1811 * @global string $cfg['Export']['latex_data_caption']
1813 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
1818 * @global string $cfg['Export']['latex_data_continued_caption']
1820 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1825 * @global string $cfg['Export']['latex_data_label']
1827 $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
1832 * @global string $cfg['Export']['latex_structure_label']
1834 $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
1839 * @global string $cfg['Export']['mediawiki_structure_or_data']
1841 $cfg['Export']['mediawiki_structure_or_data'] = 'data';
1846 * @global boolean $cfg['Export']['mediawiki_caption']
1848 $cfg['Export']['mediawiki_caption'] = true;
1853 * @global boolean $cfg['Export']['mediawiki_headers']
1855 $cfg['Export']['mediawiki_headers'] = true;
1860 * @global string $cfg['Export']['ods_structure_or_data']
1862 $cfg['Export']['ods_structure_or_data'] = 'data';
1867 * @global string $cfg['Export']['pdf_structure_or_data']
1869 $cfg['Export']['pdf_structure_or_data'] = 'data';
1874 * @global string $cfg['Export']['phparray_structure_or_data']
1876 $cfg['Export']['phparray_structure_or_data'] = 'data';
1881 * @global string $cfg['Export']['json_structure_or_data']
1883 $cfg['Export']['json_structure_or_data'] = 'data';
1886 * Export functions
1888 * @global string $cfg['Export']['json_pretty_print']
1890 $cfg['Export']['json_pretty_print'] = false;
1893 * Export functions
1895 * @global string $cfg['Export']['json_unicode']
1897 $cfg['Export']['json_unicode'] = true;
1902 * @global string $cfg['Export']['sql_structure_or_data']
1904 $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
1909 * @global string $cfg['Export']['sql_compatibility']
1911 $cfg['Export']['sql_compatibility'] = 'NONE';
1914 * Whether to include comments in SQL export.
1916 * @global string $cfg['Export']['sql_include_comments']
1918 $cfg['Export']['sql_include_comments'] = true;
1923 * @global boolean $cfg['Export']['sql_disable_fk']
1925 $cfg['Export']['sql_disable_fk'] = false;
1930 * @global boolean $cfg['Export']['sql_views_as_tables']
1932 $cfg['Export']['sql_views_as_tables'] = false;
1937 * @global boolean $cfg['Export']['sql_metadata']
1939 $cfg['Export']['sql_metadata'] = false;
1944 * @global boolean $cfg['Export']['sql_use_transaction']
1946 $cfg['Export']['sql_use_transaction'] = true;
1951 * @global boolean $cfg['Export']['sql_create_database']
1953 $cfg['Export']['sql_create_database'] = false;
1958 * @global boolean $cfg['Export']['sql_drop_database']
1960 $cfg['Export']['sql_drop_database'] = false;
1965 * @global boolean $cfg['Export']['sql_drop_table']
1967 $cfg['Export']['sql_drop_table'] = false;
1972 * true by default for correct behavior when dealing with exporting
1973 * of VIEWs and the stand-in table
1974 * @global boolean $cfg['Export']['sql_if_not_exists']
1976 $cfg['Export']['sql_if_not_exists'] = false;
1979 * @global boolean $cfg['Export']['sql_view_current_user']
1981 $cfg['Export']['sql_view_current_user'] = false;
1984 * @global boolean $cfg['Export']['sql_or_replace']
1986 $cfg['Export']['sql_or_replace_view'] = false;
1991 * @global boolean $cfg['Export']['sql_procedure_function']
1993 $cfg['Export']['sql_procedure_function'] = true;
1998 * @global boolean $cfg['Export']['sql_create_table']
2000 $cfg['Export']['sql_create_table'] = true;
2005 * @global boolean $cfg['Export']['sql_create_view']
2007 $cfg['Export']['sql_create_view'] = true;
2012 * @global boolean $cfg['Export']['sql_create_trigger']
2014 $cfg['Export']['sql_create_trigger'] = true;
2019 * @global boolean $cfg['Export']['sql_auto_increment']
2021 $cfg['Export']['sql_auto_increment'] = true;
2026 * @global boolean $cfg['Export']['sql_backquotes']
2028 $cfg['Export']['sql_backquotes'] = true;
2033 * @global boolean $cfg['Export']['sql_dates']
2035 $cfg['Export']['sql_dates'] = false;
2040 * @global boolean $cfg['Export']['sql_relation']
2042 $cfg['Export']['sql_relation'] = false;
2047 * @global boolean $cfg['Export']['sql_truncate']
2049 $cfg['Export']['sql_truncate'] = false;
2054 * @global boolean $cfg['Export']['sql_delayed']
2056 $cfg['Export']['sql_delayed'] = false;
2061 * @global boolean $cfg['Export']['sql_ignore']
2063 $cfg['Export']['sql_ignore'] = false;
2066 * Export time in UTC.
2068 * @global boolean $cfg['Export']['sql_utc_time']
2070 $cfg['Export']['sql_utc_time'] = true;
2075 * @global boolean $cfg['Export']['sql_hex_for_binary']
2077 $cfg['Export']['sql_hex_for_binary'] = true;
2080 * insert/update/replace
2082 * @global string $cfg['Export']['sql_type']
2084 $cfg['Export']['sql_type'] = 'INSERT';
2089 * @global integer $cfg['Export']['sql_max_query_size']
2091 $cfg['Export']['sql_max_query_size'] = 50000;
2096 * @global boolean $cfg['Export']['sql_mime']
2098 $cfg['Export']['sql_mime'] = false;
2101 * \n is replaced by new line
2103 * @global string $cfg['Export']['sql_header_comment']
2105 $cfg['Export']['sql_header_comment'] = '';
2108 * Whether to use complete inserts, extended inserts, both, or neither
2110 * @global string $cfg['Export']['sql_insert_syntax']
2112 $cfg['Export']['sql_insert_syntax'] = 'both';
2117 * @global string $cfg['Export']['pdf_report_title']
2119 $cfg['Export']['pdf_report_title'] = '';
2124 *@global string $cfg['Export']['xml_structure_or_data']
2126 $cfg['Export']['xml_structure_or_data'] = 'data';
2129 * Export schema for each structure
2131 * @global string $cfg['Export']['xml_export_struc']
2133 $cfg['Export']['xml_export_struc'] = true;
2136 * Export events
2138 * @global string $cfg['Export']['xml_export_events']
2140 $cfg['Export']['xml_export_events'] = true;
2143 * Export functions
2145 * @global string $cfg['Export']['xml_export_functions']
2147 $cfg['Export']['xml_export_functions'] = true;
2150 * Export procedures
2152 * @global string $cfg['Export']['xml_export_procedures']
2154 $cfg['Export']['xml_export_procedures'] = true;
2157 * Export schema for each table
2159 * @global string $cfg['Export']['xml_export_tables']
2161 $cfg['Export']['xml_export_tables'] = true;
2164 * Export triggers
2166 * @global string $cfg['Export']['xml_export_triggers']
2168 $cfg['Export']['xml_export_triggers'] = true;
2171 * Export views
2173 * @global string $cfg['Export']['xml_export_views']
2175 $cfg['Export']['xml_export_views'] = true;
2178 * Export contents data
2180 * @global string $cfg['Export']['xml_export_contents']
2182 $cfg['Export']['xml_export_contents'] = true;
2187 * @global string $cfg['Export']['yaml_structure_or_data']
2189 $cfg['Export']['yaml_structure_or_data'] = 'data';
2191 /*******************************************************************************
2192 * Import defaults
2194 $cfg['Import'] = [];
2199 * @global string $cfg['Import']['format']
2201 $cfg['Import']['format'] = 'sql';
2204 * Default charset for import.
2206 * @global string $cfg['Import']['charset']
2208 $cfg['Import']['charset'] = '';
2213 * @global boolean $cfg['Import']['allow_interrupt']
2215 $cfg['Import']['allow_interrupt'] = true;
2220 * @global integer $cfg['Import']['skip_queries']
2222 $cfg['Import']['skip_queries'] = 0;
2227 * @global string $cfg['Import']['sql_compatibility']
2229 $cfg['Import']['sql_compatibility'] = 'NONE';
2234 * @global string $cfg['Import']['sql_no_auto_value_on_zero']
2236 $cfg['Import']['sql_no_auto_value_on_zero'] = true;
2241 * @global string $cfg['Import']['sql_read_as_multibytes']
2243 $cfg['Import']['sql_read_as_multibytes'] = false;
2248 * @global boolean $cfg['Import']['csv_replace']
2250 $cfg['Import']['csv_replace'] = false;
2255 * @global boolean $cfg['Import']['csv_ignore']
2257 $cfg['Import']['csv_ignore'] = false;
2262 * @global string $cfg['Import']['csv_terminated']
2264 $cfg['Import']['csv_terminated'] = ',';
2269 * @global string $cfg['Import']['csv_enclosed']
2271 $cfg['Import']['csv_enclosed'] = '"';
2276 * @global string $cfg['Import']['csv_escaped']
2278 $cfg['Import']['csv_escaped'] = '"';
2283 * @global string $cfg['Import']['csv_new_line']
2285 $cfg['Import']['csv_new_line'] = 'auto';
2290 * @global string $cfg['Import']['csv_columns']
2292 $cfg['Import']['csv_columns'] = '';
2297 * @global string $cfg['Import']['csv_col_names']
2299 $cfg['Import']['csv_col_names'] = false;
2304 * @global boolean $cfg['Import']['ldi_replace']
2306 $cfg['Import']['ldi_replace'] = false;
2311 * @global boolean $cfg['Import']['ldi_ignore']
2313 $cfg['Import']['ldi_ignore'] = false;
2318 * @global string $cfg['Import']['ldi_terminated']
2320 $cfg['Import']['ldi_terminated'] = ';';
2325 * @global string $cfg['Import']['ldi_enclosed']
2327 $cfg['Import']['ldi_enclosed'] = '"';
2332 * @global string $cfg['Import']['ldi_escaped']
2334 $cfg['Import']['ldi_escaped'] = '\\';
2339 * @global string $cfg['Import']['ldi_new_line']
2341 $cfg['Import']['ldi_new_line'] = 'auto';
2346 * @global string $cfg['Import']['ldi_columns']
2348 $cfg['Import']['ldi_columns'] = '';
2351 * 'auto' for auto-detection, true or false for forcing
2353 * @global string $cfg['Import']['ldi_local_option']
2355 $cfg['Import']['ldi_local_option'] = 'auto';
2360 * @global string $cfg['Import']['ods_col_names']
2362 $cfg['Import']['ods_col_names'] = false;
2367 * @global string $cfg['Import']['ods_empty_rows']
2369 $cfg['Import']['ods_empty_rows'] = true;
2374 * @global string $cfg['Import']['ods_recognize_percentages']
2376 $cfg['Import']['ods_recognize_percentages'] = true;
2381 * @global string $cfg['Import']['ods_recognize_currency']
2383 $cfg['Import']['ods_recognize_currency'] = true;
2385 /*******************************************************************************
2386 * Schema export defaults
2388 $cfg['Schema'] = [];
2391 * pdf/eps/dia/svg
2393 * @global string $cfg['Schema']['format']
2395 $cfg['Schema']['format'] = 'pdf';
2400 * @global string $cfg['Schema']['pdf_show_color']
2402 $cfg['Schema']['pdf_show_color'] = true;
2407 * @global string $cfg['Schema']['pdf_show_keys']
2409 $cfg['Schema']['pdf_show_keys'] = false;
2414 * @global string $cfg['Schema']['pdf_all_tables_same_width']
2416 $cfg['Schema']['pdf_all_tables_same_width'] = false;
2419 * L/P
2421 * @global string $cfg['Schema']['pdf_orientation']
2423 $cfg['Schema']['pdf_orientation'] = 'L';
2428 * @global string $cfg['Schema']['pdf_paper']
2430 $cfg['Schema']['pdf_paper'] = 'A4';
2435 * @global string $cfg['Schema']['pdf_show_grid']
2437 $cfg['Schema']['pdf_show_grid'] = false;
2442 * @global string $cfg['Schema']['pdf_with_doc']
2444 $cfg['Schema']['pdf_with_doc'] = true;
2449 * @global string $cfg['Schema']['pdf_table_order']
2451 $cfg['Schema']['pdf_table_order'] = '';
2456 * @global string $cfg['Schema']['dia_show_color']
2458 $cfg['Schema']['dia_show_color'] = true;
2463 * @global string $cfg['Schema']['dia_show_keys']
2465 $cfg['Schema']['dia_show_keys'] = false;
2468 * L/P
2470 * @global string $cfg['Schema']['dia_orientation']
2472 $cfg['Schema']['dia_orientation'] = 'L';
2477 * @global string $cfg['Schema']['dia_paper']
2479 $cfg['Schema']['dia_paper'] = 'A4';
2484 * @global string $cfg['Schema']['eps_show_color']
2486 $cfg['Schema']['eps_show_color'] = true;
2491 * @global string $cfg['Schema']['eps_show_keys']
2493 $cfg['Schema']['eps_show_keys'] = false;
2498 * @global string $cfg['Schema']['eps_all_tables_same_width']
2500 $cfg['Schema']['eps_all_tables_same_width'] = false;
2503 * L/P
2505 * @global string $cfg['Schema']['eps_orientation']
2507 $cfg['Schema']['eps_orientation'] = 'L';
2512 * @global string $cfg['Schema']['svg_show_color']
2514 $cfg['Schema']['svg_show_color'] = true;
2519 * @global string $cfg['Schema']['svg_show_keys']
2521 $cfg['Schema']['svg_show_keys'] = false;
2526 * @global string $cfg['Schema']['svg_all_tables_same_width']
2528 $cfg['Schema']['svg_all_tables_same_width'] = false;
2530 /*******************************************************************************
2531 * PDF options
2537 * @global array $cfg['PDFPageSizes']
2539 $cfg['PDFPageSizes'] = [
2540 'A3',
2541 'A4',
2542 'A5',
2543 'letter',
2544 'legal',
2550 * @global string $cfg['PDFDefaultPageSize']
2552 $cfg['PDFDefaultPageSize'] = 'A4';
2555 /*******************************************************************************
2556 * Language and character set conversion settings
2560 * Default language to use, if not browser-defined or user-defined
2562 * @global string $cfg['DefaultLang']
2564 $cfg['DefaultLang'] = 'en';
2567 * Default connection collation
2569 * @global string $cfg['DefaultConnectionCollation']
2571 $cfg['DefaultConnectionCollation'] = 'utf8mb4_unicode_ci';
2574 * Force: always use this language, e.g. 'en'
2576 * @global string $cfg['Lang']
2578 $cfg['Lang'] = '';
2581 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
2582 * English only
2584 * @global string $cfg['FilterLanguages']
2586 $cfg['FilterLanguages'] = '';
2589 * You can select here which functions will be used for character set conversion.
2590 * Possible values are:
2591 * auto - automatically use available one (first is tested iconv, then
2592 * recode)
2593 * iconv - use iconv or libiconv functions
2594 * recode - use recode_string function
2595 * mb - use mbstring extension
2596 * none - disable encoding conversion
2598 * @global string $cfg['RecodingEngine']
2600 $cfg['RecodingEngine'] = 'auto';
2603 * Specify some parameters for iconv used in character set conversion. See iconv
2604 * documentation for details:
2605 * https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.15/iconv_open.3.html
2607 * @global string $cfg['IconvExtraParams']
2609 $cfg['IconvExtraParams'] = '//TRANSLIT';
2612 * Available character sets for MySQL conversion. currently contains all which could
2613 * be found in lang/* files and few more.
2614 * Character sets will be shown in same order as here listed, so if you frequently
2615 * use some of these move them to the top.
2617 * @global array $cfg['AvailableCharsets']
2619 $cfg['AvailableCharsets'] = [
2620 'iso-8859-1',
2621 'iso-8859-2',
2622 'iso-8859-3',
2623 'iso-8859-4',
2624 'iso-8859-5',
2625 'iso-8859-6',
2626 'iso-8859-7',
2627 'iso-8859-8',
2628 'iso-8859-9',
2629 'iso-8859-10',
2630 'iso-8859-11',
2631 'iso-8859-12',
2632 'iso-8859-13',
2633 'iso-8859-14',
2634 'iso-8859-15',
2635 'windows-1250',
2636 'windows-1251',
2637 'windows-1252',
2638 'windows-1256',
2639 'windows-1257',
2640 'koi8-r',
2641 'big5',
2642 'gb2312',
2643 'utf-16',
2644 'utf-8',
2645 'utf-7',
2646 'x-user-defined',
2647 'euc-jp',
2648 'ks_c_5601-1987',
2649 'tis-620',
2650 'SHIFT_JIS',
2651 'SJIS',
2652 'SJIS-win',
2656 /*******************************************************************************
2657 * Customization & design
2659 * The graphical settings are now located in themes/theme-name/layout.inc.php
2663 * enable the left panel pointer
2664 * see also LeftPointerColor
2665 * in layout.inc.php
2667 * @global boolean $cfg['NavigationTreePointerEnable']
2669 $cfg['NavigationTreePointerEnable'] = true;
2672 * enable the browse pointer
2673 * see also BrowsePointerColor
2674 * in layout.inc.php
2676 * @global boolean $cfg['BrowsePointerEnable']
2678 $cfg['BrowsePointerEnable'] = true;
2681 * enable the browse marker
2682 * see also BrowseMarkerColor
2683 * in layout.inc.php
2685 * @global boolean $cfg['BrowseMarkerEnable']
2687 $cfg['BrowseMarkerEnable'] = true;
2690 * textarea size (columns) in edit mode
2691 * (this value will be emphasized (*2) for SQL
2692 * query textareas and (*1.25) for query window)
2694 * @global integer $cfg['TextareaCols']
2696 $cfg['TextareaCols'] = 40;
2699 * textarea size (rows) in edit mode
2701 * @global integer $cfg['TextareaRows']
2703 $cfg['TextareaRows'] = 15;
2706 * double size of textarea size for LONGTEXT columns
2708 * @global boolean $cfg['LongtextDoubleTextarea']
2710 $cfg['LongtextDoubleTextarea'] = true;
2713 * auto-select when clicking in the textarea of the query-box
2715 * @global boolean $cfg['TextareaAutoSelect']
2717 $cfg['TextareaAutoSelect'] = false;
2720 * textarea size (columns) for CHAR/VARCHAR
2722 * @global integer $cfg['CharTextareaCols']
2724 $cfg['CharTextareaCols'] = 40;
2727 * textarea size (rows) for CHAR/VARCHAR
2729 * @global integer $cfg['CharTextareaRows']
2731 $cfg['CharTextareaRows'] = 2;
2734 * Max field data length in browse mode for all non-numeric fields
2736 * @global integer $cfg['LimitChars']
2738 $cfg['LimitChars'] = 50;
2741 * Where to show the edit/copy/delete links in browse mode
2742 * Possible values are 'left', 'right', 'both' and 'none'.
2744 * @global string $cfg['RowActionLinks']
2746 $cfg['RowActionLinks'] = 'left';
2749 * Whether to show row links (Edit, Copy, Delete) and checkboxes for
2750 * multiple row operations even when the selection does not have a unique key.
2752 * @global boolean $cfg['RowActionLinksWithoutUnique']
2754 $cfg['RowActionLinksWithoutUnique'] = false;
2757 * Default sort order by primary key.
2758 * @global string $cfg['TablePrimaryKeyOrder']
2760 $cfg['TablePrimaryKeyOrder'] = 'NONE';
2763 * remember the last way a table sorted
2765 * @global string $cfg['RememberSorting']
2767 $cfg['RememberSorting'] = true;
2770 * shows column comments in 'browse' mode.
2772 * @global boolean $cfg['ShowBrowseComments']
2774 $cfg['ShowBrowseComments'] = true;
2777 * shows column comments in 'table property' mode.
2779 * @global boolean $cfg['ShowPropertyComments']
2781 $cfg['ShowPropertyComments'] = true;
2784 * repeat header names every X cells? (0 = deactivate)
2786 * @global integer $cfg['RepeatCells']
2788 $cfg['RepeatCells'] = 100;
2791 * Set to true if you want DB-based query history.If false, this utilizes
2792 * JS-routines to display query history (lost by window close)
2794 * @global boolean $cfg['QueryHistoryDB']
2796 $cfg['QueryHistoryDB'] = false;
2799 * When using DB-based query history, how many entries should be kept?
2801 * @global integer $cfg['QueryHistoryMax']
2803 $cfg['QueryHistoryMax'] = 25;
2806 * Use MIME-Types (stored in column comments table) for
2808 * @global boolean $cfg['BrowseMIME']
2810 $cfg['BrowseMIME'] = true;
2813 * When approximate count < this, PMA will get exact count for table rows.
2815 * @global integer $cfg['MaxExactCount']
2817 $cfg['MaxExactCount'] = 50000;
2820 * Zero means that no row count is done for views; see the doc
2822 * @global integer $cfg['MaxExactCountViews']
2824 $cfg['MaxExactCountViews'] = 0;
2827 * Sort table and database in natural order
2829 * @global boolean $cfg['NaturalOrder']
2831 $cfg['NaturalOrder'] = true;
2834 * Initial state for sliders
2835 * (open | closed | disabled)
2837 * @global string $cfg['InitialSlidersState']
2839 $cfg['InitialSlidersState'] = 'closed';
2842 * User preferences: disallow these settings
2843 * For possible setting names look in libraries/config/user_preferences.forms.php
2845 * @global array $cfg['UserprefsDisallow']
2847 $cfg['UserprefsDisallow'] = [];
2850 * User preferences: enable the Developer tab
2852 $cfg['UserprefsDeveloperTab'] = false;
2854 /*******************************************************************************
2855 * Window title settings
2859 * title of browser window when a table is selected
2861 * @global string $cfg['TitleTable']
2863 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
2866 * title of browser window when a database is selected
2868 * @global string $cfg['TitleDatabase']
2870 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
2873 * title of browser window when a server is selected
2875 * @global string $cfg['TitleServer']
2877 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
2880 * title of browser window when nothing is selected
2881 * @global string $cfg['TitleDefault']
2883 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
2886 /*******************************************************************************
2887 * theme manager
2891 * if you want to use selectable themes and if ThemesPath not empty
2892 * set it to true, else set it to false (default is false);
2894 * @global boolean $cfg['ThemeManager']
2896 $cfg['ThemeManager'] = true;
2899 * set up default theme, you can set up here an valid
2900 * path to themes or 'original' for the original pma-theme
2902 * @global string $cfg['ThemeDefault']
2904 $cfg['ThemeDefault'] = 'pmahomme';
2907 * allow different theme for each configured server
2909 * @global boolean $cfg['ThemePerServer']
2911 $cfg['ThemePerServer'] = false;
2913 /*******************************************************************************
2918 * Default query for table
2920 * @global string $cfg['DefaultQueryTable']
2922 $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
2925 * Default query for database
2927 * @global string $cfg['DefaultQueryDatabase']
2929 $cfg['DefaultQueryDatabase'] = '';
2932 /*******************************************************************************
2933 * SQL Query box settings
2934 * These are the links display in all of the SQL Query boxes
2936 * @global array $cfg['SQLQuery']
2938 $cfg['SQLQuery'] = [];
2941 * Display an "Edit" link on the results page to change a query
2943 * @global boolean $cfg['SQLQuery']['Edit']
2945 $cfg['SQLQuery']['Edit'] = true;
2948 * Display an "Explain SQL" link on the results page
2950 * @global boolean $cfg['SQLQuery']['Explain']
2952 $cfg['SQLQuery']['Explain'] = true;
2955 * Display a "Create PHP code" link on the results page to wrap a query in PHP
2957 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2959 $cfg['SQLQuery']['ShowAsPHP'] = true;
2962 * Display a "Refresh" link on the results page
2964 * @global boolean $cfg['SQLQuery']['Refresh']
2966 $cfg['SQLQuery']['Refresh'] = true;
2969 * Enables autoComplete for table & column names in SQL queries
2971 * default = 'true'
2973 $cfg['EnableAutocompleteForTablesAndColumns'] = true;
2976 /*******************************************************************************
2977 * Web server upload/save/import directories
2981 * Directory for uploaded files that can be executed by phpMyAdmin.
2982 * For example './upload'. Leave empty for no upload directory support.
2983 * Use %u for username inclusion.
2985 * @global string $cfg['UploadDir']
2987 $cfg['UploadDir'] = '';
2990 * Directory where phpMyAdmin can save exported data on server.
2991 * For example './save'. Leave empty for no save directory support.
2992 * Use %u for username inclusion.
2994 * @global string $cfg['SaveDir']
2996 $cfg['SaveDir'] = '';
2999 * Directory where phpMyAdmin can save temporary files.
3001 * @global string $cfg['TempDir']
3003 if (defined('TEMP_DIR')) {
3004 $cfg['TempDir'] = TEMP_DIR;
3005 } else {
3006 $cfg['TempDir'] = ROOT_PATH . 'tmp/';
3011 * Misc. settings
3015 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
3016 * which is the only safe way to determine GD version.
3018 * @global string $cfg['GD2Available']
3020 $cfg['GD2Available'] = 'auto';
3023 * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
3025 * @global array $cfg['TrustedProxies']
3027 $cfg['TrustedProxies'] = [];
3030 * We normally check the permissions on the configuration file to ensure
3031 * it's not world writable. However, phpMyAdmin could be installed on
3032 * a NTFS filesystem mounted on a non-Windows server, in which case the
3033 * permissions seems wrong but in fact cannot be detected. In this case
3034 * a sysadmin would set the following to false.
3036 $cfg['CheckConfigurationPermissions'] = true;
3039 * Limit for length of URL in links. When length would be above this limit, it
3040 * is replaced by form with button.
3041 * This is required as some web servers (IIS) have problems with long URLs.
3042 * The recommended limit is 2000
3043 * (see https://www.boutell.com/newfaq/misc/urllength.html) but we put
3044 * 1000 to accommodate Suhosin, see bug #3358750.
3046 $cfg['LinkLengthLimit'] = 1000;
3049 * Additional string to allow in CSP headers.
3051 $cfg['CSPAllow'] = '';
3054 * Disable the table maintenance mass operations, like optimizing or
3055 * repairing the selected tables of a database. An accidental execution
3056 * of such a maintenance task can enormously slow down a bigger database.
3058 $cfg['DisableMultiTableMaintenance'] = false;
3061 * Whether or not to query the user before sending the error report to
3062 * the phpMyAdmin team when a JavaScript error occurs
3064 * Available options
3065 * (ask | always | never)
3067 * @global string $cfg['SendErrorReports']
3069 $cfg['SendErrorReports'] = 'ask';
3072 * Whether Enter or Ctrl+Enter executes queries in the console.
3074 * @global boolean $cfg['ConsoleEnterExecutes']
3076 $cfg['ConsoleEnterExecutes'] = false;
3079 * Zero Configuration mode.
3081 * @global boolean $cfg['ZeroConf']
3083 $cfg['ZeroConf'] = true;
3085 /*******************************************************************************
3086 * Developers ONLY!
3088 * @global array $cfg['DBG']
3090 $cfg['DBG'] = [];
3093 * Output executed queries and their execution times
3095 * @global boolean $cfg['DBG']['sql']
3097 $cfg['DBG']['sql'] = false;
3100 * Log executed queries and their execution times to syslog
3102 * @global boolean $cfg['DBG']['sqllog']
3104 $cfg['DBG']['sqllog'] = false;
3107 * Enable to let server present itself as demo server.
3109 * @global boolean $cfg['DBG']['demo']
3111 $cfg['DBG']['demo'] = false;
3114 * Enable Simple two-factor authentication
3116 * @global boolean $cfg['DBG']['simple2fa']
3118 $cfg['DBG']['simple2fa'] = false;
3121 /*******************************************************************************
3122 * MySQL settings
3126 * Default functions for above defined groups
3128 * @global array $cfg['DefaultFunctions']
3130 $cfg['DefaultFunctions'] = [
3131 'FUNC_CHAR' => '',
3132 'FUNC_DATE' => '',
3133 'FUNC_NUMBER' => '',
3134 'FUNC_SPATIAL' => 'GeomFromText',
3135 'FUNC_UUID' => 'UUID',
3136 'first_timestamp' => 'NOW',
3140 * Max rows retrieved for zoom search
3142 $cfg['maxRowPlotLimit'] = 500;
3145 * Show Git revision if applicable
3147 * @global boolean $cfg['ShowGitRevision']
3149 $cfg['ShowGitRevision'] = true;
3152 * MySQL minimal version required
3154 * @global array $cfg['MysqlMinVersion']
3156 $cfg['MysqlMinVersion'] = [
3157 'internal' => 50500,
3158 'human' => '5.5.0',
3162 * Disable shortcuts
3164 * @global array $cfg['DisableShortcutKeys']
3166 $cfg['DisableShortcutKeys'] = false;
3169 * Console configuration
3171 * This is mostly meant for user preferences.
3173 $cfg['Console'] = [
3174 'StartHistory' => false,
3175 'AlwaysExpand' => false,
3176 'CurrentQuery' => true,
3177 'EnterExecutes' => false,
3178 'DarkTheme' => false,
3179 'Mode' => 'info',
3180 'Height' => 92,
3181 'GroupQueries' => false,
3182 'OrderBy' => 'exec',
3183 'Order' => 'asc',
3187 /*******************************************************************************
3188 * Default options for transformations
3192 * Initialize default transformations array
3194 * @global array $cfg['DefaultTransformations']
3196 $cfg['DefaultTransformations'] = [];
3199 * Default transformations for Substring
3201 * @global array $cfg['DefaultTransformations']['Substring']
3203 $cfg['DefaultTransformations']['Substring'] = [
3205 'all',
3206 '…',
3210 * Default transformations for Bool2Text
3212 * @global array $cfg['DefaultTransformations']['Bool2Text']
3214 $cfg['DefaultTransformations']['Bool2Text'] = [
3215 'T',
3216 'F',
3220 * Default transformations for External
3222 * @global array $cfg['DefaultTransformations']['External']
3224 $cfg['DefaultTransformations']['External'] = [
3226 '-f /dev/null -i -wrap -q',
3232 * Default transformations for PreApPend
3234 * @global array $cfg['DefaultTransformations']['PreApPend']
3236 $cfg['DefaultTransformations']['PreApPend'] = [
3242 * Default transformations for Hex
3244 * @global array $cfg['DefaultTransformations']['Hex']
3246 $cfg['DefaultTransformations']['Hex'] = ['2'];
3249 * Default transformations for DateFormat
3251 * @global array $cfg['DefaultTransformations']['DateFormat']
3253 $cfg['DefaultTransformations']['DateFormat'] = [
3256 'local',
3260 * Default transformations for Inline
3262 * @global array $cfg['DefaultTransformations']['Inline']
3264 $cfg['DefaultTransformations']['Inline'] = [
3265 '100',
3266 100,
3268 $cfg['DefaultTransformations']['Inline']['wrapper_link'] = null;
3271 * Default transformations for TextImageLink
3273 * @global array $cfg['DefaultTransformations']['TextImageLink']
3275 $cfg['DefaultTransformations']['TextImageLink'] = [
3276 null,
3277 100,
3282 * Default transformations for TextLink
3284 * @global array $cfg['DefaultTransformations']['TextLink']
3286 $cfg['DefaultTransformations']['TextLink'] = [
3287 null,
3288 null,
3289 null,