libraries/config.default.php

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