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