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