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