config.inc.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5 /**
   6  * phpMyAdmin Configuration File
   7  *
   8  * All directives are explained in Documentation.html
   9  */
  10
  11
  12 /**
  13  * Sets the php error reporting - Please do not change this line!
  14  */
  15 if (!isset($old_error_reporting)) {
  16     error_reporting(E_ALL);
  17     @ini_set('display_errors', '1');
  18 }
  19
  20
  21 /**
  22  * Your phpMyAdmin url
  23  *
  24  * Complete the variable below with the full url ie
  25  *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
  26  *
  27  * It must contain characters that are valid for a URL, and the path is
  28  * case sensitive on some Web servers, for example Unix-based servers.
  29  *
  30  * In most cases you can leave this variable empty, as the correct value
  31  * will be detected automatically. However, we recommend that you do
  32  * test to see that the auto-detection code works in your system. A good
  33  * test is to browse a table, then edit a row and save it.  There will be
  34  * an error message if phpMyAdmin cannot auto-detect the correct value.
  35  *
  36  * If the auto-detection code does work properly, you can set to TRUE the
  37  * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
  38  */
  39 $cfg['PmaAbsoluteUri'] = '';
  40
  41
  42 /**
  43  * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
  44  * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
  45  * works perfectly.
  46  */
  47 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
  48
  49 /**
  50  * Disable the default warning that is displayed on the DB Details Structure page if
  51  * any of the required Tables for the relationfeatures could not be found
  52  */
  53 $cfg['PmaNoRelation_DisableWarning']  = FALSE;
  54
  55 /**
  56  * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
  57  * at least one server configuration uses 'cookie' auth_type, enter here a
  58  * passphrase that will be used by blowfish.
  59  */
  60 $cfg['blowfish_secret'] = '';
  61
  62 /**
  63  * Server(s) configuration
  64  */
  65 $i = 0;
  66 // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
  67 // You can disable a server config entry by setting host to ''.
  68 $i++;
  69 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
  70 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
  71 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  72 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  73 $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
  74                                                     // (requires PHP >= 4.3.0)
  75 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
  76                                                     // (this user must have read-only
  77 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
  78                                                     // and "mysql/db" tables)
  79 $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
  80 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
  81 $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
  82                                                     // with 'config' auth_type)
  83 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
  84                                                     // this db is displayed
  85                                                     // at left frame
  86                                                     // It may also be an array
  87                                                     // of db-names
  88 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
  89
  90 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
  91                                                     // (see scripts/create_tables.sql)
  92                                                     //   - leave blank for no support
  93                                                     //     DEFAULT: 'phpmyadmin'
  94 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
  95                                                     //   - leave blank for no bookmark support
  96                                                     //     DEFAULT: 'PMA_bookmark'
  97 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
  98                                                     //   - leave blank for no relation-links support
  99                                                     //     DEFAULT: 'PMA_relation'
 100 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
 101                                                     //   - leave blank for no display fields support
 102                                                     //     DEFAULT: 'PMA_table_info'
 103 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
 104                                                     //   - leave blank for no PDF schema support
 105                                                     //     DEFAULT: 'PMA_table_coords'
 106 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
 107                                                     //   - leave blank if you don't want to use this
 108                                                     //     DEFAULT: 'PMA_pdf_pages'
 109 $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
 110                                                     //   - leave blank for no column comments/mime types
 111                                                     //     DEFAULT: 'PMA_column_info'
 112 $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
 113                                                     //   - leave blank for no SQL query history
 114                                                     //     DEFAULT: 'PMA_history'
 115 $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your PMA_* tables
 116                                                     // are up to date. This prevents compatibility
 117                                                     // checks and thereby increases performance.
 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
 124 $i++;
 125 $cfg['Servers'][$i]['host']            = '';
 126 $cfg['Servers'][$i]['port']            = '';
 127 $cfg['Servers'][$i]['socket']          = '';
 128 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 129 $cfg['Servers'][$i]['compress']        = FALSE;
 130 $cfg['Servers'][$i]['controluser']     = '';
 131 $cfg['Servers'][$i]['controlpass']     = '';
 132 $cfg['Servers'][$i]['auth_type']       = 'config';
 133 $cfg['Servers'][$i]['user']            = 'root';
 134 $cfg['Servers'][$i]['password']        = '';
 135 $cfg['Servers'][$i]['only_db']         = '';
 136 $cfg['Servers'][$i]['verbose']         = '';
 137 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
 138 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'PMA_bookmark'
 139 $cfg['Servers'][$i]['relation']        = ''; // 'PMA_relation'
 140 $cfg['Servers'][$i]['table_info']      = ''; // 'PMA_table_info'
 141 $cfg['Servers'][$i]['table_coords']    = ''; // 'PMA_table_coords'
 142 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'PMA_pdf_pages'
 143 $cfg['Servers'][$i]['column_info']     = ''; // 'PMA_column_info'
 144 $cfg['Servers'][$i]['history']         = ''; // 'PMA_history'
 145 $cfg['Servers'][$i]['verbose_check']   = TRUE;
 146 $cfg['Servers'][$i]['AllowDeny']['order']
 147                                        = '';
 148 $cfg['Servers'][$i]['AllowDeny']['rules']
 149                                        = array();
 150
 151 $i++;
 152 $cfg['Servers'][$i]['host']            = '';
 153 $cfg['Servers'][$i]['port']            = '';
 154 $cfg['Servers'][$i]['socket']          = '';
 155 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 156 $cfg['Servers'][$i]['compress']        = FALSE;
 157 $cfg['Servers'][$i]['controluser']     = '';
 158 $cfg['Servers'][$i]['controlpass']     = '';
 159 $cfg['Servers'][$i]['auth_type']       = 'config';
 160 $cfg['Servers'][$i]['user']            = 'root';
 161 $cfg['Servers'][$i]['password']        = '';
 162 $cfg['Servers'][$i]['only_db']         = '';
 163 $cfg['Servers'][$i]['verbose']         = '';
 164 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
 165 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'PMA_bookmark'
 166 $cfg['Servers'][$i]['relation']        = ''; // 'PMA_relation'
 167 $cfg['Servers'][$i]['table_info']      = ''; // 'PMA_table_info'
 168 $cfg['Servers'][$i]['table_coords']    = ''; // 'PMA_table_coords'
 169 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'PMA_pdf_pages'
 170 $cfg['Servers'][$i]['column_info']     = ''; // 'PMA_column_info'
 171 $cfg['Servers'][$i]['history']         = ''; // 'PMA_history'
 172 $cfg['Servers'][$i]['verbose_check']   = TRUE;
 173 $cfg['Servers'][$i]['AllowDeny']['order']
 174                                        = '';
 175 $cfg['Servers'][$i]['AllowDeny']['rules']
 176                                        = array();
 177
 178 // If you have more than one server configured, you can set $cfg['ServerDefault']
 179 // to any one of them to autoconnect to that server when phpMyAdmin is started,
 180 // or set it to 0 to be given a list of servers without logging in
 181 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
 182 // set to that server.
 183 $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
 184 $cfg['Server']        = '';
 185 unset($cfg['Servers'][0]);
 186
 187
 188 /**
 189  * Other core phpMyAdmin settings
 190  */
 191 $cfg['OBGzip']                  = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
 192 $cfg['PersistentConnections']   = FALSE;  // use persistent connections to MySQL database
 193 $cfg['ExecTimeLimit']           = 300;    // maximum execution time in seconds (0 for no limit)
 194 $cfg['SkipLockedTables']        = FALSE;  // mark used tables, make possible to show
 195                                           // locked tables (since MySQL 3.23.30)
 196 $cfg['ShowSQL']                 = TRUE;   // show SQL queries as run
 197 $cfg['AllowUserDropDatabase']   = FALSE;  // show a 'Drop database' link to normal users
 198 $cfg['Confirm']                 = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
 199 $cfg['LoginCookieRecall']       = TRUE;   // recall previous login in cookie auth. mode or not
 200 $cfg['UseDbSearch']             = TRUE;   // whether to enable the "database search" feature
 201                                           // or not
 202 $cfg['IgnoreMultiSubmitErrors'] = FALSE;  // if set to true, PMA continues computing multiple-statement queries
 203                                           // even if one of the queries failed
 204 $cfg['VerboseMultiSubmit']      = TRUE;   // if set to true, PMA will show the affected rows of EACH statement on
 205                                           // multiple-statement queries. See the read_dump.php3 file for hardcoded
 206                                           // defaults on how many queries a statement may contain!
 207 $cfg['AllowArbitraryServer']    = FALSE;  // allow login to any user entered server in cookie based auth
 208
 209 // Left frame setup
 210 $cfg['LeftFrameLight']        = TRUE;   // use a select-based menu and display only the
 211                                         // current tables in the left frame.
 212 $cfg['LeftFrameTableSeparator']= '__';  // Which string will be used to generate table prefixes
 213                                         // to split tables into multiple categories
 214 $cfg['LeftFrameTableLevel']   = '1';    // How many sublevels should be displayed when splitting
 215                                         // up tables by the above Separator
 216 $cfg['ShowTooltip']           = TRUE;   // display table comment as tooltip in left frame
 217 $cfg['ShowTooltipAliasDB']    = FALSE;  // if ShowToolTip is enabled, this defines that table/db comments
 218 $cfg['ShowTooltipAliasTB']    = FALSE;  // are shown (in the left menu and db_details_structure) instead of
 219                                         // table/db names
 220
 221 $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
 222 $cfg['LeftDisplayServers']    = FALSE;  // display server choice at top of left frame
 223
 224 // In the main frame, at startup...
 225 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
 226                                         // the pages about database details and table
 227                                         // properties
 228 $cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
 229 $cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
 230 $cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for
 231 $cfg['ShowChgPassword']       = FALSE;  // simple users or not
 232 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
 233
 234 // In browse mode...
 235 $cfg['ShowBlob']              = FALSE;  // display blob field contents
 236 $cfg['NavigationBarIconic']   = TRUE;   // do not display text inside navigation bar buttons
 237 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
 238 $cfg['MaxRows']               = 30;     // maximum number of rows to display
 239 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
 240                                         // values are 'ASC', 'DESC' or 'SMART' -ie
 241                                         // descending order for fields of type
 242                                         // TIME, DATE, DATETIME & TIMESTAMP,
 243                                         // ascending order else-)
 244
 245 // In edit mode...
 246 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
 247                                         // valid values are:
 248                                         //   FALSE  allow editing
 249                                         //   'blob' allow editing except for BLOB fields
 250                                         //   'all'  disallow editing
 251 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
 252 $cfg['CharEditing']           = 'input';
 253                                         // Which editor should be used for CHAR/VARCHAR fields:
 254                                         //  input - allows limiting of input length
 255                                         //  textarea - allows newlines in fields
 256
 257 // For the export features...
 258 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
 259 $cfg['GZipDump']              = TRUE;   // compression for
 260 $cfg['BZipDump']              = TRUE;   // dump files
 261 $cfg['CompressOnFly']         = TRUE;   // Will compress gzip/bzip2 exports on
 262                                         // fly without need for much memory.
 263                                         // If you encounter problems with
 264                                         // created gzip/bzip2 files disable
 265                                         // this feature.
 266
 267 // Tabs display settings
 268 $cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs
 269 $cfg['PropertiesIconic']      = TRUE;   // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')
 270 $cfg['PropertiesNumColumns']  = 1;      // How many columns should be used for table display of a database?
 271                                         // (a value larger than 1 results in some information being hidden)
 272
 273 $cfg['DefaultTabServer']      = 'main.php3';
 274                                    // Possible values:
 275                                    // 'main.php3' = the welcome page
 276                                    // (recommended for multiuser setups)
 277                                    // 'server_databases.php3' = list of databases
 278                                    // 'server_status.php3' = runtime information
 279                                    // 'server_variables.php3' = MySQL server variables
 280                                    // 'server_privileges.php3' = user management
 281                                    // 'server_processlist.php3' = process list
 282 $cfg['DefaultTabDatabase']    = 'db_details_structure.php3';
 283                                    // Possible values:
 284                                    // 'db_details_structure.php3' = tables list
 285                                    // 'db_details.php3' = sql form
 286                                    // 'db_search.php3' = search query
 287 $cfg['DefaultTabTable']       = 'tbl_properties_structure.php3';
 288                                    // Possible values:
 289                                    // 'tbl_properties_structure.php3' = fields list
 290                                    // 'tbl_properties.php3' = sql form
 291                                    // 'tbl_select.php3 = select page
 292                                    // 'tbl_change.php3 = insert row page
 293
 294 /**
 295  * Export defaults
 296  */
 297
 298 $cfg['Export']['format']                    = 'sql';  // sql/latex/excel/csv/xml
 299 $cfg['Export']['compression']               = 'none'; // none/zip/gzip/bzip2
 300
 301 $cfg['Export']['asfile']                    = FALSE;
 302 $cfg['Export']['onserver']                  = FALSE;
 303 $cfg['Export']['onserver_overwrite']        = FALSE;
 304 $cfg['Export']['remember_file_template']    = TRUE;
 305
 306 $cfg['Export']['csv_columns']               = FALSE;
 307 $cfg['Export']['csv_null']                  = 'NULL';
 308 $cfg['Export']['csv_separator']             = ';';
 309 $cfg['Export']['csv_enclosed']              = '&quot;';
 310 $cfg['Export']['csv_escaped']               = '\\';
 311 $cfg['Export']['csv_terminated']            = 'AUTO';
 312 $cfg['Export']['excel_columns']             = FALSE;
 313 $cfg['Export']['excel_null']                = 'NULL';
 314
 315 $cfg['Export']['latex_structure']           = TRUE;
 316 $cfg['Export']['latex_data']                = TRUE;
 317 $cfg['Export']['latex_columns']             = TRUE;
 318 $cfg['Export']['latex_relation']            = TRUE;
 319 $cfg['Export']['latex_comments']            = TRUE;
 320 $cfg['Export']['latex_mime']                = TRUE;
 321 $cfg['Export']['latex_null']                = '\textit{NULL}';
 322 $cfg['Export']['latex_caption']             = TRUE;
 323 $cfg['Export']['latex_data_label']          = 'tab:__TABLE__-data';
 324 $cfg['Export']['latex_structure_label']     = 'tab:__TABLE__-structure';
 325
 326 $cfg['Export']['sql_structure']             = TRUE;
 327 $cfg['Export']['sql_data']                  = TRUE;
 328 $cfg['Export']['sql_drop_database']         = FALSE;
 329 $cfg['Export']['sql_drop_table']            = FALSE;
 330 $cfg['Export']['sql_auto_increment']        = TRUE;
 331 $cfg['Export']['sql_backquotes']            = TRUE;
 332 $cfg['Export']['sql_relation']              = FALSE;
 333 $cfg['Export']['sql_columns']               = FALSE;
 334 $cfg['Export']['sql_extended']              = FALSE;
 335 $cfg['Export']['sql_comments']              = FALSE;
 336 $cfg['Export']['sql_mime']                  = FALSE;
 337
 338 /**
 339  * Link to the official MySQL documentation.
 340  * Be sure to include no trailing slash on the path.
 341  * See http://www.mysql.com/documentation/index.html for more information
 342  * about MySQL manuals and their types.
 343  */
 344 $cfg['MySQLManualBase'] = 'http://www.mysql.com/doc/en';
 345
 346 /**
 347  * Type of MySQL documentation:
 348  *   old        - old style used in phpMyAdmin 2.3.0 and sooner
 349  *   searchable - "Searchable, with user comments"
 350  *   chapters   - "HTML, one page per chapter"
 351  *   big        - "HTML, all on one page"
 352  *   none       - do not show documentation links
 353  */
 354 $cfg['MySQLManualType'] = 'searchable';
 355
 356
 357 /**
 358  * PDF options
 359  */
 360 $cfg['PDFPageSizes']        = array('A3', 'A4', 'A5', 'letter', 'legal');
 361 $cfg['PDFDefaultPageSize']  = 'A4';
 362
 363
 364 /**
 365  * Language and charset conversion settings
 366  */
 367 // Default language to use, if not browser-defined or user-defined
 368 $cfg['DefaultLang'] = 'en-iso-8859-1';
 369
 370 // Force: always use this language - must be defined in
 371 //        libraries/select_lang.lib.php3
 372 // $cfg['Lang']     = 'en-iso-8859-1';
 373
 374 // Default charset to use for recoding of MySQL queries, does not take
 375 // any effect when charsets recoding is switched off by
 376 // $cfg['AllowAnywhereRecoding'] or in language file
 377 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
 378 $cfg['DefaultCharset'] = 'iso-8859-1';
 379
 380 // Allow charset recoding of MySQL queries, must be also enabled in language
 381 // file to make harder using other language files than unicode.
 382 // Default value is FALSE to avoid problems on servers without the iconv
 383 // extension and where dl() is not supported
 384 $cfg['AllowAnywhereRecoding'] = FALSE;
 385
 386 // You can select here which functions will be used for charset conversion.
 387 // Possible values are:
 388 //      auto   - automatically use available one (first is tested iconv, then
 389 //               recode)
 390 //      iconv  - use iconv or libiconv functions
 391 //      recode - use recode_string function
 392 $cfg['RecodingEngine'] = 'auto';
 393
 394 // Specify some parameters for iconv used in charset conversion. See iconv
 395 // documentation for details:
 396 // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
 397 $cfg['IconvExtraParams'] = '';
 398
 399 // Available charsets for MySQL conversion. currently contains all which could
 400 // be found in lang/* files and few more.
 401 // Charsets will be shown in same order as here listed, so if you frequently
 402 // use some of these move them to the top.
 403 $cfg['AvailableCharsets'] = array(
 404     'iso-8859-1',
 405     'iso-8859-2',
 406     'iso-8859-3',
 407     'iso-8859-4',
 408     'iso-8859-5',
 409     'iso-8859-6',
 410     'iso-8859-7',
 411     'iso-8859-8',
 412     'iso-8859-9',
 413     'iso-8859-10',
 414     'iso-8859-11',
 415     'iso-8859-12',
 416     'iso-8859-13',
 417     'iso-8859-14',
 418     'iso-8859-15',
 419     'windows-1250',
 420     'windows-1251',
 421     'windows-1252',
 422     'windows-1257',
 423     'koi8-r',
 424     'big5',
 425     'gb2312',
 426     'utf-8',
 427     'utf-7',
 428     'x-user-defined',
 429     'euc-jp',
 430     'ks_c_5601-1987',
 431     'tis-620',
 432     'SHIFT_JIS'
 433 );
 434
 435 // Loads language file
 436 require('./libraries/select_lang.lib.php3');
 437
 438
 439 /**
 440  * Customization & design
 441  */
 442 $cfg['LeftWidth']           = 150;          // left frame width
 443 $cfg['LeftBgColor']         = '#D0DCE0';    // background color for the left frame
 444 $cfg['RightBgColor']        = '#F5F5F5';    // background color for the right frame
 445 $cfg['RightBgImage']        = '';           // path to a background image for the right frame
 446                                             // (leave blank for no background image)
 447 $cfg['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
 448                                             // (blank for no pointer)
 449 $cfg['Border']              = 0;            // border width on tables
 450 $cfg['ThBgcolor']           = '#D3DCE3';    // table header row colour
 451 $cfg['BgcolorOne']          = '#CCCCCC';    // table data row colour
 452 $cfg['BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
 453 $cfg['BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
 454                                             // (blank for no pointer)
 455 $cfg['BrowseMarkerColor']   = '#FFCC99';    // color of the marker (visually marks row
 456                                             // by clicking on it) in browse mode
 457                                             // (blank for no marker)
 458 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
 459                                             // (this value will be emphasized (*2) for sql
 460                                             // query textareas and (*1.25) for query window)
 461 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
 462 $cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
 463 $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
 464 $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
 465 $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
 466 $cfg['CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?
 467 $cfg['LimitChars']          = 50;           // Max field data length in browse mode for all non-numeric fields
 468 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
 469                                             // (or at the top with vertical browse)
 470 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
 471                                             // (or at the bottom with vertical browse)
 472 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction
 473                                             // (horizontal|vertical|horizontalflipped)
 474 $cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
 475                                             // creating columns (tbl_properties)
 476                                             // (horizontal|vertical)
 477
 478 $cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
 479                                             // NOTE: CSS only works in IE browsers!
 480 $cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
 481 $cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
 482 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
 483
 484 $cfg['QueryFrame']          = TRUE;         // displays a new frame where a link to a querybox is always displayed.
 485 $cfg['QueryFrameJS']        = TRUE;         // whether to use JavaScript functions for opening a new window for SQL commands.
 486                                             // if set to 'false', the target of the querybox is always the right frame.
 487 $cfg['QueryFrameDebug']     = FALSE;        // display JS debugging link (DEVELOPERS only)
 488 $cfg['QueryWindowWidth']    = 550;          // Width of Query window
 489 $cfg['QueryWindowHeight']   = 310;          // Height of Query window
 490 $cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.
 491                                             // If FALSE, this utilizes JS-routines to display
 492                                             // query history (lost by window close)
 493 $cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
 494                                             // (sql|files|history|full)
 495 $cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
 496                                             // should be kept?
 497 $cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
 498 $cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for
 499                                             // table rows.
 500 $cfg['WYSIWYG-PDF']         = TRUE;         // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
 501                                             // the PDF page editor. Requires an IE6/Mozilla based browser.
 502
 503 /**
 504  * SQL Query box settings
 505  * These are the links display in all of the SQL Query boxes
 506  */
 507 $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
 508 $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
 509 $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
 510 $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
 511
 512
 513 /**
 514  * Webserver upload/save/import directories
 515  */
 516 $cfg['UploadDir']             = '';         // Directory for uploaded files that can be executed by
 517                                             // phpMyAdmin. For example './upload'. Leave empty for
 518                                             // no upload directory support
 519 $cfg['SaveDir']               = '';         // Directory where phpMyAdmin can save exported data on
 520                                             // server. For example './save'. Leave empty for no save
 521                                             // directory support.
 522 $cfg['docSQLDir']             = '';         // Directory for docSQL imports, phpMyAdmin can import
 523                                             // docSQL files from that directory. For example
 524                                             // './docSQL'. Leave empty for no docSQL import support.
 525
 526
 527 /**
 528  * Misc. settings
 529  */
 530 $cfg['GD2Available']          = 'auto';     // Is GD >= 2 available? Set to yes/no/auto. 'auto'
 531                                             // does autodetection, which is a bit expensive for
 532                                             // php < 4.3.0, but it is the only safe vay how to
 533                                             // determine GD version.
 534 /**
 535  * SQL Parser Settings
 536  */
 537 $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
 538 $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
 539 $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
 540 $cfg['SQP']['fmtColor']     = array(        // Syntax colouring data
 541     'comment'            => '#808000',
 542     'comment_mysql'      => '',
 543     'comment_ansi'       => '',
 544     'comment_c'          => '',
 545     'digit'              => '',
 546     'digit_hex'          => 'teal',
 547     'digit_integer'      => 'teal',
 548     'digit_float'        => 'aqua',
 549     'punct'              => 'fuchsia',
 550     'alpha'              => '',
 551     'alpha_columnType'   => '#FF9900',
 552     'alpha_columnAttrib' => '#0000FF',
 553     'alpha_reservedWord' => '#990099',
 554     'alpha_functionName' => '#FF0000',
 555     'alpha_identifier'   => 'black',
 556     'alpha_variable'     => '#800000',
 557     'quote'              => '#008000',
 558     'quote_double'       => '',
 559     'quote_single'       => '',
 560     'quote_backtick'     => ''
 561 );
 562
 563
 564 /**
 565  * If you wish to use the SQL Validator service, you should be
 566  * aware of the following:
 567  * All SQL statements are stored anonymously for statistical purposes.
 568  * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
 569  * All rights reserved.
 570  */
 571 $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
 572 $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
 573 $cfg['SQLValidator']['password'] = '';      // Password for username
 574
 575 /**
 576  * Developers ONLY!
 577  * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
 578  */
 579 $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
 580 $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
 581 $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
 582                                             // Anything below the threshold is not displayed
 583
 584
 585 /**
 586  * MySQL settings
 587  */
 588 // Column types;
 589 // varchar, tinyint, text and date are listed first, based on estimated popularity
 590 $cfg['ColumnTypes'] = array(
 591    'VARCHAR',
 592    'TINYINT',
 593    'TEXT',
 594    'DATE',
 595    'SMALLINT',
 596    'MEDIUMINT',
 597    'INT',
 598    'BIGINT',
 599    'FLOAT',
 600    'DOUBLE',
 601    'DECIMAL',
 602    'DATETIME',
 603    'TIMESTAMP',
 604    'TIME',
 605    'YEAR',
 606    'CHAR',
 607    'TINYBLOB',
 608    'TINYTEXT',
 609    'BLOB',
 610    'MEDIUMBLOB',
 611    'MEDIUMTEXT',
 612    'LONGBLOB',
 613    'LONGTEXT',
 614    'ENUM',
 615    'SET'
 616 );
 617
 618 // Atributes
 619 $cfg['AttributeTypes'] = array(
 620    '',
 621    'BINARY',
 622    'UNSIGNED',
 623    'UNSIGNED ZEROFILL'
 624 );
 625
 626 // Available functions
 627 if ($cfg['ShowFunctionFields']) {
 628     $cfg['Functions'] = array(
 629        'ASCII',
 630        'CHAR',
 631        'SOUNDEX',
 632        'LCASE',
 633        'UCASE',
 634        'NOW',
 635        'PASSWORD',
 636        'MD5',
 637        'ENCRYPT',
 638        'RAND',
 639        'LAST_INSERT_ID',
 640        'COUNT',
 641        'AVG',
 642        'SUM',
 643        'CURDATE',
 644        'CURTIME',
 645        'FROM_DAYS',
 646        'FROM_UNIXTIME',
 647        'PERIOD_ADD',
 648        'PERIOD_DIFF',
 649        'TO_DAYS',
 650        'UNIX_TIMESTAMP',
 651        'USER',
 652        'WEEKDAY',
 653        'CONCAT'
 654     );
 655
 656     // Which column types will be mapped to which Group?
 657     $cfg['RestrictColumnTypes'] = array(
 658        'VARCHAR'      => 'FUNC_CHAR',
 659        'TINYINT'      => 'FUNC_NUMBER',
 660        'TEXT'         => 'FUNC_CHAR',
 661        'DATE'         => 'FUNC_DATE',
 662        'SMALLINT'     => 'FUNC_NUMBER',
 663        'MEDIUMINT'    => 'FUNC_NUMBER',
 664        'INT'          => 'FUNC_NUMBER',
 665        'BIGINT'       => 'FUNC_NUMBER',
 666        'FLOAT'        => 'FUNC_NUMBER',
 667        'DOUBLE'       => 'FUNC_NUMBER',
 668        'DECIMAL'      => 'FUNC_NUMBER',
 669        'DATETIME'     => 'FUNC_DATE',
 670        'TIMESTAMP'    => 'FUNC_DATE',
 671        'TIME'         => 'FUNC_DATE',
 672        'YEAR'         => 'FUNC_DATE',
 673        'CHAR'         => 'FUNC_CHAR',
 674        'TINYBLOB'     => 'FUNC_CHAR',
 675        'TINYTEXT'     => 'FUNC_CHAR',
 676        'BLOB'         => 'FUNC_CHAR',
 677        'MEDIUMBLOB'   => 'FUNC_CHAR',
 678        'MEDIUMTEXT'   => 'FUNC_CHAR',
 679        'LONGBLOB'     => 'FUNC_CHAR',
 680        'LONGTEXT'     => 'FUNC_CHAR',
 681        'ENUM'         => '',
 682        'SET'          => ''
 683     );
 684
 685     // Map above defined groups to any function
 686     $cfg['RestrictFunctions'] = array(
 687         'FUNC_CHAR'   => array(
 688             'ASCII',
 689             'CHAR',
 690             'SOUNDEX',
 691             'LCASE',
 692             'UCASE',
 693             'PASSWORD',
 694             'MD5',
 695             'ENCRYPT',
 696             'LAST_INSERT_ID',
 697             'USER',
 698             'CONCAT'
 699         ),
 700
 701         'FUNC_DATE'   => array(
 702             'NOW',
 703             'CURDATE',
 704             'CURTIME',
 705             'FROM_DAYS',
 706             'FROM_UNIXTIME',
 707             'PERIOD_ADD',
 708             'PERIOD_DIFF',
 709             'TO_DAYS',
 710             'UNIX_TIMESTAMP',
 711             'WEEKDAY'
 712         ),
 713
 714         'FUNC_NUMBER' => array(
 715             'ASCII',
 716             'CHAR',
 717             'MD5',
 718             'ENCRYPT',
 719             'RAND',
 720             'LAST_INSERT_ID',
 721             'COUNT',
 722             'AVG',
 723             'SUM'
 724         )
 725     );
 726
 727 } // end if
 728
 729
 730 /**
 731  * Unset magic_quotes_runtime - do not change!
 732  */
 733 set_magic_quotes_runtime(0);
 734
 735 /**
 736  * File Revision - do not change either!
 737  */
 738 $cfg['FileRevision'] = '$Revision$';
 739 ?>