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