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