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