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