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