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