Farh2Rwt

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>
11 *
12 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
13 *
14 * phpMyAdmin default configuration, you can copy values from here to your
15 * config.inc.php
16 *
17 * All directives are explained in the documentation
18 *
19 * @package PhpMyAdmin
20 */
21
22/**
23 * Your phpMyAdmin URL.
24 *
25 * Complete the variable below with the full URL ie
26 *    https://example.com/path_to_your_phpMyAdmin_directory/
27 *
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.
30 *
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.
36 *
37 * @global string $cfg['PmaAbsoluteUri']
38 */
39$cfg['PmaAbsoluteUri'] = '';
40
41/**
42 * Configure authentication logging destination
43 *
44 * @global string $cfg['AuthLog']
45 */
46$cfg['AuthLog'] = 'auto';
47
48/**
49 * Whether to log successful authentication attempts
50 *
51 * @global boolean $cfg['AuthLogSuccess']
52 */
53$cfg['AuthLogSuccess'] = false;
54
55/**
56 * Disable the default warning that is displayed on the DB Details Structure page if
57 * any of the required Tables for the configuration storage could not be found
58 *
59 * @global boolean $cfg['PmaNoRelation_DisableWarning']
60 */
61$cfg['PmaNoRelation_DisableWarning'] = false;
62
63/**
64 * Disable the default warning that is displayed if Suhosin is detected
65 *
66 * @global boolean $cfg['SuhosinDisableWarning']
67 */
68$cfg['SuhosinDisableWarning'] = false;
69
70/**
71 * Disable the default warning that is displayed if session.gc_maxlifetime
72 * is less than `LoginCookieValidity`
73 *
74 * @global boolean $cfg['LoginCookieValidityDisableWarning']
75 */
76$cfg['LoginCookieValidityDisableWarning'] = false;
77
78/**
79 * Disable the default warning about MySQL reserved words in column names
80 *
81 * @global boolean $cfg['ReservedWordDisableWarning']
82 */
83$cfg['ReservedWordDisableWarning'] = false;
84
85/**
86 * Show warning about incomplete translations on certain threshold.
87 *
88 * @global boolean $cfg['TranslationWarningThreshold']
89 */
90$cfg['TranslationWarningThreshold'] = 80;
91
92/**
93 * Allows phpMyAdmin to be included from a other document in a frame;
94 * setting this to true is a potential security hole
95 *
96 * @global boolean $cfg['AllowThirdPartyFraming']
97 */
98$cfg['AllowThirdPartyFraming'] = false;
99
100/**
101 * The 'cookie' auth_type uses AES algorithm to encrypt the password. If
102 * at least one server configuration uses 'cookie' auth_type, enter here a
103 * pass phrase that will be used by AES. The maximum length seems to be 46
104 * characters.
105 *
106 * @global string $cfg['blowfish_secret']
107 */
108$cfg['blowfish_secret'] = '';
109
110
111/*******************************************************************************
112 * Server(s) configuration
113 *
114 * The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
115 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
116 * to ''. If you want more than one server, just copy following section
117 * (including $i incrementation) several times. There is no need to define
118 * full server array, just define values you need to change.
119 *
120 * @global array $cfg['Servers']
121 */
122$cfg['Servers'] = array();
123
124$i = 1;
125
126/**
127 * MySQL hostname or IP address
128 *
129 * @global string $cfg['Servers'][$i]['host']
130 */
131$cfg['Servers'][$i]['host'] = 'localhost';
132
133/**
134 * MySQL port - leave blank for default port
135 *
136 * @global string $cfg['Servers'][$i]['port']
137 */
138$cfg['Servers'][$i]['port'] = '';
139
140/**
141 * Path to the socket - leave blank for default socket
142 *
143 * @global string $cfg['Servers'][$i]['socket']
144 */
145$cfg['Servers'][$i]['socket'] = '';
146
147/**
148 * Use SSL for connecting to MySQL server?
149 *
150 * @global boolean $cfg['Servers'][$i]['ssl']
151 */
152$cfg['Servers'][$i]['ssl'] = false;
153
154/**
155 * Path to the key file when using SSL for connecting to the MySQL server
156 *
157 * @global string $cfg['Servers'][$i]['ssl_key']
158 */
159$cfg['Servers'][$i]['ssl_key'] = null;
160
161/**
162 * Path to the cert file when using SSL for connecting to the MySQL server
163 *
164 * @global string $cfg['Servers'][$i]['ssl_cert']
165 */
166$cfg['Servers'][$i]['ssl_cert'] = null;
167
168/**
169 * Path to the CA file when using SSL for connecting to the MySQL server
170 *
171 * @global string $cfg['Servers'][$i]['ssl_ca']
172 */
173$cfg['Servers'][$i]['ssl_ca'] = null;
174
175/**
176 * Directory containing trusted SSL CA certificates in PEM format
177 *
178 * @global string $cfg['Servers'][$i]['ssl_ca_path']
179 */
180$cfg['Servers'][$i]['ssl_ca_path'] = null;
181
182/**
183 * List of allowable ciphers for SSL connections to the MySQL server
184 *
185 * @global string $cfg['Servers'][$i]['ssl_ciphers']
186 */
187$cfg['Servers'][$i]['ssl_ciphers'] = null;
188
189/**
190 * MySQL 5.6 or later triggers the mysqlnd driver in PHP to validate the
191 * peer_name of the SSL certifcate
192 * For most self-signed certificates this is a problem. Setting this to false
193 * will disable the check and allow the connection (PHP 5.6.16 or later)
194 *
195 * @link https://bugs.php.net/68344
196 * @global string $cfg['Servers'][$i]['ssl_verify']
197 */
198$cfg['Servers'][$i]['ssl_verify'] = true;
199
200/**
201 * Use compressed protocol for the MySQL connection
202 *
203 * @global boolean $cfg['Servers'][$i]['compress']
204 */
205$cfg['Servers'][$i]['compress'] = false;
206
207/**
208 * MySQL control host. This permits to use a host different than the
209 * main host, for the phpMyAdmin configuration storage. If left empty,
210 * $cfg['Servers'][$i]['host'] is used instead.
211 *
212 * @global string $cfg['Servers'][$i]['controlhost']
213 */
214$cfg['Servers'][$i]['controlhost'] = '';
215
216/**
217 * MySQL control port. This permits to use a port different than the
218 * main port, for the phpMyAdmin configuration storage. If left empty,
219 * $cfg['Servers'][$i]['port'] is used instead.
220 *
221 * @global string $cfg['Servers'][$i]['controlport']
222 */
223$cfg['Servers'][$i]['controlport'] = '';
224
225/**
226 * MySQL control user settings (this user must have read-only
227 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
228 * used for all relational features (pmadb)
229 *
230 * @global string $cfg['Servers'][$i]['controluser']
231 */
232$cfg['Servers'][$i]['controluser'] = '';
233
234/**
235 * MySQL control user settings (this user must have read-only
236 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
237 * used for all relational features (pmadb)
238 *
239 * @global string $cfg['Servers'][$i]['controlpass']
240 */
241$cfg['Servers'][$i]['controlpass'] = '';
242
243/**
244 * Authentication method (valid choices: config, http, signon or cookie)
245 *
246 * @global string $cfg['Servers'][$i]['auth_type']
247 */
248$cfg['Servers'][$i]['auth_type'] = 'cookie';
249
250/**
251 * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
252 *
253 * @global string $cfg['Servers'][$i]['auth_http_realm']
254 */
255$cfg['Servers'][$i]['auth_http_realm'] = '';
256
257/**
258 * MySQL user
259 *
260 * @global string $cfg['Servers'][$i]['user']
261 */
262$cfg['Servers'][$i]['user'] = 'root';
263
264/**
265 * MySQL password (only needed with 'config' auth_type)
266 *
267 * @global string $cfg['Servers'][$i]['password']
268 */
269$cfg['Servers'][$i]['password'] = '';
270
271/**
272 * Session to use for 'signon' authentication method
273 *
274 * @global string $cfg['Servers'][$i]['SignonSession']
275 */
276$cfg['Servers'][$i]['SignonSession'] = '';
277
278/**
279 * Cookie params to match session to use for 'signon' authentication method
280 * It should be an associative array matching result of session_get_cookie_params() in other system
281 *
282 * @global array $cfg['Servers'][$i]['SignonCookieParams']
283 */
284$cfg['Servers'][$i]['SignonCookieParams'] = array();
285
286/**
287 * PHP script to use for 'signon' authentication method
288 *
289 * @global string $cfg['Servers'][$i]['SignonScript']
290 */
291$cfg['Servers'][$i]['SignonScript'] = '';
292
293/**
294 * URL where to redirect user to login for 'signon' authentication method
295 *
296 * @global string $cfg['Servers'][$i]['SignonURL']
297 */
298$cfg['Servers'][$i]['SignonURL'] = '';
299
300/**
301 * URL where to redirect user after logout
302 *
303 * @global string $cfg['Servers'][$i]['LogoutURL']
304 */
305$cfg['Servers'][$i]['LogoutURL'] = '';
306
307/**
308 * If set to a db-name, only this db is displayed in navigation panel
309 * It may also be an array of db-names
310 *
311 * @global string $cfg['Servers'][$i]['only_db']
312 */
313$cfg['Servers'][$i]['only_db'] = '';
314
315/**
316 * Database name to be hidden from listings
317 *
318 * @global string $cfg['Servers'][$i]['hide_db']
319 */
320$cfg['Servers'][$i]['hide_db'] = '';
321
322/**
323 * Verbose name for this host - leave blank to show the hostname
324 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
325 *
326 * @global string $cfg['Servers'][$i]['verbose']
327 */
328$cfg['Servers'][$i]['verbose'] = '';
329
330/**
331 * Database used for Relation, Bookmark and PDF Features
332 * (see sql/create_tables.sql)
333 *   - leave blank for no support
334 *     SUGGESTED: 'phpmyadmin'
335 *
336 * @global string $cfg['Servers'][$i]['pmadb']
337 */
338$cfg['Servers'][$i]['pmadb'] = '';
339
340/**
341 * Bookmark table
342 *   - leave blank for no bookmark support
343 *     SUGGESTED: 'pma__bookmark'
344 *
345 * @global string $cfg['Servers'][$i]['bookmarktable']
346 */
347$cfg['Servers'][$i]['bookmarktable'] = '';
348
349/**
350 * table to describe the relation between links (see doc)
351 *   - leave blank for no relation-links support
352 *     SUGGESTED: 'pma__relation'
353 *
354 * @global string $cfg['Servers'][$i]['relation']
355 */
356$cfg['Servers'][$i]['relation'] = '';
357
358/**
359 * table to describe the display fields
360 *   - leave blank for no display fields support
361 *     SUGGESTED: 'pma__table_info'
362 *
363 * @global string $cfg['Servers'][$i]['table_info']
364 */
365$cfg['Servers'][$i]['table_info'] = '';
366
367/**
368 * table to describe the tables position for the designer and PDF schema
369 *   - leave blank for no PDF schema support
370 *     SUGGESTED: 'pma__table_coords'
371 *
372 * @global string $cfg['Servers'][$i]['table_coords']
373 */
374$cfg['Servers'][$i]['table_coords'] = '';
375
376/**
377 * table to describe pages of relationpdf
378 *   - leave blank if you don't want to use this
379 *     SUGGESTED: 'pma__pdf_pages'
380 *
381 * @global string $cfg['Servers'][$i]['pdf_pages']
382 */
383$cfg['Servers'][$i]['pdf_pages'] = '';
384
385/**
386 * table to store column information
387 *   - leave blank for no column comments/mime types
388 *     SUGGESTED: 'pma__column_info'
389 *
390 * @global string $cfg['Servers'][$i]['column_info']
391 */
392$cfg['Servers'][$i]['column_info'] = '';
393
394/**
395 * table to store SQL history
396 *   - leave blank for no SQL query history
397 *     SUGGESTED: 'pma__history'
398 *
399 * @global string $cfg['Servers'][$i]['history']
400 */
401$cfg['Servers'][$i]['history'] = '';
402
403/**
404 * table to store recently used tables
405 *   - leave blank for no "persistent" recently used tables
406 *     SUGGESTED: 'pma__recent'
407 */
408$cfg['Servers'][$i]['recent'] = '';
409
410/**
411 * table to store favorite tables
412 *   - leave blank for no favorite tables
413 *     SUGGESTED: 'pma__favorite'
414 */
415$cfg['Servers'][$i]['favorite'] = '';
416
417/**
418 * table to store UI preferences for tables
419 *   - leave blank for no "persistent" UI preferences
420 *     SUGGESTED: 'pma__table_uiprefs'
421 */
422$cfg['Servers'][$i]['table_uiprefs'] = '';
423
424/**
425 * table to store SQL tracking
426 *   - leave blank for no SQL tracking
427 *     SUGGESTED: 'pma__tracking'
428 *
429 * @global string $cfg['Servers'][$i]['tracking']
430 */
431$cfg['Servers'][$i]['tracking'] = '';
432
433/**
434 * table to store user preferences
435 *   - leave blank to disable server storage
436 *     SUGGESTED: 'pma__userconfig'
437 *
438 * @global string $cfg['Servers'][$i]['userconfig']
439 */
440$cfg['Servers'][$i]['userconfig'] = '';
441
442/**
443 * table to store users and their assignment to user groups
444 *   - leave blank to disable configurable menus feature
445 *     SUGGESTED: 'pma__users'
446 *
447 * @global string $cfg['Servers'][$i]['users']
448 */
449$cfg['Servers'][$i]['users'] = '';
450
451/**
452 * table to store allowed menu items for each user group
453 *   - leave blank to disable configurable menus feature
454 *     SUGGESTED: 'pma__usergroups'
455 *
456 * @global string $cfg['Servers'][$i]['usergroups']
457 */
458$cfg['Servers'][$i]['usergroups'] = '';
459
460/**
461 * table to store information about item hidden from navigation tree
462 *   - leave blank to disable hide/show navigation items feature
463 *     SUGGESTED: 'pma__navigationhiding'
464 *
465 * @global string $cfg['Servers'][$i]['navigationhiding']
466 */
467$cfg['Servers'][$i]['navigationhiding'] = '';
468
469/**
470 * table to store information about saved searches from query-by-example on a db
471 *   - leave blank to disable saved searches feature
472 *     SUGGESTED: 'pma__savedsearches'
473 *
474 * @global string $cfg['Servers'][$i]['savedsearches']
475 */
476$cfg['Servers'][$i]['savedsearches'] = '';
477
478/**
479 * table to store central list of columns per database
480 *   - leave blank to disable central list of columns feature
481 *     SUGGESTED: 'pma__central_columns'
482 *
483 * @global string $cfg['Servers'][$i]['central_columns']
484 */
485$cfg['Servers'][$i]['central_columns'] = '';
486
487/**
488 * table to store designer settings
489 *   - leave blank to disable the storage of designer settings
490 *     SUGGESTED: 'pma__designer_settings'
491 *
492 * @global string $cfg['Servers'][$i]['designer_settings']
493 */
494$cfg['Servers'][$i]['designer_settings'] = '';
495
496/**
497 * table to store export templates
498 *   - leave blank to disable saved searches feature
499 *     SUGGESTED: 'pma__export_templates'
500 *
501 * @global string $cfg['Servers'][$i]['export_templates']
502 */
503$cfg['Servers'][$i]['export_templates'] = '';
504
505/**
506 * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
507 *
508 * In case where tables in databases is modified (e.g. dropped or renamed),
509 * table_uiprefs may contains invalid data (referring to tables which are not
510 * exist anymore).
511 * This configuration make sure that we only keep N (N = MaxTableUiprefs)
512 * newest record in table_uiprefs and automatically delete older records.
513 *
514 * @global integer $cfg['Servers'][$i]['userconfig'] = '';
515 */
516$cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
517
518/**
519 * Sets the time zone used by phpMyAdmin. Possible values are explained at
520 * https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
521 *
522 * @global string $cfg['Servers'][$i]['SessionTimeZone'] = ''
523 */
524$cfg['Servers'][$i]['SessionTimeZone'] = '';
525
526/**
527 * whether to allow root login
528 *
529 * @global boolean $cfg['Servers'][$i]['AllowRoot']
530 */
531$cfg['Servers'][$i]['AllowRoot'] = true;
532
533/**
534 * whether to allow login of any user without a password
535 *
536 * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
537 */
538$cfg['Servers'][$i]['AllowNoPassword'] = false;
539
540/**
541 * Host authentication order, leave blank to not use
542 *
543 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
544 */
545$cfg['Servers'][$i]['AllowDeny']['order'] = '';
546
547/**
548 * Host authentication rules, leave blank for defaults
549 *
550 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
551 */
552$cfg['Servers'][$i]['AllowDeny']['rules'] = array();
553
554/**
555 * Disable use of INFORMATION_SCHEMA.
556 *
557 * @see https://github.com/phpmyadmin/phpmyadmin/issues/8970
558 * @see https://bugs.mysql.com/19588
559 * @global boolean $cfg['Servers'][$i]['DisableIS']
560 */
561$cfg['Servers'][$i]['DisableIS'] = false;
562
563/**
564 * Whether the tracking mechanism creates
565 * versions for tables and views automatically.
566 *
567 * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
568 */
569$cfg['Servers'][$i]['tracking_version_auto_create'] = false;
570
571/**
572 * Defines the list of statements
573 * the auto-creation uses for new versions.
574 *
575 * @global string $cfg['Servers'][$i]['tracking_default_statements']
576 */
577$cfg['Servers'][$i]['tracking_default_statements']
578    = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
579      'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
580      'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
581
582/**
583 * Whether a DROP VIEW IF EXISTS statement will be added
584 * as first line to the log when creating a view.
585 *
586 * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
587 */
588$cfg['Servers'][$i]['tracking_add_drop_view'] = true;
589
590/**
591 * Whether a DROP TABLE IF EXISTS statement will be added
592 * as first line to the log when creating a table.
593 *
594 * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
595 */
596$cfg['Servers'][$i]['tracking_add_drop_table'] = true;
597
598/**
599 * Whether a DROP DATABASE IF EXISTS statement will be added
600 * as first line to the log when creating a database.
601 *
602 * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
603 */
604$cfg['Servers'][$i]['tracking_add_drop_database'] = true;
605
606/**
607 * Default server (0 = no default server)
608 *
609 * If you have more than one server configured, you can set $cfg['ServerDefault']
610 * to any one of them to auto-connect to that server when phpMyAdmin is started,
611 * or set it to 0 to be given a list of servers without logging in
612 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
613 * set to that server.
614 *
615 * @global integer $cfg['ServerDefault']
616 */
617$cfg['ServerDefault'] = 1;
618
619/*
620 * Other core phpMyAdmin settings
621 */
622
623/**
624 * whether version check is active
625 *
626 * @global boolean $cfg['VersionCheck']
627 */
628if (defined('VERSION_CHECK_DEFAULT')) {
629    $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
630} else {
631    $cfg['VersionCheck'] = true;
632}
633
634/**
635 * The url of the proxy to be used when retrieving the information about
636 * the latest version of phpMyAdmin or error reporting. You need this if
637 * the server where phpMyAdmin is installed does not have direct access to
638 * the internet.
639 * The format is: "hostname:portnumber"
640 *
641 * @global string $cfg['ProxyUrl']
642 */
643$cfg['ProxyUrl'] = "";
644
645/**
646 * The username for authenticating with the proxy. By default, no
647 * authentication is performed. If a username is supplied, Basic
648 * Authentication will be performed. No other types of authentication
649 * are currently supported.
650 *
651 * @global string $cfg['ProxyUser']
652 */
653$cfg['ProxyUser'] = "";
654
655/**
656 * The password for authenticating with the proxy.
657 *
658 * @global string $cfg['ProxyPass']
659 */
660$cfg['ProxyPass'] = "";
661
662/**
663 * maximum number of db's displayed in database list
664 *
665 * @global integer $cfg['MaxDbList']
666 */
667$cfg['MaxDbList'] = 100;
668
669/**
670 * maximum number of tables displayed in table list
671 *
672 * @global integer $cfg['MaxTableList']
673 */
674$cfg['MaxTableList'] = 250;
675
676/**
677 * whether to show hint or not
678 *
679 * @global boolean $cfg['ShowHint']
680 */
681$cfg['ShowHint'] = true;
682
683/**
684 * maximum number of characters when a SQL query is displayed
685 *
686 * @global integer $cfg['MaxCharactersInDisplayedSQL']
687 */
688$cfg['MaxCharactersInDisplayedSQL'] = 1000;
689
690/**
691 * use GZIP output buffering if possible (true|false|'auto')
692 *
693 * @global string $cfg['OBGzip']
694 */
695$cfg['OBGzip'] = 'auto';
696
697/**
698 * use persistent connections to MySQL database
699 *
700 * @global boolean $cfg['PersistentConnections']
701 */
702$cfg['PersistentConnections'] = false;
703
704/**
705 * maximum execution time in seconds (0 for no limit)
706 *
707 * @global integer $cfg['ExecTimeLimit']
708 */
709$cfg['ExecTimeLimit'] = 300;
710
711/**
712 * Path for storing session data (session_save_path PHP parameter).
713 *
714 * @global integer $cfg['SessionSavePath']
715 */
716$cfg['SessionSavePath'] = '';
717
718/**
719 * maximum allocated bytes ('-1' for no limit, '0' for no change)
720 * this is a string because '16M' is a valid value; we must put here
721 * a string as the default value so that /setup accepts strings
722 *
723 * @global string $cfg['MemoryLimit']
724 */
725$cfg['MemoryLimit'] = '-1';
726
727/**
728 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
729 *
730 * @global boolean $cfg['SkipLockedTables']
731 */
732$cfg['SkipLockedTables'] = false;
733
734/**
735 * show SQL queries as run
736 *
737 * @global boolean $cfg['ShowSQL']
738 */
739$cfg['ShowSQL'] = true;
740
741/**
742 * retain SQL input on Ajax execute
743 *
744 * @global boolean $cfg['RetainQueryEditor']
745 */
746$cfg['RetainQueryBox'] = false;
747
748/**
749 * use CodeMirror syntax highlighting for editing SQL
750 *
751 * @global boolean $cfg['CodemirrorEnable']
752 */
753$cfg['CodemirrorEnable'] = true;
754
755/**
756 * use the parser to find any errors in the query before executing
757 *
758 * @global boolean $cfg['LintEnable']
759 */
760$cfg['LintEnable'] = true;
761
762/**
763 * show a 'Drop database' link to normal users
764 *
765 * @global boolean $cfg['AllowUserDropDatabase']
766 */
767$cfg['AllowUserDropDatabase'] = false;
768
769/**
770 * confirm some commands that can result in loss of data
771 *
772 * @global boolean $cfg['Confirm']
773 */
774$cfg['Confirm'] = true;
775
776/**
777 * recall previous login in cookie authentication mode or not
778 *
779 * @global boolean $cfg['LoginCookieRecall']
780 */
781$cfg['LoginCookieRecall'] = true;
782
783/**
784 * validity of cookie login (in seconds; 1440 matches php.ini's
785 * session.gc_maxlifetime)
786 *
787 * @global integer $cfg['LoginCookieValidity']
788 */
789$cfg['LoginCookieValidity'] = 1440;
790
791/**
792 * how long login cookie should be stored (in seconds)
793 *
794 * @global integer $cfg['LoginCookieStore']
795 */
796$cfg['LoginCookieStore'] = 0;
797
798/**
799 * whether to delete all login cookies on logout
800 *
801 * @global boolean $cfg['LoginCookieDeleteAll']
802 */
803$cfg['LoginCookieDeleteAll'] = true;
804
805/**
806 * whether to enable the "database search" feature or not
807 *
808 * @global boolean $cfg['UseDbSearch']
809 */
810$cfg['UseDbSearch'] = true;
811
812/**
813 * if set to true, PMA continues computing multiple-statement queries
814 * even if one of the queries failed
815 *
816 * @global boolean $cfg['IgnoreMultiSubmitErrors']
817 */
818$cfg['IgnoreMultiSubmitErrors'] = false;
819
820/**
821 * allow login to any user entered server in cookie based authentication
822 *
823 * @global boolean $cfg['AllowArbitraryServer']
824 */
825$cfg['AllowArbitraryServer'] = false;
826
827/**
828 * restrict by IP (with regular expression) the MySQL servers the user can enter
829 * when $cfg['AllowArbitraryServer'] = true
830 *
831 * @global string $cfg['ArbitraryServerRegexp']
832 */
833$cfg['ArbitraryServerRegexp'] = '';
834
835/**
836 * if reCaptcha is enabled it needs public key to connect with the service
837 *
838 * @global string $cfg['CaptchaLoginPublicKey']
839 */
840$cfg['CaptchaLoginPublicKey'] = '';
841
842/**
843 * if reCaptcha is enabled it needs private key to connect with the service
844 *
845 * @global string $cfg['CaptchaLoginPrivateKey']
846 */
847$cfg['CaptchaLoginPrivateKey'] = '';
848
849/*******************************************************************************
850 * Navigation panel setup
851 */
852
853/**
854 * In the navigation panel, replaces the database tree with a selector
855 *
856 * @global boolean $cfg['ShowDatabasesNavigationAsTree']
857 */
858$cfg['ShowDatabasesNavigationAsTree'] = true;
859
860/**
861 * maximum number of first level databases displayed in navigation panel
862 *
863 * @global integer $cfg['FirstLevelNavigationItems']
864 */
865$cfg['FirstLevelNavigationItems'] = 100;
866
867/**
868 * maximum number of items displayed in navigation panel
869 *
870 * @global integer $cfg['MaxNavigationItems']
871 */
872$cfg['MaxNavigationItems'] = 50;
873
874/**
875 * turn the select-based light menu into a tree
876 *
877 * @global boolean $cfg['NavigationTreeEnableGrouping']
878 */
879$cfg['NavigationTreeEnableGrouping'] = true;
880
881/**
882 * the separator to sub-tree the select-based light menu tree
883 *
884 * @global string $cfg['NavigationTreeDbSeparator']
885 */
886$cfg['NavigationTreeDbSeparator'] = '_';
887
888/**
889 * Which string will be used to generate table prefixes
890 * to split/nest tables into multiple categories
891 *
892 * @global string $cfg['NavigationTreeTableSeparator']
893 */
894$cfg['NavigationTreeTableSeparator'] = '__';
895
896/**
897 * How many sublevels should be displayed when splitting up tables
898 * by the above Separator
899 *
900 * @global integer $cfg['NavigationTreeTableLevel']
901 */
902$cfg['NavigationTreeTableLevel'] = 1;
903
904/**
905 * link with main panel by highlighting the current db/table
906 *
907 * @global boolean $cfg['NavigationLinkWithMainPanel']
908 */
909$cfg['NavigationLinkWithMainPanel'] = true;
910
911/**
912 * display logo at top of navigation panel
913 *
914 * @global boolean $cfg['NavigationDisplayLogo']
915 */
916$cfg['NavigationDisplayLogo'] = true;
917
918/**
919 * where should logo link point to (can also contain an external URL)
920 *
921 * @global string $cfg['NavigationLogoLink']
922 */
923$cfg['NavigationLogoLink'] = 'index.php';
924
925/**
926 * whether to open the linked page in the main window ('main') or
927 * in a new window ('new')
928 *
929 * @global string $cfg['NavigationLogoLinkWindow']
930 */
931$cfg['NavigationLogoLinkWindow'] = 'main';
932
933/**
934 * number of recently used tables displayed in the navigation panel
935 *
936 * @global integer $cfg['NumRecentTables']
937 */
938$cfg['NumRecentTables'] = 10;
939
940/**
941 * number of favorite tables displayed in the navigation panel
942 *
943 * @global integer $cfg['NumFavoriteTables']
944 */
945$cfg['NumFavoriteTables'] = 10;
946
947/**
948 * display a JavaScript table filter in the navigation panel
949 * when more then x tables are present
950 *
951 * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
952 */
953$cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
954
955/**
956 * display server choice at top of navigation panel
957 *
958 * @global boolean $cfg['NavigationDisplayServers']
959 */
960$cfg['NavigationDisplayServers'] = true;
961
962/**
963 * server choice as links
964 *
965 * @global boolean $cfg['DisplayServersList']
966 */
967$cfg['DisplayServersList'] = false;
968
969/**
970 * display a JavaScript database filter in the navigation panel
971 * when more then x databases are present
972 *
973 * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
974 */
975$cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
976
977/**
978 * target of the navigation panel quick access icon
979 *
980 * Possible values:
981 * 'structure.php' = fields list
982 * 'sql' = SQL form
983 * 'search' = search page
984 * 'insert' = insert row page
985 * 'browse' = browse page
986 *
987 * @global string $cfg['NavigationTreeDefaultTabTable']
988 */
989$cfg['NavigationTreeDefaultTabTable'] = 'structure';
990
991/**
992 * target of the navigation panel quick second access icon
993 *
994 * Possible values:
995 * 'structure' = fields list
996 * 'sql' = SQL form
997 * 'search' = search page
998 * 'insert' = insert row page
999 * 'browse' = browse page
1000 * '' = no link
1001 *
1002 * @global string $cfg['NavigationTreeDefaultTabTable2']
1003 */
1004$cfg['NavigationTreeDefaultTabTable2'] = '';
1005
1006/**
1007 * Enables the possibility of navigation tree expansion
1008 *
1009 * @global boolean $cfg['NavigationTreeEnableExpansion']
1010 */
1011$cfg['NavigationTreeEnableExpansion'] = true;
1012
1013/**
1014 * Show tables in navigation panel
1015 *
1016 * @global boolean $cfg['NavigationTreeShowTables']
1017 */
1018$cfg['NavigationTreeShowTables'] = true;
1019
1020/**
1021 * Show views in navigation panel
1022 *
1023 * @global boolean $cfg['NavigationTreeShowViews']
1024 */
1025$cfg['NavigationTreeShowViews'] = true;
1026
1027/**
1028 * Show functions in navigation panel
1029 *
1030 * @global boolean $cfg['NavigationTreeShowFunctions']
1031 */
1032$cfg['NavigationTreeShowFunctions'] = true;
1033
1034/**
1035 * Show procedures in navigation panel
1036 *
1037 * @global boolean $cfg['NavigationTreeShowProcedures']
1038 */
1039$cfg['NavigationTreeShowProcedures'] = true;
1040
1041/**
1042 * Show events in navigation panel
1043 *
1044 * @global boolean $cfg['NavigationTreeShowEvents']
1045 */
1046$cfg['NavigationTreeShowEvents'] = true;
1047
1048/**
1049 * Width of navigation panel
1050 *
1051 * @global integer $cfg['NavigationWidth']
1052 */
1053$cfg['NavigationWidth'] = 240;
1054
1055/*******************************************************************************
1056 * In the main panel, at startup...
1057 */
1058
1059/**
1060 * allow to display statistics and space usage in the pages about database
1061 * details and table properties
1062 *
1063 * @global boolean $cfg['ShowStats']
1064 */
1065$cfg['ShowStats'] = true;
1066
1067/**
1068 * show PHP info link
1069 *
1070 * @global boolean $cfg['ShowPhpInfo']
1071 */
1072$cfg['ShowPhpInfo'] = false;
1073
1074/**
1075 * show MySQL server and web server information
1076 *
1077 * @global boolean $cfg['ShowServerInfo']
1078 */
1079$cfg['ShowServerInfo'] = true;
1080
1081/**
1082 * show change password link
1083 *
1084 * @global boolean $cfg['ShowChgPassword']
1085 */
1086$cfg['ShowChgPassword'] = true;
1087
1088/**
1089 * show create database form
1090 *
1091 * @global boolean $cfg['ShowCreateDb']
1092 */
1093$cfg['ShowCreateDb'] = true;
1094
1095
1096/*******************************************************************************
1097 * Database structure
1098 */
1099
1100/** show charset column in database structure (true|false)?
1101 *
1102 * @global boolean $cfg['ShowDbStructureCharset']
1103 */
1104$cfg['ShowDbStructureCharset'] = false;
1105
1106/**
1107 * show comment column in database structure (true|false)?
1108 *
1109 * @global boolean $cfg['ShowDbStructureComment']
1110 */
1111$cfg['ShowDbStructureComment'] = false;
1112
1113/**
1114 * show creation timestamp column in database structure (true|false)?
1115 *
1116 * @global boolean $cfg['ShowDbStructureCreation']
1117 */
1118$cfg['ShowDbStructureCreation'] = false;
1119
1120/**
1121 * show last update timestamp column in database structure (true|false)?
1122 *
1123 * @global boolean $cfg['ShowDbStructureLastUpdate']
1124 */
1125$cfg['ShowDbStructureLastUpdate'] = false;
1126
1127/**
1128 * show last check timestamp column in database structure (true|false)?
1129 *
1130 * @global boolean $cfg['ShowDbStructureLastCheck']
1131 */
1132$cfg['ShowDbStructureLastCheck'] = false;
1133
1134/**
1135 * allow hide action columns to drop down menu in database structure (true|false)?
1136 *
1137 * @global boolean $cfg['HideStructureActions']
1138 */
1139$cfg['HideStructureActions'] = true;
1140
1141/**
1142 * Show column comments in table structure view (true|false)?
1143 *
1144 * @global boolean $cfg['ShowColumnComments']
1145 */
1146$cfg['ShowColumnComments'] = true;
1147
1148
1149/*******************************************************************************
1150 * In browse mode...
1151 */
1152
1153/**
1154 * Use icons instead of text for the navigation bar buttons (table browse)
1155 * ('text'|'icons'|'both')
1156 *
1157 * @global string $cfg['TableNavigationLinksMode']
1158 */
1159$cfg['TableNavigationLinksMode'] = 'icons';
1160
1161/**
1162 * Defines whether a user should be displayed a "show all (records)"
1163 * button in browse mode or not.
1164 *
1165 * @global boolean $cfg['ShowAll']
1166 */
1167$cfg['ShowAll'] = false;
1168
1169/**
1170 * Number of rows displayed when browsing a result set. If the result
1171 * set contains more rows, "Previous" and "Next".
1172 * Possible values: 25,50,100,250,500
1173 *
1174 * @global integer $cfg['MaxRows']
1175 */
1176$cfg['MaxRows'] = 25;
1177
1178/**
1179 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
1180 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
1181 * ascending order else-)
1182 *
1183 * @global string $cfg['Order']
1184 */
1185$cfg['Order'] = 'SMART';
1186
1187/**
1188 * grid editing: save edited cell(s) in browse-mode at once
1189 *
1190 * @global boolean $cfg['SaveCellsAtOnce']
1191 */
1192$cfg['SaveCellsAtOnce'] = false;
1193
1194/**
1195 * grid editing: which action triggers it, or completely disable the feature
1196 *
1197 * Possible values:
1198 * 'click'
1199 * 'double-click'
1200 * 'disabled'
1201 *
1202 * @global string $cfg['GridEditing']
1203 */
1204$cfg['GridEditing'] ='double-click';
1205
1206/**
1207 * Options > Relational display
1208 *
1209 * Possible values:
1210 * 'K' for key value
1211 * 'D' for display column
1212 *
1213 * @global string $cfg['RelationalDisplay']
1214 *
1215 */
1216$cfg['RelationalDisplay'] = 'K';
1217
1218
1219/*******************************************************************************
1220 * In edit mode...
1221 */
1222
1223/**
1224 * disallow editing of binary fields
1225 * valid values are:
1226 *   false    allow editing
1227 *   'blob'   allow editing except for BLOB fields
1228 *   'noblob' disallow editing except for BLOB fields
1229 *   'all'    disallow editing
1230 *
1231 * @global string $cfg['ProtectBinary']
1232 */
1233$cfg['ProtectBinary'] = 'blob';
1234
1235/**
1236 * Display the function fields in edit/insert mode
1237 *
1238 * @global boolean $cfg['ShowFunctionFields']
1239 */
1240$cfg['ShowFunctionFields'] = true;
1241
1242/**
1243 * Display the type fields in edit/insert mode
1244 *
1245 * @global boolean $cfg['ShowFieldTypesInDataEditView']
1246 */
1247$cfg['ShowFieldTypesInDataEditView'] = true;
1248
1249/**
1250 * Which editor should be used for CHAR/VARCHAR fields:
1251 *  input - allows limiting of input length
1252 *  textarea - allows newlines in fields
1253 *
1254 * @global string $cfg['CharEditing']
1255 */
1256$cfg['CharEditing'] = 'input';
1257
1258/**
1259 * The minimum size for character input fields
1260 *
1261 * @global integer $cfg['MinSizeForInputField']
1262 */
1263$cfg['MinSizeForInputField'] = 4;
1264
1265/**
1266 * The maximum size for character input fields
1267 *
1268 * @global integer $cfg['MinSizeForInputField']
1269 */
1270$cfg['MaxSizeForInputField'] = 60;
1271
1272/**
1273 * How many rows can be inserted at one time
1274 *
1275 * @global integer $cfg['InsertRows']
1276 */
1277$cfg['InsertRows'] = 2;
1278
1279/**
1280 * Sort order for items in a foreign-key drop-down list.
1281 * 'content' is the referenced data, 'id' is the key value.
1282 *
1283 * @global array $cfg['ForeignKeyDropdownOrder']
1284 */
1285$cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
1286
1287/**
1288 * A drop-down list will be used if fewer items are present
1289 *
1290 * @global integer $cfg['ForeignKeyMaxLimit']
1291 */
1292$cfg['ForeignKeyMaxLimit'] = 100;
1293
1294/**
1295 * Whether to disable foreign key checks while importing
1296 *
1297 * @global boolean $cfg['DefaultForeignKeyChecks']
1298 */
1299$cfg['DefaultForeignKeyChecks'] = 'default';
1300
1301/*******************************************************************************
1302 * For the export features...
1303 */
1304
1305/**
1306 * Allow for the use of zip compression (requires zip support to be enabled)
1307 *
1308 * @global boolean $cfg['ZipDump']
1309 */
1310$cfg['ZipDump'] = true;
1311
1312/**
1313 * Allow for the use of gzip compression (requires zlib)
1314 *
1315 * @global boolean $cfg['GZipDump']
1316 */
1317$cfg['GZipDump'] = true;
1318
1319/**
1320 * Allow for the use of bzip2 decompression (requires bz2 extension)
1321 *
1322 * @global boolean $cfg['BZipDump']
1323 */
1324$cfg['BZipDump'] = true;
1325
1326/**
1327 * Will compress gzip exports on the fly without the need for much memory.
1328 * If you encounter problems with created gzip files disable this feature.
1329 *
1330 * @global boolean $cfg['CompressOnFly']
1331 */
1332$cfg['CompressOnFly'] = true;
1333
1334
1335/*******************************************************************************
1336 * Tabs display settings
1337 */
1338
1339/**
1340 * How to display the menu tabs ('icons'|'text'|'both')
1341 *
1342 * @global boolean $cfg['TabsMode']
1343 */
1344$cfg['TabsMode'] = 'both';
1345
1346/**
1347 * How to display various action links ('icons'|'text'|'both')
1348 *
1349 * @global boolean $cfg['ActionLinksMode']
1350 */
1351$cfg['ActionLinksMode'] = 'both';
1352
1353/**
1354 * How many columns should be used for table display of a database?
1355 * (a value larger than 1 results in some information being hidden)
1356 *
1357 * @global integer $cfg['PropertiesNumColumns']
1358 */
1359$cfg['PropertiesNumColumns'] = 1;
1360
1361/**
1362 * Possible values:
1363 * 'welcome' = the welcome page
1364 * (recommended for multiuser setups)
1365 * 'databases' = list of databases
1366 * 'status' = runtime information
1367 * 'variables' = MySQL server variables
1368 * 'privileges' = user management
1369 *
1370 * @global string $cfg['DefaultTabServer']
1371 */
1372$cfg['DefaultTabServer'] = 'welcome';
1373
1374/**
1375 * Possible values:
1376 * 'structure' = tables list
1377 * 'sql' = SQL form
1378 * 'search' = search query
1379 * 'operations' = operations on database
1380 *
1381 * @global string $cfg['DefaultTabDatabase']
1382 */
1383$cfg['DefaultTabDatabase'] = 'structure';
1384
1385/**
1386 * Possible values:
1387 * 'structure' = fields list
1388 * 'sql' = SQL form
1389 * 'search' = search page
1390 * 'insert' = insert row page
1391 * 'browse' = browse page
1392 *
1393 * @global string $cfg['DefaultTabTable']
1394 */
1395$cfg['DefaultTabTable'] = 'browse';
1396
1397/**
1398 * Whether to display image or text or both image and text in table row
1399 * action segment. Value can be either of ``image``, ``text`` or ``both``.
1400 */
1401$cfg['RowActionType'] = 'both';
1402
1403/*******************************************************************************
1404 * Export defaults
1405 */
1406$cfg['Export'] = array();
1407
1408/**
1409 * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xml/yaml
1410 *
1411 * @global string $cfg['Export']['format']
1412 */
1413$cfg['Export']['format'] = 'sql';
1414
1415/**
1416 * quick/custom/custom-no-form
1417 *
1418 * @global string $cfg['Export']['format']
1419 */
1420$cfg['Export']['method'] = 'quick';
1421
1422/**
1423 * none/zip/gzip
1424 *
1425 * @global string $cfg['Export']['compression']
1426 */
1427$cfg['Export']['compression'] = 'none';
1428
1429/**
1430 * Whether to LOCK TABLES before exporting
1431 *
1432 * @global boolean $cfg['Export']['lock_tables']
1433 */
1434$cfg['Export']['lock_tables'] = false;
1435
1436/**
1437 * Whether to export databases/tables as separate files
1438 *
1439 * @global boolean $cfg['Export']['as_separate_files']
1440 */
1441$cfg['Export']['as_separate_files'] = false;
1442
1443/**
1444 *
1445 *
1446 * @global boolean $cfg['Export']['asfile']
1447 */
1448$cfg['Export']['asfile'] = true;
1449
1450/**
1451 *
1452 *
1453 * @global string $cfg['Export']['charset']
1454 */
1455$cfg['Export']['charset'] = '';
1456
1457/**
1458 *
1459 *
1460 * @global boolean $cfg['Export']['onserver']
1461 */
1462$cfg['Export']['onserver'] = false;
1463
1464/**
1465 *
1466 *
1467 * @global boolean $cfg['Export']['onserver_overwrite']
1468 */
1469$cfg['Export']['onserver_overwrite'] = false;
1470
1471/**
1472 *
1473 *
1474 * @global boolean $cfg['Export']['quick_export_onserver']
1475 */
1476$cfg['Export']['quick_export_onserver'] = false;
1477
1478/**
1479 *
1480 *
1481 * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
1482 */
1483$cfg['Export']['quick_export_onserver_overwrite'] = false;
1484
1485/**
1486 *
1487 *
1488 * @global boolean $cfg['Export']['remember_file_template']
1489 */
1490$cfg['Export']['remember_file_template'] = true;
1491
1492/**
1493 *
1494 *
1495 * @global string $cfg['Export']['file_template_table']
1496 */
1497$cfg['Export']['file_template_table'] = '@TABLE@';
1498
1499/**
1500 *
1501 *
1502 * @global string $cfg['Export']['file_template_database']
1503 */
1504$cfg['Export']['file_template_database'] = '@DATABASE@';
1505
1506/**
1507 *
1508 *
1509 * @global string $cfg['Export']['file_template_server']
1510 */
1511$cfg['Export']['file_template_server'] = '@SERVER@';
1512
1513/**
1514 *
1515 *
1516 * @global string $cfg['Export']['codegen_structure_or_data']
1517 */
1518$cfg['Export']['codegen_structure_or_data'] = 'data';
1519
1520/**
1521 *
1522 *
1523 * @global $cfg['Export']['codegen_format']
1524 */
1525$cfg['Export']['codegen_format'] = 0;
1526
1527/**
1528 *
1529 *
1530 * @global boolean $cfg['Export']['ods_columns']
1531 */
1532$cfg['Export']['ods_columns'] = false;
1533
1534/**
1535 *
1536 *
1537 * @global string $cfg['Export']['ods_null']
1538 */
1539$cfg['Export']['ods_null'] = 'NULL';
1540
1541/**
1542 *
1543 *
1544 * @global string $cfg['Export']['odt_structure_or_data']
1545 */
1546$cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
1547
1548/**
1549 *
1550 *
1551 * @global boolean $cfg['Export']['odt_columns']
1552 */
1553$cfg['Export']['odt_columns'] = true;
1554
1555/**
1556 *
1557 *
1558 * @global boolean $cfg['Export']['odt_relation']
1559 */
1560$cfg['Export']['odt_relation'] = true;
1561
1562/**
1563 *
1564 *
1565 * @global boolean $cfg['Export']['odt_comments']
1566 */
1567$cfg['Export']['odt_comments'] = true;
1568
1569/**
1570 *
1571 *
1572 * @global boolean $cfg['Export']['odt_mime']
1573 */
1574$cfg['Export']['odt_mime'] = true;
1575
1576/**
1577 *
1578 *
1579 * @global string $cfg['Export']['odt_null']
1580 */
1581$cfg['Export']['odt_null'] = 'NULL';
1582
1583/**
1584 *
1585 *
1586 * @global boolean $cfg['Export']['htmlword_structure_or_data']
1587 */
1588$cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
1589
1590/**
1591 *
1592 *
1593 * @global boolean $cfg['Export']['htmlword_columns']
1594 */
1595$cfg['Export']['htmlword_columns'] = false;
1596
1597/**
1598 *
1599 *
1600 * @global string $cfg['Export']['htmlword_null']
1601 */
1602$cfg['Export']['htmlword_null'] = 'NULL';
1603
1604/**
1605 *
1606 *
1607 * @global string $cfg['Export']['texytext_structure_or_data']
1608 */
1609$cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
1610
1611/**
1612 *
1613 *
1614 * @global boolean $cfg['Export']['texytext_columns']
1615 */
1616$cfg['Export']['texytext_columns'] = false;
1617
1618/**
1619 *
1620 *
1621 * @global string $cfg['Export']['texytext_null']
1622 */
1623$cfg['Export']['texytext_null'] = 'NULL';
1624
1625/**
1626 *
1627 *
1628 * @global boolean $cfg['Export']['csv_columns']
1629 */
1630$cfg['Export']['csv_columns'] = false;
1631
1632/**
1633 *
1634 *
1635 * @global string $cfg['Export']['csv_structure_or_data']
1636 */
1637$cfg['Export']['csv_structure_or_data'] = 'data';
1638
1639/**
1640 *
1641 *
1642 * @global string $cfg['Export']['csv_null']
1643 */
1644$cfg['Export']['csv_null'] = 'NULL';
1645
1646/**
1647 *
1648 *
1649 * @global string $cfg['Export']['csv_separator']
1650 */
1651$cfg['Export']['csv_separator'] = ',';
1652
1653/**
1654 *
1655 *
1656 * @global string $cfg['Export']['csv_enclosed']
1657 */
1658$cfg['Export']['csv_enclosed'] = '"';
1659
1660/**
1661 *
1662 *
1663 * @global string $cfg['Export']['csv_escaped']
1664 */
1665$cfg['Export']['csv_escaped'] = '"';
1666
1667/**
1668 *
1669 *
1670 * @global string $cfg['Export']['csv_terminated']
1671 */
1672$cfg['Export']['csv_terminated'] = 'AUTO';
1673
1674/**
1675 *
1676 *
1677 * @global string $cfg['Export']['csv_removeCRLF']
1678 */
1679$cfg['Export']['csv_removeCRLF'] = false;
1680
1681/**
1682 *
1683 *
1684 * @global boolean $cfg['Export']['excel_columns']
1685 */
1686$cfg['Export']['excel_columns'] = true;
1687
1688/**
1689 *
1690 *
1691 * @global string $cfg['Export']['excel_null']
1692 */
1693$cfg['Export']['excel_null'] = 'NULL';
1694
1695/**
1696 * win/mac
1697 *
1698 * @global string $cfg['Export']['excel_edition']
1699 */
1700$cfg['Export']['excel_edition'] = 'win';
1701
1702/**
1703 *
1704 *
1705 * @global string $cfg['Export']['excel_removeCRLF']
1706 */
1707$cfg['Export']['excel_removeCRLF'] = false;
1708
1709/**
1710 *
1711 *
1712 * @global string $cfg['Export']['excel_structure_or_data']
1713 */
1714$cfg['Export']['excel_structure_or_data'] = 'data';
1715
1716/**
1717 *
1718 *
1719 * @global string $cfg['Export']['latex_structure_or_data']
1720 */
1721$cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
1722
1723/**
1724 *
1725 *
1726 * @global boolean $cfg['Export']['latex_columns']
1727 */
1728$cfg['Export']['latex_columns'] = true;
1729
1730/**
1731 *
1732 *
1733 * @global boolean $cfg['Export']['latex_relation']
1734 */
1735$cfg['Export']['latex_relation'] = true;
1736
1737/**
1738 *
1739 *
1740 * @global boolean $cfg['Export']['latex_comments']
1741 */
1742$cfg['Export']['latex_comments'] = true;
1743
1744/**
1745 *
1746 *
1747 * @global boolean $cfg['Export']['latex_mime']
1748 */
1749$cfg['Export']['latex_mime'] = true;
1750
1751/**
1752 *
1753 *
1754 * @global string $cfg['Export']['latex_null']
1755 */
1756$cfg['Export']['latex_null'] = '\textit{NULL}';
1757
1758/**
1759 *
1760 *
1761 * @global boolean $cfg['Export']['latex_caption']
1762 */
1763$cfg['Export']['latex_caption'] = true;
1764
1765/**
1766 *
1767 *
1768 * @global string $cfg['Export']['latex_structure_caption']
1769 */
1770$cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1771
1772/**
1773 *
1774 *
1775 * @global string $cfg['Export']['latex_structure_continued_caption']
1776 */
1777$cfg['Export']['latex_structure_continued_caption']
1778    = 'strLatexStructure strLatexContinued';
1779
1780/**
1781 *
1782 *
1783 * @global string $cfg['Export']['latex_data_caption']
1784 */
1785$cfg['Export']['latex_data_caption'] = 'strLatexContent';
1786
1787/**
1788 *
1789 *
1790 * @global string $cfg['Export']['latex_data_continued_caption']
1791 */
1792$cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1793
1794/**
1795 *
1796 *
1797 * @global string $cfg['Export']['latex_data_label']
1798 */
1799$cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
1800
1801/**
1802 *
1803 *
1804 * @global string $cfg['Export']['latex_structure_label']
1805 */
1806$cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
1807
1808/**
1809 *
1810 *
1811 * @global string $cfg['Export']['mediawiki_structure_or_data']
1812 */
1813$cfg['Export']['mediawiki_structure_or_data'] = 'data';
1814
1815/**
1816 *
1817 *
1818 * @global boolean $cfg['Export']['mediawiki_caption']
1819 */
1820$cfg['Export']['mediawiki_caption'] = true;
1821
1822/**
1823 *
1824 *
1825 * @global boolean $cfg['Export']['mediawiki_headers']
1826 */
1827$cfg['Export']['mediawiki_headers'] = true;
1828
1829/**
1830 *
1831 *
1832 * @global string $cfg['Export']['ods_structure_or_data']
1833 */
1834$cfg['Export']['ods_structure_or_data'] = 'data';
1835
1836/**
1837 *
1838 *
1839 * @global string $cfg['Export']['pdf_structure_or_data']
1840 */
1841$cfg['Export']['pdf_structure_or_data'] = 'data';
1842
1843/**
1844 *
1845 *
1846 * @global string $cfg['Export']['phparray_structure_or_data']
1847 */
1848$cfg['Export']['phparray_structure_or_data'] = 'data';
1849
1850/**
1851 *
1852 *
1853 * @global string $cfg['Export']['json_structure_or_data']
1854 */
1855$cfg['Export']['json_structure_or_data'] = 'data';
1856
1857/**
1858 * Export functions
1859 *
1860 * @global string $cfg['Export']['json_pretty_print']
1861 */
1862$cfg['Export']['json_pretty_print'] = false;
1863
1864/**
1865 * Export functions
1866 *
1867 * @global string $cfg['Export']['json_unicode']
1868 */
1869$cfg['Export']['json_unicode'] = true;
1870
1871/**
1872 *
1873 *
1874 * @global string $cfg['Export']['sql_structure_or_data']
1875 */
1876$cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
1877
1878/**
1879 *
1880 *
1881 * @global string $cfg['Export']['sql_compatibility']
1882 */
1883$cfg['Export']['sql_compatibility'] = 'NONE';
1884
1885/**
1886 * Whether to include comments in SQL export.
1887 *
1888 * @global string $cfg['Export']['sql_include_comments']
1889 */
1890$cfg['Export']['sql_include_comments'] = true;
1891
1892/**
1893 *
1894 *
1895 * @global boolean $cfg['Export']['sql_disable_fk']
1896 */
1897$cfg['Export']['sql_disable_fk'] = false;
1898
1899/**
1900 *
1901 *
1902 * @global boolean $cfg['Export']['sql_views_as_tables']
1903 */
1904$cfg['Export']['sql_views_as_tables'] = false;
1905
1906/**
1907 *
1908 *
1909 * @global boolean $cfg['Export']['sql_metadata']
1910 */
1911$cfg['Export']['sql_metadata'] = false;
1912
1913/**
1914 *
1915 *
1916 * @global boolean $cfg['Export']['sql_use_transaction']
1917 */
1918$cfg['Export']['sql_use_transaction'] = true;
1919
1920/**
1921 *
1922 *
1923 * @global boolean $cfg['Export']['sql_create_database']
1924 */
1925$cfg['Export']['sql_create_database'] = false;
1926
1927/**
1928 *
1929 *
1930 * @global boolean $cfg['Export']['sql_drop_database']
1931 */
1932$cfg['Export']['sql_drop_database'] = false;
1933
1934/**
1935 *
1936 *
1937 * @global boolean $cfg['Export']['sql_drop_table']
1938 */
1939$cfg['Export']['sql_drop_table'] = false;
1940
1941/**
1942 *
1943 *
1944 * true by default for correct behavior when dealing with exporting
1945 * of VIEWs and the stand-in table
1946 * @global boolean $cfg['Export']['sql_if_not_exists']
1947 */
1948$cfg['Export']['sql_if_not_exists'] = false;
1949
1950/**
1951 *
1952 *
1953 * @global boolean $cfg['Export']['sql_procedure_function']
1954 */
1955$cfg['Export']['sql_procedure_function'] = true;
1956
1957/**
1958 *
1959 *
1960 * @global boolean $cfg['Export']['sql_create_table']
1961 */
1962$cfg['Export']['sql_create_table'] = true;
1963
1964/**
1965 *
1966 *
1967 * @global boolean $cfg['Export']['sql_create_view']
1968 */
1969$cfg['Export']['sql_create_view'] = true;
1970
1971/**
1972 *
1973 *
1974 * @global boolean $cfg['Export']['sql_create_trigger']
1975 */
1976$cfg['Export']['sql_create_trigger'] = true;
1977
1978/**
1979 *
1980 *
1981 * @global boolean $cfg['Export']['sql_auto_increment']
1982 */
1983$cfg['Export']['sql_auto_increment'] = true;
1984
1985/**
1986 *
1987 *
1988 * @global boolean $cfg['Export']['sql_backquotes']
1989 */
1990$cfg['Export']['sql_backquotes'] = true;
1991
1992/**
1993 *
1994 *
1995 * @global boolean $cfg['Export']['sql_dates']
1996 */
1997$cfg['Export']['sql_dates'] = false;
1998
1999/**
2000 *
2001 *
2002 * @global boolean $cfg['Export']['sql_relation']
2003 */
2004$cfg['Export']['sql_relation'] = false;
2005
2006/**
2007 *
2008 *
2009 * @global boolean $cfg['Export']['sql_truncate']
2010 */
2011$cfg['Export']['sql_truncate'] = false;
2012
2013/**
2014 *
2015 *
2016 * @global boolean $cfg['Export']['sql_delayed']
2017 */
2018$cfg['Export']['sql_delayed'] = false;
2019
2020/**
2021 *
2022 *
2023 * @global boolean $cfg['Export']['sql_ignore']
2024 */
2025$cfg['Export']['sql_ignore'] = false;
2026
2027/**
2028 * Export time in UTC.
2029 *
2030 * @global boolean $cfg['Export']['sql_utc_time']
2031 */
2032$cfg['Export']['sql_utc_time'] = true;
2033
2034/**
2035 *
2036 *
2037 * @global boolean $cfg['Export']['sql_hex_for_binary']
2038 */
2039$cfg['Export']['sql_hex_for_binary'] = true;
2040
2041/**
2042 * insert/update/replace
2043 *
2044 * @global string $cfg['Export']['sql_type']
2045 */
2046$cfg['Export']['sql_type'] = 'INSERT';
2047
2048/**
2049 *
2050 *
2051 * @global integer $cfg['Export']['sql_max_query_size']
2052 */
2053$cfg['Export']['sql_max_query_size'] = 50000;
2054
2055/**
2056 *
2057 *
2058 * @global boolean $cfg['Export']['sql_mime']
2059 */
2060$cfg['Export']['sql_mime'] = false;
2061
2062/**
2063 * \n is replaced by new line
2064 *
2065 * @global string $cfg['Export']['sql_header_comment']
2066 */
2067$cfg['Export']['sql_header_comment'] = '';
2068
2069/**
2070 * Whether to use complete inserts, extended inserts, both, or neither
2071 *
2072 * @global string $cfg['Export']['sql_insert_syntax']
2073 */
2074$cfg['Export']['sql_insert_syntax'] = 'both';
2075
2076/**
2077 *
2078 *
2079 * @global string $cfg['Export']['pdf_report_title']
2080 */
2081$cfg['Export']['pdf_report_title'] = '';
2082
2083/**
2084 *
2085 *
2086 *@global string $cfg['Export']['xml_structure_or_data']
2087 */
2088$cfg['Export']['xml_structure_or_data'] = 'data';
2089
2090/**
2091 * Export schema for each structure
2092 *
2093 * @global string $cfg['Export']['xml_export_struc']
2094 */
2095$cfg['Export']['xml_export_struc'] = true;
2096
2097/**
2098 * Export events
2099 *
2100 * @global string $cfg['Export']['xml_export_events']
2101 */
2102$cfg['Export']['xml_export_events'] = true;
2103
2104/**
2105 * Export functions
2106 *
2107 * @global string $cfg['Export']['xml_export_functions']
2108 */
2109$cfg['Export']['xml_export_functions'] = true;
2110
2111/**
2112 * Export procedures
2113 *
2114 * @global string $cfg['Export']['xml_export_procedures']
2115 */
2116$cfg['Export']['xml_export_procedures'] = true;
2117
2118/**
2119 * Export schema for each table
2120 *
2121 * @global string $cfg['Export']['xml_export_tables']
2122 */
2123$cfg['Export']['xml_export_tables'] = true;
2124
2125/**
2126 * Export triggers
2127 *
2128 * @global string $cfg['Export']['xml_export_triggers']
2129 */
2130$cfg['Export']['xml_export_triggers'] = true;
2131
2132/**
2133 * Export views
2134 *
2135 * @global string $cfg['Export']['xml_export_views']
2136 */
2137$cfg['Export']['xml_export_views'] = true;
2138
2139/**
2140 * Export contents data
2141 *
2142 * @global string $cfg['Export']['xml_export_contents']
2143 */
2144$cfg['Export']['xml_export_contents'] = true;
2145
2146/**
2147 *
2148 *
2149 * @global string $cfg['Export']['yaml_structure_or_data']
2150 */
2151$cfg['Export']['yaml_structure_or_data'] = 'data';
2152
2153/*******************************************************************************
2154 * Import defaults
2155 */
2156$cfg['Import'] = array();
2157
2158/**
2159 *
2160 *
2161 * @global string $cfg['Import']['format']
2162 */
2163$cfg['Import']['format'] = 'sql';
2164
2165/**
2166 * Default charset for import.
2167 *
2168 * @global string $cfg['Import']['charset']
2169 */
2170$cfg['Import']['charset'] = '';
2171
2172/**
2173 *
2174 *
2175 * @global boolean $cfg['Import']['allow_interrupt']
2176 */
2177$cfg['Import']['allow_interrupt'] = true;
2178
2179/**
2180 *
2181 *
2182 * @global integer $cfg['Import']['skip_queries']
2183 */
2184$cfg['Import']['skip_queries'] = 0;
2185
2186/**
2187 *
2188 *
2189 * @global string $cfg['Import']['sql_compatibility']
2190 */
2191$cfg['Import']['sql_compatibility'] = 'NONE';
2192
2193/**
2194 *
2195 *
2196 * @global string $cfg['Import']['sql_no_auto_value_on_zero']
2197 */
2198$cfg['Import']['sql_no_auto_value_on_zero'] = true;
2199
2200/**
2201 *
2202 *
2203 * @global string $cfg['Import']['sql_read_as_multibytes']
2204 */
2205$cfg['Import']['sql_read_as_multibytes'] = false;
2206
2207/**
2208 *
2209 *
2210 * @global boolean $cfg['Import']['csv_replace']
2211 */
2212$cfg['Import']['csv_replace'] = false;
2213
2214/**
2215 *
2216 *
2217 * @global boolean $cfg['Import']['csv_ignore']
2218 */
2219$cfg['Import']['csv_ignore'] = false;
2220
2221/**
2222 *
2223 *
2224 * @global string $cfg['Import']['csv_terminated']
2225 */
2226$cfg['Import']['csv_terminated'] = ',';
2227
2228/**
2229 *
2230 *
2231 * @global string $cfg['Import']['csv_enclosed']
2232 */
2233$cfg['Import']['csv_enclosed'] = '"';
2234
2235/**
2236 *
2237 *
2238 * @global string $cfg['Import']['csv_escaped']
2239 */
2240$cfg['Import']['csv_escaped'] = '"';
2241
2242/**
2243 *
2244 *
2245 * @global string $cfg['Import']['csv_new_line']
2246 */
2247$cfg['Import']['csv_new_line'] = 'auto';
2248
2249/**
2250 *
2251 *
2252 * @global string $cfg['Import']['csv_columns']
2253 */
2254$cfg['Import']['csv_columns'] = '';
2255
2256/**
2257 *
2258 *
2259 * @global string $cfg['Import']['csv_col_names']
2260 */
2261$cfg['Import']['csv_col_names'] = false;
2262
2263/**
2264 *
2265 *
2266 * @global boolean $cfg['Import']['ldi_replace']
2267 */
2268$cfg['Import']['ldi_replace'] = false;
2269
2270/**
2271 *
2272 *
2273 * @global boolean $cfg['Import']['ldi_ignore']
2274 */
2275$cfg['Import']['ldi_ignore'] = false;
2276
2277/**
2278 *
2279 *
2280 * @global string $cfg['Import']['ldi_terminated']
2281 */
2282$cfg['Import']['ldi_terminated'] = ';';
2283
2284/**
2285 *
2286 *
2287 * @global string $cfg['Import']['ldi_enclosed']
2288 */
2289$cfg['Import']['ldi_enclosed'] = '"';
2290
2291/**
2292 *
2293 *
2294 * @global string $cfg['Import']['ldi_escaped']
2295 */
2296$cfg['Import']['ldi_escaped'] = '\\';
2297
2298/**
2299 *
2300 *
2301 * @global string $cfg['Import']['ldi_new_line']
2302 */
2303$cfg['Import']['ldi_new_line'] = 'auto';
2304
2305/**
2306 *
2307 *
2308 * @global string $cfg['Import']['ldi_columns']
2309 */
2310$cfg['Import']['ldi_columns'] = '';
2311
2312/**
2313 * 'auto' for auto-detection, true or false for forcing
2314 *
2315 * @global string $cfg['Import']['ldi_local_option']
2316 */
2317$cfg['Import']['ldi_local_option'] = 'auto';
2318
2319/**
2320 *
2321 *
2322 * @global string $cfg['Import']['ods_col_names']
2323 */
2324$cfg['Import']['ods_col_names'] = false;
2325
2326/**
2327 *
2328 *
2329 * @global string $cfg['Import']['ods_empty_rows']
2330 */
2331$cfg['Import']['ods_empty_rows'] = true;
2332
2333/**
2334 *
2335 *
2336 * @global string $cfg['Import']['ods_recognize_percentages']
2337 */
2338$cfg['Import']['ods_recognize_percentages'] = true;
2339
2340/**
2341 *
2342 *
2343 * @global string $cfg['Import']['ods_recognize_currency']
2344 */
2345$cfg['Import']['ods_recognize_currency'] = true;
2346
2347/*******************************************************************************
2348 * Schema export defaults
2349*/
2350$cfg['Schema'] = array();
2351
2352/**
2353 * pdf/eps/dia/svg
2354 *
2355 * @global string $cfg['Schema']['format']
2356*/
2357$cfg['Schema']['format'] = 'pdf';
2358
2359/**
2360 *
2361 *
2362 * @global string $cfg['Schema']['pdf_show_color']
2363 */
2364$cfg['Schema']['pdf_show_color'] = true;
2365
2366/**
2367 *
2368 *
2369 * @global string $cfg['Schema']['pdf_show_keys']
2370 */
2371$cfg['Schema']['pdf_show_keys'] = false;
2372
2373/**
2374 *
2375 *
2376 * @global string $cfg['Schema']['pdf_all_tables_same_width']
2377 */
2378$cfg['Schema']['pdf_all_tables_same_width'] = false;
2379
2380/**
2381 * L/P
2382 *
2383 * @global string $cfg['Schema']['pdf_orientation']
2384 */
2385$cfg['Schema']['pdf_orientation'] = 'L';
2386
2387/**
2388 *
2389 *
2390 * @global string $cfg['Schema']['pdf_paper']
2391 */
2392$cfg['Schema']['pdf_paper'] = 'A4';
2393
2394/**
2395 *
2396 *
2397 * @global string $cfg['Schema']['pdf_show_grid']
2398 */
2399$cfg['Schema']['pdf_show_grid'] = false;
2400
2401/**
2402 *
2403 *
2404 * @global string $cfg['Schema']['pdf_with_doc']
2405 */
2406$cfg['Schema']['pdf_with_doc'] = true;
2407
2408/**
2409 *
2410 *
2411 * @global string $cfg['Schema']['pdf_table_order']
2412 */
2413$cfg['Schema']['pdf_table_order'] = '';
2414
2415/**
2416 *
2417 *
2418 * @global string $cfg['Schema']['dia_show_color']
2419 */
2420$cfg['Schema']['dia_show_color'] = true;
2421
2422/**
2423 *
2424 *
2425 * @global string $cfg['Schema']['dia_show_keys']
2426 */
2427$cfg['Schema']['dia_show_keys'] = false;
2428
2429/**
2430 * L/P
2431 *
2432 * @global string $cfg['Schema']['dia_orientation']
2433 */
2434$cfg['Schema']['dia_orientation'] = 'L';
2435
2436/**
2437 *
2438 *
2439 * @global string $cfg['Schema']['dia_paper']
2440 */
2441$cfg['Schema']['dia_paper'] = 'A4';
2442
2443/**
2444 *
2445 *
2446 * @global string $cfg['Schema']['eps_show_color']
2447 */
2448$cfg['Schema']['eps_show_color'] = true;
2449
2450/**
2451 *
2452 *
2453 * @global string $cfg['Schema']['eps_show_keys']
2454 */
2455$cfg['Schema']['eps_show_keys'] = false;
2456
2457/**
2458 *
2459 *
2460 * @global string $cfg['Schema']['eps_all_tables_same_width']
2461 */
2462$cfg['Schema']['eps_all_tables_same_width'] = false;
2463
2464/**
2465 * L/P
2466 *
2467 * @global string $cfg['Schema']['eps_orientation']
2468 */
2469$cfg['Schema']['eps_orientation'] = 'L';
2470
2471/**
2472 *
2473 *
2474 * @global string $cfg['Schema']['svg_show_color']
2475 */
2476$cfg['Schema']['svg_show_color'] = true;
2477
2478/**
2479 *
2480 *
2481 * @global string $cfg['Schema']['svg_show_keys']
2482 */
2483$cfg['Schema']['svg_show_keys'] = false;
2484
2485/**
2486 *
2487 *
2488 * @global string $cfg['Schema']['svg_all_tables_same_width']
2489 */
2490$cfg['Schema']['svg_all_tables_same_width'] = false;
2491
2492/*******************************************************************************
2493 * PDF options
2494 */
2495
2496/**
2497 *
2498 *
2499 * @global array $cfg['PDFPageSizes']
2500 */
2501$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
2502
2503/**
2504 *
2505 *
2506 * @global string $cfg['PDFDefaultPageSize']
2507 */
2508$cfg['PDFDefaultPageSize'] = 'A4';
2509
2510
2511/*******************************************************************************
2512 * Language and character set conversion settings
2513 */
2514
2515/**
2516 * Default language to use, if not browser-defined or user-defined
2517 *
2518 * @global string $cfg['DefaultLang']
2519 */
2520$cfg['DefaultLang'] = 'en';
2521
2522/**
2523 * Default connection collation
2524 *
2525 * @global string $cfg['DefaultConnectionCollation']
2526 */
2527$cfg['DefaultConnectionCollation'] = 'utf8mb4_unicode_ci';
2528
2529/**
2530 * Force: always use this language, e.g. 'en'
2531 *
2532 * @global string $cfg['Lang']
2533 */
2534$cfg['Lang'] = '';
2535
2536/**
2537 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
2538 * English only
2539 *
2540 * @global string $cfg['FilterLanguages']
2541 */
2542$cfg['FilterLanguages'] = '';
2543
2544/**
2545 * You can select here which functions will be used for character set conversion.
2546 * Possible values are:
2547 *      auto   - automatically use available one (first is tested iconv, then
2548 *               recode)
2549 *      iconv  - use iconv or libiconv functions
2550 *      recode - use recode_string function
2551 *      mb     - use mbstring extension
2552 *      none   - disable encoding conversion
2553 *
2554 * @global string $cfg['RecodingEngine']
2555 */
2556$cfg['RecodingEngine'] = 'auto';
2557
2558/**
2559 * Specify some parameters for iconv used in character set conversion. See iconv
2560 * documentation for details:
2561 * https://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
2562 *
2563 * @global string $cfg['IconvExtraParams']
2564 */
2565$cfg['IconvExtraParams'] = '//TRANSLIT';
2566
2567/**
2568 * Available character sets for MySQL conversion. currently contains all which could
2569 * be found in lang/* files and few more.
2570 * Character sets will be shown in same order as here listed, so if you frequently
2571 * use some of these move them to the top.
2572 *
2573 * @global array $cfg['AvailableCharsets']
2574 */
2575$cfg['AvailableCharsets'] = array(
2576    'iso-8859-1',
2577    'iso-8859-2',
2578    'iso-8859-3',
2579    'iso-8859-4',
2580    'iso-8859-5',
2581    'iso-8859-6',
2582    'iso-8859-7',
2583    'iso-8859-8',
2584    'iso-8859-9',
2585    'iso-8859-10',
2586    'iso-8859-11',
2587    'iso-8859-12',
2588    'iso-8859-13',
2589    'iso-8859-14',
2590    'iso-8859-15',
2591    'windows-1250',
2592    'windows-1251',
2593    'windows-1252',
2594    'windows-1256',
2595    'windows-1257',
2596    'koi8-r',
2597    'big5',
2598    'gb2312',
2599    'utf-16',
2600    'utf-8',
2601    'utf-7',
2602    'x-user-defined',
2603    'euc-jp',
2604    'ks_c_5601-1987',
2605    'tis-620',
2606    'SHIFT_JIS',
2607    'SJIS',
2608    'SJIS-win',
2609);
2610
2611
2612/*******************************************************************************
2613 * Customization & design
2614 *
2615 * The graphical settings are now located in themes/theme-name/layout.inc.php
2616 */
2617
2618/**
2619 * enable the left panel pointer
2620 * see also LeftPointerColor
2621 * in layout.inc.php
2622 *
2623 * @global boolean $cfg['NavigationTreePointerEnable']
2624 */
2625$cfg['NavigationTreePointerEnable'] = true;
2626
2627/**
2628 * enable the browse pointer
2629 * see also BrowsePointerColor
2630 * in layout.inc.php
2631 *
2632 * @global boolean $cfg['BrowsePointerEnable']
2633 */
2634$cfg['BrowsePointerEnable'] = true;
2635
2636/**
2637 * enable the browse marker
2638 * see also BrowseMarkerColor
2639 * in layout.inc.php
2640 *
2641 * @global boolean $cfg['BrowseMarkerEnable']
2642 */
2643$cfg['BrowseMarkerEnable'] = true;
2644
2645/**
2646 * textarea size (columns) in edit mode
2647 * (this value will be emphasized (*2) for SQL
2648 * query textareas and (*1.25) for query window)
2649 *
2650 * @global integer $cfg['TextareaCols']
2651 */
2652$cfg['TextareaCols'] = 40;
2653
2654/**
2655 * textarea size (rows) in edit mode
2656 *
2657 * @global integer $cfg['TextareaRows']
2658 */
2659$cfg['TextareaRows'] = 15;
2660
2661/**
2662 * double size of textarea size for LONGTEXT columns
2663 *
2664 * @global boolean $cfg['LongtextDoubleTextarea']
2665 */
2666$cfg['LongtextDoubleTextarea'] = true;
2667
2668/**
2669 * auto-select when clicking in the textarea of the query-box
2670 *
2671 * @global boolean $cfg['TextareaAutoSelect']
2672 */
2673$cfg['TextareaAutoSelect'] = false;
2674
2675/**
2676 * textarea size (columns) for CHAR/VARCHAR
2677 *
2678 * @global integer $cfg['CharTextareaCols']
2679 */
2680$cfg['CharTextareaCols'] = 40;
2681
2682/**
2683 * textarea size (rows) for CHAR/VARCHAR
2684 *
2685 * @global integer $cfg['CharTextareaRows']
2686 */
2687$cfg['CharTextareaRows'] = 2;
2688
2689/**
2690 * Max field data length in browse mode for all non-numeric fields
2691 *
2692 * @global integer $cfg['LimitChars']
2693 */
2694$cfg['LimitChars'] = 50;
2695
2696/**
2697 * Where to show the edit/copy/delete links in browse mode
2698 * Possible values are 'left', 'right', 'both' and 'none'.
2699 *
2700 * @global string $cfg['RowActionLinks']
2701 */
2702$cfg['RowActionLinks'] = 'left';
2703
2704/**
2705 * Whether to show row links (Edit, Copy, Delete) and checkboxes for
2706 * multiple row operations even when the selection does not have a unique key.
2707 *
2708 * @global boolean $cfg['RowActionLinksWithoutUnique']
2709 */
2710$cfg['RowActionLinksWithoutUnique'] = false;
2711
2712/**
2713 * Default sort order by primary key.
2714 * @global string $cfg['TablePrimaryKeyOrder']
2715 */
2716$cfg['TablePrimaryKeyOrder'] = 'NONE';
2717
2718/**
2719 * remember the last way a table sorted
2720 *
2721 * @global string $cfg['RememberSorting']
2722 */
2723$cfg['RememberSorting'] = true;
2724
2725/**
2726 * shows column comments in 'browse' mode.
2727 *
2728 * @global boolean $cfg['ShowBrowseComments']
2729 */
2730$cfg['ShowBrowseComments'] = true;
2731
2732/**
2733 * shows column comments in 'table property' mode.
2734 *
2735 * @global boolean $cfg['ShowPropertyComments']
2736 */
2737$cfg['ShowPropertyComments']= true;
2738
2739/**
2740 * repeat header names every X cells? (0 = deactivate)
2741 *
2742 * @global integer $cfg['RepeatCells']
2743 */
2744$cfg['RepeatCells'] = 100;
2745
2746/**
2747 * Set to true if you want DB-based query history.If false, this utilizes
2748 * JS-routines to display query history (lost by window close)
2749 *
2750 * @global boolean $cfg['QueryHistoryDB']
2751 */
2752$cfg['QueryHistoryDB'] = false;
2753
2754/**
2755 * When using DB-based query history, how many entries should be kept?
2756 *
2757 * @global integer $cfg['QueryHistoryMax']
2758 */
2759$cfg['QueryHistoryMax'] = 25;
2760
2761/**
2762 * Use MIME-Types (stored in column comments table) for
2763 *
2764 * @global boolean $cfg['BrowseMIME']
2765 */
2766$cfg['BrowseMIME'] = true;
2767
2768/**
2769 * When approximate count < this, PMA will get exact count for table rows.
2770 *
2771 * @global integer $cfg['MaxExactCount']
2772 */
2773$cfg['MaxExactCount'] = 50000;
2774
2775/**
2776 * Zero means that no row count is done for views; see the doc
2777 *
2778 * @global integer $cfg['MaxExactCountViews']
2779 */
2780$cfg['MaxExactCountViews'] = 0;
2781
2782/**
2783 * Sort table and database in natural order
2784 *
2785 * @global boolean $cfg['NaturalOrder']
2786 */
2787$cfg['NaturalOrder'] = true;
2788
2789/**
2790 * Initial state for sliders
2791 * (open | closed | disabled)
2792 *
2793 * @global string $cfg['InitialSlidersState']
2794 */
2795$cfg['InitialSlidersState'] = 'closed';
2796
2797/**
2798 * User preferences: disallow these settings
2799 * For possible setting names look in libraries/config/user_preferences.forms.php
2800 *
2801 * @global array $cfg['UserprefsDisallow']
2802 */
2803$cfg['UserprefsDisallow'] = array();
2804
2805/**
2806 * User preferences: enable the Developer tab
2807 */
2808$cfg['UserprefsDeveloperTab'] = false;
2809
2810/*******************************************************************************
2811 * Window title settings
2812 */
2813
2814/**
2815 * title of browser window when a table is selected
2816 *
2817 * @global string $cfg['TitleTable']
2818 */
2819$cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
2820
2821/**
2822 * title of browser window when a database is selected
2823 *
2824 * @global string $cfg['TitleDatabase']
2825 */
2826$cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
2827
2828/**
2829 * title of browser window when a server is selected
2830 *
2831 * @global string $cfg['TitleServer']
2832 */
2833$cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
2834
2835/**
2836 * title of browser window when nothing is selected
2837 * @global string $cfg['TitleDefault']
2838 */
2839$cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
2840
2841
2842/*******************************************************************************
2843 * theme manager
2844 */
2845
2846/**
2847 * if you want to use selectable themes and if ThemesPath not empty
2848 * set it to true, else set it to false (default is false);
2849 *
2850 * @global boolean $cfg['ThemeManager']
2851 */
2852$cfg['ThemeManager'] = true;
2853
2854/**
2855 * set up default theme, you can set up here an valid
2856 * path to themes or 'original' for the original pma-theme
2857 *
2858 * @global string $cfg['ThemeDefault']
2859 */
2860$cfg['ThemeDefault'] = 'pmahomme';
2861
2862/**
2863 * allow different theme for each configured server
2864 *
2865 * @global boolean $cfg['ThemePerServer']
2866 */
2867$cfg['ThemePerServer'] = false;
2868
2869
2870/**
2871 * Font size to use by default
2872 */
2873$cfg['FontSize'] = '82%';
2874
2875/*******************************************************************************
2876 *
2877 */
2878
2879/**
2880 * Default query for table
2881 *
2882 * @global string $cfg['DefaultQueryTable']
2883 */
2884$cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
2885
2886/**
2887 * Default query for database
2888 *
2889 * @global string $cfg['DefaultQueryDatabase']
2890 */
2891$cfg['DefaultQueryDatabase'] = '';
2892
2893
2894/*******************************************************************************
2895 * SQL Query box settings
2896 * These are the links display in all of the SQL Query boxes
2897 *
2898 * @global array $cfg['SQLQuery']
2899 */
2900$cfg['SQLQuery'] = array();
2901
2902/**
2903 * Display an "Edit" link on the results page to change a query
2904 *
2905 * @global boolean $cfg['SQLQuery']['Edit']
2906 */
2907$cfg['SQLQuery']['Edit'] = true;
2908
2909/**
2910 * Display an "Explain SQL" link on the results page
2911 *
2912 * @global boolean $cfg['SQLQuery']['Explain']
2913 */
2914$cfg['SQLQuery']['Explain'] = true;
2915
2916/**
2917 * Display a "Create PHP code" link on the results page to wrap a query in PHP
2918 *
2919 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2920 */
2921$cfg['SQLQuery']['ShowAsPHP'] = true;
2922
2923/**
2924 * Display a "Refresh" link on the results page
2925 *
2926 * @global boolean $cfg['SQLQuery']['Refresh']
2927 */
2928$cfg['SQLQuery']['Refresh'] = true;
2929
2930/**
2931 * Enables autoComplete for table & column names in SQL queries
2932 *
2933 * default = 'true'
2934 */
2935$cfg['EnableAutocompleteForTablesAndColumns'] = true;
2936
2937
2938/*******************************************************************************
2939 * Web server upload/save/import directories
2940 */
2941
2942/**
2943 * Directory for uploaded files that can be executed by phpMyAdmin.
2944 * For example './upload'. Leave empty for no upload directory support.
2945 * Use %u for username inclusion.
2946 *
2947 * @global string $cfg['UploadDir']
2948 */
2949$cfg['UploadDir'] = '';
2950
2951/**
2952 * Directory where phpMyAdmin can save exported data on server.
2953 * For example './save'. Leave empty for no save directory support.
2954 * Use %u for username inclusion.
2955 *
2956 * @global string $cfg['SaveDir']
2957 */
2958$cfg['SaveDir'] = '';
2959
2960/**
2961 * Directory where phpMyAdmin can save temporary files.
2962 *
2963 * @global string $cfg['TempDir']
2964 */
2965if (defined('TEMP_DIR')) {
2966    $cfg['TempDir'] = TEMP_DIR;
2967} else {
2968    $cfg['TempDir'] = './tmp/';
2969}
2970
2971
2972/**
2973 * Misc. settings
2974 */
2975
2976/**
2977 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2978 * which is the only safe way to determine GD version.
2979 *
2980 * @global string $cfg['GD2Available']
2981 */
2982$cfg['GD2Available'] = 'auto';
2983
2984/**
2985 * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
2986 *
2987 * @global array $cfg['TrustedProxies']
2988 */
2989$cfg['TrustedProxies'] = array();
2990
2991/**
2992 * We normally check the permissions on the configuration file to ensure
2993 * it's not world writable. However, phpMyAdmin could be installed on
2994 * a NTFS filesystem mounted on a non-Windows server, in which case the
2995 * permissions seems wrong but in fact cannot be detected. In this case
2996 * a sysadmin would set the following to false.
2997 */
2998$cfg['CheckConfigurationPermissions'] = true;
2999
3000/**
3001 * Limit for length of URL in links. When length would be above this limit, it
3002 * is replaced by form with button.
3003 * This is required as some web servers (IIS) have problems with long URLs.
3004 * The recommended limit is 2000
3005 * (see https://www.boutell.com/newfaq/misc/urllength.html) but we put
3006 * 1000 to accommodate Suhosin, see bug #3358750.
3007 */
3008$cfg['LinkLengthLimit'] = 1000;
3009
3010/**
3011 * Additional string to allow in CSP headers.
3012 */
3013 $cfg['CSPAllow'] = '';
3014
3015/**
3016 * Disable the table maintenance mass operations, like optimizing or
3017 * repairing the selected tables of a database. An accidental execution
3018 * of such a maintenance task can enormously slow down a bigger database.
3019 */
3020$cfg['DisableMultiTableMaintenance'] = false;
3021
3022/**
3023 * Whether or not to query the user before sending the error report to
3024 * the phpMyAdmin team when a JavaScript error occurs
3025 *
3026 * Available options
3027 * (ask | always | never)
3028 *
3029 * @global string $cfg['SendErrorReports']
3030 */
3031$cfg['SendErrorReports'] = 'ask';
3032
3033/**
3034 * Whether Enter or Ctrl+Enter executes queries in the console.
3035 *
3036 * @global boolean $cfg['ConsoleEnterExecutes']
3037 */
3038$cfg['ConsoleEnterExecutes'] = false;
3039
3040/**
3041 * Zero Configuration mode.
3042 *
3043 * @global boolean $cfg['ZeroConf']
3044 */
3045$cfg['ZeroConf'] = true;
3046
3047/*******************************************************************************
3048 * Developers ONLY!
3049 *
3050 * @global array $cfg['DBG']
3051 */
3052$cfg['DBG'] = array();
3053
3054/**
3055 * Output executed queries and their execution times
3056 *
3057 * @global boolean $cfg['DBG']['sql']
3058 */
3059$cfg['DBG']['sql'] = false;
3060
3061/**
3062 * Log executed queries and their execution times to syslog
3063 *
3064 * @global boolean $cfg['DBG']['sqllog']
3065 */
3066$cfg['DBG']['sqllog'] = false;
3067
3068/**
3069 * Enable to let server present itself as demo server.
3070 *
3071 * @global boolean $cfg['DBG']['demo']
3072 */
3073$cfg['DBG']['demo'] = false;
3074
3075/**
3076 * Enable Simple two-factor authentication
3077 *
3078 * @global boolean $cfg['DBG']['simple2fa']
3079 */
3080$cfg['DBG']['simple2fa'] = false;
3081
3082
3083/*******************************************************************************
3084 * MySQL settings
3085 */
3086
3087/**
3088 * Default functions for above defined groups
3089 *
3090 * @global array $cfg['DefaultFunctions']
3091 */
3092$cfg['DefaultFunctions'] = array(
3093    'FUNC_CHAR' => '',
3094    'FUNC_DATE' => '',
3095    'FUNC_NUMBER' => '',
3096    'FUNC_SPATIAL' => 'GeomFromText',
3097    'FUNC_UUID' => 'UUID',
3098    'first_timestamp' => 'NOW',
3099);
3100
3101/**
3102 * Max rows retrieved for zoom search
3103 */
3104$cfg['maxRowPlotLimit'] = 500;
3105
3106/**
3107 * Show Git revision if applicable
3108 *
3109 * @global boolean $cfg['ShowGitRevision']
3110 */
3111$cfg['ShowGitRevision'] = true;
3112
3113/**
3114 * MySQL minimal version required
3115 *
3116 * @global array $cfg['MysqlMinVersion']
3117 */
3118$cfg['MysqlMinVersion'] = array(
3119    'internal' => 50500,
3120    'human' => '5.5.0'
3121);
3122
3123/**
3124 * Disable shortcuts
3125 *
3126 * @global array $cfg['DisableShortcutKeys']
3127 */
3128$cfg['DisableShortcutKeys'] = false;
3129
3130/**
3131 * Console configuration
3132 *
3133 * This is mostly meant for user preferences.
3134 */
3135$cfg['Console'] = [
3136    'StartHistory' => false,
3137    'AlwaysExpand' => false,
3138    'CurrentQuery' => true,
3139    'EnterExecutes' => false,
3140    'DarkTheme' => false,
3141    'Mode' => 'info',
3142    'Height' => 92,
3143    'GroupQueries' => false,
3144    'OrderBy' => 'exec',
3145    'Order' => 'asc',
3146];
3147
3148
3149/*******************************************************************************
3150 * Default options for transformations
3151 */
3152
3153/**
3154 * Initialize default transformations array
3155 *
3156 * @global array $cfg['DefaultTransformations']
3157 */
3158$cfg['DefaultTransformations'] = array();
3159
3160/**
3161 * Default transformations for Substring
3162 *
3163 * @global array $cfg['DefaultTransformations']['Substring']
3164 */
3165$cfg['DefaultTransformations']['Substring'] = array(0, 'all', '…');
3166
3167/**
3168 * Default transformations for Bool2Text
3169 *
3170 * @global array $cfg['DefaultTransformations']['Bool2Text']
3171 */
3172$cfg['DefaultTransformations']['Bool2Text'] = array('T', 'F');
3173
3174/**
3175 * Default transformations for External
3176 *
3177 * @global array $cfg['DefaultTransformations']['External']
3178 */
3179$cfg['DefaultTransformations']['External'] = array(0, '-f /dev/null -i -wrap -q', 1, 1);
3180
3181/**
3182 * Default transformations for PreApPend
3183 *
3184 * @global array $cfg['DefaultTransformations']['PreApPend']
3185 */
3186$cfg['DefaultTransformations']['PreApPend'] = array('', '');
3187
3188/**
3189 * Default transformations for Hex
3190 *
3191 * @global array $cfg['DefaultTransformations']['Hex']
3192 */
3193$cfg['DefaultTransformations']['Hex'] = array('2');
3194
3195/**
3196 * Default transformations for DateFormat
3197 *
3198 * @global array $cfg['DefaultTransformations']['DateFormat']
3199 */
3200$cfg['DefaultTransformations']['DateFormat'] = array(0, '', 'local');
3201
3202/**
3203 * Default transformations for Inline
3204 *
3205 * @global array $cfg['DefaultTransformations']['Inline']
3206 */
3207$cfg['DefaultTransformations']['Inline'] = array('100', 100);
3208$cfg['DefaultTransformations']['Inline']['wrapper_link'] = null;
3209
3210/**
3211 * Default transformations for TextImageLink
3212 *
3213 * @global array $cfg['DefaultTransformations']['TextImageLink']
3214 */
3215$cfg['DefaultTransformations']['TextImageLink'] = array(null, 100, 50);
3216
3217/**
3218 * Default transformations for TextLink
3219 *
3220 * @global array $cfg['DefaultTransformations']['TextLink']
3221 */
3222$cfg['DefaultTransformations']['TextLink'] = array(null, null, null);