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