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