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