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