2
/* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */
4
/* $Id: config.default.php 10040 2007-03-01 15:36:20Z lem9 $ */
5
// vim: expandtab sw=4 ts=4 sts=4:
8
* phpMyAdmin default configuration, you can copy values from here to your
11
* All directives are explained in Documentation.html
16
* Your phpMyAdmin URL.
18
* Complete the variable below with the full url ie
19
* http://www.your_web.net/path_to_your_phpMyAdmin_directory/
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.
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.
30
$cfg['PmaAbsoluteUri'] = '';
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
36
$cfg['PmaNoRelation_DisableWarning'] = FALSE;
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
44
$cfg['blowfish_secret'] = '';
47
* Server(s) configuration
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.
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
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
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
119
$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults
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)
130
* Other core phpMyAdmin settings
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
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
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.
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
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
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)
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-)
204
$cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields
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
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
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
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)
237
$cfg['DefaultTabServer'] = 'main.php';
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';
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';
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
264
$cfg['Export']['format'] = 'sql'; // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt
265
$cfg['Export']['compression'] = 'none'; // none/zip/gzip/bzip2
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__';
276
$cfg['Export']['ods_columns'] = FALSE;
277
$cfg['Export']['ods_null'] = 'NULL';
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';
287
$cfg['Export']['htmlexcel_columns'] = FALSE;
288
$cfg['Export']['htmlexcel_null'] = 'NULL';
290
$cfg['Export']['htmlword_structure'] = TRUE;
291
$cfg['Export']['htmlword_data'] = TRUE;
292
$cfg['Export']['htmlword_columns'] = FALSE;
293
$cfg['Export']['htmlword_null'] = 'NULL';
295
$cfg['Export']['xls_columns'] = FALSE;
296
$cfg['Export']['xls_null'] = 'NULL';
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
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';
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'] = FALSE;
331
$cfg['Export']['sql_auto_increment'] = TRUE;
332
$cfg['Export']['sql_backquotes'] = TRUE;
333
$cfg['Export']['sql_dates'] = FALSE;
334
$cfg['Export']['sql_relation'] = FALSE;
335
$cfg['Export']['sql_columns'] = TRUE;
336
$cfg['Export']['sql_delayed'] = FALSE;
337
$cfg['Export']['sql_ignore'] = FALSE;
338
$cfg['Export']['sql_hex_for_binary'] = TRUE;
339
$cfg['Export']['sql_type'] = 'insert'; // insert/update/replace
340
$cfg['Export']['sql_extended'] = TRUE;
341
$cfg['Export']['sql_max_query_size'] = 50000;
342
$cfg['Export']['sql_comments'] = FALSE;
343
$cfg['Export']['sql_mime'] = FALSE;
344
$cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line
346
$cfg['Export']['pdf_structure'] = FALSE;
347
$cfg['Export']['pdf_data'] = TRUE;
348
$cfg['Export']['pdf_report_title'] = '';
353
$cfg['Import']['format'] = 'sql';
354
$cfg['Import']['allow_interrupt'] = TRUE;
355
$cfg['Import']['skip_queries'] = '0';
356
$cfg['Import']['sql_compatibility'] = 'NONE';
357
$cfg['Import']['csv_replace'] = FALSE;
358
$cfg['Import']['csv_terminated'] = ';';
359
$cfg['Import']['csv_enclosed'] = '"';
360
$cfg['Import']['csv_escaped'] = '\\';
361
$cfg['Import']['csv_new_line'] = 'auto';
362
$cfg['Import']['csv_columns'] = '';
363
$cfg['Import']['ldi_replace'] = FALSE;
364
$cfg['Import']['ldi_terminated'] = ';';
365
$cfg['Import']['ldi_enclosed'] = '"';
366
$cfg['Import']['ldi_escaped'] = '\\';
367
$cfg['Import']['ldi_new_line'] = 'auto';
368
$cfg['Import']['ldi_columns'] = '';
369
$cfg['Import']['ldi_local_option'] = 'auto'; // 'auto' for autodetection, TRUE or FALSE for forcing
373
* Link to the official MySQL documentation.
374
* Be sure to include no trailing slash on the path.
375
* See http://dev.mysql.com/doc/ for more information
376
* about MySQL manuals and their types.
378
$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
381
* Type of MySQL documentation:
382
* viewable - "viewable online", current one used on MySQL website
383
* searchable - "Searchable, with user comments"
384
* chapters - "HTML, one page per chapter"
385
* chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release
386
* big - "HTML, all on one page"
387
* old - old style used in phpMyAdmin 2.3.0 and sooner
388
* none - do not show documentation links
390
$cfg['MySQLManualType'] = 'viewable';
396
$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
397
$cfg['PDFDefaultPageSize'] = 'A4';
401
* Language and charset conversion settings
403
// Default language to use, if not browser-defined or user-defined
404
$cfg['DefaultLang'] = 'en-iso-8859-1';
406
// Default connection collation (used for MySQL >= 4.1)
407
$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';
409
// Force: always use this language - must be defined in
410
// libraries/select_lang.lib.php
411
// $cfg['Lang'] = 'en-iso-8859-1';
413
// Regullar expression to limit listed languages, eg. '^(cs|en)' for Czech and
415
$cfg['FilterLanguages'] = '';
417
// Default charset to use for recoding of MySQL queries, does not take
418
// any effect when charsets recoding is switched off by
419
// $cfg['AllowAnywhereRecoding'] or in language file
420
// (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
421
$cfg['DefaultCharset'] = 'iso-8859-1';
423
// Allow charset recoding of MySQL queries, must be also enabled in language
424
// file to make harder using other language files than unicode.
425
// Default value is FALSE to avoid problems on servers without the iconv
426
// extension and where dl() is not supported
427
$cfg['AllowAnywhereRecoding'] = FALSE;
429
// You can select here which functions will be used for charset conversion.
430
// Possible values are:
431
// auto - automatically use available one (first is tested iconv, then
433
// iconv - use iconv or libiconv functions
434
// recode - use recode_string function
435
$cfg['RecodingEngine'] = 'auto';
437
// Specify some parameters for iconv used in charset conversion. See iconv
438
// documentation for details:
439
// http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
440
$cfg['IconvExtraParams'] = '//TRANSLIT';
442
// Available charsets for MySQL conversion. currently contains all which could
443
// be found in lang/* files and few more.
444
// Charsets will be shown in same order as here listed, so if you frequently
445
// use some of these move them to the top.
446
$cfg['AvailableCharsets'] = array(
481
* Customization & design
483
* The graphical settings are now located in themes/themename/layout.inc.php
486
$cfg['LeftPointerEnable'] = TRUE; // enable the left panel pointer
487
// (used when LeftFrameLight is FALSE)
488
// see also LeftPointerColor
491
$cfg['BrowsePointerEnable'] = TRUE; // enable the browse pointer
492
// see also BrowsePointerColor
495
$cfg['BrowseMarkerEnable'] = TRUE; // enable the browse marker
496
// see also BrowseMarkerColor
499
$cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode
500
// (this value will be emphasized (*2) for sql
501
// query textareas and (*1.25) for query window)
502
$cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode
503
$cfg['LongtextDoubleTextarea'] = TRUE; // double size of textarea size for longtext fields
504
$cfg['TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox
505
$cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR
506
$cfg['CharTextareaRows'] = 2; // textarea size (rows) for CHAR/VARCHAR
507
$cfg['CtrlArrowsMoving'] = TRUE; // Enable Ctrl+Arrows moving between fields when editing?
508
$cfg['LimitChars'] = 50; // Max field data length in browse mode for all non-numeric fields
509
$cfg['ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse
510
// (or at the top with vertical browse)
511
$cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse
512
// (or at the bottom with vertical browse)
513
$cfg['DefaultDisplay'] = 'horizontal'; // default display direction
514
// (horizontal|vertical|horizontalflipped)
515
$cfg['DefaultPropDisplay'] = 3; // default display direction for altering/
516
// creating columns (tbl_properties)
517
// (horizontal|vertical|<number>)
518
// number indicates maximal number for which vertical model is used
520
$cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake)
521
// NOTE: CSS only works in IE browsers!
522
$cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode.
523
$cfg['ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' mode.
524
$cfg['RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate)
526
$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
527
$cfg['QueryWindowWidth'] = 550; // Width of Query window
528
$cfg['QueryWindowHeight'] = 310; // Height of Query window
529
$cfg['QueryHistoryDB'] = FALSE; // Set to TRUE if you want DB-based query history.
530
// If FALSE, this utilizes JS-routines to display
531
// query history (lost by window close)
532
$cfg['QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup
533
// (sql|files|history|full)
534
$cfg['QueryHistoryMax'] = 25; // When using DB-based query history, how many entries
536
$cfg['BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for
537
$cfg['MaxExactCount'] = 20000; // When approximate count < this, PMA will get exact count for table rows.
538
$cfg['MaxExactCountViews'] = 0; // Zero means that no row count is done for views; see the doc
539
$cfg['WYSIWYG-PDF'] = TRUE; // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
540
// the PDF page editor. Requires an IE6/Mozilla based browser.
542
$cfg['NaturalOrder'] = TRUE; // Sort table and database in natural order
545
//-----------------------------------------------------------------------------
546
// custom-setup by mkkeck: 2004-05-04
547
// some specials for new icons and scrollings
549
* @todo 2004-05-08 rabus: We need to rearrange these variables.
552
// Window title settings
553
$cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
554
$cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
555
$cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
556
$cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
558
$cfg['ErrorIconic'] = TRUE; // show some icons for warning, error and information messages (true|false)?
559
$cfg['MainPageIconic'] = TRUE; // show icons in list on main page and on menu tabs (true|false)?
560
$cfg['ReplaceHelpImg'] = TRUE; // show help button instead of strDocu (true|false)?
563
$cfg['ThemePath'] = './themes'; // using themes manager please set up here the path to 'themes'
565
$cfg['ThemeManager'] = TRUE; // if you want to use selectable themes and if ThemesPath not empty
566
// set it to true, else set it to false (default is false);
567
$cfg['ThemeDefault'] = 'original'; // set up default theme, if ThemePath not empty
568
// you can set up here an valid path to themes or 'original' for
569
// the original pma-theme
570
$cfg['ThemePerServer'] = FALSE; // allow different theme for each configured server
572
//-----------------------------------------------------------------------------
577
* %d will be replaced by the database name.
578
* %t will be replaced by the table name.
579
* %f will be replaced by a list of field names.
580
* (%t and %f only applies to DefaultQueryTable)
582
$cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';
583
$cfg['DefaultQueryDatabase'] = '';
586
* SQL Query box settings
587
* These are the links display in all of the SQL Query boxes
589
$cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query
590
$cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries
591
$cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP
592
$cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well)
593
$cfg['SQLQuery']['Refresh'] = TRUE; // Refresh the results page
597
* Webserver upload/save/import directories
599
$cfg['UploadDir'] = ''; // Directory for uploaded files that can be executed by
600
// phpMyAdmin. For example './upload'. Leave empty for
601
// no upload directory support. Use %u for username
603
$cfg['SaveDir'] = ''; // Directory where phpMyAdmin can save exported data on
604
// server. For example './save'. Leave empty for no save
605
// directory support. Use %u for username inclusion.
606
$cfg['TempDir'] = ''; // Directory where phpMyAdmin can save temporary files.
607
// This is needed for MS Excel export, see documentation
608
// how to enable that.
614
$cfg['GD2Available'] = 'auto'; // Is GD >= 2 available? Set to yes/no/auto. 'auto'
615
// does autodetection, which is a bit expensive for
616
// php < 4.3.0, but it is the only safe vay how to
617
// determine GD version.
618
$cfg['TrustedProxies'] = array(); // List of trusted proxies for IP allow/deny
621
* SQL Parser Settings
623
$cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none)
624
$cfg['SQP']['fmtInd'] = '1'; // Amount to indent each level (floats ok)
625
$cfg['SQP']['fmtIndUnit'] = 'em'; // Units for indenting each level (CSS Types - {em,px,pt})
626
// The graphical settings are now located in themes/themename/layout.inc.php
629
* If you wish to use the SQL Validator service, you should be
630
* aware of the following:
631
* All SQL statements are stored anonymously for statistical purposes.
632
* Mimer SQL Validator, Copyright 2002 Upright Database Technology.
633
* All rights reserved.
635
$cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator available
636
$cfg['SQLValidator']['username'] = ''; // If you have a custom username, specify it here (defaults to anonymous)
637
$cfg['SQLValidator']['password'] = ''; // Password for username
641
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
643
$cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available
644
$cfg['DBG']['profile']['enable'] = FALSE; // Produce profiling results of PHP
645
$cfg['DBG']['profile']['threshold'] = 0.5; // Threshold of long running code to display
646
// Anything below the threshold is not displayed
653
// varchar, tinyint, text and date are listed first, based on estimated popularity
654
$cfg['ColumnTypes'] = array(
684
// Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically
685
// for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php
687
$cfg['AttributeTypes'] = array(
694
// Available functions
695
if ($cfg['ShowFunctionFields']) {
696
$cfg['Functions'] = array(
733
// Which column types will be mapped to which Group?
734
$cfg['RestrictColumnTypes'] = array(
735
'VARCHAR' => 'FUNC_CHAR',
736
'TINYINT' => 'FUNC_NUMBER',
737
'TEXT' => 'FUNC_CHAR',
738
'DATE' => 'FUNC_DATE',
739
'SMALLINT' => 'FUNC_NUMBER',
740
'MEDIUMINT' => 'FUNC_NUMBER',
741
'INT' => 'FUNC_NUMBER',
742
'BIGINT' => 'FUNC_NUMBER',
743
'FLOAT' => 'FUNC_NUMBER',
744
'DOUBLE' => 'FUNC_NUMBER',
745
'DECIMAL' => 'FUNC_NUMBER',
746
'DATETIME' => 'FUNC_DATE',
747
'TIMESTAMP' => 'FUNC_DATE',
748
'TIME' => 'FUNC_DATE',
749
'YEAR' => 'FUNC_DATE',
750
'CHAR' => 'FUNC_CHAR',
751
'TINYBLOB' => 'FUNC_CHAR',
752
'TINYTEXT' => 'FUNC_CHAR',
753
'BLOB' => 'FUNC_CHAR',
754
'MEDIUMBLOB' => 'FUNC_CHAR',
755
'MEDIUMTEXT' => 'FUNC_CHAR',
756
'LONGBLOB' => 'FUNC_CHAR',
757
'LONGTEXT' => 'FUNC_CHAR',
762
// Map above defined groups to any function
763
$cfg['RestrictFunctions'] = array(
764
'FUNC_CHAR' => array(
784
'FUNC_DATE' => array(
800
'FUNC_NUMBER' => array(
815
// Default functions for above defined groups
816
$cfg['DefaultFunctions'] = array(
820
'first_timestamp' => 'NOW'
827
$cfg['NumOperators'] = array(
838
$cfg['TextOperators'] = array(
848
$cfg['EnumOperators'] = array(
853
$cfg['SetOperators'] = array(
858
$cfg['NullOperators'] = array(
863
$cfg['UnaryOperators'] = array(