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