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