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