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