2 /* vim: set expandtab sw=4 ts=4 sts=4: */
5 * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !!
6 * NN N O O !! D D O O NN N O O T E D D I T !!
7 * N N N O O !! D D O O N N N O O T EEEE D D I T !!
8 * N NN O O D D O O N NN O O T E D D I T
9 * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !!
12 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
14 * phpMyAdmin default configuration, you can copy values from here to your
17 * All directives are explained in Documentation.html
23 * Your phpMyAdmin URL.
25 * Complete the variable below with the full URL ie
26 * http://www.your_web.net/path_to_your_phpMyAdmin_directory/
28 * It must contain characters that are valid for a URL, and the path is
29 * case sensitive on some Web servers, for example Unix-based servers.
31 * In most cases you can leave this variable empty, as the correct value
32 * will be detected automatically. However, we recommend that you do
33 * test to see that the auto-detection code works in your system. A good
34 * test is to browse a table, then edit a row and save it. There will be
35 * an error message if phpMyAdmin cannot auto-detect the correct value.
37 * @global string $cfg['PmaAbsoluteUri']
39 $cfg['PmaAbsoluteUri'] = '';
42 * Disable the default warning that is displayed on the DB Details Structure page if
43 * any of the required Tables for the relation features could not be found
45 * @global boolean $cfg['PmaNoRelation_DisableWarning']
47 $cfg['PmaNoRelation_DisableWarning'] = false;
50 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
51 * at least one server configuration uses 'cookie' auth_type, enter here a
52 * pass phrase that will be used by blowfish. The maximum length seems to be 46
55 * @global string $cfg['blowfish_secret']
57 $cfg['blowfish_secret'] = '';
60 /*******************************************************************************
61 * Server(s) configuration
63 * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
64 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
65 * to ''. If you want more than one server, just copy following section
66 * (including $i incrementation) several times. There is no need to define
67 * full server array, just define values you need to change.
69 * @global array $cfg['Servers']
71 $cfg['Servers'] = array();
76 * MySQL hostname or IP address
78 * @global string $cfg['Servers'][$i]['host']
80 $cfg['Servers'][$i]['host'] = 'localhost';
83 * MySQL port - leave blank for default port
85 * @global string $cfg['Servers'][$i]['port']
87 $cfg['Servers'][$i]['port'] = '';
90 * Path to the socket - leave blank for default socket
92 * @global string $cfg['Servers'][$i]['socket']
94 $cfg['Servers'][$i]['socket'] = '';
97 * Use SSL for connecting to MySQL server?
99 * @global boolean $cfg['Servers'][$i]['ssl']
101 $cfg['Servers'][$i]['ssl'] = false;
104 * How to connect to MySQL server ('tcp' or 'socket')
106 * @global string $cfg['Servers'][$i]['connect_type']
108 $cfg['Servers'][$i]['connect_type'] = 'tcp';
111 * The PHP MySQL extension to use ('mysql' or 'mysqli')
113 * @global string $cfg['Servers'][$i]['extension']
115 $cfg['Servers'][$i]['extension'] = 'mysql';
118 * Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
120 * @global boolean $cfg['Servers'][$i]['compress']
122 $cfg['Servers'][$i]['compress'] = false;
125 * MySQL control user settings (this user must have read-only
127 * @global string $cfg['Servers'][$i]['controluser']
129 $cfg['Servers'][$i]['controluser'] = '';
132 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
133 * used for all relational features (pmadb)
135 * @global string $cfg['Servers'][$i]['controlpass']
137 $cfg['Servers'][$i]['controlpass'] = '';
140 * Authentication method (valid choices: config, http, signon or cookie)
142 * @global string $cfg['Servers'][$i]['auth_type']
144 $cfg['Servers'][$i]['auth_type'] = 'config';
149 * @global string $cfg['Servers'][$i]['user']
151 $cfg['Servers'][$i]['user'] = 'root';
154 * MySQL password (only needed with 'config' auth_type)
156 * @global string $cfg['Servers'][$i]['password']
158 $cfg['Servers'][$i]['password'] = '';
161 * Session to use for 'signon' authentication method
163 * @global string $cfg['Servers'][$i]['SignonSession']
165 $cfg['Servers'][$i]['SignonSession'] = '';
168 * URL where to redirect user to login for 'signon' authentication method
170 * @global string $cfg['Servers'][$i]['SignonURL']
172 $cfg['Servers'][$i]['SignonURL'] = '';
175 * URL where to redirect user after logout
177 * @global string $cfg['Servers'][$i]['LogoutURL']
179 $cfg['Servers'][$i]['LogoutURL'] = '';
182 * Whether to try to connect without password
184 * @global boolean $cfg['Servers'][$i]['nopassword']
186 $cfg['Servers'][$i]['nopassword'] = false;
189 * If set to a db-name, only this db is displayed in left frame
190 * It may also be an array of db-names, where sorting order is relevant.
192 * @global string $cfg['Servers'][$i]['only_db']
194 $cfg['Servers'][$i]['only_db'] = '';
197 * Database name to be hidden from listings
199 * @global string $cfg['Servers'][$i]['hide_db']
201 $cfg['Servers'][$i]['hide_db'] = '';
204 * Verbose name for this host - leave blank to show the hostname
205 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
207 * @global string $cfg['Servers'][$i]['verbose']
209 $cfg['Servers'][$i]['verbose'] = '';
212 * Database used for Relation, Bookmark and PDF Features
213 * (see scripts/create_tables.sql)
214 * - leave blank for no support
215 * DEFAULT: 'phpmyadmin'
217 * @global string $cfg['Servers'][$i]['pmadb']
219 $cfg['Servers'][$i]['pmadb'] = '';
223 * - leave blank for no bookmark support
224 * DEFAULT: 'pma_bookmark'
226 * @global string $cfg['Servers'][$i]['bookmarktable']
228 $cfg['Servers'][$i]['bookmarktable'] = '';
231 * table to describe the relation between links (see doc)
232 * - leave blank for no relation-links support
233 * DEFAULT: 'pma_relation'
235 * @global string $cfg['Servers'][$i]['relation']
237 $cfg['Servers'][$i]['relation'] = '';
240 * table to describe the display fields
241 * - leave blank for no display fields support
242 * DEFAULT: 'pma_table_info'
244 * @global string $cfg['Servers'][$i]['table_info']
246 $cfg['Servers'][$i]['table_info'] = '';
249 * table to describe the tables position for the PDF schema
250 * - leave blank for no PDF schema support
251 * DEFAULT: 'pma_table_coords'
253 * @global string $cfg['Servers'][$i]['table_coords']
255 $cfg['Servers'][$i]['table_coords'] = '';
258 * table to describe pages of relationpdf
259 * - leave blank if you don't want to use this
260 * DEFAULT: 'pma_pdf_pages'
262 * @global string $cfg['Servers'][$i]['pdf_pages']
264 $cfg['Servers'][$i]['pdf_pages'] = '';
267 * table to store column information
268 * - leave blank for no column comments/mime types
269 * DEFAULT: 'pma_column_info'
271 * @global string $cfg['Servers'][$i]['column_info']
273 $cfg['Servers'][$i]['column_info'] = '';
276 * table to store SQL history
277 * - leave blank for no SQL query history
278 * DEFAULT: 'pma_history'
280 * @global string $cfg['Servers'][$i]['history']
282 $cfg['Servers'][$i]['history'] = '';
285 * table to store the coordinates for Designer
286 * - leave blank for no Designer feature
287 * DEFAULT: 'pma_designer_coords'
289 * @global string $cfg['Servers'][$i]['designer_coords']
291 $cfg['Servers'][$i]['designer_coords'] = '';
294 * set to false if you know that your pma_* tables are up to date.
295 * This prevents compatibility checks and thereby increases performance.
297 * @global boolean $cfg['Servers'][$i]['verbose_check']
299 $cfg['Servers'][$i]['verbose_check'] = true;
302 * whether to allow root login
304 * @global boolean $cfg['Servers'][$i]['AllowRoot']
306 $cfg['Servers'][$i]['AllowRoot'] = true;
309 * Host authentication order, leave blank to not use
311 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
313 $cfg['Servers'][$i]['AllowDeny']['order'] = '';
316 * Host authentication rules, leave blank for defaults
318 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
320 $cfg['Servers'][$i]['AllowDeny']['rules'] = array();
323 * Default server (0 = no default server)
325 * If you have more than one server configured, you can set $cfg['ServerDefault']
326 * to any one of them to auto-connect to that server when phpMyAdmin is started,
327 * or set it to 0 to be given a list of servers without logging in
328 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
329 * set to that server.
331 * @global integer $cfg['ServerDefault']
333 $cfg['ServerDefault'] = 1;
336 * Other core phpMyAdmin settings
339 * maximum number of db's displayed in left frame and database list
341 * @global integer $cfg['MaxDbList']
343 $cfg['MaxDbList'] = 100;
346 * maximum number of tables displayed in table list
348 * @global integer $cfg['MaxTableList']
350 $cfg['MaxTableList'] = 250;
353 * maximum number of characters when a SQL query is displayed
355 * @global integer $cfg['MaxCharactersInDisplayedSQL']
357 $cfg['MaxCharactersInDisplayedSQL'] = 1000;
360 * use GZIP output buffering if possible (true|false|'auto')
362 * @global string $cfg['OBGzip']
364 $cfg['OBGzip'] = 'auto';
367 * use persistent connections to MySQL database
369 * @global boolean $cfg['PersistentConnections']
371 $cfg['PersistentConnections'] = false;
374 * whether to force using HTTPS
376 * @global boolean $cfg['ForceSSL']
378 $cfg['ForceSSL'] = false;
381 * maximum execution time in seconds (0 for no limit)
383 * @global integer $cfg['ExecTimeLimit']
385 $cfg['ExecTimeLimit'] = 300;
388 * maximum allocated bytes (0 for no limit)
390 * @global integer $cfg['MemoryLimit']
392 $cfg['MemoryLimit'] = 0;
395 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
397 * @global boolean $cfg['SkipLockedTables']
399 $cfg['SkipLockedTables'] = false;
402 * show SQL queries as run
404 * @global boolean $cfg['ShowSQL']
406 $cfg['ShowSQL'] = true;
409 * show a 'Drop database' link to normal users
411 * @global boolean $cfg['AllowUserDropDatabase']
413 $cfg['AllowUserDropDatabase'] = false;
416 * confirm 'DROP TABLE' & 'DROP DATABASE'
418 * @global boolean $cfg['Confirm']
420 $cfg['Confirm'] = true;
423 * recall previous login in cookie authentication mode or not
425 * @global boolean $cfg['LoginCookieRecall']
427 $cfg['LoginCookieRecall'] = true;
430 * validity of cookie login (in seconds)
432 * @global integer $cfg['LoginCookieValidity']
434 $cfg['LoginCookieValidity'] = 1800;
437 * how long login cookie should be stored (in seconds)
439 * @global integer $cfg['LoginCookieStore']
441 $cfg['LoginCookieStore'] = 0;
444 * whether to delete all login cookies on logout
446 * @global boolean $cfg['LoginCookieDeleteAll']
448 $cfg['LoginCookieDeleteAll'] = true;
451 * whether to enable the "database search" feature or not
453 * @global boolean $cfg['UseDbSearch']
455 $cfg['UseDbSearch'] = true;
458 * if set to true, PMA continues computing multiple-statement queries
459 * even if one of the queries failed
461 * @global boolean $cfg['IgnoreMultiSubmitErrors']
463 $cfg['IgnoreMultiSubmitErrors'] = false;
466 * if set to true, PMA will show the affected rows of EACH statement on
467 * multiple-statement queries. See the libraries/import.php file for
468 * hard coded defaults on how many queries a statement may contain!
470 * @global boolean $cfg['VerboseMultiSubmit']
472 $cfg['VerboseMultiSubmit'] = true;
475 * allow login to any user entered server in cookie based authentication
477 * @global boolean $cfg['AllowArbitraryServer']
479 $cfg['AllowArbitraryServer'] = false;
482 /*******************************************************************************
487 * use a select-based menu and display only the current tables in the left frame.
489 * @global boolean $cfg['LeftFrameLight']
491 $cfg['LeftFrameLight'] = true;
494 * turn the select-based light menu into a tree
496 * @global boolean $cfg['LeftFrameDBTree']
498 $cfg['LeftFrameDBTree'] = true;
501 * the separator to sub-tree the select-based light menu tree
503 * @global string $cfg['LeftFrameDBSeparator']
505 $cfg['LeftFrameDBSeparator'] = '_';
508 * Which string will be used to generate table prefixes
509 * to split/nest tables into multiple categories
511 * @global string $cfg['LeftFrameTableSeparator']
513 $cfg['LeftFrameTableSeparator']= '__';
516 * How many sublevels should be displayed when splitting up tables by the above Separator
518 * @global integer $cfg['LeftFrameTableLevel']
520 $cfg['LeftFrameTableLevel'] = '1';
523 * display table comment as tooltip in left frame
525 * @global boolean $cfg['ShowTooltip']
527 $cfg['ShowTooltip'] = true;
530 * if ShowToolTip is enabled, this defines that table/db comments
532 * @global boolean $cfg['ShowTooltipAliasDB']
534 $cfg['ShowTooltipAliasDB'] = false;
537 * are shown (in the left menu and db_structure) instead of table/db names.
538 * Setting ShowTooltipAliasTB to 'nested' will only use the Aliases for nested
539 * descriptors, not the table itself.
541 * @global boolean $cfg['ShowTooltipAliasTB']
543 $cfg['ShowTooltipAliasTB'] = false;
546 * display logo at top of left frame
548 * @global boolean $cfg['LeftDisplayLogo']
550 $cfg['LeftDisplayLogo'] = true;
553 * where should logo link point to (can also contain an external URL)
555 * @global string $cfg['LeftLogoLink']
557 $cfg['LeftLogoLink'] = 'main.php';
560 * whether to open the linked page in the main window ('main') or
561 * in a new window ('new')
563 * @global string $cfg['LeftLogoLinkWindow']
565 $cfg['LeftLogoLinkWindow'] = 'main';
568 * display server choice at top of left frame
570 * @global boolean $cfg['LeftDisplayServers']
572 $cfg['LeftDisplayServers'] = false;
575 * server choice as links
577 * @global boolean $cfg['DisplayServersList']
579 $cfg['DisplayServersList'] = false;
582 * database choice in light as links
584 * @global boolean $cfg['DisplayDatabasesList']
586 $cfg['DisplayDatabasesList'] = 'auto';
589 /*******************************************************************************
590 * In the main frame, at startup...
594 * allow to display statistics and space usage in the pages about database
595 * details and table properties
597 * @global boolean $cfg['ShowStats']
599 $cfg['ShowStats'] = true;
604 * @global boolean $cfg['ShowPhpInfo']
606 $cfg['ShowPhpInfo'] = false;
609 * show MySQL server information
611 * @global boolean $cfg['ShowServerInfo']
613 $cfg['ShowServerInfo'] = true;
616 * show change password link
618 * @global boolean $cfg['ShowChgPassword']
620 $cfg['ShowChgPassword'] = false;
623 * show create database form
625 * @global boolean $cfg['ShowCreateDb']
627 $cfg['ShowCreateDb'] = true;
630 * suggest a new DB name if possible (false = keep empty)
632 * @global boolean $cfg['SuggestDBName']
634 $cfg['SuggestDBName'] = true;
637 /*******************************************************************************
642 * display blob field contents
644 * @global boolean $cfg['ShowBlob']
646 $cfg['ShowBlob'] = false;
649 * Use icons instead of text for the navigation bar buttons
650 * and on right panel top menu (server db table) (true|false|'both')
652 * @global string $cfg['NavigationBarIconic']
654 $cfg['NavigationBarIconic'] = 'both';
657 * allows to display all the rows
659 * @global boolean $cfg['ShowAll']
661 $cfg['ShowAll'] = false;
664 * maximum number of rows to display
666 * @global integer $cfg['MaxRows']
668 $cfg['MaxRows'] = 30;
671 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
672 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
673 * ascending order else-)
675 * @global string $cfg['Order']
677 $cfg['Order'] = 'ASC';
680 /*******************************************************************************
685 * disallow editing of binary fields
687 * false allow editing
688 * 'blob' allow editing except for BLOB fields
689 * 'all' disallow editing
691 * @global string $cfg['ProtectBinary']
693 $cfg['ProtectBinary'] = 'blob';
696 * Display the function fields in edit/insert mode
698 * @global boolean $cfg['ShowFunctionFields']
700 $cfg['ShowFunctionFields'] = true;
703 * Which editor should be used for CHAR/VARCHAR fields:
704 * input - allows limiting of input length
705 * textarea - allows newlines in fields
707 * @global string $cfg['CharEditing']
709 $cfg['CharEditing'] = 'input';
712 * How many rows can be inserted at one time
714 * @global integer $cfg['InsertRows']
716 $cfg['InsertRows'] = 2;
719 * Sort order for items in a foreign-key drop-down list.
720 * 'content' is the referenced data, 'id' is the key value.
722 * @global array $cfg['ForeignKeyDropdownOrder']
724 $cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
727 * A drop-down list will be used if fewer items are present
729 * @global integer $cfg['ForeignKeyMaxLimit']
731 $cfg['ForeignKeyMaxLimit'] = 100;
734 /*******************************************************************************
735 * For the export features...
739 * Allow the use of zip/gzip/bzip
741 * @global boolean $cfg['ZipDump']
743 $cfg['ZipDump'] = true;
748 * @global boolean $cfg['GZipDump']
750 $cfg['GZipDump'] = true;
755 * @global boolean $cfg['BZipDump']
757 $cfg['BZipDump'] = true;
760 * Will compress gzip/bzip2 exports on fly without need for much memory.
761 * If you encounter problems with created gzip/bzip2 files disable this feature.
763 * @global boolean $cfg['CompressOnFly']
765 $cfg['CompressOnFly'] = true;
768 /*******************************************************************************
769 * Tabs display settings
773 * use graphically less intense menu tabs
775 * @global boolean $cfg['LightTabs']
777 $cfg['LightTabs'] = false;
780 * Use icons instead of text for the table display of a database (true|false|'both')
782 * @global boolean $cfg['PropertiesIconic']
784 $cfg['PropertiesIconic'] = true;
787 * How many columns should be used for table display of a database?
788 * (a value larger than 1 results in some information being hidden)
790 * @global integer $cfg['PropertiesNumColumns']
792 $cfg['PropertiesNumColumns'] = 1;
796 * 'main.php' = the welcome page
797 * (recommended for multiuser setups)
798 * 'server_databases.php' = list of databases
799 * 'server_status.php' = runtime information
800 * 'server_variables.php' = MySQL server variables
801 * 'server_privileges.php' = user management
802 * 'server_processlist.php' = process list
804 * @global string $cfg['DefaultTabServer']
806 $cfg['DefaultTabServer'] = 'main.php';
810 * 'db_structure.php' = tables list
811 * 'db_sql.php' = SQL form
812 * 'db_search.php' = search query
813 * 'db_operations.php' = operations on database
815 * @global string $cfg['DefaultTabDatabase']
817 $cfg['DefaultTabDatabase'] = 'db_structure.php';
821 * 'tbl_structure.php' = fields list
822 * 'tbl_sql.php' = SQL form
823 * 'tbl_select.php' = select page
824 * 'tbl_change.php' = insert row page
825 * 'sql.php' = browse page
827 * @global string $cfg['DefaultTabTable']
829 $cfg['DefaultTabTable'] = 'tbl_structure.php';
832 /*******************************************************************************
835 $cfg['Export'] = array();
838 * sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt
840 * @global string $cfg['Export']['format']
842 $cfg['Export']['format'] = 'sql';
845 * none/zip/gzip/bzip2
847 * @global string $cfg['Export']['compression']
849 $cfg['Export']['compression'] = 'none';
854 * @global boolean $cfg['Export']['asfile']
856 $cfg['Export']['asfile'] = false;
861 * @global string $cfg['Export']['charset']
863 $cfg['Export']['charset'] = '';
868 * @global boolean $cfg['Export']['onserver']
870 $cfg['Export']['onserver'] = false;
875 * @global boolean $cfg['Export']['onserver_overwrite']
877 $cfg['Export']['onserver_overwrite'] = false;
882 * @global boolean $cfg['Export']['remember_file_template']
884 $cfg['Export']['remember_file_template'] = true;
889 * @global string $cfg['Export']['file_template_table']
891 $cfg['Export']['file_template_table'] = '__TABLE__';
896 * @global string $cfg['Export']['file_template_database']
898 $cfg['Export']['file_template_database'] = '__DB__';
903 * @global string $cfg['Export']['file_template_server']
905 $cfg['Export']['file_template_server'] = '__SERVER__';
910 * @global boolean $cfg['Export']['ods_columns']
912 $cfg['Export']['ods_columns'] = false;
917 * @global string $cfg['Export']['ods_null']
919 $cfg['Export']['ods_null'] = 'NULL';
924 * @global boolean $cfg['Export']['odt_structure']
926 $cfg['Export']['odt_structure'] = true;
931 * @global boolean $cfg['Export']['odt_data']
933 $cfg['Export']['odt_data'] = true;
938 * @global boolean $cfg['Export']['odt_columns']
940 $cfg['Export']['odt_columns'] = true;
945 * @global boolean $cfg['Export']['odt_relation']
947 $cfg['Export']['odt_relation'] = true;
952 * @global boolean $cfg['Export']['odt_comments']
954 $cfg['Export']['odt_comments'] = true;
959 * @global boolean $cfg['Export']['odt_mime']
961 $cfg['Export']['odt_mime'] = true;
966 * @global string $cfg['Export']['odt_null']
968 $cfg['Export']['odt_null'] = 'NULL';
973 * @global boolean $cfg['Export']['htmlexcel_columns']
975 $cfg['Export']['htmlexcel_columns'] = false;
980 * @global string $cfg['Export']['htmlexcel_null']
982 $cfg['Export']['htmlexcel_null'] = 'NULL';
987 * @global boolean $cfg['Export']['htmlword_structure']
989 $cfg['Export']['htmlword_structure'] = true;
994 * @global boolean $cfg['Export']['htmlword_data']
996 $cfg['Export']['htmlword_data'] = true;
1001 * @global boolean $cfg['Export']['htmlword_columns']
1003 $cfg['Export']['htmlword_columns'] = false;
1008 * @global string $cfg['Export']['htmlword_null']
1010 $cfg['Export']['htmlword_null'] = 'NULL';
1015 * @global boolean $cfg['Export']['xls_columns']
1017 $cfg['Export']['xls_columns'] = false;
1022 * @global string $cfg['Export']['xls_null']
1024 $cfg['Export']['xls_null'] = 'NULL';
1029 * @global boolean $cfg['Export']['csv_columns']
1031 $cfg['Export']['csv_columns'] = false;
1036 * @global string $cfg['Export']['csv_null']
1038 $cfg['Export']['csv_null'] = 'NULL';
1043 * @global string $cfg['Export']['csv_separator']
1045 $cfg['Export']['csv_separator'] = ';';
1050 * @global string $cfg['Export']['csv_enclosed']
1052 $cfg['Export']['csv_enclosed'] = '"';
1057 * @global string $cfg['Export']['csv_escaped']
1059 $cfg['Export']['csv_escaped'] = '\\';
1064 * @global string $cfg['Export']['csv_terminated']
1066 $cfg['Export']['csv_terminated'] = 'AUTO';
1071 * @global boolean $cfg['Export']['excel_columns']
1073 $cfg['Export']['excel_columns'] = false;
1078 * @global string $cfg['Export']['excel_null']
1080 $cfg['Export']['excel_null'] = 'NULL';
1085 * @global string $cfg['Export']['excel_edition']
1087 $cfg['Export']['excel_edition'] = 'win';
1092 * @global boolean $cfg['Export']['latex_structure']
1094 $cfg['Export']['latex_structure'] = true;
1099 * @global boolean $cfg['Export']['latex_data']
1101 $cfg['Export']['latex_data'] = true;
1106 * @global boolean $cfg['Export']['latex_columns']
1108 $cfg['Export']['latex_columns'] = true;
1113 * @global boolean $cfg['Export']['latex_relation']
1115 $cfg['Export']['latex_relation'] = true;
1120 * @global boolean $cfg['Export']['latex_comments']
1122 $cfg['Export']['latex_comments'] = true;
1127 * @global boolean $cfg['Export']['latex_mime']
1129 $cfg['Export']['latex_mime'] = true;
1134 * @global string $cfg['Export']['latex_null']
1136 $cfg['Export']['latex_null'] = '\textit{NULL}';
1141 * @global boolean $cfg['Export']['latex_caption']
1143 $cfg['Export']['latex_caption'] = true;
1148 * @global string $cfg['Export']['latex_structure_caption']
1150 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1155 * @global string $cfg['Export']['latex_structure_continued_caption']
1157 $cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';
1162 * @global string $cfg['Export']['latex_data_caption']
1164 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
1169 * @global string $cfg['Export']['latex_data_continued_caption']
1171 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1176 * @global string $cfg['Export']['latex_data_label']
1178 $cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';
1183 * @global string $cfg['Export']['latex_structure_label']
1185 $cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';
1190 * @global boolean $cfg['Export']['sql_structure']
1192 $cfg['Export']['sql_structure'] = true;
1197 * @global boolean $cfg['Export']['sql_data']
1199 $cfg['Export']['sql_data'] = true;
1204 * @global string $cfg['Export']['sql_compatibility']
1206 $cfg['Export']['sql_compatibility'] = 'NONE';
1211 * @global boolean $cfg['Export']['sql_disable_fk']
1213 $cfg['Export']['sql_disable_fk'] = false;
1218 * @global boolean $cfg['Export']['sql_use_transaction']
1220 $cfg['Export']['sql_use_transaction'] = false;
1225 * @global boolean $cfg['Export']['sql_drop_database']
1227 $cfg['Export']['sql_drop_database'] = false;
1232 * @global boolean $cfg['Export']['sql_drop_table']
1234 $cfg['Export']['sql_drop_table'] = false;
1239 * @global boolean $cfg['Export']['sql_if_not_exists']
1240 * true by default for correct behavior when dealing with exporting
1241 * of VIEWs and the stand-in table
1243 $cfg['Export']['sql_if_not_exists'] = true;
1248 * @global boolean $cfg['Export']['sql_procedure_function']
1250 $cfg['Export']['sql_procedure_function'] = false;
1255 * @global boolean $cfg['Export']['sql_auto_increment']
1257 $cfg['Export']['sql_auto_increment'] = true;
1262 * @global boolean $cfg['Export']['sql_backquotes']
1264 $cfg['Export']['sql_backquotes'] = true;
1269 * @global boolean $cfg['Export']['sql_dates']
1271 $cfg['Export']['sql_dates'] = false;
1276 * @global boolean $cfg['Export']['sql_relation']
1278 $cfg['Export']['sql_relation'] = false;
1283 * @global boolean $cfg['Export']['sql_columns']
1285 $cfg['Export']['sql_columns'] = true;
1290 * @global boolean $cfg['Export']['sql_delayed']
1292 $cfg['Export']['sql_delayed'] = false;
1297 * @global boolean $cfg['Export']['sql_ignore']
1299 $cfg['Export']['sql_ignore'] = false;
1304 * @global boolean $cfg['Export']['sql_hex_for_blob']
1306 $cfg['Export']['sql_hex_for_blob'] = true;
1309 * insert/update/replace
1311 * @global string $cfg['Export']['sql_type']
1313 $cfg['Export']['sql_type'] = 'insert';
1318 * @global boolean $cfg['Export']['sql_extended']
1320 $cfg['Export']['sql_extended'] = true;
1325 * @global integer $cfg['Export']['sql_max_query_size']
1327 $cfg['Export']['sql_max_query_size'] = 50000;
1332 * @global boolean $cfg['Export']['sql_comments']
1334 $cfg['Export']['sql_comments'] = false;
1339 * @global boolean $cfg['Export']['sql_mime']
1341 $cfg['Export']['sql_mime'] = false;
1344 * \n is replaced by new line
1346 * @global string $cfg['Export']['sql_header_comment']
1348 $cfg['Export']['sql_header_comment'] = '';
1353 * @global boolean $cfg['Export']['pdf_structure']
1355 $cfg['Export']['pdf_structure'] = false;
1360 * @global boolean $cfg['Export']['pdf_data']
1362 $cfg['Export']['pdf_data'] = true;
1367 * @global string $cfg['Export']['pdf_report_title']
1369 $cfg['Export']['pdf_report_title'] = '';
1372 /*******************************************************************************
1375 $cfg['Import'] = array();
1380 * @global string $cfg['Import']['format']
1382 $cfg['Import']['format'] = 'sql';
1387 * @global boolean $cfg['Import']['allow_interrupt']
1389 $cfg['Import']['allow_interrupt'] = true;
1394 * @global integer $cfg['Import']['skip_queries']
1396 $cfg['Import']['skip_queries'] = '0';
1401 * @global string $cfg['Import']['sql_compatibility']
1403 $cfg['Import']['sql_compatibility'] = 'NONE';
1408 * @global boolean $cfg['Import']['csv_replace']
1410 $cfg['Import']['csv_replace'] = false;
1415 * @global string $cfg['Import']['csv_terminated']
1417 $cfg['Import']['csv_terminated'] = ';';
1422 * @global string $cfg['Import']['csv_enclosed']
1424 $cfg['Import']['csv_enclosed'] = '"';
1429 * @global string $cfg['Import']['csv_escaped']
1431 $cfg['Import']['csv_escaped'] = '\\';
1436 * @global string $cfg['Import']['csv_new_line']
1438 $cfg['Import']['csv_new_line'] = 'auto';
1443 * @global string $cfg['Import']['csv_columns']
1445 $cfg['Import']['csv_columns'] = '';
1450 * @global boolean $cfg['Import']['ldi_replace']
1452 $cfg['Import']['ldi_replace'] = false;
1457 * @global string $cfg['Import']['ldi_terminated']
1459 $cfg['Import']['ldi_terminated'] = ';';
1464 * @global string $cfg['Import']['ldi_enclosed']
1466 $cfg['Import']['ldi_enclosed'] = '"';
1471 * @global string $cfg['Import']['ldi_escaped']
1473 $cfg['Import']['ldi_escaped'] = '\\';
1478 * @global string $cfg['Import']['ldi_new_line']
1480 $cfg['Import']['ldi_new_line'] = 'auto';
1485 * @global string $cfg['Import']['ldi_columns']
1487 $cfg['Import']['ldi_columns'] = '';
1490 * 'auto' for auto-detection, true or false for forcing
1492 * @global string $cfg['Import']['ldi_local_option']
1494 $cfg['Import']['ldi_local_option'] = 'auto';
1497 * Link to the official MySQL documentation.
1498 * Be sure to include no trailing slash on the path.
1499 * See http://dev.mysql.com/doc/ for more information
1500 * about MySQL manuals and their types.
1502 * @global string $cfg['MySQLManualBase']
1504 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
1507 * Type of MySQL documentation:
1508 * viewable - "viewable online", current one used on MySQL website
1509 * searchable - "Searchable, with user comments"
1510 * chapters - "HTML, one page per chapter"
1511 * chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release
1512 * big - "HTML, all on one page"
1513 * old - old style used in phpMyAdmin 2.3.0 and sooner
1514 * none - do not show documentation links
1516 * @global string $cfg['MySQLManualType']
1518 $cfg['MySQLManualType'] = 'viewable';
1521 /*******************************************************************************
1528 * @global array $cfg['PDFPageSizes']
1530 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
1535 * @global string $cfg['PDFDefaultPageSize']
1537 $cfg['PDFDefaultPageSize'] = 'A4';
1540 /*******************************************************************************
1541 * Language and character set conversion settings
1545 * Default language to use, if not browser-defined or user-defined
1547 * @global string $cfg['DefaultLang']
1549 $cfg['DefaultLang'] = 'en-iso-8859-1';
1552 * Default connection collation (used for MySQL >= 4.1)
1554 * @global string $cfg['DefaultConnectionCollation']
1556 $cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';
1559 * Force: always use this language - must be defined in
1560 * libraries/select_lang.lib.php
1561 * $cfg['Lang'] = 'en-iso-8859-1';
1563 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
1566 * @global string $cfg['FilterLanguages']
1568 $cfg['FilterLanguages'] = '';
1571 * Default character set to use for recoding of MySQL queries, does not take
1572 * any effect when character sets recoding is switched off by
1573 * $cfg['AllowAnywhereRecoding'] or in language file
1574 * (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
1576 * @global string $cfg['DefaultCharset']
1578 $cfg['DefaultCharset'] = 'iso-8859-1';
1581 * Allow character set recoding of MySQL queries, must be also enabled in language
1582 * file to make harder using other language files than Unicode.
1583 * Default value is false to avoid problems on servers without the iconv
1584 * extension and where dl() is not supported
1586 * @global boolean $cfg['AllowAnywhereRecoding']
1588 $cfg['AllowAnywhereRecoding'] = false;
1591 * You can select here which functions will be used for character set conversion.
1592 * Possible values are:
1593 * auto - automatically use available one (first is tested iconv, then
1595 * iconv - use iconv or libiconv functions
1596 * recode - use recode_string function
1598 * @global string $cfg['RecodingEngine']
1600 $cfg['RecodingEngine'] = 'auto';
1603 * Specify some parameters for iconv used in character set conversion. See iconv
1604 * documentation for details:
1605 * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
1607 * @global string $cfg['IconvExtraParams']
1609 $cfg['IconvExtraParams'] = '//TRANSLIT';
1612 * Available character sets for MySQL conversion. currently contains all which could
1613 * be found in lang/* files and few more.
1614 * Character sets will be shown in same order as here listed, so if you frequently
1615 * use some of these move them to the top.
1617 * @global array $cfg['AvailableCharsets']
1619 $cfg['AvailableCharsets'] = array(
1654 /*******************************************************************************
1655 * Customization & design
1657 * The graphical settings are now located in themes/theme-name/layout.inc.php
1661 * enable the left panel pointer
1662 * (used when LeftFrameLight is false)
1663 * see also LeftPointerColor
1666 * @global boolean $cfg['LeftPointerEnable']
1668 $cfg['LeftPointerEnable'] = true;
1671 * enable the browse pointer
1672 * see also BrowsePointerColor
1675 * @global boolean $cfg['BrowsePointerEnable']
1677 $cfg['BrowsePointerEnable'] = true;
1680 * enable the browse marker
1681 * see also BrowseMarkerColor
1684 * @global boolean $cfg['BrowseMarkerEnable']
1686 $cfg['BrowseMarkerEnable'] = true;
1689 * textarea size (columns) in edit mode
1690 * (this value will be emphasized (*2) for SQL
1691 * query textareas and (*1.25) for query window)
1693 * @global integer $cfg['TextareaCols']
1695 $cfg['TextareaCols'] = 40;
1698 * textarea size (rows) in edit mode
1700 * @global integer $cfg['TextareaRows']
1702 $cfg['TextareaRows'] = 7;
1705 * double size of textarea size for LONGTEXT fields
1707 * @global boolean $cfg['LongtextDoubleTextarea']
1709 $cfg['LongtextDoubleTextarea'] = true;
1712 * auto-select when clicking in the textarea of the query-box
1714 * @global boolean $cfg['TextareaAutoSelect']
1716 $cfg['TextareaAutoSelect'] = true;
1719 * textarea size (columns) for CHAR/VARCHAR
1721 * @global integer $cfg['CharTextareaCols']
1723 $cfg['CharTextareaCols'] = 40;
1726 * textarea size (rows) for CHAR/VARCHAR
1728 * @global integer $cfg['CharTextareaRows']
1730 $cfg['CharTextareaRows'] = 2;
1733 * Enable Ctrl+Arrows moving between fields when editing?
1735 * @global boolean $cfg['CtrlArrowsMoving']
1737 $cfg['CtrlArrowsMoving'] = true;
1740 * Max field data length in browse mode for all non-numeric fields
1742 * @global integer $cfg['LimitChars']
1744 $cfg['LimitChars'] = 50;
1747 * show edit/delete links on left side of browse
1748 * (or at the top with vertical browse)
1750 * @global boolean $cfg['ModifyDeleteAtLeft']
1752 $cfg['ModifyDeleteAtLeft'] = true;
1755 * show edit/delete links on right side of browse
1756 * (or at the bottom with vertical browse)
1758 * @global boolean $cfg['ModifyDeleteAtRight']
1760 $cfg['ModifyDeleteAtRight'] = false;
1763 * default display direction (horizontal|vertical|horizontalflipped)
1765 * @global string $cfg['DefaultDisplay']
1767 $cfg['DefaultDisplay'] = 'horizontal';
1770 * default display direction for altering/creating columns (tbl_properties)
1771 * (horizontal|vertical|<number>)
1772 * number indicates maximal number for which vertical model is used
1774 * @global integer $cfg['DefaultPropDisplay']
1776 $cfg['DefaultPropDisplay'] = 3;
1779 * table-header rotation via faking or CSS? (css|fake)
1780 * NOTE: CSS only works in IE browsers!
1782 * @global string $cfg['HeaderFlipType']
1784 $cfg['HeaderFlipType'] = 'css';
1787 * shows stored relation-comments in 'browse' mode.
1789 * @global boolean $cfg['ShowBrowseComments']
1791 $cfg['ShowBrowseComments'] = true;
1794 * shows stored relation-comments in 'table property' mode.
1796 * @global boolean $cfg['ShowPropertyComments']
1798 $cfg['ShowPropertyComments']= true;
1801 * repeat header names every X cells? (0 = deactivate)
1803 * @global integer $cfg['RepeatCells']
1805 $cfg['RepeatCells'] = 100;
1808 * Set to true if Edit link should open the query to edit in the query window
1809 * (assuming JavaScript is enabled), and to false if we should edit in the right panel
1811 * @global boolean $cfg['EditInWindow']
1813 $cfg['EditInWindow'] = true;
1816 * Width of Query window
1818 * @global integer $cfg['QueryWindowWidth']
1820 $cfg['QueryWindowWidth'] = 550;
1823 * Height of Query window
1825 * @global integer $cfg['QueryWindowHeight']
1827 $cfg['QueryWindowHeight'] = 310;
1830 * Set to true if you want DB-based query history.If false, this utilizes
1831 * JS-routines to display query history (lost by window close)
1833 * @global boolean $cfg['QueryHistoryDB']
1835 $cfg['QueryHistoryDB'] = false;
1838 * which tab to display in the querywindow on startup
1839 * (sql|files|history|full)
1841 * @global string $cfg['QueryWindowDefTab']
1843 $cfg['QueryWindowDefTab'] = 'sql';
1846 * When using DB-based query history, how many entries should be kept?
1848 * @global integer $cfg['QueryHistoryMax']
1850 $cfg['QueryHistoryMax'] = 25;
1853 * Use MIME-Types (stored in column comments table) for
1855 * @global boolean $cfg['BrowseMIME']
1857 $cfg['BrowseMIME'] = true;
1860 * When approximate count < this, PMA will get exact count for table rows.
1862 * @global integer $cfg['MaxExactCount']
1864 $cfg['MaxExactCount'] = 20000;
1867 * Zero means that no row count is done for views; see the doc
1869 * @global integer $cfg['MaxExactCountViews']
1871 $cfg['MaxExactCountViews'] = 0;
1874 * Utilize DHTML/JS capabilities to allow WYSIWYG editing of
1875 * the PDF page editor. Requires an IE6/Gecko based browser.
1877 * @global boolean $cfg['WYSIWYG-PDF']
1879 $cfg['WYSIWYG-PDF'] = true;
1882 * Sort table and database in natural order
1884 * @global boolean $cfg['NaturalOrder']
1886 $cfg['NaturalOrder'] = true;
1889 //-----------------------------------------------------------------------------
1890 // custom-setup by mkkeck: 2004-05-04
1891 // some specials for new icons and scrolling
1893 * @todo 2004-05-08 rabus: We need to rearrange these variables.
1897 /*******************************************************************************
1898 * Window title settings
1902 * title of browser window when a table is selected
1904 * @global string $cfg['TitleTable']
1906 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
1909 * title of browser window when a database is selected
1911 * @global string $cfg['TitleDatabase']
1913 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
1916 * title of browser window when a server is selected
1918 * @global string $cfg['TitleServer']
1920 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
1923 * title of browser window when nothing is selected
1924 * @global string $cfg['TitleDefault']
1926 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
1929 * show some icons for warning, error and information messages (true|false)?
1931 * @global boolean $cfg['ErrorIconic']
1933 $cfg['ErrorIconic'] = true;
1936 * show icons in list on main page and on menu tabs (true|false)?
1938 * @global boolean $cfg['MainPageIconic']
1940 $cfg['MainPageIconic'] = true;
1943 * show help button instead of strDocu (true|false)?
1945 * @global boolean $cfg['ReplaceHelpImg']
1947 $cfg['ReplaceHelpImg'] = true;
1950 /*******************************************************************************
1955 * using themes manager please set up here the path to 'themes' else leave empty
1957 * @global string $cfg['ThemePath']
1959 $cfg['ThemePath'] = './themes';
1962 * if you want to use selectable themes and if ThemesPath not empty
1963 * set it to true, else set it to false (default is false);
1965 * @global boolean $cfg['ThemeManager']
1967 $cfg['ThemeManager'] = true;
1970 * set up default theme, if ThemePath not empty you can set up here an valid
1971 * path to themes or 'original' for the original pma-theme
1973 * @global string $cfg['ThemeDefault']
1975 $cfg['ThemeDefault'] = 'original';
1978 * allow different theme for each configured server
1980 * @global boolean $cfg['ThemePerServer']
1982 $cfg['ThemePerServer'] = false;
1985 /*******************************************************************************
1991 * %d will be replaced by the database name.
1992 * %t will be replaced by the table name.
1993 * %f will be replaced by a list of field names.
1994 * (%t and %f only applies to DefaultQueryTable)
1996 * @global string $cfg['DefaultQueryTable']
1998 $cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';
2002 * %d will be replaced by the database name.
2003 * %t will be replaced by the table name.
2004 * %f will be replaced by a list of field names.
2005 * (%t and %f only applies to DefaultQueryTable)
2007 * @global string $cfg['DefaultQueryDatabase']
2009 $cfg['DefaultQueryDatabase'] = '';
2012 /*******************************************************************************
2013 * SQL Query box settings
2014 * These are the links display in all of the SQL Query boxes
2016 * @global array $cfg['SQLQuery']
2018 $cfg['SQLQuery'] = array();
2021 * Edit link to change a query
2023 * @global boolean $cfg['SQLQuery']['Edit']
2025 $cfg['SQLQuery']['Edit'] = true;
2028 * EXPLAIN on SELECT queries
2030 * @global boolean $cfg['SQLQuery']['Explain']
2032 $cfg['SQLQuery']['Explain'] = true;
2035 * Wrap a query in PHP
2037 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2039 $cfg['SQLQuery']['ShowAsPHP'] = true;
2042 * Validate a query (see $cfg['SQLValidator'] as well)
2044 * @global boolean $cfg['SQLQuery']['Validate']
2046 $cfg['SQLQuery']['Validate'] = false;
2049 * Refresh the results page
2051 * @global boolean $cfg['SQLQuery']['Refresh']
2053 $cfg['SQLQuery']['Refresh'] = true;
2056 /*******************************************************************************
2057 * Web server upload/save/import directories
2061 * Directory for uploaded files that can be executed by phpMyAdmin.
2062 * For example './upload'. Leave empty for no upload directory support.
2063 * Use %u for username inclusion.
2065 * @global string $cfg['UploadDir']
2067 $cfg['UploadDir'] = '';
2070 * Directory where phpMyAdmin can save exported data on server.
2071 * For example './save'. Leave empty for no save directory support.
2072 * Use %u for username inclusion.
2074 * @global string $cfg['SaveDir']
2076 $cfg['SaveDir'] = '';
2079 * Directory where phpMyAdmin can save temporary files.
2080 * This is needed for MS Excel export, see documentation how to enable that.
2082 * @global string $cfg['TempDir']
2084 $cfg['TempDir'] = '';
2092 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2093 * which is a bit expensive for PHP < 4.3.0, but it is the only safe way how to
2094 * determine GD version.
2096 * @global string $cfg['GD2Available']
2098 $cfg['GD2Available'] = 'auto';
2101 * List of trusted proxies for IP allow/deny
2103 * @global array $cfg['TrustedProxies']
2105 $cfg['TrustedProxies'] = array();
2108 /*******************************************************************************
2109 * SQL Parser Settings
2111 * @global array $cfg['SQP']
2113 $cfg['SQP'] = array();
2116 * Pretty-printing style to use on queries (html, text, none)
2118 * @global string $cfg['SQP']['fmtType']
2120 $cfg['SQP']['fmtType'] = 'html';
2123 * Amount to indent each level (floats are valid)
2125 * @global integer $cfg['SQP']['fmtInd']
2127 $cfg['SQP']['fmtInd'] = '1';
2130 * Units for indenting each level (CSS Types - {em, px, pt})
2132 * @global string $cfg['SQP']['fmtIndUnit']
2134 $cfg['SQP']['fmtIndUnit'] = 'em';
2137 /*******************************************************************************
2138 * If you wish to use the SQL Validator service, you should be aware of the
2140 * All SQL statements are stored anonymously for statistical purposes.
2141 * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
2142 * All rights reserved.
2144 * @global array $cfg['SQLValidator']
2146 $cfg['SQLValidator'] = array();
2149 * Make the SQL Validator available
2151 * @global boolean $cfg['SQLValidator']['use']
2153 $cfg['SQLValidator']['use'] = false;
2156 * If you have a custom username, specify it here (defaults to anonymous)
2158 * @global string $cfg['SQLValidator']['username']
2160 $cfg['SQLValidator']['username'] = '';
2163 * Password for username
2165 * @global string $cfg['SQLValidator']['password']
2167 $cfg['SQLValidator']['password'] = '';
2170 /*******************************************************************************
2172 * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
2174 * @global array $cfg['DBG']
2176 $cfg['DBG'] = array();
2179 * Make the DBG stuff available
2181 * @global boolean $cfg['DBG']['enable']
2183 $cfg['DBG']['enable'] = false;
2186 * Produce profiling results of PHP
2188 * @global boolean $cfg['DBG']['profile']['enable']
2190 $cfg['DBG']['profile']['enable'] = false;
2193 * Threshold of long running code to display
2194 * Anything below the threshold is not displayed
2196 * @global float $cfg['DBG']['profile']['threshold']
2198 $cfg['DBG']['profile']['threshold'] = 0.5;
2201 /*******************************************************************************
2207 * VARCHAR, TINYINT, TEXT and DATE are listed first, based on estimated popularity
2209 * @global array $cfg['ColumnTypes']
2211 $cfg['ColumnTypes'] = array(
2243 * Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically
2244 * for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php
2246 * @global array $cfg['AttributeTypes']
2248 $cfg['AttributeTypes'] = array(
2256 if ($cfg['ShowFunctionFields']) {
2258 * Available functions
2260 * @global array $cfg['Functions']
2262 $cfg['Functions'] = array(
2300 * Which column types will be mapped to which Group?
2302 * @global array $cfg['RestrictColumnTypes']
2304 $cfg['RestrictColumnTypes'] = array(
2305 'VARCHAR' => 'FUNC_CHAR',
2306 'TINYINT' => 'FUNC_NUMBER',
2307 'TEXT' => 'FUNC_CHAR',
2308 'DATE' => 'FUNC_DATE',
2309 'SMALLINT' => 'FUNC_NUMBER',
2310 'MEDIUMINT' => 'FUNC_NUMBER',
2311 'INT' => 'FUNC_NUMBER',
2312 'BIGINT' => 'FUNC_NUMBER',
2313 'FLOAT' => 'FUNC_NUMBER',
2314 'DOUBLE' => 'FUNC_NUMBER',
2315 'DECIMAL' => 'FUNC_NUMBER',
2316 'DATETIME' => 'FUNC_DATE',
2317 'TIMESTAMP' => 'FUNC_DATE',
2318 'TIME' => 'FUNC_DATE',
2319 'YEAR' => 'FUNC_DATE',
2320 'CHAR' => 'FUNC_CHAR',
2321 'TINYBLOB' => 'FUNC_CHAR',
2322 'TINYTEXT' => 'FUNC_CHAR',
2323 'BLOB' => 'FUNC_CHAR',
2324 'MEDIUMBLOB' => 'FUNC_CHAR',
2325 'MEDIUMTEXT' => 'FUNC_CHAR',
2326 'LONGBLOB' => 'FUNC_CHAR',
2327 'LONGTEXT' => 'FUNC_CHAR',
2333 * Map above defined groups to any function
2335 * @global array $cfg['RestrictFunctions']
2337 $cfg['RestrictFunctions'] = array(
2338 'FUNC_CHAR' => array(
2358 'FUNC_DATE' => array(
2374 'FUNC_NUMBER' => array(
2390 * Default functions for above defined groups
2392 * @global array $cfg['DefaultFunctions']
2394 $cfg['DefaultFunctions'] = array(
2397 'FUNC_NUMBER' => '',
2398 'first_timestamp' => 'NOW'
2407 * @global array $cfg['NumOperators']
2409 $cfg['NumOperators'] = array(
2423 * @global array $cfg['TextOperators']
2425 $cfg['TextOperators'] = array(
2438 * @global array $cfg['EnumOperators']
2440 $cfg['EnumOperators'] = array(
2448 * @global array $cfg['SetOperators']
2450 $cfg['SetOperators'] = array(
2458 * @global array $cfg['NullOperators']
2460 $cfg['NullOperators'] = array(
2468 * @global array $cfg['UnaryOperators']
2470 $cfg['UnaryOperators'] = array(