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