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