libraries/config.default.php

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