libraries/config.default.php

   1 <?php
   2
   3 /* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */
   4
   5 /* $Id$ */
   6 // vim: expandtab sw=4 ts=4 sts=4:
   7
   8 /**
   9  * phpMyAdmin default configuration, you can copy values from here to your
  10  * config.inc.php
  11  *
  12  * All directives are explained in Documentation.html
  13  */
  14
  15
  16 /**
  17  * Your phpMyAdmin URL.
  18  *
  19  * Complete the variable below with the full url ie
  20  *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
  21  *
  22  * It must contain characters that are valid for a URL, and the path is
  23  * case sensitive on some Web servers, for example Unix-based servers.
  24  *
  25  * In most cases you can leave this variable empty, as the correct value
  26  * will be detected automatically. However, we recommend that you do
  27  * test to see that the auto-detection code works in your system. A good
  28  * test is to browse a table, then edit a row and save it.  There will be
  29  * an error message if phpMyAdmin cannot auto-detect the correct value.
  30  */
  31 $cfg['PmaAbsoluteUri'] = '';
  32
  33 /**
  34  * Disable the default warning that is displayed on the DB Details Structure page if
  35  * any of the required Tables for the relationfeatures could not be found
  36  */
  37 $cfg['PmaNoRelation_DisableWarning']  = FALSE;
  38
  39 /**
  40  * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
  41  * at least one server configuration uses 'cookie' auth_type, enter here a
  42  * passphrase that will be used by blowfish. The maximum length seems to be 46
  43  * characters.
  44  */
  45 $cfg['blowfish_secret'] = '';
  46
  47 /**
  48  * Server(s) configuration
  49  */
  50 $i = 0;
  51 // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
  52 // $cfg['Servers'][0]. You can disable a server config entry by setting host
  53 // to ''. If you want more than one server, just copy following section
  54 // (including $i incrementation) serveral times. There is no need to define
  55 // full server array, just define values you need to change.
  56 $i++;
  57 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
  58 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
  59 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  60 $cfg['Servers'][$i]['ssl']           = true;        // Use SSL for connecting to MySQL server?
  61 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  62 $cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
  63 $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
  64                                                     // (requires PHP >= 4.3.0)
  65 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
  66                                                     // (this user must have read-only
  67 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
  68                                                     // and "mysql/db" tables).
  69                                                     // The controluser is also
  70                                                     // used for all relational
  71                                                     // features (pmadb)
  72 $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http, signon or cookie based)?
  73 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
  74 $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
  75                                                     // with 'config' auth_type)
  76 $cfg['Servers'][$i]['SignonSession'] = '';          // Session to use for 'signon' auth method
  77 $cfg['Servers'][$i]['SignonURL']     = '';          // URL where to redirect user to login for 'signon' auth method
  78 $cfg['Servers'][$i]['LogoutURL']     = '';          // URL where to redirect user after logout
  79 $cfg['Servers'][$i]['nopassword']    = FALSE;       // Whether to try to connect without password
  80 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
  81                                                     // this db is displayed in left frame
  82                                                     // It may also be an array of db-names, where sorting order is relevant.
  83 $cfg['Servers'][$i]['hide_db']       = '';          // Database name to be hidden from listings
  84 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
  85
  86 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
  87                                                     // (see scripts/create_tables.sql)
  88                                                     //   - leave blank for no support
  89                                                     //     DEFAULT: 'phpmyadmin'
  90 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
  91                                                     //   - leave blank for no bookmark support
  92                                                     //     DEFAULT: 'pma_bookmark'
  93 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
  94                                                     //   - leave blank for no relation-links support
  95                                                     //     DEFAULT: 'pma_relation'
  96 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
  97                                                     //   - leave blank for no display fields support
  98                                                     //     DEFAULT: 'pma_table_info'
  99 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
 100                                                     //   - leave blank for no PDF schema support
 101                                                     //     DEFAULT: 'pma_table_coords'
 102 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
 103                                                     //   - leave blank if you don't want to use this
 104                                                     //     DEFAULT: 'pma_pdf_pages'
 105 $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
 106                                                     //   - leave blank for no column comments/mime types
 107                                                     //     DEFAULT: 'pma_column_info'
 108 $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
 109                                                     //   - leave blank for no SQL query history
 110                                                     //     DEFAULT: 'pma_history'
 111 $cfg['Servers'][$i]['designer_coords'] = '';        // table to store the coordinates for Designer
 112                                                     //   - leave blank for no Designer feature
 113                                                     //     DEFAULT: 'pma_designer_coords'
 114 $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
 115                                                     // are up to date. This prevents compatibility
 116                                                     // checks and thereby increases performance.
 117 $cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
 118 $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
 119                                      = '';
 120 $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
 121                                      = array();
 122
 123 // If you have more than one server configured, you can set $cfg['ServerDefault']
 124 // to any one of them to autoconnect to that server when phpMyAdmin is started,
 125 // or set it to 0 to be given a list of servers without logging in
 126 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
 127 // set to that server.
 128 $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
 129
 130 /**
 131  * Other core phpMyAdmin settings
 132  */
 133 $cfg['MaxDbList']               = 100;    // maximum number of db's displayed in left frame and databaes list
 134 $cfg['OBGzip']                  = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
 135 $cfg['PersistentConnections']   = FALSE;  // use persistent connections to MySQL database
 136 $cfg['ForceSSL']                = FALSE;  // whether to force using https
 137 $cfg['ExecTimeLimit']           = 300;    // maximum execution time in seconds (0 for no limit)
 138 $cfg['MemoryLimit']             = 0;      // maximum allocated bytes (0 for no limit)
 139 $cfg['SkipLockedTables']        = FALSE;  // mark used tables, make possible to show
 140                                           // locked tables (since MySQL 3.23.30)
 141 $cfg['ShowSQL']                 = TRUE;   // show SQL queries as run
 142 $cfg['AllowUserDropDatabase']   = FALSE;  // show a 'Drop database' link to normal users
 143 $cfg['Confirm']                 = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
 144 $cfg['LoginCookieRecall']       = TRUE;   // recall previous login in cookie auth. mode or not
 145 $cfg['LoginCookieValidity']     = 1800;   // validity of cookie login (in seconds)
 146 $cfg['LoginCookieStore']        = 0;      // how long login cookie should be stored (in seconds)
 147 $cfg['LoginCookieDeleteAll']    = TRUE;   // whether to delete all login cookies on logout
 148 $cfg['UseDbSearch']             = TRUE;   // whether to enable the "database search" feature
 149                                           // or not
 150 $cfg['IgnoreMultiSubmitErrors'] = FALSE;  // if set to true, PMA continues computing multiple-statement queries
 151                                           // even if one of the queries failed
 152 $cfg['VerboseMultiSubmit']      = TRUE;   // if set to true, PMA will show the affected rows of EACH statement on
 153                                           // multiple-statement queries. See the libraries/import.php file for
 154                                           // hardcoded defaults on how many queries a statement may contain!
 155 $cfg['AllowArbitraryServer']    = FALSE;  // allow login to any user entered server in cookie based auth
 156
 157 // Left frame setup
 158 $cfg['LeftFrameLight']        = TRUE;    // use a select-based menu and display only the
 159                                          // current tables in the left frame.
 160 $cfg['LeftFrameDBTree']       = TRUE;    // turn the select-based light menu into a tree
 161 $cfg['LeftFrameDBSeparator']  = '_';     // the separator to sub-tree the select-based light menu tree
 162 $cfg['LeftFrameTableSeparator']= '__';   // Which string will be used to generate table prefixes
 163                                          // to split/nest tables into multiple categories
 164 $cfg['LeftFrameTableLevel']   = '1';     // How many sublevels should be displayed when splitting
 165                                          // up tables by the above Separator
 166 $cfg['ShowTooltip']           = TRUE;    // display table comment as tooltip in left frame
 167 $cfg['ShowTooltipAliasDB']    = FALSE;   // if ShowToolTip is enabled, this defines that table/db comments
 168 $cfg['ShowTooltipAliasTB']    = FALSE;   // are shown (in the left menu and db_structure) instead of
 169                                          // table/db names. Setting ShowTooltipAliasTB to 'nested' will only
 170                                          // use the Aliases for nested descriptors, not the table itself.
 171
 172 $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
 173 $cfg['LeftLogoLink']          = 'http://www.phpmyadmin.net/';   // where should logo link point to
 174 $cfg['LeftDisplayServers']    = FALSE;  // display server choice at top of left frame
 175 $cfg['DisplayServersList']    = FALSE;  // server choice as links
 176 $cfg['DisplayDatabasesList']  = FALSE;  // database choice in light as links
 177
 178 // In the main frame, at startup...
 179 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
 180                                         // the pages about database details and table
 181                                         // properties
 182 $cfg['ShowPhpInfo']           = FALSE;  // show php info link
 183 $cfg['ShowServerInfo']        = TRUE;   // show MySQL server information
 184 $cfg['ShowChgPassword']       = FALSE;  // show change password link
 185 $cfg['ShowCreateDb']          = TRUE;   // show create database form
 186 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
 187
 188 // In browse mode...
 189 $cfg['ShowBlob']              = FALSE;  // display blob field contents
 190 $cfg['NavigationBarIconic']   = 'both'; // Use icons instead of text for the navigation bar buttons
 191                                         // and on right panel top menu (server db table) (TRUE|FALSE|'both')
 192 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
 193 $cfg['MaxRows']               = 30;     // maximum number of rows to display
 194 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
 195                                         // values are 'ASC', 'DESC' or 'SMART' -ie
 196                                         // descending order for fields of type
 197                                         // TIME, DATE, DATETIME & TIMESTAMP,
 198                                         // ascending order else-)
 199
 200 // In edit mode...
 201 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
 202                                         // valid values are:
 203                                         //   FALSE  allow editing
 204                                         //   'blob' allow editing except for BLOB fields
 205                                         //   'all'  disallow editing
 206 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
 207 $cfg['CharEditing']           = 'input';
 208                                         // Which editor should be used for CHAR/VARCHAR fields:
 209                                         //  input - allows limiting of input length
 210                                         //  textarea - allows newlines in fields
 211 $cfg['InsertRows']            = 2;      // How many rows can be inserted at one time
 212
 213 $cfg['ForeignKeyDropdownOrder'] =       // Sort order for items in a foreign-key dropdown box.
 214     array( 'content-id', 'id-content'); // 'content' is the referenced data, 'id' is the key value.
 215 $cfg['ForeignKeyMaxLimit'] = 100;       // A dropdown will be used if fewer items are present
 216
 217
 218 // For the export features...
 219 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
 220 $cfg['GZipDump']              = TRUE;   // compression for
 221 $cfg['BZipDump']              = TRUE;   // dump files
 222 $cfg['CompressOnFly']         = TRUE;   // Will compress gzip/bzip2 exports on
 223                                         // fly without need for much memory.
 224                                         // If you encounter problems with
 225                                         // created gzip/bzip2 files disable
 226                                         // this feature.
 227
 228 // Tabs display settings
 229 $cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs
 230 $cfg['PropertiesIconic']      = TRUE;   // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')
 231 $cfg['PropertiesNumColumns']  = 1;      // How many columns should be used for table display of a database?
 232                                         // (a value larger than 1 results in some information being hidden)
 233
 234 $cfg['DefaultTabServer']      = 'main.php';
 235                                    // Possible values:
 236                                    // 'main.php' = the welcome page
 237                                    // (recommended for multiuser setups)
 238                                    // 'server_databases.php' = list of databases
 239                                    // 'server_status.php' = runtime information
 240                                    // 'server_variables.php' = MySQL server variables
 241                                    // 'server_privileges.php' = user management
 242                                    // 'server_processlist.php' = process list
 243 $cfg['DefaultTabDatabase']    = 'db_structure.php';
 244                                    // Possible values:
 245                                    // 'db_structure.php' = tables list
 246                                    // 'db_sql.php' = sql form
 247                                    // 'db_search.php' = search query
 248                                    // 'db_operations.php' = operations on database
 249 $cfg['DefaultTabTable']       = 'tbl_structure.php';
 250                                    // Possible values:
 251                                    // 'tbl_structure.php' = fields list
 252                                    // 'tbl_sql.php' = sql form
 253                                    // 'tbl_select.php' = select page
 254                                    // 'tbl_change.php' = insert row page
 255                                    // 'sql.php' = browse page
 256
 257 /**
 258  * Export defaults
 259  */
 260
 261 $cfg['Export']['format']                    = 'sql';  // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt
 262 $cfg['Export']['compression']               = 'none'; // none/zip/gzip/bzip2
 263
 264 $cfg['Export']['asfile']                    = FALSE;
 265 $cfg['Export']['charset']                   = '';
 266 $cfg['Export']['onserver']                  = FALSE;
 267 $cfg['Export']['onserver_overwrite']        = FALSE;
 268 $cfg['Export']['remember_file_template']    = TRUE;
 269 $cfg['Export']['file_template_table']       = '__TABLE__';
 270 $cfg['Export']['file_template_database']    = '__DB__';
 271 $cfg['Export']['file_template_server']      = '__SERVER__';
 272
 273 $cfg['Export']['ods_columns']               = FALSE;
 274 $cfg['Export']['ods_null']                  = 'NULL';
 275
 276 $cfg['Export']['odt_structure']             = TRUE;
 277 $cfg['Export']['odt_data']                  = TRUE;
 278 $cfg['Export']['odt_columns']               = TRUE;
 279 $cfg['Export']['odt_relation']              = TRUE;
 280 $cfg['Export']['odt_comments']              = TRUE;
 281 $cfg['Export']['odt_mime']                  = TRUE;
 282 $cfg['Export']['odt_null']                  = 'NULL';
 283
 284 $cfg['Export']['htmlexcel_columns']         = FALSE;
 285 $cfg['Export']['htmlexcel_null']            = 'NULL';
 286
 287 $cfg['Export']['htmlword_structure']        = TRUE;
 288 $cfg['Export']['htmlword_data']             = TRUE;
 289 $cfg['Export']['htmlword_columns']          = FALSE;
 290 $cfg['Export']['htmlword_null']             = 'NULL';
 291
 292 $cfg['Export']['xls_columns']               = FALSE;
 293 $cfg['Export']['xls_null']                  = 'NULL';
 294
 295 $cfg['Export']['csv_columns']               = FALSE;
 296 $cfg['Export']['csv_null']                  = 'NULL';
 297 $cfg['Export']['csv_separator']             = ';';
 298 $cfg['Export']['csv_enclosed']              = '"';
 299 $cfg['Export']['csv_escaped']               = '\\';
 300 $cfg['Export']['csv_terminated']            = 'AUTO';
 301 $cfg['Export']['excel_columns']             = FALSE;
 302 $cfg['Export']['excel_null']                = 'NULL';
 303 $cfg['Export']['excel_edition']             = 'win'; // win/mac
 304
 305 $cfg['Export']['latex_structure']           = TRUE;
 306 $cfg['Export']['latex_data']                = TRUE;
 307 $cfg['Export']['latex_columns']             = TRUE;
 308 $cfg['Export']['latex_relation']            = TRUE;
 309 $cfg['Export']['latex_comments']            = TRUE;
 310 $cfg['Export']['latex_mime']                = TRUE;
 311 $cfg['Export']['latex_null']                = '\textit{NULL}';
 312 $cfg['Export']['latex_caption']             = TRUE;
 313 $cfg['Export']['latex_structure_caption']   = 'strLatexStructure';
 314 $cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';
 315 $cfg['Export']['latex_data_caption']        = 'strLatexContent';
 316 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
 317 $cfg['Export']['latex_data_label']          = 'tab:__TABLE__-data';
 318 $cfg['Export']['latex_structure_label']     = 'tab:__TABLE__-structure';
 319
 320 $cfg['Export']['sql_structure']             = TRUE;
 321 $cfg['Export']['sql_data']                  = TRUE;
 322 $cfg['Export']['sql_compatibility']         = 'NONE';
 323 $cfg['Export']['sql_disable_fk']            = FALSE;
 324 $cfg['Export']['sql_use_transaction']       = FALSE;
 325 $cfg['Export']['sql_drop_database']         = FALSE;
 326 $cfg['Export']['sql_drop_table']            = FALSE;
 327 $cfg['Export']['sql_if_not_exists']         = FALSE;
 328 $cfg['Export']['sql_auto_increment']        = TRUE;
 329 $cfg['Export']['sql_backquotes']            = TRUE;
 330 $cfg['Export']['sql_dates']                 = FALSE;
 331 $cfg['Export']['sql_relation']              = FALSE;
 332 $cfg['Export']['sql_columns']               = TRUE;
 333 $cfg['Export']['sql_delayed']               = FALSE;
 334 $cfg['Export']['sql_ignore']                = FALSE;
 335 $cfg['Export']['sql_hex_for_binary']        = TRUE;
 336 $cfg['Export']['sql_type']                  = 'insert'; // insert/update/replace
 337 $cfg['Export']['sql_extended']              = TRUE;
 338 $cfg['Export']['sql_max_query_size']        = 50000;
 339 $cfg['Export']['sql_comments']              = FALSE;
 340 $cfg['Export']['sql_mime']                  = FALSE;
 341 $cfg['Export']['sql_header_comment']        = ''; // \n is replaced by new line
 342
 343 $cfg['Export']['pdf_structure']             = FALSE;
 344 $cfg['Export']['pdf_data']                  = TRUE;
 345 $cfg['Export']['pdf_report_title']          = '';
 346
 347 /**
 348  * Import defaults
 349  */
 350 $cfg['Import']['format'] = 'sql';
 351 $cfg['Import']['allow_interrupt'] = TRUE;
 352 $cfg['Import']['skip_queries'] = '0';
 353 $cfg['Import']['sql_compatibility'] = 'NONE';
 354 $cfg['Import']['csv_replace'] = FALSE;
 355 $cfg['Import']['csv_terminated'] = ';';
 356 $cfg['Import']['csv_enclosed'] = '"';
 357 $cfg['Import']['csv_escaped'] = '\\';
 358 $cfg['Import']['csv_new_line'] = 'auto';
 359 $cfg['Import']['csv_columns'] = '';
 360 $cfg['Import']['ldi_replace'] = FALSE;
 361 $cfg['Import']['ldi_terminated'] = ';';
 362 $cfg['Import']['ldi_enclosed'] = '"';
 363 $cfg['Import']['ldi_escaped'] = '\\';
 364 $cfg['Import']['ldi_new_line'] = 'auto';
 365 $cfg['Import']['ldi_columns'] = '';
 366 $cfg['Import']['ldi_local_option'] = 'auto'; // 'auto' for autodetection, TRUE or FALSE for forcing
 367
 368
 369 /**
 370  * Link to the official MySQL documentation.
 371  * Be sure to include no trailing slash on the path.
 372  * See http://dev.mysql.com/doc/ for more information
 373  * about MySQL manuals and their types.
 374  */
 375 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
 376
 377 /**
 378  * Type of MySQL documentation:
 379  *   viewable   - "viewable online", current one used on MySQL website
 380  *   searchable - "Searchable, with user comments"
 381  *   chapters   - "HTML, one page per chapter"
 382  *   chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release
 383  *   big        - "HTML, all on one page"
 384  *   old        - old style used in phpMyAdmin 2.3.0 and sooner
 385  *   none       - do not show documentation links
 386  */
 387 $cfg['MySQLManualType'] = 'viewable';
 388
 389
 390 /**
 391  * PDF options
 392  */
 393 $cfg['PDFPageSizes']        = array('A3', 'A4', 'A5', 'letter', 'legal');
 394 $cfg['PDFDefaultPageSize']  = 'A4';
 395
 396
 397 /**
 398  * Language and charset conversion settings
 399  */
 400 // Default language to use, if not browser-defined or user-defined
 401 $cfg['DefaultLang'] = 'en-iso-8859-1';
 402
 403 // Default connection collation (used for MySQL >= 4.1)
 404 $cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';
 405
 406 // Force: always use this language - must be defined in
 407 //        libraries/select_lang.lib.php
 408 // $cfg['Lang']     = 'en-iso-8859-1';
 409
 410 // Regullar expression to limit listed languages, eg. '^(cs|en)' for Czech and
 411 // English only
 412 $cfg['FilterLanguages'] = '';
 413
 414 // Default charset to use for recoding of MySQL queries, does not take
 415 // any effect when charsets recoding is switched off by
 416 // $cfg['AllowAnywhereRecoding'] or in language file
 417 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
 418 $cfg['DefaultCharset'] = 'iso-8859-1';
 419
 420 // Allow charset recoding of MySQL queries, must be also enabled in language
 421 // file to make harder using other language files than unicode.
 422 // Default value is FALSE to avoid problems on servers without the iconv
 423 // extension and where dl() is not supported
 424 $cfg['AllowAnywhereRecoding'] = FALSE;
 425
 426 // You can select here which functions will be used for charset conversion.
 427 // Possible values are:
 428 //      auto   - automatically use available one (first is tested iconv, then
 429 //               recode)
 430 //      iconv  - use iconv or libiconv functions
 431 //      recode - use recode_string function
 432 $cfg['RecodingEngine'] = 'auto';
 433
 434 // Specify some parameters for iconv used in charset conversion. See iconv
 435 // documentation for details:
 436 // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
 437 $cfg['IconvExtraParams'] = '//TRANSLIT';
 438
 439 // Available charsets for MySQL conversion. currently contains all which could
 440 // be found in lang/* files and few more.
 441 // Charsets will be shown in same order as here listed, so if you frequently
 442 // use some of these move them to the top.
 443 $cfg['AvailableCharsets'] = array(
 444     'iso-8859-1',
 445     'iso-8859-2',
 446     'iso-8859-3',
 447     'iso-8859-4',
 448     'iso-8859-5',
 449     'iso-8859-6',
 450     'iso-8859-7',
 451     'iso-8859-8',
 452     'iso-8859-9',
 453     'iso-8859-10',
 454     'iso-8859-11',
 455     'iso-8859-12',
 456     'iso-8859-13',
 457     'iso-8859-14',
 458     'iso-8859-15',
 459     'windows-1250',
 460     'windows-1251',
 461     'windows-1252',
 462     'windows-1256',
 463     'windows-1257',
 464     'koi8-r',
 465     'big5',
 466     'gb2312',
 467     'utf-16',
 468     'utf-8',
 469     'utf-7',
 470     'x-user-defined',
 471     'euc-jp',
 472     'ks_c_5601-1987',
 473     'tis-620',
 474     'SHIFT_JIS'
 475 );
 476
 477 /**
 478  * Customization & design
 479  *
 480  * The graphical settings are now located in themes/themename/layout.inc.php
 481  */
 482
 483 $cfg['LeftPointerEnable']   = TRUE;         // enable the left panel pointer
 484                                             // (used when LeftFrameLight is FALSE)
 485                                             // see also LeftPointerColor
 486                                             // in layout.inc.php
 487
 488 $cfg['BrowsePointerEnable'] = TRUE;        // enable the browse pointer
 489                                             // see also BrowsePointerColor
 490                                             // in layout.inc.php
 491
 492 $cfg['BrowseMarkerEnable'] = TRUE;         // enable the browse marker
 493                                             // see also BrowseMarkerColor
 494                                             // in layout.inc.php
 495
 496 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
 497                                             // (this value will be emphasized (*2) for sql
 498                                             // query textareas and (*1.25) for query window)
 499 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
 500 $cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
 501 $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
 502 $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
 503 $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
 504 $cfg['CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?
 505 $cfg['LimitChars']          = 50;           // Max field data length in browse mode for all non-numeric fields
 506 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
 507                                             // (or at the top with vertical browse)
 508 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
 509                                             // (or at the bottom with vertical browse)
 510 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction
 511                                             // (horizontal|vertical|horizontalflipped)
 512 $cfg['DefaultPropDisplay']  = 3;            // default display direction for altering/
 513                                             // creating columns (tbl_properties)
 514                                             // (horizontal|vertical|<number>)
 515                                             // number indicates maximal number for which vertical model is used
 516
 517 $cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
 518                                             // NOTE: CSS only works in IE browsers!
 519 $cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
 520 $cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
 521 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
 522
 523 $cfg['EditInWindow']        = TRUE;         // Set to TRUE if Edit link should open the query to edit in the query window (assuming Javascript is enabled), and to FALSE if we should edit in the right panel
 524 $cfg['QueryWindowWidth']    = 550;          // Width of Query window
 525 $cfg['QueryWindowHeight']   = 310;          // Height of Query window
 526 $cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.
 527                                             // If FALSE, this utilizes JS-routines to display
 528                                             // query history (lost by window close)
 529 $cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
 530                                             // (sql|files|history|full)
 531 $cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
 532                                             // should be kept?
 533 $cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
 534 $cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for
 535                                             // table rows.
 536 $cfg['WYSIWYG-PDF']         = TRUE;         // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
 537                                             // the PDF page editor. Requires an IE6/Mozilla based browser.
 538
 539 $cfg['NaturalOrder']        = TRUE;         // Sort table and database in natural order
 540
 541
 542 //-----------------------------------------------------------------------------
 543 // custom-setup by mkkeck: 2004-05-04
 544 //    some specials for new icons and scrollings
 545 /**
 546  * @todo 2004-05-08 rabus: We need to rearrange these variables.
 547  */
 548
 549 // Window title settings
 550 $cfg['TitleTable']          = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
 551 $cfg['TitleDatabase']       = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
 552 $cfg['TitleServer']         = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
 553 $cfg['TitleDefault']        = '@HTTP_HOST@ | @PHPMYADMIN@';
 554
 555 $cfg['ErrorIconic']          = TRUE;    // show some icons for warning, error and information messages (true|false)?
 556 $cfg['MainPageIconic']       = TRUE;    // show icons in list on main page and on menu tabs (true|false)?
 557 $cfg['ReplaceHelpImg']       = TRUE;    // show help button instead of strDocu (true|false)?
 558
 559 // theme manager
 560 $cfg['ThemePath']           = './themes';    // using themes manager please set up here the path to 'themes'
 561                                              // else leave empty
 562 $cfg['ThemeManager']        = TRUE;          // if you want to use selectable themes and if ThemesPath not empty
 563                                              // set it to true, else set it to false (default is false);
 564 $cfg['ThemeDefault']        = 'original';         // set up default theme, if ThemePath not empty
 565                                              // you can set up here an valid path to themes or 'original' for
 566                                              // the original pma-theme
 567 $cfg['ThemePerServer']      = FALSE;         // allow different theme for each configured server
 568
 569 //-----------------------------------------------------------------------------
 570
 571
 572 /**
 573  * Default queries
 574  * %d will be replaced by the database name.
 575  * %t will be replaced by the table name.
 576  * %f will be replaced by a list of field names.
 577  * (%t and %f only applies to DefaultQueryTable)
 578  */
 579 $cfg['DefaultQueryTable']    = 'SELECT * FROM %t WHERE 1';
 580 $cfg['DefaultQueryDatabase'] = '';
 581
 582 /**
 583  * SQL Query box settings
 584  * These are the links display in all of the SQL Query boxes
 585  */
 586 $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
 587 $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
 588 $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
 589 $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
 590 $cfg['SQLQuery']['Refresh']   = TRUE;       // Refresh the results page
 591
 592
 593 /**
 594  * Webserver upload/save/import directories
 595  */
 596 $cfg['UploadDir']             = '';         // Directory for uploaded files that can be executed by
 597                                             // phpMyAdmin. For example './upload'. Leave empty for
 598                                             // no upload directory support. Use %u for username
 599                                             // inclusion.
 600 $cfg['SaveDir']               = '';         // Directory where phpMyAdmin can save exported data on
 601                                             // server. For example './save'. Leave empty for no save
 602                                             // directory support. Use %u for username inclusion.
 603 $cfg['TempDir']               = '';         // Directory where phpMyAdmin can save temporary files.
 604                                             // This is needed for MS Excel export, see documentation
 605                                             // how to enable that.
 606
 607
 608 /**
 609  * Misc. settings
 610  */
 611 $cfg['GD2Available']          = 'auto';     // Is GD >= 2 available? Set to yes/no/auto. 'auto'
 612                                             // does autodetection, which is a bit expensive for
 613                                             // php < 4.3.0, but it is the only safe vay how to
 614                                             // determine GD version.
 615 /**
 616  * SQL Parser Settings
 617  */
 618 $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
 619 $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
 620 $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
 621 // The graphical settings are now located in themes/themename/layout.inc.php
 622
 623 /**
 624  * If you wish to use the SQL Validator service, you should be
 625  * aware of the following:
 626  * All SQL statements are stored anonymously for statistical purposes.
 627  * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
 628  * All rights reserved.
 629  */
 630 $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
 631 $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
 632 $cfg['SQLValidator']['password'] = '';      // Password for username
 633
 634 /**
 635  * Developers ONLY!
 636  * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
 637  */
 638 $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
 639 $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
 640 $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
 641                                             // Anything below the threshold is not displayed
 642
 643
 644 /**
 645  * MySQL settings
 646  */
 647 // Column types;
 648 // varchar, tinyint, text and date are listed first, based on estimated popularity
 649 $cfg['ColumnTypes'] = array(
 650    'VARCHAR',
 651    'TINYINT',
 652    'TEXT',
 653    'DATE',
 654    'SMALLINT',
 655    'MEDIUMINT',
 656    'INT',
 657    'BIGINT',
 658    'FLOAT',
 659    'DOUBLE',
 660    'DECIMAL',
 661    'DATETIME',
 662    'TIMESTAMP',
 663    'TIME',
 664    'YEAR',
 665    'CHAR',
 666    'TINYBLOB',
 667    'TINYTEXT',
 668    'BLOB',
 669    'MEDIUMBLOB',
 670    'MEDIUMTEXT',
 671    'LONGBLOB',
 672    'LONGTEXT',
 673    'ENUM',
 674    'SET',
 675    'BOOL'
 676 );
 677
 678 // Attributes
 679 // Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically
 680 // for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php
 681
 682 $cfg['AttributeTypes'] = array(
 683    '',
 684    'BINARY',
 685    'UNSIGNED',
 686    'UNSIGNED ZEROFILL'
 687 );
 688
 689 // Available functions
 690 if ($cfg['ShowFunctionFields']) {
 691     $cfg['Functions'] = array(
 692        'ASCII',
 693        'CHAR',
 694        'SOUNDEX',
 695        'LCASE',
 696        'UCASE',
 697        'NOW',
 698        'PASSWORD',
 699        'OLD_PASSWORD',
 700        'MD5',
 701        'SHA1',
 702        'ENCRYPT',
 703        'COMPRESS',
 704        'UNCOMPRESS',
 705        'RAND',
 706        'LAST_INSERT_ID',
 707        'COUNT',
 708        'AVG',
 709        'SUM',
 710        'CURDATE',
 711        'CURTIME',
 712        'UTC_DATE',
 713        'UTC_TIME',
 714        'UTC_TIMESTAMP',
 715        'FROM_DAYS',
 716        'FROM_UNIXTIME',
 717        'PERIOD_ADD',
 718        'PERIOD_DIFF',
 719        'TO_DAYS',
 720        'UNIX_TIMESTAMP',
 721        'USER',
 722        'WEEKDAY',
 723        'CONCAT'
 724     );
 725
 726     // Which column types will be mapped to which Group?
 727     $cfg['RestrictColumnTypes'] = array(
 728        'VARCHAR'      => 'FUNC_CHAR',
 729        'TINYINT'      => 'FUNC_NUMBER',
 730        'TEXT'         => 'FUNC_CHAR',
 731        'DATE'         => 'FUNC_DATE',
 732        'SMALLINT'     => 'FUNC_NUMBER',
 733        'MEDIUMINT'    => 'FUNC_NUMBER',
 734        'INT'          => 'FUNC_NUMBER',
 735        'BIGINT'       => 'FUNC_NUMBER',
 736        'FLOAT'        => 'FUNC_NUMBER',
 737        'DOUBLE'       => 'FUNC_NUMBER',
 738        'DECIMAL'      => 'FUNC_NUMBER',
 739        'DATETIME'     => 'FUNC_DATE',
 740        'TIMESTAMP'    => 'FUNC_DATE',
 741        'TIME'         => 'FUNC_DATE',
 742        'YEAR'         => 'FUNC_DATE',
 743        'CHAR'         => 'FUNC_CHAR',
 744        'TINYBLOB'     => 'FUNC_CHAR',
 745        'TINYTEXT'     => 'FUNC_CHAR',
 746        'BLOB'         => 'FUNC_CHAR',
 747        'MEDIUMBLOB'   => 'FUNC_CHAR',
 748        'MEDIUMTEXT'   => 'FUNC_CHAR',
 749        'LONGBLOB'     => 'FUNC_CHAR',
 750        'LONGTEXT'     => 'FUNC_CHAR',
 751        'ENUM'         => '',
 752        'SET'          => ''
 753     );
 754
 755     // Map above defined groups to any function
 756     $cfg['RestrictFunctions'] = array(
 757         'FUNC_CHAR'   => array(
 758             'ASCII',
 759             'CHAR',
 760             'SOUNDEX',
 761             'LCASE',
 762             'UCASE',
 763             'PASSWORD',
 764             'OLD_PASSWORD',
 765             'MD5',
 766             'SHA1',
 767             'ENCRYPT',
 768             'COMPRESS',
 769             'UNCOMPRESS',
 770             'LAST_INSERT_ID',
 771             'USER',
 772             'CONCAT'
 773         ),
 774
 775         'FUNC_DATE'   => array(
 776             'NOW',
 777             'CURDATE',
 778             'CURTIME',
 779             'FROM_DAYS',
 780             'FROM_UNIXTIME',
 781             'PERIOD_ADD',
 782             'PERIOD_DIFF',
 783             'TO_DAYS',
 784             'UNIX_TIMESTAMP',
 785             'UTC_DATE',
 786             'UTC_TIME',
 787             'UTC_TIMESTAMP',
 788             'WEEKDAY'
 789         ),
 790
 791         'FUNC_NUMBER' => array(
 792             'ASCII',
 793             'CHAR',
 794             'MD5',
 795             'SHA1',
 796             'ENCRYPT',
 797             'RAND',
 798             'LAST_INSERT_ID',
 799             'UNIX_TIMESTAMP',
 800             'COUNT',
 801             'AVG',
 802             'SUM'
 803         )
 804     );
 805
 806     // Default functions for above defined groups
 807     $cfg['DefaultFunctions'] = array(
 808         'FUNC_CHAR'         => '',
 809         'FUNC_DATE'         => '',
 810         'FUNC_NUMBER'       => '',
 811         'first_timestamp'   => 'NOW'
 812     );
 813
 814
 815 } // end if
 816
 817 // Search operators
 818 $cfg['NumOperators'] = array(
 819    '=',
 820    '>',
 821    '>=',
 822    '<',
 823    '<=',
 824    '!=',
 825    'LIKE',
 826    'NOT LIKE'
 827 );
 828
 829 $cfg['TextOperators'] = array(
 830    'LIKE',
 831    'LIKE %...%',
 832    'NOT LIKE',
 833    '=',
 834    '!=',
 835    'REGEXP',
 836    'NOT REGEXP'
 837 );
 838
 839 $cfg['EnumOperators'] = array(
 840    '=',
 841    '!='
 842 );
 843
 844 $cfg['SetOperators'] = array(
 845    'IN',
 846    'NOT IN'
 847 );
 848
 849 $cfg['NullOperators'] = array(
 850    'IS NULL',
 851    'IS NOT NULL'
 852 );
 853
 854 $cfg['UnaryOperators'] = array(
 855    'IS NULL'     => 1,
 856    'IS NOT NULL' => 1
 857 );
 858
 859 ?>