diff --git a/htdocs/sql/libraries/config.default.php b/htdocs/sql/libraries/config.default.php new file mode 100755 --- /dev/null +++ b/htdocs/sql/libraries/config.default.php @@ -0,0 +1,2490 @@ + + * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !! + * NN N O O !! D D O O NN N O O T E D D I T !! + * N N N O O !! D D O O N N N O O T EEEE D D I T !! + * N NN O O D D O O N NN O O T E D D I T + * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !! + * + * + * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! + * + * phpMyAdmin default configuration, you can copy values from here to your + * config.inc.php + * + * All directives are explained in Documentation.html + * + * @version $Id: config.default.php 11422 2008-07-24 17:12:32Z lem9 $ + */ + +/** + * Your phpMyAdmin URL. + * + * Complete the variable below with the full URL ie + * http://www.your_web.net/path_to_your_phpMyAdmin_directory/ + * + * It must contain characters that are valid for a URL, and the path is + * case sensitive on some Web servers, for example Unix-based servers. + * + * In most cases you can leave this variable empty, as the correct value + * will be detected automatically. However, we recommend that you do + * test to see that the auto-detection code works in your system. A good + * test is to browse a table, then edit a row and save it. There will be + * an error message if phpMyAdmin cannot auto-detect the correct value. + * + * @global string $cfg['PmaAbsoluteUri'] + */ +$cfg['PmaAbsoluteUri'] = ''; + +/** + * Disable the default warning that is displayed on the DB Details Structure page if + * any of the required Tables for the relation features could not be found + * + * @global boolean $cfg['PmaNoRelation_DisableWarning'] + */ +$cfg['PmaNoRelation_DisableWarning'] = false; + +/** + * Disable the default warning that is displayed if Suhosin is detected + * + * @global boolean $cfg['SuhosinDisableWarning'] + */ +$cfg['SuhosinDisableWarning'] = false; + +/** + * Allows phpMyAdmin to be included from a document located on + * another domain; setting this to true is a potential security hole + * + * @global boolean $cfg['AllowThirdPartyFraming'] + */ +$cfg['AllowThirdPartyFraming'] = false; + +/** + * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If + * at least one server configuration uses 'cookie' auth_type, enter here a + * pass phrase that will be used by blowfish. The maximum length seems to be 46 + * characters. + * + * @global string $cfg['blowfish_secret'] + */ +$cfg['blowfish_secret'] = ''; + + +/******************************************************************************* + * Server(s) configuration + * + * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use + * $cfg['Servers'][0]. You can disable a server configuration entry by setting host + * to ''. If you want more than one server, just copy following section + * (including $i incrementation) several times. There is no need to define + * full server array, just define values you need to change. + * + * @global array $cfg['Servers'] + */ +$cfg['Servers'] = array(); + +$i = 1; + +/** + * MySQL hostname or IP address + * + * @global string $cfg['Servers'][$i]['host'] + */ +$cfg['Servers'][$i]['host'] = 'localhost'; + +/** + * MySQL port - leave blank for default port + * + * @global string $cfg['Servers'][$i]['port'] + */ +$cfg['Servers'][$i]['port'] = ''; + +/** + * Path to the socket - leave blank for default socket + * + * @global string $cfg['Servers'][$i]['socket'] + */ +$cfg['Servers'][$i]['socket'] = ''; + +/** + * Use SSL for connecting to MySQL server? + * + * @global boolean $cfg['Servers'][$i]['ssl'] + */ +$cfg['Servers'][$i]['ssl'] = false; + +/** + * How to connect to MySQL server ('tcp' or 'socket') + * + * @global string $cfg['Servers'][$i]['connect_type'] + */ +$cfg['Servers'][$i]['connect_type'] = 'tcp'; + +/** + * The PHP MySQL extension to use ('mysql' or 'mysqli') + * + * @global string $cfg['Servers'][$i]['extension'] + */ +$cfg['Servers'][$i]['extension'] = 'mysql'; + +/** + * Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0) + * + * @global boolean $cfg['Servers'][$i]['compress'] + */ +$cfg['Servers'][$i]['compress'] = false; + +/** + * MySQL control user settings (this user must have read-only + * + * @global string $cfg['Servers'][$i]['controluser'] + */ +$cfg['Servers'][$i]['controluser'] = ''; + +/** + * access to the "mysql/user" and "mysql/db" tables). The controluser is also + * used for all relational features (pmadb) + * + * @global string $cfg['Servers'][$i]['controlpass'] + */ +$cfg['Servers'][$i]['controlpass'] = ''; + +/** + * Authentication method (valid choices: config, http, signon or cookie) + * + * @global string $cfg['Servers'][$i]['auth_type'] + */ +$cfg['Servers'][$i]['auth_type'] = 'config'; + +/** + * MySQL user + * + * @global string $cfg['Servers'][$i]['user'] + */ +$cfg['Servers'][$i]['user'] = 'root'; + +/** + * MySQL password (only needed with 'config' auth_type) + * + * @global string $cfg['Servers'][$i]['password'] + */ +$cfg['Servers'][$i]['password'] = ''; + +/** + * Session to use for 'signon' authentication method + * + * @global string $cfg['Servers'][$i]['SignonSession'] + */ +$cfg['Servers'][$i]['SignonSession'] = ''; + +/** + * URL where to redirect user to login for 'signon' authentication method + * + * @global string $cfg['Servers'][$i]['SignonURL'] + */ +$cfg['Servers'][$i]['SignonURL'] = ''; + +/** + * URL where to redirect user after logout + * + * @global string $cfg['Servers'][$i]['LogoutURL'] + */ +$cfg['Servers'][$i]['LogoutURL'] = ''; + +/** + * Whether to try to connect without password + * + * @global boolean $cfg['Servers'][$i]['nopassword'] + */ +$cfg['Servers'][$i]['nopassword'] = false; + +/** + * If set to a db-name, only this db is displayed in left frame + * It may also be an array of db-names, where sorting order is relevant. + * + * @global string $cfg['Servers'][$i]['only_db'] + */ +$cfg['Servers'][$i]['only_db'] = ''; + +/** + * Database name to be hidden from listings + * + * @global string $cfg['Servers'][$i]['hide_db'] + */ +$cfg['Servers'][$i]['hide_db'] = ''; + +/** + * Verbose name for this host - leave blank to show the hostname + * (for HTTP authentication, all non-US-ASCII characters will be stripped) + * + * @global string $cfg['Servers'][$i]['verbose'] + */ +$cfg['Servers'][$i]['verbose'] = ''; + +/** + * Database used for Relation, Bookmark and PDF Features + * (see scripts/create_tables.sql) + * - leave blank for no support + * DEFAULT: 'phpmyadmin' + * + * @global string $cfg['Servers'][$i]['pmadb'] + */ +$cfg['Servers'][$i]['pmadb'] = ''; + +/** + * Bookmark table + * - leave blank for no bookmark support + * DEFAULT: 'pma_bookmark' + * + * @global string $cfg['Servers'][$i]['bookmarktable'] + */ +$cfg['Servers'][$i]['bookmarktable'] = ''; + +/** + * table to describe the relation between links (see doc) + * - leave blank for no relation-links support + * DEFAULT: 'pma_relation' + * + * @global string $cfg['Servers'][$i]['relation'] + */ +$cfg['Servers'][$i]['relation'] = ''; + +/** + * table to describe the display fields + * - leave blank for no display fields support + * DEFAULT: 'pma_table_info' + * + * @global string $cfg['Servers'][$i]['table_info'] + */ +$cfg['Servers'][$i]['table_info'] = ''; + +/** + * table to describe the tables position for the PDF schema + * - leave blank for no PDF schema support + * DEFAULT: 'pma_table_coords' + * + * @global string $cfg['Servers'][$i]['table_coords'] + */ +$cfg['Servers'][$i]['table_coords'] = ''; + +/** + * table to describe pages of relationpdf + * - leave blank if you don't want to use this + * DEFAULT: 'pma_pdf_pages' + * + * @global string $cfg['Servers'][$i]['pdf_pages'] + */ +$cfg['Servers'][$i]['pdf_pages'] = ''; + +/** + * table to store column information + * - leave blank for no column comments/mime types + * DEFAULT: 'pma_column_info' + * + * @global string $cfg['Servers'][$i]['column_info'] + */ +$cfg['Servers'][$i]['column_info'] = ''; + +/** + * table to store SQL history + * - leave blank for no SQL query history + * DEFAULT: 'pma_history' + * + * @global string $cfg['Servers'][$i]['history'] + */ +$cfg['Servers'][$i]['history'] = ''; + +/** + * table to store the coordinates for Designer + * - leave blank for no Designer feature + * DEFAULT: 'pma_designer_coords' + * + * @global string $cfg['Servers'][$i]['designer_coords'] + */ +$cfg['Servers'][$i]['designer_coords'] = ''; + +/** + * set to false if you know that your pma_* tables are up to date. + * This prevents compatibility checks and thereby increases performance. + * + * @global boolean $cfg['Servers'][$i]['verbose_check'] + */ +$cfg['Servers'][$i]['verbose_check'] = true; + +/** + * whether to allow root login + * + * @global boolean $cfg['Servers'][$i]['AllowRoot'] + */ +$cfg['Servers'][$i]['AllowRoot'] = true; + +/** + * Host authentication order, leave blank to not use + * + * @global string $cfg['Servers'][$i]['AllowDeny']['order'] + */ +$cfg['Servers'][$i]['AllowDeny']['order'] = ''; + +/** + * Host authentication rules, leave blank for defaults + * + * @global array $cfg['Servers'][$i]['AllowDeny']['rules'] + */ +$cfg['Servers'][$i]['AllowDeny']['rules'] = array(); + +/** + * Default server (0 = no default server) + * + * If you have more than one server configured, you can set $cfg['ServerDefault'] + * to any one of them to auto-connect to that server when phpMyAdmin is started, + * or set it to 0 to be given a list of servers without logging in + * If you have only one server configured, $cfg['ServerDefault'] *MUST* be + * set to that server. + * + * @global integer $cfg['ServerDefault'] + */ +$cfg['ServerDefault'] = 1; + +/* + * Other core phpMyAdmin settings + */ +/** + * maximum number of db's displayed in left frame and database list + * + * @global integer $cfg['MaxDbList'] + */ +$cfg['MaxDbList'] = 100; + +/** + * maximum number of tables displayed in table list + * + * @global integer $cfg['MaxTableList'] + */ +$cfg['MaxTableList'] = 250; + +/** + * maximum number of characters when a SQL query is displayed + * + * @global integer $cfg['MaxCharactersInDisplayedSQL'] + */ +$cfg['MaxCharactersInDisplayedSQL'] = 1000; + +/** + * use GZIP output buffering if possible (true|false|'auto') + * + * @global string $cfg['OBGzip'] + */ +$cfg['OBGzip'] = 'auto'; + +/** + * use persistent connections to MySQL database + * + * @global boolean $cfg['PersistentConnections'] + */ +$cfg['PersistentConnections'] = false; + +/** + * whether to force using HTTPS + * + * @global boolean $cfg['ForceSSL'] + */ +$cfg['ForceSSL'] = false; + +/** + * maximum execution time in seconds (0 for no limit) + * + * @global integer $cfg['ExecTimeLimit'] + */ +$cfg['ExecTimeLimit'] = 300; + +/** + * maximum allocated bytes (0 for no limit) + * + * @global integer $cfg['MemoryLimit'] + */ +$cfg['MemoryLimit'] = 0; + +/** + * mark used tables, make possible to show locked tables (since MySQL 3.23.30) + * + * @global boolean $cfg['SkipLockedTables'] + */ +$cfg['SkipLockedTables'] = false; + +/** + * show SQL queries as run + * + * @global boolean $cfg['ShowSQL'] + */ +$cfg['ShowSQL'] = true; + +/** + * show a 'Drop database' link to normal users + * + * @global boolean $cfg['AllowUserDropDatabase'] + */ +$cfg['AllowUserDropDatabase'] = false; + +/** + * confirm 'DROP TABLE' & 'DROP DATABASE' + * + * @global boolean $cfg['Confirm'] + */ +$cfg['Confirm'] = true; + +/** + * recall previous login in cookie authentication mode or not + * + * @global boolean $cfg['LoginCookieRecall'] + */ +$cfg['LoginCookieRecall'] = true; + +/** + * validity of cookie login (in seconds) + * + * @global integer $cfg['LoginCookieValidity'] + */ +$cfg['LoginCookieValidity'] = 1800; + +/** + * how long login cookie should be stored (in seconds) + * + * @global integer $cfg['LoginCookieStore'] + */ +$cfg['LoginCookieStore'] = 0; + +/** + * whether to delete all login cookies on logout + * + * @global boolean $cfg['LoginCookieDeleteAll'] + */ +$cfg['LoginCookieDeleteAll'] = true; + +/** + * whether to enable the "database search" feature or not + * + * @global boolean $cfg['UseDbSearch'] + */ +$cfg['UseDbSearch'] = true; + +/** + * if set to true, PMA continues computing multiple-statement queries + * even if one of the queries failed + * + * @global boolean $cfg['IgnoreMultiSubmitErrors'] + */ +$cfg['IgnoreMultiSubmitErrors'] = false; + +/** + * if set to true, PMA will show the affected rows of EACH statement on + * multiple-statement queries. See the libraries/import.php file for + * hard coded defaults on how many queries a statement may contain! + * + * @global boolean $cfg['VerboseMultiSubmit'] + */ +$cfg['VerboseMultiSubmit'] = true; + +/** + * allow login to any user entered server in cookie based authentication + * + * @global boolean $cfg['AllowArbitraryServer'] + */ +$cfg['AllowArbitraryServer'] = false; + + +/******************************************************************************* + * Left frame setup + */ + +/** + * use a select-based menu and display only the current tables in the left frame. + * + * @global boolean $cfg['LeftFrameLight'] + */ +$cfg['LeftFrameLight'] = true; + +/** + * turn the select-based light menu into a tree + * + * @global boolean $cfg['LeftFrameDBTree'] + */ +$cfg['LeftFrameDBTree'] = true; + +/** + * the separator to sub-tree the select-based light menu tree + * + * @global string $cfg['LeftFrameDBSeparator'] + */ +$cfg['LeftFrameDBSeparator'] = '_'; + +/** + * Which string will be used to generate table prefixes + * to split/nest tables into multiple categories + * + * @global string $cfg['LeftFrameTableSeparator'] + */ +$cfg['LeftFrameTableSeparator']= '__'; + +/** + * How many sublevels should be displayed when splitting up tables by the above Separator + * + * @global integer $cfg['LeftFrameTableLevel'] + */ +$cfg['LeftFrameTableLevel'] = '1'; + +/** + * display table comment as tooltip in left frame + * + * @global boolean $cfg['ShowTooltip'] + */ +$cfg['ShowTooltip'] = true; + +/** + * if ShowToolTip is enabled, this defines that table/db comments + * + * @global boolean $cfg['ShowTooltipAliasDB'] + */ +$cfg['ShowTooltipAliasDB'] = false; + +/** + * are shown (in the left menu and db_structure) instead of table/db names. + * Setting ShowTooltipAliasTB to 'nested' will only use the Aliases for nested + * descriptors, not the table itself. + * + * @global boolean $cfg['ShowTooltipAliasTB'] + */ +$cfg['ShowTooltipAliasTB'] = false; + +/** + * display logo at top of left frame + * + * @global boolean $cfg['LeftDisplayLogo'] + */ +$cfg['LeftDisplayLogo'] = true; + +/** + * where should logo link point to (can also contain an external URL) + * + * @global string $cfg['LeftLogoLink'] + */ +$cfg['LeftLogoLink'] = 'main.php'; + +/** + * whether to open the linked page in the main window ('main') or + * in a new window ('new') + * + * @global string $cfg['LeftLogoLinkWindow'] + */ +$cfg['LeftLogoLinkWindow'] = 'main'; + +/** + * display server choice at top of left frame + * + * @global boolean $cfg['LeftDisplayServers'] + */ +$cfg['LeftDisplayServers'] = false; + +/** + * server choice as links + * + * @global boolean $cfg['DisplayServersList'] + */ +$cfg['DisplayServersList'] = false; + +/** + * database choice in light as links + * + * @global boolean $cfg['DisplayDatabasesList'] + */ +$cfg['DisplayDatabasesList'] = 'auto'; + + +/******************************************************************************* + * In the main frame, at startup... + */ + +/** + * allow to display statistics and space usage in the pages about database + * details and table properties + * + * @global boolean $cfg['ShowStats'] + */ +$cfg['ShowStats'] = true; + +/** + * show PHP info link + * + * @global boolean $cfg['ShowPhpInfo'] + */ +$cfg['ShowPhpInfo'] = false; + +/** + * show MySQL server information + * + * @global boolean $cfg['ShowServerInfo'] + */ +$cfg['ShowServerInfo'] = true; + +/** + * show change password link + * + * @global boolean $cfg['ShowChgPassword'] + */ +$cfg['ShowChgPassword'] = false; + +/** + * show create database form + * + * @global boolean $cfg['ShowCreateDb'] + */ +$cfg['ShowCreateDb'] = true; + +/** + * suggest a new DB name if possible (false = keep empty) + * + * @global boolean $cfg['SuggestDBName'] + */ +$cfg['SuggestDBName'] = true; + + +/******************************************************************************* + * In browse mode... + */ + +/** + * display blob field contents + * + * @global boolean $cfg['ShowBlob'] + */ +$cfg['ShowBlob'] = false; + +/** + * Use icons instead of text for the navigation bar buttons + * and on right panel top menu (server db table) (true|false|'both') + * + * @global string $cfg['NavigationBarIconic'] + */ +$cfg['NavigationBarIconic'] = 'both'; + +/** + * allows to display all the rows + * + * @global boolean $cfg['ShowAll'] + */ +$cfg['ShowAll'] = false; + +/** + * maximum number of rows to display + * + * @global integer $cfg['MaxRows'] + */ +$cfg['MaxRows'] = 30; + +/** + * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie + * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP, + * ascending order else-) + * + * @global string $cfg['Order'] + */ +$cfg['Order'] = 'ASC'; + + +/******************************************************************************* + * In edit mode... + */ + +/** + * disallow editing of binary fields + * valid values are: + * false allow editing + * 'blob' allow editing except for BLOB fields + * 'all' disallow editing + * + * @global string $cfg['ProtectBinary'] + */ +$cfg['ProtectBinary'] = 'blob'; + +/** + * Display the function fields in edit/insert mode + * + * @global boolean $cfg['ShowFunctionFields'] + */ +$cfg['ShowFunctionFields'] = true; + +/** + * Which editor should be used for CHAR/VARCHAR fields: + * input - allows limiting of input length + * textarea - allows newlines in fields + * + * @global string $cfg['CharEditing'] + */ +$cfg['CharEditing'] = 'input'; + +/** + * How many rows can be inserted at one time + * + * @global integer $cfg['InsertRows'] + */ +$cfg['InsertRows'] = 2; + +/** + * Sort order for items in a foreign-key drop-down list. + * 'content' is the referenced data, 'id' is the key value. + * + * @global array $cfg['ForeignKeyDropdownOrder'] + */ +$cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content'); + +/** + * A drop-down list will be used if fewer items are present + * + * @global integer $cfg['ForeignKeyMaxLimit'] + */ +$cfg['ForeignKeyMaxLimit'] = 100; + + +/******************************************************************************* + * For the export features... + */ + +/** + * Allow the use of zip/gzip/bzip + * + * @global boolean $cfg['ZipDump'] + */ +$cfg['ZipDump'] = true; + +/** + * compression for + * + * @global boolean $cfg['GZipDump'] + */ +$cfg['GZipDump'] = true; + +/** + * dump files + * + * @global boolean $cfg['BZipDump'] + */ +$cfg['BZipDump'] = true; + +/** + * Will compress gzip/bzip2 exports on fly without need for much memory. + * If you encounter problems with created gzip/bzip2 files disable this feature. + * + * @global boolean $cfg['CompressOnFly'] + */ +$cfg['CompressOnFly'] = true; + + +/******************************************************************************* + * Tabs display settings + */ + +/** + * use graphically less intense menu tabs + * + * @global boolean $cfg['LightTabs'] + */ +$cfg['LightTabs'] = false; + +/** + * Use icons instead of text for the table display of a database (true|false|'both') + * + * @global boolean $cfg['PropertiesIconic'] + */ +$cfg['PropertiesIconic'] = true; + +/** + * How many columns should be used for table display of a database? + * (a value larger than 1 results in some information being hidden) + * + * @global integer $cfg['PropertiesNumColumns'] + */ +$cfg['PropertiesNumColumns'] = 1; + +/** + * Possible values: + * 'main.php' = the welcome page + * (recommended for multiuser setups) + * 'server_databases.php' = list of databases + * 'server_status.php' = runtime information + * 'server_variables.php' = MySQL server variables + * 'server_privileges.php' = user management + * 'server_processlist.php' = process list + * + * @global string $cfg['DefaultTabServer'] + */ +$cfg['DefaultTabServer'] = 'main.php'; + +/** + * Possible values: + * 'db_structure.php' = tables list + * 'db_sql.php' = SQL form + * 'db_search.php' = search query + * 'db_operations.php' = operations on database + * + * @global string $cfg['DefaultTabDatabase'] + */ +$cfg['DefaultTabDatabase'] = 'db_structure.php'; + +/** + * Possible values: + * 'tbl_structure.php' = fields list + * 'tbl_sql.php' = SQL form + * 'tbl_select.php' = select page + * 'tbl_change.php' = insert row page + * 'sql.php' = browse page + * + * @global string $cfg['DefaultTabTable'] + */ +$cfg['DefaultTabTable'] = 'tbl_structure.php'; + + +/******************************************************************************* + * Export defaults + */ +$cfg['Export'] = array(); + +/** + * sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt + * + * @global string $cfg['Export']['format'] + */ +$cfg['Export']['format'] = 'sql'; + +/** + * none/zip/gzip/bzip2 + * + * @global string $cfg['Export']['compression'] + */ +$cfg['Export']['compression'] = 'none'; + +/** + * + * + * @global boolean $cfg['Export']['asfile'] + */ +$cfg['Export']['asfile'] = false; + +/** + * + * + * @global string $cfg['Export']['charset'] + */ +$cfg['Export']['charset'] = ''; + +/** + * + * + * @global boolean $cfg['Export']['onserver'] + */ +$cfg['Export']['onserver'] = false; + +/** + * + * + * @global boolean $cfg['Export']['onserver_overwrite'] + */ +$cfg['Export']['onserver_overwrite'] = false; + +/** + * + * + * @global boolean $cfg['Export']['remember_file_template'] + */ +$cfg['Export']['remember_file_template'] = true; + +/** + * + * + * @global string $cfg['Export']['file_template_table'] + */ +$cfg['Export']['file_template_table'] = '__TABLE__'; + +/** + * + * + * @global string $cfg['Export']['file_template_database'] + */ +$cfg['Export']['file_template_database'] = '__DB__'; + +/** + * + * + * @global string $cfg['Export']['file_template_server'] + */ +$cfg['Export']['file_template_server'] = '__SERVER__'; + +/** + * + * + * @global boolean $cfg['Export']['ods_columns'] + */ +$cfg['Export']['ods_columns'] = false; + +/** + * + * + * @global string $cfg['Export']['ods_null'] + */ +$cfg['Export']['ods_null'] = 'NULL'; + +/** + * + * + * @global boolean $cfg['Export']['odt_structure'] + */ +$cfg['Export']['odt_structure'] = true; + +/** + * + * + * @global boolean $cfg['Export']['odt_data'] + */ +$cfg['Export']['odt_data'] = true; + +/** + * + * + * @global boolean $cfg['Export']['odt_columns'] + */ +$cfg['Export']['odt_columns'] = true; + +/** + * + * + * @global boolean $cfg['Export']['odt_relation'] + */ +$cfg['Export']['odt_relation'] = true; + +/** + * + * + * @global boolean $cfg['Export']['odt_comments'] + */ +$cfg['Export']['odt_comments'] = true; + +/** + * + * + * @global boolean $cfg['Export']['odt_mime'] + */ +$cfg['Export']['odt_mime'] = true; + +/** + * + * + * @global string $cfg['Export']['odt_null'] + */ +$cfg['Export']['odt_null'] = 'NULL'; + +/** + * + * + * @global boolean $cfg['Export']['htmlexcel_columns'] + */ +$cfg['Export']['htmlexcel_columns'] = false; + +/** + * + * + * @global string $cfg['Export']['htmlexcel_null'] + */ +$cfg['Export']['htmlexcel_null'] = 'NULL'; + +/** + * + * + * @global boolean $cfg['Export']['htmlword_structure'] + */ +$cfg['Export']['htmlword_structure'] = true; + +/** + * + * + * @global boolean $cfg['Export']['htmlword_data'] + */ +$cfg['Export']['htmlword_data'] = true; + +/** + * + * + * @global boolean $cfg['Export']['htmlword_columns'] + */ +$cfg['Export']['htmlword_columns'] = false; + +/** + * + * + * @global string $cfg['Export']['htmlword_null'] + */ +$cfg['Export']['htmlword_null'] = 'NULL'; + +/** + * + * + * @global boolean $cfg['Export']['xls_columns'] + */ +$cfg['Export']['xls_columns'] = false; + +/** + * + * + * @global string $cfg['Export']['xls_null'] + */ +$cfg['Export']['xls_null'] = 'NULL'; + +/** + * + * + * @global boolean $cfg['Export']['csv_columns'] + */ +$cfg['Export']['csv_columns'] = false; + +/** + * + * + * @global string $cfg['Export']['csv_null'] + */ +$cfg['Export']['csv_null'] = 'NULL'; + +/** + * + * + * @global string $cfg['Export']['csv_separator'] + */ +$cfg['Export']['csv_separator'] = ';'; + +/** + * + * + * @global string $cfg['Export']['csv_enclosed'] + */ +$cfg['Export']['csv_enclosed'] = '"'; + +/** + * + * + * @global string $cfg['Export']['csv_escaped'] + */ +$cfg['Export']['csv_escaped'] = '\\'; + +/** + * + * + * @global string $cfg['Export']['csv_terminated'] + */ +$cfg['Export']['csv_terminated'] = 'AUTO'; + +/** + * + * + * @global boolean $cfg['Export']['excel_columns'] + */ +$cfg['Export']['excel_columns'] = false; + +/** + * + * + * @global string $cfg['Export']['excel_null'] + */ +$cfg['Export']['excel_null'] = 'NULL'; + +/** + * win/mac + * + * @global string $cfg['Export']['excel_edition'] + */ +$cfg['Export']['excel_edition'] = 'win'; + +/** + * + * + * @global boolean $cfg['Export']['latex_structure'] + */ +$cfg['Export']['latex_structure'] = true; + +/** + * + * + * @global boolean $cfg['Export']['latex_data'] + */ +$cfg['Export']['latex_data'] = true; + +/** + * + * + * @global boolean $cfg['Export']['latex_columns'] + */ +$cfg['Export']['latex_columns'] = true; + +/** + * + * + * @global boolean $cfg['Export']['latex_relation'] + */ +$cfg['Export']['latex_relation'] = true; + +/** + * + * + * @global boolean $cfg['Export']['latex_comments'] + */ +$cfg['Export']['latex_comments'] = true; + +/** + * + * + * @global boolean $cfg['Export']['latex_mime'] + */ +$cfg['Export']['latex_mime'] = true; + +/** + * + * + * @global string $cfg['Export']['latex_null'] + */ +$cfg['Export']['latex_null'] = '\textit{NULL}'; + +/** + * + * + * @global boolean $cfg['Export']['latex_caption'] + */ +$cfg['Export']['latex_caption'] = true; + +/** + * + * + * @global string $cfg['Export']['latex_structure_caption'] + */ +$cfg['Export']['latex_structure_caption'] = 'strLatexStructure'; + +/** + * + * + * @global string $cfg['Export']['latex_structure_continued_caption'] + */ +$cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued'; + +/** + * + * + * @global string $cfg['Export']['latex_data_caption'] + */ +$cfg['Export']['latex_data_caption'] = 'strLatexContent'; + +/** + * + * + * @global string $cfg['Export']['latex_data_continued_caption'] + */ +$cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued'; + +/** + * + * + * @global string $cfg['Export']['latex_data_label'] + */ +$cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data'; + +/** + * + * + * @global string $cfg['Export']['latex_structure_label'] + */ +$cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure'; + +/** + * + * + * @global boolean $cfg['Export']['sql_structure'] + */ +$cfg['Export']['sql_structure'] = true; + +/** + * + * + * @global boolean $cfg['Export']['sql_data'] + */ +$cfg['Export']['sql_data'] = true; + +/** + * + * + * @global string $cfg['Export']['sql_compatibility'] + */ +$cfg['Export']['sql_compatibility'] = 'NONE'; + +/** + * + * + * @global boolean $cfg['Export']['sql_disable_fk'] + */ +$cfg['Export']['sql_disable_fk'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_use_transaction'] + */ +$cfg['Export']['sql_use_transaction'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_drop_database'] + */ +$cfg['Export']['sql_drop_database'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_drop_table'] + */ +$cfg['Export']['sql_drop_table'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_if_not_exists'] + * true by default for correct behavior when dealing with exporting + * of VIEWs and the stand-in table + */ +$cfg['Export']['sql_if_not_exists'] = true; + +/** + * + * + * @global boolean $cfg['Export']['sql_procedure_function'] + */ +$cfg['Export']['sql_procedure_function'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_auto_increment'] + */ +$cfg['Export']['sql_auto_increment'] = true; + +/** + * + * + * @global boolean $cfg['Export']['sql_backquotes'] + */ +$cfg['Export']['sql_backquotes'] = true; + +/** + * + * + * @global boolean $cfg['Export']['sql_dates'] + */ +$cfg['Export']['sql_dates'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_relation'] + */ +$cfg['Export']['sql_relation'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_columns'] + */ +$cfg['Export']['sql_columns'] = true; + +/** + * + * + * @global boolean $cfg['Export']['sql_delayed'] + */ +$cfg['Export']['sql_delayed'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_ignore'] + */ +$cfg['Export']['sql_ignore'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_hex_for_blob'] + */ +$cfg['Export']['sql_hex_for_blob'] = true; + +/** + * insert/update/replace + * + * @global string $cfg['Export']['sql_type'] + */ +$cfg['Export']['sql_type'] = 'insert'; + +/** + * + * + * @global boolean $cfg['Export']['sql_extended'] + */ +$cfg['Export']['sql_extended'] = true; + +/** + * + * + * @global integer $cfg['Export']['sql_max_query_size'] + */ +$cfg['Export']['sql_max_query_size'] = 50000; + +/** + * + * + * @global boolean $cfg['Export']['sql_comments'] + */ +$cfg['Export']['sql_comments'] = false; + +/** + * + * + * @global boolean $cfg['Export']['sql_mime'] + */ +$cfg['Export']['sql_mime'] = false; + +/** + * \n is replaced by new line + * + * @global string $cfg['Export']['sql_header_comment'] + */ +$cfg['Export']['sql_header_comment'] = ''; + +/** + * + * + * @global boolean $cfg['Export']['pdf_structure'] + */ +$cfg['Export']['pdf_structure'] = false; + +/** + * + * + * @global boolean $cfg['Export']['pdf_data'] + */ +$cfg['Export']['pdf_data'] = true; + +/** + * + * + * @global string $cfg['Export']['pdf_report_title'] + */ +$cfg['Export']['pdf_report_title'] = ''; + + +/******************************************************************************* + * Import defaults + */ +$cfg['Import'] = array(); + +/** + * + * + * @global string $cfg['Import']['format'] + */ +$cfg['Import']['format'] = 'sql'; + +/** + * + * + * @global boolean $cfg['Import']['allow_interrupt'] + */ +$cfg['Import']['allow_interrupt'] = true; + +/** + * + * + * @global integer $cfg['Import']['skip_queries'] + */ +$cfg['Import']['skip_queries'] = '0'; + +/** + * + * + * @global string $cfg['Import']['sql_compatibility'] + */ +$cfg['Import']['sql_compatibility'] = 'NONE'; + +/** + * + * + * @global boolean $cfg['Import']['csv_replace'] + */ +$cfg['Import']['csv_replace'] = false; + +/** + * + * + * @global string $cfg['Import']['csv_terminated'] + */ +$cfg['Import']['csv_terminated'] = ';'; + +/** + * + * + * @global string $cfg['Import']['csv_enclosed'] + */ +$cfg['Import']['csv_enclosed'] = '"'; + +/** + * + * + * @global string $cfg['Import']['csv_escaped'] + */ +$cfg['Import']['csv_escaped'] = '\\'; + +/** + * + * + * @global string $cfg['Import']['csv_new_line'] + */ +$cfg['Import']['csv_new_line'] = 'auto'; + +/** + * + * + * @global string $cfg['Import']['csv_columns'] + */ +$cfg['Import']['csv_columns'] = ''; + +/** + * + * + * @global boolean $cfg['Import']['ldi_replace'] + */ +$cfg['Import']['ldi_replace'] = false; + +/** + * + * + * @global string $cfg['Import']['ldi_terminated'] + */ +$cfg['Import']['ldi_terminated'] = ';'; + +/** + * + * + * @global string $cfg['Import']['ldi_enclosed'] + */ +$cfg['Import']['ldi_enclosed'] = '"'; + +/** + * + * + * @global string $cfg['Import']['ldi_escaped'] + */ +$cfg['Import']['ldi_escaped'] = '\\'; + +/** + * + * + * @global string $cfg['Import']['ldi_new_line'] + */ +$cfg['Import']['ldi_new_line'] = 'auto'; + +/** + * + * + * @global string $cfg['Import']['ldi_columns'] + */ +$cfg['Import']['ldi_columns'] = ''; + +/** + * 'auto' for auto-detection, true or false for forcing + * + * @global string $cfg['Import']['ldi_local_option'] + */ +$cfg['Import']['ldi_local_option'] = 'auto'; + +/** + * Link to the official MySQL documentation. + * Be sure to include no trailing slash on the path. + * See http://dev.mysql.com/doc/ for more information + * about MySQL manuals and their types. + * + * @global string $cfg['MySQLManualBase'] + */ +$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman'; + +/** + * Type of MySQL documentation: + * viewable - "viewable online", current one used on MySQL website + * searchable - "Searchable, with user comments" + * chapters - "HTML, one page per chapter" + * chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release + * big - "HTML, all on one page" + * old - old style used in phpMyAdmin 2.3.0 and sooner + * none - do not show documentation links + * + * @global string $cfg['MySQLManualType'] + */ +$cfg['MySQLManualType'] = 'viewable'; + + +/******************************************************************************* + * PDF options + */ + +/** + * + * + * @global array $cfg['PDFPageSizes'] + */ +$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal'); + +/** + * + * + * @global string $cfg['PDFDefaultPageSize'] + */ +$cfg['PDFDefaultPageSize'] = 'A4'; + + +/******************************************************************************* + * Language and character set conversion settings + */ + +/** + * Default language to use, if not browser-defined or user-defined + * + * @global string $cfg['DefaultLang'] + */ +$cfg['DefaultLang'] = 'en-iso-8859-1'; + +/** + * Default connection collation (used for MySQL >= 4.1) + * + * @global string $cfg['DefaultConnectionCollation'] + */ +$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci'; + +/** + * Force: always use this language - must be defined in + * libraries/select_lang.lib.php + * $cfg['Lang'] = 'en-iso-8859-1'; + * + * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and + * English only + * + * @global string $cfg['FilterLanguages'] + */ +$cfg['FilterLanguages'] = ''; + +/** + * Default character set to use for recoding of MySQL queries, does not take + * any effect when character sets recoding is switched off by + * $cfg['AllowAnywhereRecoding'] or in language file + * (see $cfg['AvailableCharsets'] to possible choices, you can add your own) + * + * @global string $cfg['DefaultCharset'] + */ +$cfg['DefaultCharset'] = 'iso-8859-1'; + +/** + * Allow character set recoding of MySQL queries, must be also enabled in language + * file to make harder using other language files than Unicode. + * Default value is false to avoid problems on servers without the iconv + * extension and where dl() is not supported + * + * @global boolean $cfg['AllowAnywhereRecoding'] + */ +$cfg['AllowAnywhereRecoding'] = false; + +/** + * You can select here which functions will be used for character set conversion. + * Possible values are: + * auto - automatically use available one (first is tested iconv, then + * recode) + * iconv - use iconv or libiconv functions + * recode - use recode_string function + * + * @global string $cfg['RecodingEngine'] + */ +$cfg['RecodingEngine'] = 'auto'; + +/** + * Specify some parameters for iconv used in character set conversion. See iconv + * documentation for details: + * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html + * + * @global string $cfg['IconvExtraParams'] + */ +$cfg['IconvExtraParams'] = '//TRANSLIT'; + +/** + * Available character sets for MySQL conversion. currently contains all which could + * be found in lang/* files and few more. + * Character sets will be shown in same order as here listed, so if you frequently + * use some of these move them to the top. + * + * @global array $cfg['AvailableCharsets'] + */ +$cfg['AvailableCharsets'] = array( + 'iso-8859-1', + 'iso-8859-2', + 'iso-8859-3', + 'iso-8859-4', + 'iso-8859-5', + 'iso-8859-6', + 'iso-8859-7', + 'iso-8859-8', + 'iso-8859-9', + 'iso-8859-10', + 'iso-8859-11', + 'iso-8859-12', + 'iso-8859-13', + 'iso-8859-14', + 'iso-8859-15', + 'windows-1250', + 'windows-1251', + 'windows-1252', + 'windows-1256', + 'windows-1257', + 'koi8-r', + 'big5', + 'gb2312', + 'utf-16', + 'utf-8', + 'utf-7', + 'x-user-defined', + 'euc-jp', + 'ks_c_5601-1987', + 'tis-620', + 'SHIFT_JIS' +); + + +/******************************************************************************* + * Customization & design + * + * The graphical settings are now located in themes/theme-name/layout.inc.php + */ + +/** + * enable the left panel pointer + * (used when LeftFrameLight is false) + * see also LeftPointerColor + * in layout.inc.php + * + * @global boolean $cfg['LeftPointerEnable'] + */ +$cfg['LeftPointerEnable'] = true; + +/** + * enable the browse pointer + * see also BrowsePointerColor + * in layout.inc.php + * + * @global boolean $cfg['BrowsePointerEnable'] + */ +$cfg['BrowsePointerEnable'] = true; + +/** + * enable the browse marker + * see also BrowseMarkerColor + * in layout.inc.php + * + * @global boolean $cfg['BrowseMarkerEnable'] + */ +$cfg['BrowseMarkerEnable'] = true; + +/** + * textarea size (columns) in edit mode + * (this value will be emphasized (*2) for SQL + * query textareas and (*1.25) for query window) + * + * @global integer $cfg['TextareaCols'] + */ +$cfg['TextareaCols'] = 40; + +/** + * textarea size (rows) in edit mode + * + * @global integer $cfg['TextareaRows'] + */ +$cfg['TextareaRows'] = 7; + +/** + * double size of textarea size for LONGTEXT fields + * + * @global boolean $cfg['LongtextDoubleTextarea'] + */ +$cfg['LongtextDoubleTextarea'] = true; + +/** + * auto-select when clicking in the textarea of the query-box + * + * @global boolean $cfg['TextareaAutoSelect'] + */ +$cfg['TextareaAutoSelect'] = false; + +/** + * textarea size (columns) for CHAR/VARCHAR + * + * @global integer $cfg['CharTextareaCols'] + */ +$cfg['CharTextareaCols'] = 40; + +/** + * textarea size (rows) for CHAR/VARCHAR + * + * @global integer $cfg['CharTextareaRows'] + */ +$cfg['CharTextareaRows'] = 2; + +/** + * Enable Ctrl+Arrows moving between fields when editing? + * + * @global boolean $cfg['CtrlArrowsMoving'] + */ +$cfg['CtrlArrowsMoving'] = true; + +/** + * Max field data length in browse mode for all non-numeric fields + * + * @global integer $cfg['LimitChars'] + */ +$cfg['LimitChars'] = 50; + +/** + * show edit/delete links on left side of browse + * (or at the top with vertical browse) + * + * @global boolean $cfg['ModifyDeleteAtLeft'] + */ +$cfg['ModifyDeleteAtLeft'] = true; + +/** + * show edit/delete links on right side of browse + * (or at the bottom with vertical browse) + * + * @global boolean $cfg['ModifyDeleteAtRight'] + */ +$cfg['ModifyDeleteAtRight'] = false; + +/** + * default display direction (horizontal|vertical|horizontalflipped) + * + * @global string $cfg['DefaultDisplay'] + */ +$cfg['DefaultDisplay'] = 'horizontal'; + +/** + * default display direction for altering/creating columns (tbl_properties) + * (horizontal|vertical|) + * number indicates maximal number for which vertical model is used + * + * @global integer $cfg['DefaultPropDisplay'] + */ +$cfg['DefaultPropDisplay'] = 3; + +/** + * table-header rotation via faking or CSS? (css|fake) + * NOTE: CSS only works in IE browsers! + * + * @global string $cfg['HeaderFlipType'] + */ +$cfg['HeaderFlipType'] = 'css'; + +/** + * shows stored relation-comments in 'browse' mode. + * + * @global boolean $cfg['ShowBrowseComments'] + */ +$cfg['ShowBrowseComments'] = true; + +/** + * shows stored relation-comments in 'table property' mode. + * + * @global boolean $cfg['ShowPropertyComments'] + */ +$cfg['ShowPropertyComments']= true; + +/** + * repeat header names every X cells? (0 = deactivate) + * + * @global integer $cfg['RepeatCells'] + */ +$cfg['RepeatCells'] = 100; + +/** + * Set to true if Edit link should open the query to edit in the query window + * (assuming JavaScript is enabled), and to false if we should edit in the right panel + * + * @global boolean $cfg['EditInWindow'] + */ +$cfg['EditInWindow'] = true; + +/** + * Width of Query window + * + * @global integer $cfg['QueryWindowWidth'] + */ +$cfg['QueryWindowWidth'] = 550; + +/** + * Height of Query window + * + * @global integer $cfg['QueryWindowHeight'] + */ +$cfg['QueryWindowHeight'] = 310; + +/** + * Set to true if you want DB-based query history.If false, this utilizes + * JS-routines to display query history (lost by window close) + * + * @global boolean $cfg['QueryHistoryDB'] + */ +$cfg['QueryHistoryDB'] = false; + +/** + * which tab to display in the querywindow on startup + * (sql|files|history|full) + * + * @global string $cfg['QueryWindowDefTab'] + */ +$cfg['QueryWindowDefTab'] = 'sql'; + +/** + * When using DB-based query history, how many entries should be kept? + * + * @global integer $cfg['QueryHistoryMax'] + */ +$cfg['QueryHistoryMax'] = 25; + +/** + * Use MIME-Types (stored in column comments table) for + * + * @global boolean $cfg['BrowseMIME'] + */ +$cfg['BrowseMIME'] = true; + +/** + * When approximate count < this, PMA will get exact count for table rows. + * + * @global integer $cfg['MaxExactCount'] + */ +$cfg['MaxExactCount'] = 20000; + +/** + * Zero means that no row count is done for views; see the doc + * + * @global integer $cfg['MaxExactCountViews'] + */ +$cfg['MaxExactCountViews'] = 0; + +/** + * Utilize DHTML/JS capabilities to allow WYSIWYG editing of + * the PDF page editor. Requires an IE6/Gecko based browser. + * + * @global boolean $cfg['WYSIWYG-PDF'] + */ +$cfg['WYSIWYG-PDF'] = true; + +/** + * Sort table and database in natural order + * + * @global boolean $cfg['NaturalOrder'] + */ +$cfg['NaturalOrder'] = true; + + +//----------------------------------------------------------------------------- +// custom-setup by mkkeck: 2004-05-04 +// some specials for new icons and scrolling +/** + * @todo 2004-05-08 rabus: We need to rearrange these variables. + */ + + +/******************************************************************************* + * Window title settings + */ + +/** + * title of browser window when a table is selected + * + * @global string $cfg['TitleTable'] + */ +$cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@'; + +/** + * title of browser window when a database is selected + * + * @global string $cfg['TitleDatabase'] + */ +$cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@'; + +/** + * title of browser window when a server is selected + * + * @global string $cfg['TitleServer'] + */ +$cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@'; + +/** + * title of browser window when nothing is selected + * @global string $cfg['TitleDefault'] + */ +$cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@'; + +/** + * show some icons for warning, error and information messages (true|false)? + * + * @global boolean $cfg['ErrorIconic'] + */ +$cfg['ErrorIconic'] = true; + +/** + * show icons in list on main page and on menu tabs (true|false)? + * + * @global boolean $cfg['MainPageIconic'] + */ +$cfg['MainPageIconic'] = true; + +/** + * show help button instead of strDocu (true|false)? + * + * @global boolean $cfg['ReplaceHelpImg'] + */ +$cfg['ReplaceHelpImg'] = true; + + +/******************************************************************************* + * theme manager + */ + +/** + * using themes manager please set up here the path to 'themes' else leave empty + * + * @global string $cfg['ThemePath'] + */ +$cfg['ThemePath'] = './themes'; + +/** + * if you want to use selectable themes and if ThemesPath not empty + * set it to true, else set it to false (default is false); + * + * @global boolean $cfg['ThemeManager'] + */ +$cfg['ThemeManager'] = true; + +/** + * set up default theme, if ThemePath not empty you can set up here an valid + * path to themes or 'original' for the original pma-theme + * + * @global string $cfg['ThemeDefault'] + */ +$cfg['ThemeDefault'] = 'original'; + +/** + * allow different theme for each configured server + * + * @global boolean $cfg['ThemePerServer'] + */ +$cfg['ThemePerServer'] = false; + + +/******************************************************************************* + * + */ + +/** + * Default queries + * %d will be replaced by the database name. + * %t will be replaced by the table name. + * %f will be replaced by a list of field names. + * (%t and %f only applies to DefaultQueryTable) + * + * @global string $cfg['DefaultQueryTable'] + */ +$cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1'; + +/** + * Default queries + * %d will be replaced by the database name. + * %t will be replaced by the table name. + * %f will be replaced by a list of field names. + * (%t and %f only applies to DefaultQueryTable) + * + * @global string $cfg['DefaultQueryDatabase'] + */ +$cfg['DefaultQueryDatabase'] = ''; + + +/******************************************************************************* + * SQL Query box settings + * These are the links display in all of the SQL Query boxes + * + * @global array $cfg['SQLQuery'] + */ +$cfg['SQLQuery'] = array(); + +/** + * Edit link to change a query + * + * @global boolean $cfg['SQLQuery']['Edit'] + */ +$cfg['SQLQuery']['Edit'] = true; + +/** + * EXPLAIN on SELECT queries + * + * @global boolean $cfg['SQLQuery']['Explain'] + */ +$cfg['SQLQuery']['Explain'] = true; + +/** + * Wrap a query in PHP + * + * @global boolean $cfg['SQLQuery']['ShowAsPHP'] + */ +$cfg['SQLQuery']['ShowAsPHP'] = true; + +/** + * Validate a query (see $cfg['SQLValidator'] as well) + * + * @global boolean $cfg['SQLQuery']['Validate'] + */ +$cfg['SQLQuery']['Validate'] = false; + +/** + * Refresh the results page + * + * @global boolean $cfg['SQLQuery']['Refresh'] + */ +$cfg['SQLQuery']['Refresh'] = true; + + +/******************************************************************************* + * Web server upload/save/import directories + */ + +/** + * Directory for uploaded files that can be executed by phpMyAdmin. + * For example './upload'. Leave empty for no upload directory support. + * Use %u for username inclusion. + * + * @global string $cfg['UploadDir'] + */ +$cfg['UploadDir'] = ''; + +/** + * Directory where phpMyAdmin can save exported data on server. + * For example './save'. Leave empty for no save directory support. + * Use %u for username inclusion. + * + * @global string $cfg['SaveDir'] + */ +$cfg['SaveDir'] = ''; + +/** + * Directory where phpMyAdmin can save temporary files. + * This is needed for MS Excel export, see documentation how to enable that. + * + * @global string $cfg['TempDir'] + */ +$cfg['TempDir'] = ''; + + +/** + * Misc. settings + */ + +/** + * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection, + * which is a bit expensive for PHP < 4.3.0, but it is the only safe way how to + * determine GD version. + * + * @global string $cfg['GD2Available'] + */ +$cfg['GD2Available'] = 'auto'; + +/** + * List of trusted proxies for IP allow/deny + * + * @global array $cfg['TrustedProxies'] + */ +$cfg['TrustedProxies'] = array(); + + +/******************************************************************************* + * SQL Parser Settings + * + * @global array $cfg['SQP'] + */ +$cfg['SQP'] = array(); + +/** + * Pretty-printing style to use on queries (html, text, none) + * + * @global string $cfg['SQP']['fmtType'] + */ +$cfg['SQP']['fmtType'] = 'html'; + +/** + * Amount to indent each level (floats are valid) + * + * @global integer $cfg['SQP']['fmtInd'] + */ +$cfg['SQP']['fmtInd'] = '1'; + +/** + * Units for indenting each level (CSS Types - {em, px, pt}) + * + * @global string $cfg['SQP']['fmtIndUnit'] + */ +$cfg['SQP']['fmtIndUnit'] = 'em'; + + +/******************************************************************************* + * If you wish to use the SQL Validator service, you should be aware of the + * following: + * All SQL statements are stored anonymously for statistical purposes. + * Mimer SQL Validator, Copyright 2002 Upright Database Technology. + * All rights reserved. + * + * @global array $cfg['SQLValidator'] + */ +$cfg['SQLValidator'] = array(); + +/** + * Make the SQL Validator available + * + * @global boolean $cfg['SQLValidator']['use'] + */ +$cfg['SQLValidator']['use'] = false; + +/** + * If you have a custom username, specify it here (defaults to anonymous) + * + * @global string $cfg['SQLValidator']['username'] + */ +$cfg['SQLValidator']['username'] = ''; + +/** + * Password for username + * + * @global string $cfg['SQLValidator']['password'] + */ +$cfg['SQLValidator']['password'] = ''; + + +/******************************************************************************* + * Developers ONLY! + * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/ + * + * @global array $cfg['DBG'] + */ +$cfg['DBG'] = array(); + +/** + * Make the DBG stuff available + * + * @global boolean $cfg['DBG']['enable'] + */ +$cfg['DBG']['enable'] = false; + +/** + * Produce profiling results of PHP + * + * @global boolean $cfg['DBG']['profile']['enable'] + */ +$cfg['DBG']['profile']['enable'] = false; + +/** + * Threshold of long running code to display + * Anything below the threshold is not displayed + * + * @global float $cfg['DBG']['profile']['threshold'] + */ +$cfg['DBG']['profile']['threshold'] = 0.5; + + +/******************************************************************************* + * MySQL settings + */ + +/** + * Column types; + * VARCHAR, TINYINT, TEXT and DATE are listed first, based on estimated popularity + * + * @global array $cfg['ColumnTypes'] + */ +$cfg['ColumnTypes'] = array( + 'VARCHAR', + 'TINYINT', + 'TEXT', + 'DATE', + 'SMALLINT', + 'MEDIUMINT', + 'INT', + 'BIGINT', + 'FLOAT', + 'DOUBLE', + 'DECIMAL', + 'DATETIME', + 'TIMESTAMP', + 'TIME', + 'YEAR', + 'CHAR', + 'TINYBLOB', + 'TINYTEXT', + 'BLOB', + 'MEDIUMBLOB', + 'MEDIUMTEXT', + 'LONGBLOB', + 'LONGTEXT', + 'ENUM', + 'SET', + 'BIT', + 'BOOL' +); + +/** + * Attributes + * Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically + * for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php + * + * @global array $cfg['AttributeTypes'] + */ +$cfg['AttributeTypes'] = array( + '', + 'BINARY', + 'UNSIGNED', + 'UNSIGNED ZEROFILL' +); + + +if ($cfg['ShowFunctionFields']) { + /** + * Available functions + * + * @global array $cfg['Functions'] + */ + $cfg['Functions'] = array( + 'ASCII', + 'CHAR', + 'SOUNDEX', + 'LCASE', + 'UCASE', + 'NOW', + 'PASSWORD', + 'OLD_PASSWORD', + 'MD5', + 'SHA1', + 'ENCRYPT', + 'COMPRESS', + 'UNCOMPRESS', + 'RAND', + 'LAST_INSERT_ID', + 'COUNT', + 'AVG', + 'SUM', + 'CURDATE', + 'CURTIME', + 'UTC_DATE', + 'UTC_TIME', + 'UTC_TIMESTAMP', + 'FROM_DAYS', + 'FROM_UNIXTIME', + 'PERIOD_ADD', + 'PERIOD_DIFF', + 'TO_DAYS', + 'UNIX_TIMESTAMP', + 'USER', + 'WEEKDAY', + 'CONCAT', + 'HEX', + 'UNHEX' + ); + + /** + * Which column types will be mapped to which Group? + * + * @global array $cfg['RestrictColumnTypes'] + */ + $cfg['RestrictColumnTypes'] = array( + 'VARCHAR' => 'FUNC_CHAR', + 'TINYINT' => 'FUNC_NUMBER', + 'TEXT' => 'FUNC_CHAR', + 'DATE' => 'FUNC_DATE', + 'SMALLINT' => 'FUNC_NUMBER', + 'MEDIUMINT' => 'FUNC_NUMBER', + 'INT' => 'FUNC_NUMBER', + 'BIGINT' => 'FUNC_NUMBER', + 'FLOAT' => 'FUNC_NUMBER', + 'DOUBLE' => 'FUNC_NUMBER', + 'DECIMAL' => 'FUNC_NUMBER', + 'DATETIME' => 'FUNC_DATE', + 'TIMESTAMP' => 'FUNC_DATE', + 'TIME' => 'FUNC_DATE', + 'YEAR' => 'FUNC_DATE', + 'CHAR' => 'FUNC_CHAR', + 'TINYBLOB' => 'FUNC_CHAR', + 'TINYTEXT' => 'FUNC_CHAR', + 'BLOB' => 'FUNC_CHAR', + 'MEDIUMBLOB' => 'FUNC_CHAR', + 'MEDIUMTEXT' => 'FUNC_CHAR', + 'LONGBLOB' => 'FUNC_CHAR', + 'LONGTEXT' => 'FUNC_CHAR', + 'ENUM' => '', + 'SET' => '' + ); + + /** + * Map above defined groups to any function + * + * @global array $cfg['RestrictFunctions'] + */ + $cfg['RestrictFunctions'] = array( + 'FUNC_CHAR' => array( + 'ASCII', + 'CHAR', + 'SOUNDEX', + 'LCASE', + 'UCASE', + 'PASSWORD', + 'OLD_PASSWORD', + 'MD5', + 'SHA1', + 'ENCRYPT', + 'COMPRESS', + 'UNCOMPRESS', + 'LAST_INSERT_ID', + 'USER', + 'CONCAT', + 'HEX', + 'UNHEX' + ), + + 'FUNC_DATE' => array( + 'NOW', + 'CURDATE', + 'CURTIME', + 'FROM_DAYS', + 'FROM_UNIXTIME', + 'PERIOD_ADD', + 'PERIOD_DIFF', + 'TO_DAYS', + 'UNIX_TIMESTAMP', + 'UTC_DATE', + 'UTC_TIME', + 'UTC_TIMESTAMP', + 'WEEKDAY' + ), + + 'FUNC_NUMBER' => array( + 'ASCII', + 'CHAR', + 'MD5', + 'SHA1', + 'ENCRYPT', + 'RAND', + 'LAST_INSERT_ID', + 'UNIX_TIMESTAMP', + 'COUNT', + 'AVG', + 'SUM' + ) + ); + + /** + * Default functions for above defined groups + * + * @global array $cfg['DefaultFunctions'] + */ + $cfg['DefaultFunctions'] = array( + 'FUNC_CHAR' => '', + 'FUNC_DATE' => '', + 'FUNC_NUMBER' => '', + 'first_timestamp' => 'NOW' + ); + + +} // end if + +/** + * Search operators + * + * @global array $cfg['NumOperators'] + */ +$cfg['NumOperators'] = array( + '=', + '>', + '>=', + '<', + '<=', + '!=', + 'LIKE', + 'NOT LIKE' +); + +/** + * Search operators + * + * @global array $cfg['TextOperators'] + */ +$cfg['TextOperators'] = array( + 'LIKE', + 'LIKE %...%', + 'NOT LIKE', + '=', + '!=', + 'REGEXP', + 'NOT REGEXP' +); + +/** + * Search operators + * + * @global array $cfg['EnumOperators'] + */ +$cfg['EnumOperators'] = array( + '=', + '!=' +); + +/** + * Search operators + * + * @global array $cfg['SetOperators'] + */ +$cfg['SetOperators'] = array( + 'IN', + 'NOT IN' +); + +/** + * Search operators + * + * @global array $cfg['NullOperators'] + */ +$cfg['NullOperators'] = array( + 'IS NULL', + 'IS NOT NULL' +); + +/** + * Search operators + * + * @global array $cfg['UnaryOperators'] + */ +$cfg['UnaryOperators'] = array( + 'IS NULL' => 1, + 'IS NOT NULL' => 1 +); + +?>