interface/main/myadmin/config.inc.php

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