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