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 string $cfg['Import']['sql_no_auto_value_on_zero']
1616  */
1617 $cfg['Import']['sql_no_auto_value_on_zero'] = true;
1618
1619 /**
1620  *
1621  *
1622  * @global boolean $cfg['Import']['csv_replace']
1623  */
1624 $cfg['Import']['csv_replace'] = false;
1625
1626 /**
1627  *
1628  *
1629  * @global string $cfg['Import']['csv_terminated']
1630  */
1631 $cfg['Import']['csv_terminated'] = ';';
1632
1633 /**
1634  *
1635  *
1636  * @global string $cfg['Import']['csv_enclosed']
1637  */
1638 $cfg['Import']['csv_enclosed'] = '"';
1639
1640 /**
1641  *
1642  *
1643  * @global string $cfg['Import']['csv_escaped']
1644  */
1645 $cfg['Import']['csv_escaped'] = '\\';
1646
1647 /**
1648  *
1649  *
1650  * @global string $cfg['Import']['csv_new_line']
1651  */
1652 $cfg['Import']['csv_new_line'] = 'auto';
1653
1654 /**
1655  *
1656  *
1657  * @global string $cfg['Import']['csv_columns']
1658  */
1659 $cfg['Import']['csv_columns'] = '';
1660
1661 /**
1662  *
1663  *
1664  * @global boolean $cfg['Import']['ldi_replace']
1665  */
1666 $cfg['Import']['ldi_replace'] = false;
1667
1668 /**
1669  *
1670  *
1671  * @global string $cfg['Import']['ldi_terminated']
1672  */
1673 $cfg['Import']['ldi_terminated'] = ';';
1674
1675 /**
1676  *
1677  *
1678  * @global string $cfg['Import']['ldi_enclosed']
1679  */
1680 $cfg['Import']['ldi_enclosed'] = '"';
1681
1682 /**
1683  *
1684  *
1685  * @global string $cfg['Import']['ldi_escaped']
1686  */
1687 $cfg['Import']['ldi_escaped'] = '\\';
1688
1689 /**
1690  *
1691  *
1692  * @global string $cfg['Import']['ldi_new_line']
1693  */
1694 $cfg['Import']['ldi_new_line'] = 'auto';
1695
1696 /**
1697  *
1698  *
1699  * @global string $cfg['Import']['ldi_columns']
1700  */
1701 $cfg['Import']['ldi_columns'] = '';
1702
1703 /**
1704  * 'auto' for auto-detection, true or false for forcing
1705  *
1706  * @global string $cfg['Import']['ldi_local_option']
1707  */
1708 $cfg['Import']['ldi_local_option'] = 'auto';
1709
1710 /**
1711  * Link to the official MySQL documentation.
1712  * Be sure to include no trailing slash on the path.
1713  * See http://dev.mysql.com/doc/ for more information
1714  * about MySQL manuals and their types.
1715  *
1716  * @global string $cfg['MySQLManualBase']
1717  */
1718 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
1719
1720 /**
1721  * Type of MySQL documentation:
1722  *   viewable   - "viewable online", current one used on MySQL website
1723  *   searchable - "Searchable, with user comments"
1724  *   chapters   - "HTML, one page per chapter"
1725  *   chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release
1726  *   big        - "HTML, all on one page"
1727  *   old        - old style used in phpMyAdmin 2.3.0 and sooner
1728  *   none       - do not show documentation links
1729  *
1730  * @global string $cfg['MySQLManualType']
1731  */
1732 $cfg['MySQLManualType'] = 'viewable';
1733
1734
1735 /*******************************************************************************
1736  * PDF options
1737  */
1738
1739 /**
1740  *
1741  *
1742  * @global array $cfg['PDFPageSizes']
1743  */
1744 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
1745
1746 /**
1747  *
1748  *
1749  * @global string $cfg['PDFDefaultPageSize']
1750  */
1751 $cfg['PDFDefaultPageSize'] = 'A4';
1752
1753
1754 /*******************************************************************************
1755  * Language and character set conversion settings
1756  */
1757
1758 /**
1759  * Default language to use, if not browser-defined or user-defined
1760  *
1761  * @global string $cfg['DefaultLang']
1762  */
1763 $cfg['DefaultLang'] = 'en-utf-8';
1764
1765 /**
1766  * Default connection collation
1767  *
1768  * @global string $cfg['DefaultConnectionCollation']
1769  */
1770 $cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
1771
1772 /**
1773  * Force: always use this language - must be defined in
1774  *        libraries/select_lang.lib.php
1775  * $cfg['Lang'] = 'en-utf-8';
1776  *
1777  * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
1778  * English only
1779  *
1780  * @global string $cfg['FilterLanguages']
1781  */
1782 $cfg['FilterLanguages'] = '';
1783
1784 /**
1785  * Default character set to use for recoding of MySQL queries, does not take
1786  * any effect when character sets recoding is switched off by
1787  * $cfg['AllowAnywhereRecoding'] or in language file
1788  * (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
1789  *
1790  * @global string $cfg['DefaultCharset']
1791  */
1792 $cfg['DefaultCharset'] = 'utf-8';
1793
1794 /**
1795  * Allow character set recoding of MySQL queries, must be also enabled in language
1796  * file to make harder using other language files than Unicode.
1797  * Default value is false to avoid problems on servers without the iconv
1798  * extension
1799  *
1800  * @global boolean $cfg['AllowAnywhereRecoding']
1801  */
1802 $cfg['AllowAnywhereRecoding'] = false;
1803
1804 /**
1805  * You can select here which functions will be used for character set conversion.
1806  * Possible values are:
1807  *      auto   - automatically use available one (first is tested iconv, then
1808  *               recode)
1809  *      iconv  - use iconv or libiconv functions
1810  *      recode - use recode_string function
1811  *
1812  * @global string $cfg['RecodingEngine']
1813  */
1814 $cfg['RecodingEngine'] = 'auto';
1815
1816 /**
1817  * Specify some parameters for iconv used in character set conversion. See iconv
1818  * documentation for details:
1819  * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
1820  *
1821  * @global string $cfg['IconvExtraParams']
1822  */
1823 $cfg['IconvExtraParams'] = '//TRANSLIT';
1824
1825 /**
1826  * Available character sets for MySQL conversion. currently contains all which could
1827  * be found in lang/* files and few more.
1828  * Character sets will be shown in same order as here listed, so if you frequently
1829  * use some of these move them to the top.
1830  *
1831  * @global array $cfg['AvailableCharsets']
1832  */
1833 $cfg['AvailableCharsets'] = array(
1834     'iso-8859-1',
1835     'iso-8859-2',
1836     'iso-8859-3',
1837     'iso-8859-4',
1838     'iso-8859-5',
1839     'iso-8859-6',
1840     'iso-8859-7',
1841     'iso-8859-8',
1842     'iso-8859-9',
1843     'iso-8859-10',
1844     'iso-8859-11',
1845     'iso-8859-12',
1846     'iso-8859-13',
1847     'iso-8859-14',
1848     'iso-8859-15',
1849     'windows-1250',
1850     'windows-1251',
1851     'windows-1252',
1852     'windows-1256',
1853     'windows-1257',
1854     'koi8-r',
1855     'big5',
1856     'gb2312',
1857     'utf-16',
1858     'utf-8',
1859     'utf-7',
1860     'x-user-defined',
1861     'euc-jp',
1862     'ks_c_5601-1987',
1863     'tis-620',
1864     'SHIFT_JIS'
1865 );
1866
1867
1868 /*******************************************************************************
1869  * Customization & design
1870  *
1871  * The graphical settings are now located in themes/theme-name/layout.inc.php
1872  */
1873
1874 /**
1875  * enable the left panel pointer
1876  * (used when LeftFrameLight is false)
1877  * see also LeftPointerColor
1878  * in layout.inc.php
1879  *
1880  * @global boolean $cfg['LeftPointerEnable']
1881  */
1882 $cfg['LeftPointerEnable'] = true;
1883
1884 /**
1885  * enable the browse pointer
1886  * see also BrowsePointerColor
1887  * in layout.inc.php
1888  *
1889  * @global boolean $cfg['BrowsePointerEnable']
1890  */
1891 $cfg['BrowsePointerEnable'] = true;
1892
1893 /**
1894  * enable the browse marker
1895  * see also BrowseMarkerColor
1896  * in layout.inc.php
1897  *
1898  * @global boolean $cfg['BrowseMarkerEnable']
1899  */
1900 $cfg['BrowseMarkerEnable'] = true;
1901
1902 /**
1903  * textarea size (columns) in edit mode
1904  * (this value will be emphasized (*2) for SQL
1905  * query textareas and (*1.25) for query window)
1906  *
1907  * @global integer $cfg['TextareaCols']
1908  */
1909 $cfg['TextareaCols'] = 40;
1910
1911 /**
1912  * textarea size (rows) in edit mode
1913  *
1914  * @global integer $cfg['TextareaRows']
1915  */
1916 $cfg['TextareaRows'] = 7;
1917
1918 /**
1919  * double size of textarea size for LONGTEXT fields
1920  *
1921  * @global boolean $cfg['LongtextDoubleTextarea']
1922  */
1923 $cfg['LongtextDoubleTextarea'] = true;
1924
1925 /**
1926  * auto-select when clicking in the textarea of the query-box
1927  *
1928  * @global boolean $cfg['TextareaAutoSelect']
1929  */
1930 $cfg['TextareaAutoSelect'] = false;
1931
1932 /**
1933  * textarea size (columns) for CHAR/VARCHAR
1934  *
1935  * @global integer $cfg['CharTextareaCols']
1936  */
1937 $cfg['CharTextareaCols'] = 40;
1938
1939 /**
1940  * textarea size (rows) for CHAR/VARCHAR
1941  *
1942  * @global integer $cfg['CharTextareaRows']
1943  */
1944 $cfg['CharTextareaRows'] = 2;
1945
1946 /**
1947  * Enable Ctrl+Arrows moving between fields when editing?
1948  *
1949  * @global boolean $cfg['CtrlArrowsMoving']
1950  */
1951 $cfg['CtrlArrowsMoving'] = true;
1952
1953 /**
1954  * Max field data length in browse mode for all non-numeric fields
1955  *
1956  * @global integer $cfg['LimitChars']
1957  */
1958 $cfg['LimitChars'] = 50;
1959
1960 /**
1961  * show edit/delete links on left side of browse
1962  * (or at the top with vertical browse)
1963  *
1964  * @global boolean $cfg['ModifyDeleteAtLeft']
1965  */
1966 $cfg['ModifyDeleteAtLeft'] = true;
1967
1968 /**
1969  * show edit/delete links on right side of browse
1970  * (or at the bottom with vertical browse)
1971  *
1972  * @global boolean $cfg['ModifyDeleteAtRight']
1973  */
1974 $cfg['ModifyDeleteAtRight'] = false;
1975
1976 /**
1977  * default display direction (horizontal|vertical|horizontalflipped)
1978  *
1979  * @global string $cfg['DefaultDisplay']
1980  */
1981 $cfg['DefaultDisplay'] = 'horizontal';
1982
1983 /**
1984  * default display direction for altering/creating columns (tbl_properties)
1985  * (horizontal|vertical|<number>)
1986  * number indicates maximal number for which vertical model is used
1987  *
1988  * @global integer $cfg['DefaultPropDisplay']
1989  */
1990 $cfg['DefaultPropDisplay'] = 3;
1991
1992 /**
1993  * table-header rotation via faking or CSS? (css|fake)
1994  * NOTE: CSS only works in IE browsers!
1995  *
1996  * @global string $cfg['HeaderFlipType']
1997  */
1998 $cfg['HeaderFlipType'] = 'css';
1999
2000 /**
2001  * shows stored relation-comments in 'browse' mode.
2002  *
2003  * @global boolean $cfg['ShowBrowseComments']
2004  */
2005 $cfg['ShowBrowseComments'] = true;
2006
2007 /**
2008  * shows stored relation-comments in 'table property' mode.
2009  *
2010  * @global boolean $cfg['ShowPropertyComments']
2011  */
2012 $cfg['ShowPropertyComments']= true;
2013
2014 /**
2015  * repeat header names every X cells? (0 = deactivate)
2016  *
2017  * @global integer $cfg['RepeatCells']
2018  */
2019 $cfg['RepeatCells'] = 100;
2020
2021 /**
2022  * Set to true if Edit link should open the query to edit in the query window
2023  * (assuming JavaScript is enabled), and to false if we should edit in the right panel
2024  *
2025  * @global boolean $cfg['EditInWindow']
2026  */
2027 $cfg['EditInWindow'] = true;
2028
2029 /**
2030  * Width of Query window
2031  *
2032  * @global integer $cfg['QueryWindowWidth']
2033  */
2034 $cfg['QueryWindowWidth'] = 550;
2035
2036 /**
2037  * Height of Query window
2038  *
2039  * @global integer $cfg['QueryWindowHeight']
2040  */
2041 $cfg['QueryWindowHeight'] = 310;
2042
2043 /**
2044  * Set to true if you want DB-based query history.If false, this utilizes
2045  * JS-routines to display query history (lost by window close)
2046  *
2047  * @global boolean $cfg['QueryHistoryDB']
2048  */
2049 $cfg['QueryHistoryDB'] = false;
2050
2051 /**
2052  * which tab to display in the querywindow on startup
2053  * (sql|files|history|full)
2054  *
2055  * @global string $cfg['QueryWindowDefTab']
2056  */
2057 $cfg['QueryWindowDefTab'] = 'sql';
2058
2059 /**
2060  * When using DB-based query history, how many entries should be kept?
2061  *
2062  * @global integer $cfg['QueryHistoryMax']
2063  */
2064 $cfg['QueryHistoryMax'] = 25;
2065
2066 /**
2067  * Use MIME-Types (stored in column comments table) for
2068  *
2069  * @global boolean $cfg['BrowseMIME']
2070  */
2071 $cfg['BrowseMIME'] = true;
2072
2073 /**
2074  * When approximate count < this, PMA will get exact count for table rows.
2075  *
2076  * @global integer $cfg['MaxExactCount']
2077  */
2078 $cfg['MaxExactCount'] = 20000;
2079
2080 /**
2081  * Zero means that no row count is done for views; see the doc
2082  *
2083  * @global integer $cfg['MaxExactCountViews']
2084  */
2085 $cfg['MaxExactCountViews'] = 0;
2086
2087 /**
2088  * Utilize DHTML/JS capabilities to allow WYSIWYG editing of
2089  * the PDF page editor. Requires an IE6/Gecko based browser.
2090  *
2091  * @global boolean $cfg['WYSIWYG-PDF']
2092  */
2093 $cfg['WYSIWYG-PDF'] = true;
2094
2095 /**
2096  * Sort table and database in natural order
2097  *
2098  * @global boolean $cfg['NaturalOrder']
2099  */
2100 $cfg['NaturalOrder'] = true;
2101
2102 /**
2103  * Initial state for sliders
2104  * (open | closed)
2105  *
2106  * @global string $cfg['InitialSlidersState']
2107  */
2108 $cfg['InitialSlidersState'] = 'closed';
2109
2110
2111
2112 //-----------------------------------------------------------------------------
2113 // custom-setup by mkkeck: 2004-05-04
2114 //    some specials for new icons and scrolling
2115 /**
2116  * @todo 2004-05-08 rabus: We need to rearrange these variables.
2117  */
2118
2119
2120 /*******************************************************************************
2121  * Window title settings
2122  */
2123
2124 /**
2125  * title of browser window when a table is selected
2126  *
2127  * @global string $cfg['TitleTable']
2128  */
2129 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
2130
2131 /**
2132  * title of browser window when a database is selected
2133  *
2134  * @global string $cfg['TitleDatabase']
2135  */
2136 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
2137
2138 /**
2139  * title of browser window when a server is selected
2140  *
2141  * @global string $cfg['TitleServer']
2142  */
2143 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
2144
2145 /**
2146  * title of browser window when nothing is selected
2147  * @global string $cfg['TitleDefault']
2148  */
2149 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
2150
2151 /**
2152  * show some icons for warning, error and information messages (true|false)?
2153  *
2154  * @global boolean $cfg['ErrorIconic']
2155  */
2156 $cfg['ErrorIconic'] = true;
2157
2158 /**
2159  * show icons in list on main page and on menu tabs (true|false)?
2160  *
2161  * @global boolean $cfg['MainPageIconic']
2162  */
2163 $cfg['MainPageIconic'] = true;
2164
2165 /**
2166  * show help button instead of strDocu (true|false)?
2167  *
2168  * @global boolean $cfg['ReplaceHelpImg']
2169  */
2170 $cfg['ReplaceHelpImg'] = true;
2171
2172
2173 /*******************************************************************************
2174  * theme manager
2175  */
2176
2177 /**
2178  * using themes manager please set up here the path to 'themes' else leave empty
2179  *
2180  * @global string $cfg['ThemePath']
2181  */
2182 $cfg['ThemePath'] = './themes';
2183
2184 /**
2185  * if you want to use selectable themes and if ThemesPath not empty
2186  * set it to true, else set it to false (default is false);
2187  *
2188  * @global boolean $cfg['ThemeManager']
2189  */
2190 $cfg['ThemeManager'] = true;
2191
2192 /**
2193  * set up default theme, if ThemePath not empty you can set up here an valid
2194  * path to themes or 'original' for the original pma-theme
2195  *
2196  * @global string $cfg['ThemeDefault']
2197  */
2198 $cfg['ThemeDefault'] = 'original';
2199
2200 /**
2201  * allow different theme for each configured server
2202  *
2203  * @global boolean $cfg['ThemePerServer']
2204  */
2205 $cfg['ThemePerServer'] = false;
2206
2207
2208 /*******************************************************************************
2209  *
2210  */
2211
2212 /**
2213  * Default queries
2214  * %d will be replaced by the database name.
2215  * %t will be replaced by the table name.
2216  * %f will be replaced by a list of field names.
2217  * (%t and %f only applies to DefaultQueryTable)
2218  *
2219  * @global string $cfg['DefaultQueryTable']
2220  */
2221 $cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';
2222
2223 /**
2224  * Default queries
2225  * %d will be replaced by the database name.
2226  * %t will be replaced by the table name.
2227  * %f will be replaced by a list of field names.
2228  * (%t and %f only applies to DefaultQueryTable)
2229  *
2230  * @global string $cfg['DefaultQueryDatabase']
2231  */
2232 $cfg['DefaultQueryDatabase'] = '';
2233
2234
2235 /*******************************************************************************
2236  * SQL Query box settings
2237  * These are the links display in all of the SQL Query boxes
2238  *
2239  * @global array $cfg['SQLQuery']
2240  */
2241 $cfg['SQLQuery'] = array();
2242
2243 /**
2244  * Edit link to change a query
2245  *
2246  * @global boolean $cfg['SQLQuery']['Edit']
2247  */
2248 $cfg['SQLQuery']['Edit'] = true;
2249
2250 /**
2251  * EXPLAIN on SELECT queries
2252  *
2253  * @global boolean $cfg['SQLQuery']['Explain']
2254  */
2255 $cfg['SQLQuery']['Explain'] = true;
2256
2257 /**
2258  * Wrap a query in PHP
2259  *
2260  * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2261  */
2262 $cfg['SQLQuery']['ShowAsPHP'] = true;
2263
2264 /**
2265  * Validate a query (see $cfg['SQLValidator'] as well)
2266  *
2267  * @global boolean $cfg['SQLQuery']['Validate']
2268  */
2269 $cfg['SQLQuery']['Validate'] = false;
2270
2271 /**
2272  * Refresh the results page
2273  *
2274  * @global boolean $cfg['SQLQuery']['Refresh']
2275  */
2276 $cfg['SQLQuery']['Refresh'] = true;
2277
2278
2279 /*******************************************************************************
2280  * Web server upload/save/import directories
2281  */
2282
2283 /**
2284  * Directory for uploaded files that can be executed by phpMyAdmin.
2285  * For example './upload'. Leave empty for no upload directory support.
2286  * Use %u for username inclusion.
2287  *
2288  * @global string $cfg['UploadDir']
2289  */
2290 $cfg['UploadDir'] = '';
2291
2292 /**
2293  * Directory where phpMyAdmin can save exported data on server.
2294  * For example './save'. Leave empty for no save directory support.
2295  * Use %u for username inclusion.
2296  *
2297  * @global string $cfg['SaveDir']
2298  */
2299 $cfg['SaveDir'] = '';
2300
2301 /**
2302  * Directory where phpMyAdmin can save temporary files.
2303  * This is needed for MS Excel export, see documentation how to enable that.
2304  *
2305  * @global string $cfg['TempDir']
2306  */
2307 $cfg['TempDir'] = '';
2308
2309
2310 /**
2311  * Misc. settings
2312  */
2313
2314 /**
2315  * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2316  * which is the only safe way to determine GD version.
2317  *
2318  * @global string $cfg['GD2Available']
2319  */
2320 $cfg['GD2Available'] = 'auto';
2321
2322 /**
2323  * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
2324  *
2325  * @global array $cfg['TrustedProxies']
2326  */
2327 $cfg['TrustedProxies'] = array();
2328
2329 /**
2330  * We normally check the permissions on the configuration file to ensure
2331  * it's not world writable. However, phpMyAdmin could be installed on
2332  * a NTFS filesystem mounted on a non-Windows server, in which case the
2333  * permissions seems wrong but in fact cannot be detected. In this case
2334  * a sysadmin would set the following to false.
2335  */
2336 $cfg['CheckConfigurationPermissions'] = true;
2337
2338 /*******************************************************************************
2339  * SQL Parser Settings
2340  *
2341  * @global array $cfg['SQP']
2342  */
2343 $cfg['SQP'] = array();
2344
2345 /**
2346  * Pretty-printing style to use on queries (html, text, none)
2347  *
2348  * @global string $cfg['SQP']['fmtType']
2349  */
2350 $cfg['SQP']['fmtType'] = 'html';
2351
2352 /**
2353  * Amount to indent each level (floats are valid)
2354  *
2355  * @global integer $cfg['SQP']['fmtInd']
2356  */
2357 $cfg['SQP']['fmtInd'] = '1';
2358
2359 /**
2360  * Units for indenting each level (CSS Types - {em, px, pt})
2361  *
2362  * @global string $cfg['SQP']['fmtIndUnit']
2363  */
2364 $cfg['SQP']['fmtIndUnit'] = 'em';
2365
2366
2367 /*******************************************************************************
2368  * If you wish to use the SQL Validator service, you should be aware of the
2369  * following:
2370  * All SQL statements are stored anonymously for statistical purposes.
2371  * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
2372  * All rights reserved.
2373  *
2374  * @global array $cfg['SQLValidator']
2375  */
2376 $cfg['SQLValidator'] = array();
2377
2378 /**
2379  * Make the SQL Validator available
2380  *
2381  * @global boolean $cfg['SQLValidator']['use']
2382  */
2383 $cfg['SQLValidator']['use'] = false;
2384
2385 /**
2386  * If you have a custom username, specify it here (defaults to anonymous)
2387  *
2388  * @global string $cfg['SQLValidator']['username']
2389  */
2390 $cfg['SQLValidator']['username'] = '';
2391
2392 /**
2393  * Password for username
2394  *
2395  * @global string $cfg['SQLValidator']['password']
2396  */
2397 $cfg['SQLValidator']['password'] = '';
2398
2399
2400 /*******************************************************************************
2401  * Developers ONLY!
2402  *
2403  * @global array $cfg['DBG']
2404  */
2405 $cfg['DBG'] = array();
2406
2407 /**
2408  * Output executed queries and their execution times
2409  *
2410  * @global boolean $cfg['DBG']['sql']
2411  */
2412 $cfg['DBG']['sql'] = false;
2413
2414 /**
2415  * Make the DBG stuff available
2416  * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
2417  *
2418  * @global boolean $cfg['DBG']['php']
2419  */
2420 $cfg['DBG']['php'] = false;
2421
2422 /**
2423  * Produce profiling results of PHP
2424  *
2425  * @global boolean $cfg['DBG']['profile']['enable']
2426  */
2427 $cfg['DBG']['profile']['enable'] = false;
2428
2429 /**
2430  * Threshold of long running code to display
2431  * Anything below the threshold is not displayed
2432  *
2433  * @global float $cfg['DBG']['profile']['threshold']
2434  */
2435 $cfg['DBG']['profile']['threshold'] = 0.5;
2436
2437
2438 /*******************************************************************************
2439  * MySQL settings
2440  */
2441
2442 /**
2443  * Column types;
2444  * VARCHAR, TINYINT, TEXT and DATE are listed first, based on estimated popularity
2445  *
2446  * @global array $cfg['ColumnTypes']
2447  */
2448 $cfg['ColumnTypes'] = array(
2449     // most used
2450     'INT',
2451     'VARCHAR',
2452     'TEXT',
2453     'DATE',
2454
2455     // numeric
2456     'NUMERIC' => array(
2457         'TINYINT',
2458         'SMALLINT',
2459         'MEDIUMINT',
2460         'INT',
2461         'BIGINT',
2462         '-',
2463         'DECIMAL',
2464         'FLOAT',
2465         'DOUBLE',
2466         'REAL',
2467         '-',
2468         'BIT',
2469         'BOOL',
2470         'SERIAL',
2471     ),
2472
2473
2474     // Date/Time
2475     'DATE and TIME' => array(
2476         'DATE',
2477         'DATETIME',
2478         'TIMESTAMP',
2479         'TIME',
2480         'YEAR',
2481     ),
2482
2483     // Text
2484     'STRING' => array(
2485         'CHAR',
2486         'VARCHAR',
2487         '-',
2488         'TINYTEXT',
2489         'TEXT',
2490         'MEDIUMTEXT',
2491         'LONGTEXT',
2492         '-',
2493         'BINARY',
2494         'VARBINARY',
2495         '-',
2496         'TINYBLOB',
2497         'MEDIUMBLOB',
2498         'BLOB',
2499         'LONGBLOB',
2500         '-',
2501         'ENUM',
2502         'SET',
2503     ),
2504
2505     'SPATIAL' => array(
2506         'GEOMETRY',
2507         'POINT',
2508         'LINESTRING',
2509         'POLYGON',
2510         'MULTIPOINT',
2511         'MULTILINESTRING',
2512         'MULTIPOLYGON',
2513         'GEOMETRYCOLLECTION',
2514     ),
2515 );
2516
2517 /**
2518  * Attributes
2519  *
2520  * @global array $cfg['AttributeTypes']
2521  */
2522 $cfg['AttributeTypes'] = array(
2523    '',
2524    'BINARY',
2525    'UNSIGNED',
2526    'UNSIGNED ZEROFILL',
2527    'on update CURRENT_TIMESTAMP',
2528 );
2529
2530
2531 if ($cfg['ShowFunctionFields']) {
2532     /**
2533      * Available functions
2534      *
2535      * @global array $cfg['Functions']
2536      */
2537     $cfg['Functions'] = array(
2538         'ABS',
2539         'ACOS',
2540         'ASCII',
2541         'ASIN',
2542         'ATAN',
2543         'BIN',
2544         'BIT_COUNT',
2545         'BIT_LENGTH',
2546         'CEILING',
2547         'CHAR',
2548         'CHAR_LENGTH',
2549         'COMPRESS',
2550         'COS',
2551         'COT',
2552         'CRC32',
2553         'CURDATE',
2554         'CURRENT_USER',
2555         'CURTIME',
2556         'DATE',
2557         'DAYNAME',
2558         'DEGREES',
2559         'DES_DECRYPT',
2560         'DES_ENCRYPT',
2561         'ENCRYPT',
2562         'EXP',
2563         'FLOOR',
2564         'FROM_DAYS',
2565         'FROM_UNIXTIME',
2566         'HEX',
2567         'INET_ATON',
2568         'INET_NTOA',
2569         'LENGTH',
2570         'LN',
2571         'LOG',
2572         'LOG10',
2573         'LOG2',
2574         'LOWER',
2575         'MD5',
2576         'NOW',
2577         'OCT',
2578         'OLD_PASSWORD',
2579         'ORD',
2580         'PASSWORD',
2581         'RADIANS',
2582         'RAND',
2583         'REVERSE',
2584         'ROUND',
2585         'SEC_TO_TIME',
2586         'SHA1',
2587         'SOUNDEX',
2588         'SPACE',
2589         'SQRT',
2590         'STDDEV_POP',
2591         'STDDEV_SAMP',
2592         'TAN',
2593         'TIMESTAMP',
2594         'TIME_TO_SEC',
2595         'UNCOMPRESS',
2596         'UNHEX',
2597         'UNIX_TIMESTAMP',
2598         'UPPER',
2599         'USER',
2600         'UTC_DATE',
2601         'UTC_TIME',
2602         'UTC_TIMESTAMP',
2603         'UUID',
2604         'VAR_POP',
2605         'VAR_SAMP',
2606         'YEAR',
2607     );
2608
2609     /**
2610      * Which column types will be mapped to which Group?
2611      *
2612      * @global array $cfg['RestrictColumnTypes']
2613      */
2614     $cfg['RestrictColumnTypes'] = array(
2615         'TINYINT'   => 'FUNC_NUMBER',
2616         'SMALLINT'  => 'FUNC_NUMBER',
2617         'MEDIUMINT' => 'FUNC_NUMBER',
2618         'INT'       => 'FUNC_NUMBER',
2619         'BIGINT'    => 'FUNC_NUMBER',
2620         'DECIMAL'   => 'FUNC_NUMBER',
2621         'FLOAT'     => 'FUNC_NUMBER',
2622         'DOUBLE'    => 'FUNC_NUMBER',
2623         'REAL'      => 'FUNC_NUMBER',
2624         'BIT'       => 'FUNC_NUMBER',
2625         'BOOL'      => 'FUNC_NUMBER',
2626         'SERIAL'    => 'FUNC_NUMBER',
2627
2628         'DATE'      => 'FUNC_DATE',
2629         'DATETIME'  => 'FUNC_DATE',
2630         'TIMESTAMP' => 'FUNC_DATE',
2631         'TIME'      => 'FUNC_DATE',
2632         'YEAR'      => 'FUNC_DATE',
2633
2634         'CHAR'          => 'FUNC_CHAR',
2635         'VARCHAR'       => 'FUNC_CHAR',
2636         'TINYTEXT'      => 'FUNC_CHAR',
2637         'TEXT'          => 'FUNC_CHAR',
2638         'MEDIUMTEXT'    => 'FUNC_CHAR',
2639         'LONGTEXT'      => 'FUNC_CHAR',
2640         'BINARY'        => 'FUNC_CHAR',
2641         'VARBINARY'     => 'FUNC_CHAR',
2642         'TINYBLOB'      => 'FUNC_CHAR',
2643         'MEDIUMBLOB'    => 'FUNC_CHAR',
2644         'BLOB'          => 'FUNC_CHAR',
2645         'LONGBLOB'      => 'FUNC_CHAR',
2646         'ENUM'          => '',
2647         'SET'           => '',
2648
2649         'GEOMETRY'              => 'FUNC_SPATIAL',
2650         'POINT'                 => 'FUNC_SPATIAL',
2651         'LINESTRING'            => 'FUNC_SPATIAL',
2652         'POLYGON'               => 'FUNC_SPATIAL',
2653         'MULTIPOINT'            => 'FUNC_SPATIAL',
2654         'MULTILINESTRING'       => 'FUNC_SPATIAL',
2655         'MULTIPOLYGON'          => 'FUNC_SPATIAL',
2656         'GEOMETRYCOLLECTION'    => 'FUNC_SPATIAL',
2657
2658     );
2659
2660     /**
2661      * Map above defined groups to any function
2662      *
2663      * @global array $cfg['RestrictFunctions']
2664      */
2665     $cfg['RestrictFunctions'] = array(
2666         'FUNC_CHAR' => array(
2667             'BIN',
2668             'CHAR',
2669             'CURRENT_USER',
2670             'COMPRESS',
2671             'DAYNAME',
2672             'DES_DECRYPT',
2673             'DES_ENCRYPT',
2674             'ENCRYPT',
2675             'HEX',
2676             'INET_NTOA',
2677             'LOWER',
2678             'MD5',
2679             'OLD_PASSWORD',
2680             'PASSWORD',
2681             'REVERSE',
2682             'SHA1',
2683             'SOUNDEX',
2684             'SPACE',
2685             'UNCOMPRESS',
2686             'UNHEX',
2687             'UPPER',
2688             'USER',
2689             'UUID',
2690         ),
2691
2692         'FUNC_DATE' => array(
2693             'CURDATE',
2694             'CURTIME',
2695             'DATE',
2696             'FROM_DAYS',
2697             'FROM_UNIXTIME',
2698             'NOW',
2699             'SEC_TO_TIME',
2700             'TIMESTAMP',
2701             'UTC_DATE',
2702             'UTC_TIME',
2703             'UTC_TIMESTAMP',
2704             'YEAR',
2705         ),
2706
2707         'FUNC_NUMBER' => array(
2708             'ABS',
2709             'ACOS',
2710             'ASCII',
2711             'ASIN',
2712             'ATAN',
2713             'BIT_LENGTH',
2714             'BIT_COUNT',
2715             'CEILING',
2716             'CHAR_LENGTH',
2717             'COS',
2718             'COT',
2719             'CRC32',
2720             'DEGREES',
2721             'EXP',
2722             'FLOOR',
2723             'INET_ATON',
2724             'LENGTH',
2725             'LN',
2726             'LOG',
2727             'LOG2',
2728             'LOG10',
2729             'OCT',
2730             'ORD',
2731             'RADIANS',
2732             'RAND',
2733             'ROUND',
2734             'SQRT',
2735             'STDDEV_POP',
2736             'STDDEV_SAMP',
2737             'TAN',
2738             'TIME_TO_SEC',
2739             'UNIX_TIMESTAMP',
2740             'VAR_POP',
2741             'VAR_SAMP',
2742         ),
2743
2744         'FUNC_SPATIAL' => array(
2745             'GeomFromText',
2746             'GeomFromWKB',
2747
2748             'GeomCollFromText',
2749             'LineFromText',
2750             'MLineFromText',
2751             'PointFromText',
2752             'MPointFromText',
2753             'PolyFromText',
2754             'MPolyFromText',
2755
2756             'GeomCollFromWKB',
2757             'LineFromWKB',
2758             'MLineFromWKB',
2759             'PointFromWKB',
2760             'MPointFromWKB',
2761             'PolyFromWKB',
2762             'MPolyFromWKB',
2763         ),
2764     );
2765
2766     /**
2767      * Default functions for above defined groups
2768      *
2769      * @global array $cfg['DefaultFunctions']
2770      */
2771     $cfg['DefaultFunctions'] = array(
2772         'FUNC_CHAR' => '',
2773         'FUNC_DATE' => '',
2774         'FUNC_NUMBER' => '',
2775         'first_timestamp' => 'NOW',
2776         'pk_char36' => 'UUID',
2777     );
2778
2779
2780 } // end if
2781
2782 /**
2783  * Search operators
2784  *
2785  * @global array $cfg['NumOperators']
2786  */
2787 $cfg['NumOperators'] = array(
2788    '=',
2789    '>',
2790    '>=',
2791    '<',
2792    '<=',
2793    '!=',
2794    'LIKE',
2795    'NOT LIKE',
2796 );
2797
2798 /**
2799  * Search operators
2800  *
2801  * @global array $cfg['TextOperators']
2802  */
2803 $cfg['TextOperators'] = array(
2804    'LIKE',
2805    'LIKE %...%',
2806    'NOT LIKE',
2807    '=',
2808    '!=',
2809    'REGEXP',
2810    'NOT REGEXP',
2811    "= ''",
2812    "!= ''"
2813 );
2814
2815 /**
2816  * Search operators
2817  *
2818  * @global array $cfg['EnumOperators']
2819  */
2820 $cfg['EnumOperators'] = array(
2821    '=',
2822    '!=',
2823 );
2824
2825 /**
2826  * Search operators
2827  *
2828  * @global array $cfg['SetOperators']
2829  */
2830 $cfg['SetOperators'] = array(
2831    'IN',
2832    'NOT IN',
2833 );
2834
2835 /**
2836  * Search operators
2837  *
2838  * @global array $cfg['NullOperators']
2839  */
2840 $cfg['NullOperators'] = array(
2841    'IS NULL',
2842    'IS NOT NULL',
2843 );
2844
2845 /**
2846  * Search operators
2847  *
2848  * @global array $cfg['UnaryOperators']
2849  */
2850 $cfg['UnaryOperators'] = array(
2851    'IS NULL' => 1,
2852    'IS NOT NULL' => 1,
2853    "= ''" => 1,
2854    "!= ''" => 1
2855 );
2856
2857 ?>