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