libraries/config.default.php

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