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