alternate --ALL-- fix
[openemr.git] / phpmyadmin / libraries / config.default.php
blob3dabe496de15226fa566c0d313b38d693d5d880a
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
4 * <code>
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 !!
10 * </code>
12 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
14 * phpMyAdmin default configuration, you can copy values from here to your
15 * config.inc.php
17 * All directives are explained in Documentation.html
19 * @version $Id$
22 /**
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'] = '';
41 /**
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;
49 /**
50 * Disable the default warning that is displayed if Suhosin is detected
52 * @global boolean $cfg['SuhosinDisableWarning']
54 $cfg['SuhosinDisableWarning'] = false;
56 /**
57 * Allows phpMyAdmin to be included from a document located on
58 * another domain; setting this to true is a potential security hole
60 * @global boolean $cfg['AllowThirdPartyFraming']
62 $cfg['AllowThirdPartyFraming'] = false;
64 /**
65 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
66 * at least one server configuration uses 'cookie' auth_type, enter here a
67 * pass phrase that will be used by blowfish. The maximum length seems to be 46
68 * characters.
70 * @global string $cfg['blowfish_secret']
72 $cfg['blowfish_secret'] = '';
75 /*******************************************************************************
76 * Server(s) configuration
78 * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
79 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
80 * to ''. If you want more than one server, just copy following section
81 * (including $i incrementation) several times. There is no need to define
82 * full server array, just define values you need to change.
84 * @global array $cfg['Servers']
86 $cfg['Servers'] = array();
88 $i = 1;
90 /**
91 * MySQL hostname or IP address
93 * @global string $cfg['Servers'][$i]['host']
95 $cfg['Servers'][$i]['host'] = 'localhost';
97 /**
98 * MySQL port - leave blank for default port
100 * @global string $cfg['Servers'][$i]['port']
102 $cfg['Servers'][$i]['port'] = '';
105 * Path to the socket - leave blank for default socket
107 * @global string $cfg['Servers'][$i]['socket']
109 $cfg['Servers'][$i]['socket'] = '';
112 * Use SSL for connecting to MySQL server?
114 * @global boolean $cfg['Servers'][$i]['ssl']
116 $cfg['Servers'][$i]['ssl'] = false;
119 * How to connect to MySQL server ('tcp' or 'socket')
121 * @global string $cfg['Servers'][$i]['connect_type']
123 $cfg['Servers'][$i]['connect_type'] = 'tcp';
126 * The PHP MySQL extension to use ('mysql' or 'mysqli')
128 * @global string $cfg['Servers'][$i]['extension']
130 $cfg['Servers'][$i]['extension'] = 'mysql';
133 * Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
135 * @global boolean $cfg['Servers'][$i]['compress']
137 $cfg['Servers'][$i]['compress'] = false;
140 * MySQL control user settings (this user must have read-only
142 * @global string $cfg['Servers'][$i]['controluser']
144 $cfg['Servers'][$i]['controluser'] = '';
147 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
148 * used for all relational features (pmadb)
150 * @global string $cfg['Servers'][$i]['controlpass']
152 $cfg['Servers'][$i]['controlpass'] = '';
155 * Authentication method (valid choices: config, http, signon or cookie)
157 * @global string $cfg['Servers'][$i]['auth_type']
159 $cfg['Servers'][$i]['auth_type'] = 'config';
162 * MySQL user
164 * @global string $cfg['Servers'][$i]['user']
166 $cfg['Servers'][$i]['user'] = 'root';
169 * MySQL password (only needed with 'config' auth_type)
171 * @global string $cfg['Servers'][$i]['password']
173 $cfg['Servers'][$i]['password'] = '';
176 * Session to use for 'signon' authentication method
178 * @global string $cfg['Servers'][$i]['SignonSession']
180 $cfg['Servers'][$i]['SignonSession'] = '';
183 * URL where to redirect user to login for 'signon' authentication method
185 * @global string $cfg['Servers'][$i]['SignonURL']
187 $cfg['Servers'][$i]['SignonURL'] = '';
190 * URL where to redirect user after logout
192 * @global string $cfg['Servers'][$i]['LogoutURL']
194 $cfg['Servers'][$i]['LogoutURL'] = '';
197 * Whether to try to connect without password
199 * @global boolean $cfg['Servers'][$i]['nopassword']
201 $cfg['Servers'][$i]['nopassword'] = false;
204 * If set to a db-name, only this db is displayed in left frame
205 * It may also be an array of db-names, where sorting order is relevant.
207 * @global string $cfg['Servers'][$i]['only_db']
209 $cfg['Servers'][$i]['only_db'] = '';
212 * Database name to be hidden from listings
214 * @global string $cfg['Servers'][$i]['hide_db']
216 $cfg['Servers'][$i]['hide_db'] = '';
219 * Verbose name for this host - leave blank to show the hostname
220 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
222 * @global string $cfg['Servers'][$i]['verbose']
224 $cfg['Servers'][$i]['verbose'] = '';
227 * Database used for Relation, Bookmark and PDF Features
228 * (see scripts/create_tables.sql)
229 * - leave blank for no support
230 * DEFAULT: 'phpmyadmin'
232 * @global string $cfg['Servers'][$i]['pmadb']
234 $cfg['Servers'][$i]['pmadb'] = '';
237 * Bookmark table
238 * - leave blank for no bookmark support
239 * DEFAULT: 'pma_bookmark'
241 * @global string $cfg['Servers'][$i]['bookmarktable']
243 $cfg['Servers'][$i]['bookmarktable'] = '';
246 * table to describe the relation between links (see doc)
247 * - leave blank for no relation-links support
248 * DEFAULT: 'pma_relation'
250 * @global string $cfg['Servers'][$i]['relation']
252 $cfg['Servers'][$i]['relation'] = '';
255 * table to describe the display fields
256 * - leave blank for no display fields support
257 * DEFAULT: 'pma_table_info'
259 * @global string $cfg['Servers'][$i]['table_info']
261 $cfg['Servers'][$i]['table_info'] = '';
264 * table to describe the tables position for the PDF schema
265 * - leave blank for no PDF schema support
266 * DEFAULT: 'pma_table_coords'
268 * @global string $cfg['Servers'][$i]['table_coords']
270 $cfg['Servers'][$i]['table_coords'] = '';
273 * table to describe pages of relationpdf
274 * - leave blank if you don't want to use this
275 * DEFAULT: 'pma_pdf_pages'
277 * @global string $cfg['Servers'][$i]['pdf_pages']
279 $cfg['Servers'][$i]['pdf_pages'] = '';
282 * table to store column information
283 * - leave blank for no column comments/mime types
284 * DEFAULT: 'pma_column_info'
286 * @global string $cfg['Servers'][$i]['column_info']
288 $cfg['Servers'][$i]['column_info'] = '';
291 * table to store SQL history
292 * - leave blank for no SQL query history
293 * DEFAULT: 'pma_history'
295 * @global string $cfg['Servers'][$i]['history']
297 $cfg['Servers'][$i]['history'] = '';
300 * table to store the coordinates for Designer
301 * - leave blank for no Designer feature
302 * DEFAULT: 'pma_designer_coords'
304 * @global string $cfg['Servers'][$i]['designer_coords']
306 $cfg['Servers'][$i]['designer_coords'] = '';
309 * set to false if you know that your pma_* tables are up to date.
310 * This prevents compatibility checks and thereby increases performance.
312 * @global boolean $cfg['Servers'][$i]['verbose_check']
314 $cfg['Servers'][$i]['verbose_check'] = true;
317 * whether to allow root login
319 * @global boolean $cfg['Servers'][$i]['AllowRoot']
321 $cfg['Servers'][$i]['AllowRoot'] = true;
324 * Host authentication order, leave blank to not use
326 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
328 $cfg['Servers'][$i]['AllowDeny']['order'] = '';
331 * Host authentication rules, leave blank for defaults
333 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
335 $cfg['Servers'][$i]['AllowDeny']['rules'] = array();
338 * Default server (0 = no default server)
340 * If you have more than one server configured, you can set $cfg['ServerDefault']
341 * to any one of them to auto-connect to that server when phpMyAdmin is started,
342 * or set it to 0 to be given a list of servers without logging in
343 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
344 * set to that server.
346 * @global integer $cfg['ServerDefault']
348 $cfg['ServerDefault'] = 1;
351 * Other core phpMyAdmin settings
354 * maximum number of db's displayed in left frame and database list
356 * @global integer $cfg['MaxDbList']
358 $cfg['MaxDbList'] = 100;
361 * maximum number of tables displayed in table list
363 * @global integer $cfg['MaxTableList']
365 $cfg['MaxTableList'] = 250;
368 * maximum number of characters when a SQL query is displayed
370 * @global integer $cfg['MaxCharactersInDisplayedSQL']
372 $cfg['MaxCharactersInDisplayedSQL'] = 1000;
375 * use GZIP output buffering if possible (true|false|'auto')
377 * @global string $cfg['OBGzip']
379 $cfg['OBGzip'] = 'auto';
382 * use persistent connections to MySQL database
384 * @global boolean $cfg['PersistentConnections']
386 $cfg['PersistentConnections'] = false;
389 * whether to force using HTTPS
391 * @global boolean $cfg['ForceSSL']
393 $cfg['ForceSSL'] = false;
396 * maximum execution time in seconds (0 for no limit)
398 * @global integer $cfg['ExecTimeLimit']
400 $cfg['ExecTimeLimit'] = 300;
403 * maximum allocated bytes (0 for no limit)
405 * @global integer $cfg['MemoryLimit']
407 $cfg['MemoryLimit'] = 0;
410 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
412 * @global boolean $cfg['SkipLockedTables']
414 $cfg['SkipLockedTables'] = false;
417 * show SQL queries as run
419 * @global boolean $cfg['ShowSQL']
421 $cfg['ShowSQL'] = true;
424 * show a 'Drop database' link to normal users
426 * @global boolean $cfg['AllowUserDropDatabase']
428 $cfg['AllowUserDropDatabase'] = false;
431 * confirm 'DROP TABLE' & 'DROP DATABASE'
433 * @global boolean $cfg['Confirm']
435 $cfg['Confirm'] = true;
438 * recall previous login in cookie authentication mode or not
440 * @global boolean $cfg['LoginCookieRecall']
442 $cfg['LoginCookieRecall'] = true;
445 * validity of cookie login (in seconds)
447 * @global integer $cfg['LoginCookieValidity']
449 $cfg['LoginCookieValidity'] = 1800;
452 * how long login cookie should be stored (in seconds)
454 * @global integer $cfg['LoginCookieStore']
456 $cfg['LoginCookieStore'] = 0;
459 * whether to delete all login cookies on logout
461 * @global boolean $cfg['LoginCookieDeleteAll']
463 $cfg['LoginCookieDeleteAll'] = true;
466 * whether to enable the "database search" feature or not
468 * @global boolean $cfg['UseDbSearch']
470 $cfg['UseDbSearch'] = true;
473 * if set to true, PMA continues computing multiple-statement queries
474 * even if one of the queries failed
476 * @global boolean $cfg['IgnoreMultiSubmitErrors']
478 $cfg['IgnoreMultiSubmitErrors'] = false;
481 * if set to true, PMA will show the affected rows of EACH statement on
482 * multiple-statement queries. See the libraries/import.php file for
483 * hard coded defaults on how many queries a statement may contain!
485 * @global boolean $cfg['VerboseMultiSubmit']
487 $cfg['VerboseMultiSubmit'] = true;
490 * allow login to any user entered server in cookie based authentication
492 * @global boolean $cfg['AllowArbitraryServer']
494 $cfg['AllowArbitraryServer'] = false;
497 /*******************************************************************************
498 * Left frame setup
502 * use a select-based menu and display only the current tables in the left frame.
504 * @global boolean $cfg['LeftFrameLight']
506 $cfg['LeftFrameLight'] = true;
509 * turn the select-based light menu into a tree
511 * @global boolean $cfg['LeftFrameDBTree']
513 $cfg['LeftFrameDBTree'] = true;
516 * the separator to sub-tree the select-based light menu tree
518 * @global string $cfg['LeftFrameDBSeparator']
520 $cfg['LeftFrameDBSeparator'] = '_';
523 * Which string will be used to generate table prefixes
524 * to split/nest tables into multiple categories
526 * @global string $cfg['LeftFrameTableSeparator']
528 $cfg['LeftFrameTableSeparator']= '__';
531 * How many sublevels should be displayed when splitting up tables by the above Separator
533 * @global integer $cfg['LeftFrameTableLevel']
535 $cfg['LeftFrameTableLevel'] = '1';
538 * display table comment as tooltip in left frame
540 * @global boolean $cfg['ShowTooltip']
542 $cfg['ShowTooltip'] = true;
545 * if ShowToolTip is enabled, this defines that table/db comments
547 * @global boolean $cfg['ShowTooltipAliasDB']
549 $cfg['ShowTooltipAliasDB'] = false;
552 * are shown (in the left menu and db_structure) instead of table/db names.
553 * Setting ShowTooltipAliasTB to 'nested' will only use the Aliases for nested
554 * descriptors, not the table itself.
556 * @global boolean $cfg['ShowTooltipAliasTB']
558 $cfg['ShowTooltipAliasTB'] = false;
561 * display logo at top of left frame
563 * @global boolean $cfg['LeftDisplayLogo']
565 $cfg['LeftDisplayLogo'] = true;
568 * where should logo link point to (can also contain an external URL)
570 * @global string $cfg['LeftLogoLink']
572 $cfg['LeftLogoLink'] = 'main.php';
575 * whether to open the linked page in the main window ('main') or
576 * in a new window ('new')
578 * @global string $cfg['LeftLogoLinkWindow']
580 $cfg['LeftLogoLinkWindow'] = 'main';
583 * display server choice at top of left frame
585 * @global boolean $cfg['LeftDisplayServers']
587 $cfg['LeftDisplayServers'] = false;
590 * server choice as links
592 * @global boolean $cfg['DisplayServersList']
594 $cfg['DisplayServersList'] = false;
597 * database choice in light as links
599 * @global boolean $cfg['DisplayDatabasesList']
601 $cfg['DisplayDatabasesList'] = 'auto';
604 /*******************************************************************************
605 * In the main frame, at startup...
609 * allow to display statistics and space usage in the pages about database
610 * details and table properties
612 * @global boolean $cfg['ShowStats']
614 $cfg['ShowStats'] = true;
617 * show PHP info link
619 * @global boolean $cfg['ShowPhpInfo']
621 $cfg['ShowPhpInfo'] = false;
624 * show MySQL server information
626 * @global boolean $cfg['ShowServerInfo']
628 $cfg['ShowServerInfo'] = true;
631 * show change password link
633 * @global boolean $cfg['ShowChgPassword']
635 $cfg['ShowChgPassword'] = false;
638 * show create database form
640 * @global boolean $cfg['ShowCreateDb']
642 $cfg['ShowCreateDb'] = true;
645 * suggest a new DB name if possible (false = keep empty)
647 * @global boolean $cfg['SuggestDBName']
649 $cfg['SuggestDBName'] = true;
652 /*******************************************************************************
653 * In browse mode...
657 * display blob field contents
659 * @global boolean $cfg['ShowBlob']
661 $cfg['ShowBlob'] = false;
664 * Use icons instead of text for the navigation bar buttons
665 * and on right panel top menu (server db table) (true|false|'both')
667 * @global string $cfg['NavigationBarIconic']
669 $cfg['NavigationBarIconic'] = 'both';
672 * allows to display all the rows
674 * @global boolean $cfg['ShowAll']
676 $cfg['ShowAll'] = false;
679 * maximum number of rows to display
681 * @global integer $cfg['MaxRows']
683 $cfg['MaxRows'] = 30;
686 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
687 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
688 * ascending order else-)
690 * @global string $cfg['Order']
692 $cfg['Order'] = 'ASC';
695 /*******************************************************************************
696 * In edit mode...
700 * disallow editing of binary fields
701 * valid values are:
702 * false allow editing
703 * 'blob' allow editing except for BLOB fields
704 * 'all' disallow editing
706 * @global string $cfg['ProtectBinary']
708 $cfg['ProtectBinary'] = 'blob';
711 * Display the function fields in edit/insert mode
713 * @global boolean $cfg['ShowFunctionFields']
715 $cfg['ShowFunctionFields'] = true;
718 * Which editor should be used for CHAR/VARCHAR fields:
719 * input - allows limiting of input length
720 * textarea - allows newlines in fields
722 * @global string $cfg['CharEditing']
724 $cfg['CharEditing'] = 'input';
727 * How many rows can be inserted at one time
729 * @global integer $cfg['InsertRows']
731 $cfg['InsertRows'] = 2;
734 * Sort order for items in a foreign-key drop-down list.
735 * 'content' is the referenced data, 'id' is the key value.
737 * @global array $cfg['ForeignKeyDropdownOrder']
739 $cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
742 * A drop-down list will be used if fewer items are present
744 * @global integer $cfg['ForeignKeyMaxLimit']
746 $cfg['ForeignKeyMaxLimit'] = 100;
749 /*******************************************************************************
750 * For the export features...
754 * Allow the use of zip/gzip/bzip
756 * @global boolean $cfg['ZipDump']
758 $cfg['ZipDump'] = true;
761 * compression for
763 * @global boolean $cfg['GZipDump']
765 $cfg['GZipDump'] = true;
768 * dump files
770 * @global boolean $cfg['BZipDump']
772 $cfg['BZipDump'] = true;
775 * Will compress gzip/bzip2 exports on fly without need for much memory.
776 * If you encounter problems with created gzip/bzip2 files disable this feature.
778 * @global boolean $cfg['CompressOnFly']
780 $cfg['CompressOnFly'] = true;
783 /*******************************************************************************
784 * Tabs display settings
788 * use graphically less intense menu tabs
790 * @global boolean $cfg['LightTabs']
792 $cfg['LightTabs'] = false;
795 * Use icons instead of text for the table display of a database (true|false|'both')
797 * @global boolean $cfg['PropertiesIconic']
799 $cfg['PropertiesIconic'] = true;
802 * How many columns should be used for table display of a database?
803 * (a value larger than 1 results in some information being hidden)
805 * @global integer $cfg['PropertiesNumColumns']
807 $cfg['PropertiesNumColumns'] = 1;
810 * Possible values:
811 * 'main.php' = the welcome page
812 * (recommended for multiuser setups)
813 * 'server_databases.php' = list of databases
814 * 'server_status.php' = runtime information
815 * 'server_variables.php' = MySQL server variables
816 * 'server_privileges.php' = user management
817 * 'server_processlist.php' = process list
819 * @global string $cfg['DefaultTabServer']
821 $cfg['DefaultTabServer'] = 'main.php';
824 * Possible values:
825 * 'db_structure.php' = tables list
826 * 'db_sql.php' = SQL form
827 * 'db_search.php' = search query
828 * 'db_operations.php' = operations on database
830 * @global string $cfg['DefaultTabDatabase']
832 $cfg['DefaultTabDatabase'] = 'db_structure.php';
835 * Possible values:
836 * 'tbl_structure.php' = fields list
837 * 'tbl_sql.php' = SQL form
838 * 'tbl_select.php' = select page
839 * 'tbl_change.php' = insert row page
840 * 'sql.php' = browse page
842 * @global string $cfg['DefaultTabTable']
844 $cfg['DefaultTabTable'] = 'tbl_structure.php';
847 /*******************************************************************************
848 * Export defaults
850 $cfg['Export'] = array();
853 * sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt
855 * @global string $cfg['Export']['format']
857 $cfg['Export']['format'] = 'sql';
860 * none/zip/gzip/bzip2
862 * @global string $cfg['Export']['compression']
864 $cfg['Export']['compression'] = 'none';
869 * @global boolean $cfg['Export']['asfile']
871 $cfg['Export']['asfile'] = false;
876 * @global string $cfg['Export']['charset']
878 $cfg['Export']['charset'] = '';
883 * @global boolean $cfg['Export']['onserver']
885 $cfg['Export']['onserver'] = false;
890 * @global boolean $cfg['Export']['onserver_overwrite']
892 $cfg['Export']['onserver_overwrite'] = false;
897 * @global boolean $cfg['Export']['remember_file_template']
899 $cfg['Export']['remember_file_template'] = true;
904 * @global string $cfg['Export']['file_template_table']
906 $cfg['Export']['file_template_table'] = '__TABLE__';
911 * @global string $cfg['Export']['file_template_database']
913 $cfg['Export']['file_template_database'] = '__DB__';
918 * @global string $cfg['Export']['file_template_server']
920 $cfg['Export']['file_template_server'] = '__SERVER__';
925 * @global boolean $cfg['Export']['ods_columns']
927 $cfg['Export']['ods_columns'] = false;
932 * @global string $cfg['Export']['ods_null']
934 $cfg['Export']['ods_null'] = 'NULL';
939 * @global boolean $cfg['Export']['odt_structure']
941 $cfg['Export']['odt_structure'] = true;
946 * @global boolean $cfg['Export']['odt_data']
948 $cfg['Export']['odt_data'] = true;
953 * @global boolean $cfg['Export']['odt_columns']
955 $cfg['Export']['odt_columns'] = true;
960 * @global boolean $cfg['Export']['odt_relation']
962 $cfg['Export']['odt_relation'] = true;
967 * @global boolean $cfg['Export']['odt_comments']
969 $cfg['Export']['odt_comments'] = true;
974 * @global boolean $cfg['Export']['odt_mime']
976 $cfg['Export']['odt_mime'] = true;
981 * @global string $cfg['Export']['odt_null']
983 $cfg['Export']['odt_null'] = 'NULL';
988 * @global boolean $cfg['Export']['htmlexcel_columns']
990 $cfg['Export']['htmlexcel_columns'] = false;
995 * @global string $cfg['Export']['htmlexcel_null']
997 $cfg['Export']['htmlexcel_null'] = 'NULL';
1002 * @global boolean $cfg['Export']['htmlword_structure']
1004 $cfg['Export']['htmlword_structure'] = true;
1009 * @global boolean $cfg['Export']['htmlword_data']
1011 $cfg['Export']['htmlword_data'] = true;
1016 * @global boolean $cfg['Export']['htmlword_columns']
1018 $cfg['Export']['htmlword_columns'] = false;
1023 * @global string $cfg['Export']['htmlword_null']
1025 $cfg['Export']['htmlword_null'] = 'NULL';
1030 * @global boolean $cfg['Export']['xls_columns']
1032 $cfg['Export']['xls_columns'] = false;
1037 * @global string $cfg['Export']['xls_null']
1039 $cfg['Export']['xls_null'] = 'NULL';
1044 * @global boolean $cfg['Export']['csv_columns']
1046 $cfg['Export']['csv_columns'] = false;
1051 * @global string $cfg['Export']['csv_null']
1053 $cfg['Export']['csv_null'] = 'NULL';
1058 * @global string $cfg['Export']['csv_separator']
1060 $cfg['Export']['csv_separator'] = ';';
1065 * @global string $cfg['Export']['csv_enclosed']
1067 $cfg['Export']['csv_enclosed'] = '"';
1072 * @global string $cfg['Export']['csv_escaped']
1074 $cfg['Export']['csv_escaped'] = '\\';
1079 * @global string $cfg['Export']['csv_terminated']
1081 $cfg['Export']['csv_terminated'] = 'AUTO';
1086 * @global boolean $cfg['Export']['excel_columns']
1088 $cfg['Export']['excel_columns'] = false;
1093 * @global string $cfg['Export']['excel_null']
1095 $cfg['Export']['excel_null'] = 'NULL';
1098 * win/mac
1100 * @global string $cfg['Export']['excel_edition']
1102 $cfg['Export']['excel_edition'] = 'win';
1107 * @global boolean $cfg['Export']['latex_structure']
1109 $cfg['Export']['latex_structure'] = true;
1114 * @global boolean $cfg['Export']['latex_data']
1116 $cfg['Export']['latex_data'] = true;
1121 * @global boolean $cfg['Export']['latex_columns']
1123 $cfg['Export']['latex_columns'] = true;
1128 * @global boolean $cfg['Export']['latex_relation']
1130 $cfg['Export']['latex_relation'] = true;
1135 * @global boolean $cfg['Export']['latex_comments']
1137 $cfg['Export']['latex_comments'] = true;
1142 * @global boolean $cfg['Export']['latex_mime']
1144 $cfg['Export']['latex_mime'] = true;
1149 * @global string $cfg['Export']['latex_null']
1151 $cfg['Export']['latex_null'] = '\textit{NULL}';
1156 * @global boolean $cfg['Export']['latex_caption']
1158 $cfg['Export']['latex_caption'] = true;
1163 * @global string $cfg['Export']['latex_structure_caption']
1165 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1170 * @global string $cfg['Export']['latex_structure_continued_caption']
1172 $cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';
1177 * @global string $cfg['Export']['latex_data_caption']
1179 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
1184 * @global string $cfg['Export']['latex_data_continued_caption']
1186 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1191 * @global string $cfg['Export']['latex_data_label']
1193 $cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';
1198 * @global string $cfg['Export']['latex_structure_label']
1200 $cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';
1205 * @global boolean $cfg['Export']['sql_structure']
1207 $cfg['Export']['sql_structure'] = true;
1212 * @global boolean $cfg['Export']['sql_data']
1214 $cfg['Export']['sql_data'] = true;
1219 * @global string $cfg['Export']['sql_compatibility']
1221 $cfg['Export']['sql_compatibility'] = 'NONE';
1226 * @global boolean $cfg['Export']['sql_disable_fk']
1228 $cfg['Export']['sql_disable_fk'] = false;
1233 * @global boolean $cfg['Export']['sql_use_transaction']
1235 $cfg['Export']['sql_use_transaction'] = false;
1240 * @global boolean $cfg['Export']['sql_drop_database']
1242 $cfg['Export']['sql_drop_database'] = false;
1247 * @global boolean $cfg['Export']['sql_drop_table']
1249 $cfg['Export']['sql_drop_table'] = false;
1254 * @global boolean $cfg['Export']['sql_if_not_exists']
1255 * true by default for correct behavior when dealing with exporting
1256 * of VIEWs and the stand-in table
1258 $cfg['Export']['sql_if_not_exists'] = true;
1263 * @global boolean $cfg['Export']['sql_procedure_function']
1265 $cfg['Export']['sql_procedure_function'] = false;
1270 * @global boolean $cfg['Export']['sql_auto_increment']
1272 $cfg['Export']['sql_auto_increment'] = true;
1277 * @global boolean $cfg['Export']['sql_backquotes']
1279 $cfg['Export']['sql_backquotes'] = true;
1284 * @global boolean $cfg['Export']['sql_dates']
1286 $cfg['Export']['sql_dates'] = false;
1291 * @global boolean $cfg['Export']['sql_relation']
1293 $cfg['Export']['sql_relation'] = false;
1298 * @global boolean $cfg['Export']['sql_columns']
1300 $cfg['Export']['sql_columns'] = true;
1305 * @global boolean $cfg['Export']['sql_delayed']
1307 $cfg['Export']['sql_delayed'] = false;
1312 * @global boolean $cfg['Export']['sql_ignore']
1314 $cfg['Export']['sql_ignore'] = false;
1319 * @global boolean $cfg['Export']['sql_hex_for_blob']
1321 $cfg['Export']['sql_hex_for_blob'] = true;
1324 * insert/update/replace
1326 * @global string $cfg['Export']['sql_type']
1328 $cfg['Export']['sql_type'] = 'insert';
1333 * @global boolean $cfg['Export']['sql_extended']
1335 $cfg['Export']['sql_extended'] = true;
1340 * @global integer $cfg['Export']['sql_max_query_size']
1342 $cfg['Export']['sql_max_query_size'] = 50000;
1347 * @global boolean $cfg['Export']['sql_comments']
1349 $cfg['Export']['sql_comments'] = false;
1354 * @global boolean $cfg['Export']['sql_mime']
1356 $cfg['Export']['sql_mime'] = false;
1359 * \n is replaced by new line
1361 * @global string $cfg['Export']['sql_header_comment']
1363 $cfg['Export']['sql_header_comment'] = '';
1368 * @global boolean $cfg['Export']['pdf_structure']
1370 $cfg['Export']['pdf_structure'] = false;
1375 * @global boolean $cfg['Export']['pdf_data']
1377 $cfg['Export']['pdf_data'] = true;
1382 * @global string $cfg['Export']['pdf_report_title']
1384 $cfg['Export']['pdf_report_title'] = '';
1387 /*******************************************************************************
1388 * Import defaults
1390 $cfg['Import'] = array();
1395 * @global string $cfg['Import']['format']
1397 $cfg['Import']['format'] = 'sql';
1402 * @global boolean $cfg['Import']['allow_interrupt']
1404 $cfg['Import']['allow_interrupt'] = true;
1409 * @global integer $cfg['Import']['skip_queries']
1411 $cfg['Import']['skip_queries'] = '0';
1416 * @global string $cfg['Import']['sql_compatibility']
1418 $cfg['Import']['sql_compatibility'] = 'NONE';
1423 * @global boolean $cfg['Import']['csv_replace']
1425 $cfg['Import']['csv_replace'] = false;
1430 * @global string $cfg['Import']['csv_terminated']
1432 $cfg['Import']['csv_terminated'] = ';';
1437 * @global string $cfg['Import']['csv_enclosed']
1439 $cfg['Import']['csv_enclosed'] = '"';
1444 * @global string $cfg['Import']['csv_escaped']
1446 $cfg['Import']['csv_escaped'] = '\\';
1451 * @global string $cfg['Import']['csv_new_line']
1453 $cfg['Import']['csv_new_line'] = 'auto';
1458 * @global string $cfg['Import']['csv_columns']
1460 $cfg['Import']['csv_columns'] = '';
1465 * @global boolean $cfg['Import']['ldi_replace']
1467 $cfg['Import']['ldi_replace'] = false;
1472 * @global string $cfg['Import']['ldi_terminated']
1474 $cfg['Import']['ldi_terminated'] = ';';
1479 * @global string $cfg['Import']['ldi_enclosed']
1481 $cfg['Import']['ldi_enclosed'] = '"';
1486 * @global string $cfg['Import']['ldi_escaped']
1488 $cfg['Import']['ldi_escaped'] = '\\';
1493 * @global string $cfg['Import']['ldi_new_line']
1495 $cfg['Import']['ldi_new_line'] = 'auto';
1500 * @global string $cfg['Import']['ldi_columns']
1502 $cfg['Import']['ldi_columns'] = '';
1505 * 'auto' for auto-detection, true or false for forcing
1507 * @global string $cfg['Import']['ldi_local_option']
1509 $cfg['Import']['ldi_local_option'] = 'auto';
1512 * Link to the official MySQL documentation.
1513 * Be sure to include no trailing slash on the path.
1514 * See http://dev.mysql.com/doc/ for more information
1515 * about MySQL manuals and their types.
1517 * @global string $cfg['MySQLManualBase']
1519 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
1522 * Type of MySQL documentation:
1523 * viewable - "viewable online", current one used on MySQL website
1524 * searchable - "Searchable, with user comments"
1525 * chapters - "HTML, one page per chapter"
1526 * chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release
1527 * big - "HTML, all on one page"
1528 * old - old style used in phpMyAdmin 2.3.0 and sooner
1529 * none - do not show documentation links
1531 * @global string $cfg['MySQLManualType']
1533 $cfg['MySQLManualType'] = 'viewable';
1536 /*******************************************************************************
1537 * PDF options
1543 * @global array $cfg['PDFPageSizes']
1545 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
1550 * @global string $cfg['PDFDefaultPageSize']
1552 $cfg['PDFDefaultPageSize'] = 'A4';
1555 /*******************************************************************************
1556 * Language and character set conversion settings
1560 * Default language to use, if not browser-defined or user-defined
1562 * @global string $cfg['DefaultLang']
1564 $cfg['DefaultLang'] = 'en-iso-8859-1';
1567 * Default connection collation (used for MySQL >= 4.1)
1569 * @global string $cfg['DefaultConnectionCollation']
1571 $cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';
1574 * Force: always use this language - must be defined in
1575 * libraries/select_lang.lib.php
1576 * $cfg['Lang'] = 'en-iso-8859-1';
1578 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
1579 * English only
1581 * @global string $cfg['FilterLanguages']
1583 $cfg['FilterLanguages'] = '';
1586 * Default character set to use for recoding of MySQL queries, does not take
1587 * any effect when character sets recoding is switched off by
1588 * $cfg['AllowAnywhereRecoding'] or in language file
1589 * (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
1591 * @global string $cfg['DefaultCharset']
1593 $cfg['DefaultCharset'] = 'iso-8859-1';
1596 * Allow character set recoding of MySQL queries, must be also enabled in language
1597 * file to make harder using other language files than Unicode.
1598 * Default value is false to avoid problems on servers without the iconv
1599 * extension and where dl() is not supported
1601 * @global boolean $cfg['AllowAnywhereRecoding']
1603 $cfg['AllowAnywhereRecoding'] = false;
1606 * You can select here which functions will be used for character set conversion.
1607 * Possible values are:
1608 * auto - automatically use available one (first is tested iconv, then
1609 * recode)
1610 * iconv - use iconv or libiconv functions
1611 * recode - use recode_string function
1613 * @global string $cfg['RecodingEngine']
1615 $cfg['RecodingEngine'] = 'auto';
1618 * Specify some parameters for iconv used in character set conversion. See iconv
1619 * documentation for details:
1620 * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
1622 * @global string $cfg['IconvExtraParams']
1624 $cfg['IconvExtraParams'] = '//TRANSLIT';
1627 * Available character sets for MySQL conversion. currently contains all which could
1628 * be found in lang/* files and few more.
1629 * Character sets will be shown in same order as here listed, so if you frequently
1630 * use some of these move them to the top.
1632 * @global array $cfg['AvailableCharsets']
1634 $cfg['AvailableCharsets'] = array(
1635 'iso-8859-1',
1636 'iso-8859-2',
1637 'iso-8859-3',
1638 'iso-8859-4',
1639 'iso-8859-5',
1640 'iso-8859-6',
1641 'iso-8859-7',
1642 'iso-8859-8',
1643 'iso-8859-9',
1644 'iso-8859-10',
1645 'iso-8859-11',
1646 'iso-8859-12',
1647 'iso-8859-13',
1648 'iso-8859-14',
1649 'iso-8859-15',
1650 'windows-1250',
1651 'windows-1251',
1652 'windows-1252',
1653 'windows-1256',
1654 'windows-1257',
1655 'koi8-r',
1656 'big5',
1657 'gb2312',
1658 'utf-16',
1659 'utf-8',
1660 'utf-7',
1661 'x-user-defined',
1662 'euc-jp',
1663 'ks_c_5601-1987',
1664 'tis-620',
1665 'SHIFT_JIS'
1669 /*******************************************************************************
1670 * Customization & design
1672 * The graphical settings are now located in themes/theme-name/layout.inc.php
1676 * enable the left panel pointer
1677 * (used when LeftFrameLight is false)
1678 * see also LeftPointerColor
1679 * in layout.inc.php
1681 * @global boolean $cfg['LeftPointerEnable']
1683 $cfg['LeftPointerEnable'] = true;
1686 * enable the browse pointer
1687 * see also BrowsePointerColor
1688 * in layout.inc.php
1690 * @global boolean $cfg['BrowsePointerEnable']
1692 $cfg['BrowsePointerEnable'] = true;
1695 * enable the browse marker
1696 * see also BrowseMarkerColor
1697 * in layout.inc.php
1699 * @global boolean $cfg['BrowseMarkerEnable']
1701 $cfg['BrowseMarkerEnable'] = true;
1704 * textarea size (columns) in edit mode
1705 * (this value will be emphasized (*2) for SQL
1706 * query textareas and (*1.25) for query window)
1708 * @global integer $cfg['TextareaCols']
1710 $cfg['TextareaCols'] = 40;
1713 * textarea size (rows) in edit mode
1715 * @global integer $cfg['TextareaRows']
1717 $cfg['TextareaRows'] = 7;
1720 * double size of textarea size for LONGTEXT fields
1722 * @global boolean $cfg['LongtextDoubleTextarea']
1724 $cfg['LongtextDoubleTextarea'] = true;
1727 * auto-select when clicking in the textarea of the query-box
1729 * @global boolean $cfg['TextareaAutoSelect']
1731 $cfg['TextareaAutoSelect'] = false;
1734 * textarea size (columns) for CHAR/VARCHAR
1736 * @global integer $cfg['CharTextareaCols']
1738 $cfg['CharTextareaCols'] = 40;
1741 * textarea size (rows) for CHAR/VARCHAR
1743 * @global integer $cfg['CharTextareaRows']
1745 $cfg['CharTextareaRows'] = 2;
1748 * Enable Ctrl+Arrows moving between fields when editing?
1750 * @global boolean $cfg['CtrlArrowsMoving']
1752 $cfg['CtrlArrowsMoving'] = true;
1755 * Max field data length in browse mode for all non-numeric fields
1757 * @global integer $cfg['LimitChars']
1759 $cfg['LimitChars'] = 50;
1762 * show edit/delete links on left side of browse
1763 * (or at the top with vertical browse)
1765 * @global boolean $cfg['ModifyDeleteAtLeft']
1767 $cfg['ModifyDeleteAtLeft'] = true;
1770 * show edit/delete links on right side of browse
1771 * (or at the bottom with vertical browse)
1773 * @global boolean $cfg['ModifyDeleteAtRight']
1775 $cfg['ModifyDeleteAtRight'] = false;
1778 * default display direction (horizontal|vertical|horizontalflipped)
1780 * @global string $cfg['DefaultDisplay']
1782 $cfg['DefaultDisplay'] = 'horizontal';
1785 * default display direction for altering/creating columns (tbl_properties)
1786 * (horizontal|vertical|<number>)
1787 * number indicates maximal number for which vertical model is used
1789 * @global integer $cfg['DefaultPropDisplay']
1791 $cfg['DefaultPropDisplay'] = 3;
1794 * table-header rotation via faking or CSS? (css|fake)
1795 * NOTE: CSS only works in IE browsers!
1797 * @global string $cfg['HeaderFlipType']
1799 $cfg['HeaderFlipType'] = 'css';
1802 * shows stored relation-comments in 'browse' mode.
1804 * @global boolean $cfg['ShowBrowseComments']
1806 $cfg['ShowBrowseComments'] = true;
1809 * shows stored relation-comments in 'table property' mode.
1811 * @global boolean $cfg['ShowPropertyComments']
1813 $cfg['ShowPropertyComments']= true;
1816 * repeat header names every X cells? (0 = deactivate)
1818 * @global integer $cfg['RepeatCells']
1820 $cfg['RepeatCells'] = 100;
1823 * Set to true if Edit link should open the query to edit in the query window
1824 * (assuming JavaScript is enabled), and to false if we should edit in the right panel
1826 * @global boolean $cfg['EditInWindow']
1828 $cfg['EditInWindow'] = true;
1831 * Width of Query window
1833 * @global integer $cfg['QueryWindowWidth']
1835 $cfg['QueryWindowWidth'] = 550;
1838 * Height of Query window
1840 * @global integer $cfg['QueryWindowHeight']
1842 $cfg['QueryWindowHeight'] = 310;
1845 * Set to true if you want DB-based query history.If false, this utilizes
1846 * JS-routines to display query history (lost by window close)
1848 * @global boolean $cfg['QueryHistoryDB']
1850 $cfg['QueryHistoryDB'] = false;
1853 * which tab to display in the querywindow on startup
1854 * (sql|files|history|full)
1856 * @global string $cfg['QueryWindowDefTab']
1858 $cfg['QueryWindowDefTab'] = 'sql';
1861 * When using DB-based query history, how many entries should be kept?
1863 * @global integer $cfg['QueryHistoryMax']
1865 $cfg['QueryHistoryMax'] = 25;
1868 * Use MIME-Types (stored in column comments table) for
1870 * @global boolean $cfg['BrowseMIME']
1872 $cfg['BrowseMIME'] = true;
1875 * When approximate count < this, PMA will get exact count for table rows.
1877 * @global integer $cfg['MaxExactCount']
1879 $cfg['MaxExactCount'] = 20000;
1882 * Zero means that no row count is done for views; see the doc
1884 * @global integer $cfg['MaxExactCountViews']
1886 $cfg['MaxExactCountViews'] = 0;
1889 * Utilize DHTML/JS capabilities to allow WYSIWYG editing of
1890 * the PDF page editor. Requires an IE6/Gecko based browser.
1892 * @global boolean $cfg['WYSIWYG-PDF']
1894 $cfg['WYSIWYG-PDF'] = true;
1897 * Sort table and database in natural order
1899 * @global boolean $cfg['NaturalOrder']
1901 $cfg['NaturalOrder'] = true;
1904 //-----------------------------------------------------------------------------
1905 // custom-setup by mkkeck: 2004-05-04
1906 // some specials for new icons and scrolling
1908 * @todo 2004-05-08 rabus: We need to rearrange these variables.
1912 /*******************************************************************************
1913 * Window title settings
1917 * title of browser window when a table is selected
1919 * @global string $cfg['TitleTable']
1921 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
1924 * title of browser window when a database is selected
1926 * @global string $cfg['TitleDatabase']
1928 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
1931 * title of browser window when a server is selected
1933 * @global string $cfg['TitleServer']
1935 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
1938 * title of browser window when nothing is selected
1939 * @global string $cfg['TitleDefault']
1941 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
1944 * show some icons for warning, error and information messages (true|false)?
1946 * @global boolean $cfg['ErrorIconic']
1948 $cfg['ErrorIconic'] = true;
1951 * show icons in list on main page and on menu tabs (true|false)?
1953 * @global boolean $cfg['MainPageIconic']
1955 $cfg['MainPageIconic'] = true;
1958 * show help button instead of strDocu (true|false)?
1960 * @global boolean $cfg['ReplaceHelpImg']
1962 $cfg['ReplaceHelpImg'] = true;
1965 /*******************************************************************************
1966 * theme manager
1970 * using themes manager please set up here the path to 'themes' else leave empty
1972 * @global string $cfg['ThemePath']
1974 $cfg['ThemePath'] = './themes';
1977 * if you want to use selectable themes and if ThemesPath not empty
1978 * set it to true, else set it to false (default is false);
1980 * @global boolean $cfg['ThemeManager']
1982 $cfg['ThemeManager'] = true;
1985 * set up default theme, if ThemePath not empty you can set up here an valid
1986 * path to themes or 'original' for the original pma-theme
1988 * @global string $cfg['ThemeDefault']
1990 $cfg['ThemeDefault'] = 'original';
1993 * allow different theme for each configured server
1995 * @global boolean $cfg['ThemePerServer']
1997 $cfg['ThemePerServer'] = false;
2000 /*******************************************************************************
2005 * Default queries
2006 * %d will be replaced by the database name.
2007 * %t will be replaced by the table name.
2008 * %f will be replaced by a list of field names.
2009 * (%t and %f only applies to DefaultQueryTable)
2011 * @global string $cfg['DefaultQueryTable']
2013 $cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';
2016 * Default queries
2017 * %d will be replaced by the database name.
2018 * %t will be replaced by the table name.
2019 * %f will be replaced by a list of field names.
2020 * (%t and %f only applies to DefaultQueryTable)
2022 * @global string $cfg['DefaultQueryDatabase']
2024 $cfg['DefaultQueryDatabase'] = '';
2027 /*******************************************************************************
2028 * SQL Query box settings
2029 * These are the links display in all of the SQL Query boxes
2031 * @global array $cfg['SQLQuery']
2033 $cfg['SQLQuery'] = array();
2036 * Edit link to change a query
2038 * @global boolean $cfg['SQLQuery']['Edit']
2040 $cfg['SQLQuery']['Edit'] = true;
2043 * EXPLAIN on SELECT queries
2045 * @global boolean $cfg['SQLQuery']['Explain']
2047 $cfg['SQLQuery']['Explain'] = true;
2050 * Wrap a query in PHP
2052 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2054 $cfg['SQLQuery']['ShowAsPHP'] = true;
2057 * Validate a query (see $cfg['SQLValidator'] as well)
2059 * @global boolean $cfg['SQLQuery']['Validate']
2061 $cfg['SQLQuery']['Validate'] = false;
2064 * Refresh the results page
2066 * @global boolean $cfg['SQLQuery']['Refresh']
2068 $cfg['SQLQuery']['Refresh'] = true;
2071 /*******************************************************************************
2072 * Web server upload/save/import directories
2076 * Directory for uploaded files that can be executed by phpMyAdmin.
2077 * For example './upload'. Leave empty for no upload directory support.
2078 * Use %u for username inclusion.
2080 * @global string $cfg['UploadDir']
2082 $cfg['UploadDir'] = '';
2085 * Directory where phpMyAdmin can save exported data on server.
2086 * For example './save'. Leave empty for no save directory support.
2087 * Use %u for username inclusion.
2089 * @global string $cfg['SaveDir']
2091 $cfg['SaveDir'] = '';
2094 * Directory where phpMyAdmin can save temporary files.
2095 * This is needed for MS Excel export, see documentation how to enable that.
2097 * @global string $cfg['TempDir']
2099 $cfg['TempDir'] = '';
2103 * Misc. settings
2107 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2108 * which is a bit expensive for PHP < 4.3.0, but it is the only safe way how to
2109 * determine GD version.
2111 * @global string $cfg['GD2Available']
2113 $cfg['GD2Available'] = 'auto';
2116 * List of trusted proxies for IP allow/deny
2118 * @global array $cfg['TrustedProxies']
2120 $cfg['TrustedProxies'] = array();
2123 /*******************************************************************************
2124 * SQL Parser Settings
2126 * @global array $cfg['SQP']
2128 $cfg['SQP'] = array();
2131 * Pretty-printing style to use on queries (html, text, none)
2133 * @global string $cfg['SQP']['fmtType']
2135 $cfg['SQP']['fmtType'] = 'html';
2138 * Amount to indent each level (floats are valid)
2140 * @global integer $cfg['SQP']['fmtInd']
2142 $cfg['SQP']['fmtInd'] = '1';
2145 * Units for indenting each level (CSS Types - {em, px, pt})
2147 * @global string $cfg['SQP']['fmtIndUnit']
2149 $cfg['SQP']['fmtIndUnit'] = 'em';
2152 /*******************************************************************************
2153 * If you wish to use the SQL Validator service, you should be aware of the
2154 * following:
2155 * All SQL statements are stored anonymously for statistical purposes.
2156 * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
2157 * All rights reserved.
2159 * @global array $cfg['SQLValidator']
2161 $cfg['SQLValidator'] = array();
2164 * Make the SQL Validator available
2166 * @global boolean $cfg['SQLValidator']['use']
2168 $cfg['SQLValidator']['use'] = false;
2171 * If you have a custom username, specify it here (defaults to anonymous)
2173 * @global string $cfg['SQLValidator']['username']
2175 $cfg['SQLValidator']['username'] = '';
2178 * Password for username
2180 * @global string $cfg['SQLValidator']['password']
2182 $cfg['SQLValidator']['password'] = '';
2185 /*******************************************************************************
2186 * Developers ONLY!
2187 * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
2189 * @global array $cfg['DBG']
2191 $cfg['DBG'] = array();
2194 * Make the DBG stuff available
2196 * @global boolean $cfg['DBG']['enable']
2198 $cfg['DBG']['enable'] = false;
2201 * Produce profiling results of PHP
2203 * @global boolean $cfg['DBG']['profile']['enable']
2205 $cfg['DBG']['profile']['enable'] = false;
2208 * Threshold of long running code to display
2209 * Anything below the threshold is not displayed
2211 * @global float $cfg['DBG']['profile']['threshold']
2213 $cfg['DBG']['profile']['threshold'] = 0.5;
2216 /*******************************************************************************
2217 * MySQL settings
2221 * Column types;
2222 * VARCHAR, TINYINT, TEXT and DATE are listed first, based on estimated popularity
2224 * @global array $cfg['ColumnTypes']
2226 $cfg['ColumnTypes'] = array(
2227 'VARCHAR',
2228 'TINYINT',
2229 'TEXT',
2230 'DATE',
2231 'SMALLINT',
2232 'MEDIUMINT',
2233 'INT',
2234 'BIGINT',
2235 'FLOAT',
2236 'DOUBLE',
2237 'DECIMAL',
2238 'DATETIME',
2239 'TIMESTAMP',
2240 'TIME',
2241 'YEAR',
2242 'CHAR',
2243 'TINYBLOB',
2244 'TINYTEXT',
2245 'BLOB',
2246 'MEDIUMBLOB',
2247 'MEDIUMTEXT',
2248 'LONGBLOB',
2249 'LONGTEXT',
2250 'ENUM',
2251 'SET',
2252 'BIT',
2253 'BOOL'
2257 * Attributes
2258 * Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically
2259 * for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php
2261 * @global array $cfg['AttributeTypes']
2263 $cfg['AttributeTypes'] = array(
2265 'BINARY',
2266 'UNSIGNED',
2267 'UNSIGNED ZEROFILL'
2271 if ($cfg['ShowFunctionFields']) {
2273 * Available functions
2275 * @global array $cfg['Functions']
2277 $cfg['Functions'] = array(
2278 'ASCII',
2279 'CHAR',
2280 'SOUNDEX',
2281 'LCASE',
2282 'UCASE',
2283 'NOW',
2284 'PASSWORD',
2285 'OLD_PASSWORD',
2286 'MD5',
2287 'SHA1',
2288 'ENCRYPT',
2289 'COMPRESS',
2290 'UNCOMPRESS',
2291 'RAND',
2292 'LAST_INSERT_ID',
2293 'COUNT',
2294 'AVG',
2295 'SUM',
2296 'CURDATE',
2297 'CURTIME',
2298 'UTC_DATE',
2299 'UTC_TIME',
2300 'UTC_TIMESTAMP',
2301 'FROM_DAYS',
2302 'FROM_UNIXTIME',
2303 'PERIOD_ADD',
2304 'PERIOD_DIFF',
2305 'TO_DAYS',
2306 'UNIX_TIMESTAMP',
2307 'USER',
2308 'WEEKDAY',
2309 'CONCAT',
2310 'HEX',
2311 'UNHEX'
2315 * Which column types will be mapped to which Group?
2317 * @global array $cfg['RestrictColumnTypes']
2319 $cfg['RestrictColumnTypes'] = array(
2320 'VARCHAR' => 'FUNC_CHAR',
2321 'TINYINT' => 'FUNC_NUMBER',
2322 'TEXT' => 'FUNC_CHAR',
2323 'DATE' => 'FUNC_DATE',
2324 'SMALLINT' => 'FUNC_NUMBER',
2325 'MEDIUMINT' => 'FUNC_NUMBER',
2326 'INT' => 'FUNC_NUMBER',
2327 'BIGINT' => 'FUNC_NUMBER',
2328 'FLOAT' => 'FUNC_NUMBER',
2329 'DOUBLE' => 'FUNC_NUMBER',
2330 'DECIMAL' => 'FUNC_NUMBER',
2331 'DATETIME' => 'FUNC_DATE',
2332 'TIMESTAMP' => 'FUNC_DATE',
2333 'TIME' => 'FUNC_DATE',
2334 'YEAR' => 'FUNC_DATE',
2335 'CHAR' => 'FUNC_CHAR',
2336 'TINYBLOB' => 'FUNC_CHAR',
2337 'TINYTEXT' => 'FUNC_CHAR',
2338 'BLOB' => 'FUNC_CHAR',
2339 'MEDIUMBLOB' => 'FUNC_CHAR',
2340 'MEDIUMTEXT' => 'FUNC_CHAR',
2341 'LONGBLOB' => 'FUNC_CHAR',
2342 'LONGTEXT' => 'FUNC_CHAR',
2343 'ENUM' => '',
2344 'SET' => ''
2348 * Map above defined groups to any function
2350 * @global array $cfg['RestrictFunctions']
2352 $cfg['RestrictFunctions'] = array(
2353 'FUNC_CHAR' => array(
2354 'ASCII',
2355 'CHAR',
2356 'SOUNDEX',
2357 'LCASE',
2358 'UCASE',
2359 'PASSWORD',
2360 'OLD_PASSWORD',
2361 'MD5',
2362 'SHA1',
2363 'ENCRYPT',
2364 'COMPRESS',
2365 'UNCOMPRESS',
2366 'LAST_INSERT_ID',
2367 'USER',
2368 'CONCAT',
2369 'HEX',
2370 'UNHEX'
2373 'FUNC_DATE' => array(
2374 'NOW',
2375 'CURDATE',
2376 'CURTIME',
2377 'FROM_DAYS',
2378 'FROM_UNIXTIME',
2379 'PERIOD_ADD',
2380 'PERIOD_DIFF',
2381 'TO_DAYS',
2382 'UNIX_TIMESTAMP',
2383 'UTC_DATE',
2384 'UTC_TIME',
2385 'UTC_TIMESTAMP',
2386 'WEEKDAY'
2389 'FUNC_NUMBER' => array(
2390 'ASCII',
2391 'CHAR',
2392 'MD5',
2393 'SHA1',
2394 'ENCRYPT',
2395 'RAND',
2396 'LAST_INSERT_ID',
2397 'UNIX_TIMESTAMP',
2398 'COUNT',
2399 'AVG',
2400 'SUM'
2405 * Default functions for above defined groups
2407 * @global array $cfg['DefaultFunctions']
2409 $cfg['DefaultFunctions'] = array(
2410 'FUNC_CHAR' => '',
2411 'FUNC_DATE' => '',
2412 'FUNC_NUMBER' => '',
2413 'first_timestamp' => 'NOW'
2417 } // end if
2420 * Search operators
2422 * @global array $cfg['NumOperators']
2424 $cfg['NumOperators'] = array(
2425 '=',
2426 '>',
2427 '>=',
2428 '<',
2429 '<=',
2430 '!=',
2431 'LIKE',
2432 'NOT LIKE'
2436 * Search operators
2438 * @global array $cfg['TextOperators']
2440 $cfg['TextOperators'] = array(
2441 'LIKE',
2442 'LIKE %...%',
2443 'NOT LIKE',
2444 '=',
2445 '!=',
2446 'REGEXP',
2447 'NOT REGEXP'
2451 * Search operators
2453 * @global array $cfg['EnumOperators']
2455 $cfg['EnumOperators'] = array(
2456 '=',
2457 '!='
2461 * Search operators
2463 * @global array $cfg['SetOperators']
2465 $cfg['SetOperators'] = array(
2466 'IN',
2467 'NOT IN'
2471 * Search operators
2473 * @global array $cfg['NullOperators']
2475 $cfg['NullOperators'] = array(
2476 'IS NULL',
2477 'IS NOT NULL'
2481 * Search operators
2483 * @global array $cfg['UnaryOperators']
2485 $cfg['UnaryOperators'] = array(
2486 'IS NULL' => 1,
2487 'IS NOT NULL' => 1