/**
*
*
* @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']['texytext_structure']
*/
$cfg['Export']['texytext_structure'] = TRUE;
/**
*
*
* @global boolean $cfg['Export']['texytext_data']
*/
$cfg['Export']['texytext_data'] = TRUE;
/**
*
*
* @global boolean $cfg['Export']['texytext_columns']
*/
$cfg['Export']['texytext_columns'] = FALSE;
/**
*
*
* @global string $cfg['Export']['texytext_null']
*/
$cfg['Export']['texytext_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';
/**
* Whether to include comments in SQL export.
*
* @global string $cfg['Export']['sql_include_comments']
*/
$cfg['Export']['sql_include_comments'] = true;
/**
*
*
* @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;
/**
*
*
* true by default for correct behavior when dealing with exporting
* of VIEWs and the stand-in table
* @global boolean $cfg['Export']['sql_if_not_exists']
*/
$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';
/**
* Default charset for import.
*
* @global string $cfg['Import']['charset']
*/
$cfg['Import']['charset'] = '';
/**
*
*
* @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 string $cfg['Import']['sql_no_auto_value_on_zero']
*/
$cfg['Import']['sql_no_auto_value_on_zero'] = true;
/**
*
*
* @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'] = 'zh';
/**
* Default connection collation
*
* @global string $cfg['DefaultConnectionCollation']
*/
$cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
/**
* Force: always use this language - must be defined in
* libraries/select_lang.lib.php
* $cfg['Lang'] = 'en-utf-8';
*
* 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'] = 'utf-8';
/**
* 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
*
* @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/libi ... v/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>)
* 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;
/**
* Initial state for sliders
* (open | closed)
*
* @global string $cfg['InitialSlidersState']
*/
$cfg['InitialSlidersState'] = 'closed';
//-----------------------------------------------------------------------------
// 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 the only safe way to determine GD version.
*
* @global string $cfg['GD2Available']
*/
$cfg['GD2Available'] = 'auto';
/**
* Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
*
* @global array $cfg['TrustedProxies']
*/
$cfg['TrustedProxies'] = array();
/**
* We normally check the permissions on the configuration file to ensure
* it's not world writable. However, phpMyAdmin could be installed on
* a NTFS filesystem mounted on a non-Windows server, in which case the
* permissions seems wrong but in fact cannot be detected. In this case
* a sysadmin would set the following to false.
*/
$cfg['CheckConfigurationPermissions'] = true;
/*******************************************************************************
* 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!
*
* @global array $cfg['DBG']
*/
$cfg['DBG'] = array();
/**
* Output executed queries and their execution times
*
* @global boolean $cfg['DBG']['sql']
*/
$cfg['DBG']['sql'] = false;
/**
* Make the DBG stuff available
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
*
* @global boolean $cfg['DBG']['php']
*/
$cfg['DBG']['php'] = 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(
// most used
'INT',
'VARCHAR',
'TEXT',
'DATE',
// numeric
'NUMERIC' => array(
'TINYINT',
'SMALLINT',
'MEDIUMINT',
'INT',
'BIGINT',
'-',
'DECIMAL',
'FLOAT',
'DOUBLE',
'REAL',
'-',
'BIT',
'BOOL',
'SERIAL',
),
// Date/Time
'DATE and TIME' => array(
'DATE',
'DATETIME',
'TIMESTAMP',
'TIME',
'YEAR',
),
// Text
'STRING' => array(
'CHAR',
'VARCHAR',
'-',
'TINYTEXT',
'TEXT',
'MEDIUMTEXT',
'LONGTEXT',
'-',
'BINARY',
'VARBINARY',
'-',
'TINYBLOB',
'MEDIUMBLOB',
'BLOB',
'LONGBLOB',
'-',
'ENUM',
'SET',
),
'SPATIAL' => array(
'GEOMETRY',
'POINT',
'LINESTRING',
'POLYGON',
'MULTIPOINT',
'MULTILINESTRING',
'MULTIPOLYGON',
'GEOMETRYCOLLECTION',
),
);
/**
* Attributes
*
* @global array $cfg['AttributeTypes']
*/
$cfg['AttributeTypes'] = array(
'',
'BINARY',
'UNSIGNED',
'UNSIGNED ZEROFILL',
'on update CURRENT_TIMESTAMP',
);
if ($cfg['ShowFunctionFields']) {
/**
* Available functions
*
* @global array $cfg['Functions']
*/
$cfg['Functions'] = array(
'ABS',
'ACOS',
'ASCII',
'ASIN',
'ATAN',
'BIN',
'BIT_COUNT',
'BIT_LENGTH',
'CEILING',
'CHAR',
'CHAR_LENGTH',
'COMPRESS',
'COS',
'COT',
'CRC32',
'CURDATE',
'CURRENT_USER',
'CURTIME',
'DATE',
'DAYNAME',
'DEGREES',
'DES_DECRYPT',
'DES_ENCRYPT',
'ENCRYPT',
'EXP',
'FLOOR',
'FROM_DAYS',
'FROM_UNIXTIME',
'HEX',
'INET_ATON',
'INET_NTOA',
'LENGTH',
'LN',
'LOG',
'LOG10',
'LOG2',
'LOWER',
'MD5',
'NOW',
'OCT',
'OLD_PASSWORD',
'ORD',
'PASSWORD',
'RADIANS',
'RAND',
'REVERSE',
'ROUND',
'SEC_TO_TIME',
'SHA1',
'SOUNDEX',
'SPACE',
'SQRT',
'STDDEV_POP',
'STDDEV_SAMP',
'TAN',
'TIMESTAMP',
'TIME_TO_SEC',
'UNCOMPRESS',
'UNHEX',
'UNIX_TIMESTAMP',
'UPPER',
'USER',
'UTC_DATE',
'UTC_TIME',
'UTC_TIMESTAMP',
'UUID',
'VAR_POP',
'VAR_SAMP',
'YEAR',
);
/**
* Which column types will be mapped to which Group?
*
* @global array $cfg['RestrictColumnTypes']
*/
$cfg['RestrictColumnTypes'] = array(
'TINYINT' => 'FUNC_NUMBER',
'SMALLINT' => 'FUNC_NUMBER',
'MEDIUMINT' => 'FUNC_NUMBER',
'INT' => 'FUNC_NUMBER',
'BIGINT' => 'FUNC_NUMBER',
'DECIMAL' => 'FUNC_NUMBER',
'FLOAT' => 'FUNC_NUMBER',
'DOUBLE' => 'FUNC_NUMBER',
'REAL' => 'FUNC_NUMBER',
'BIT' => 'FUNC_NUMBER',
'BOOL' => 'FUNC_NUMBER',
'SERIAL' => 'FUNC_NUMBER',
'DATE' => 'FUNC_DATE',
'DATETIME' => 'FUNC_DATE',
'TIMESTAMP' => 'FUNC_DATE',
'TIME' => 'FUNC_DATE',
'YEAR' => 'FUNC_DATE',
'CHAR' => 'FUNC_CHAR',
'VARCHAR' => 'FUNC_CHAR',
'TINYTEXT' => 'FUNC_CHAR',
'TEXT' => 'FUNC_CHAR',
'MEDIUMTEXT' => 'FUNC_CHAR',
'LONGTEXT' => 'FUNC_CHAR',
'BINARY' => 'FUNC_CHAR',
'VARBINARY' => 'FUNC_CHAR',
'TINYBLOB' => 'FUNC_CHAR',
'MEDIUMBLOB' => 'FUNC_CHAR',
'BLOB' => 'FUNC_CHAR',
'LONGBLOB' => 'FUNC_CHAR',
'ENUM' => '',
'SET' => '',
'GEOMETRY' => 'FUNC_SPATIAL',
'POINT' => 'FUNC_SPATIAL',
'LINESTRING' => 'FUNC_SPATIAL',
'POLYGON' => 'FUNC_SPATIAL',
'MULTIPOINT' => 'FUNC_SPATIAL',
'MULTILINESTRING' => 'FUNC_SPATIAL',
'MULTIPOLYGON' => 'FUNC_SPATIAL',
'GEOMETRYCOLLECTION' => 'FUNC_SPATIAL',
);
/**
* Map above defined groups to any function
*
* @global array $cfg['RestrictFunctions']
*/
$cfg['RestrictFunctions'] = array(
'FUNC_CHAR' => array(
'BIN',
'CHAR',
'CURRENT_USER',
'COMPRESS',
'DAYNAME',
'DES_DECRYPT',
'DES_ENCRYPT',
'ENCRYPT',
'HEX',
'INET_NTOA',
'LOWER',
'MD5',
'OLD_PASSWORD',
'PASSWORD',
'REVERSE',
'SHA1',
'SOUNDEX',
'SPACE',
'UNCOMPRESS',
'UNHEX',
'UPPER',
'USER',
'UUID',
),
'FUNC_DATE' => array(
'CURDATE',
'CURTIME',
'DATE',
'FROM_DAYS',
'FROM_UNIXTIME',
'NOW',
'SEC_TO_TIME',
'TIMESTAMP',
'UTC_DATE',
'UTC_TIME',
'UTC_TIMESTAMP',
'YEAR',
),
'FUNC_NUMBER' => array(
'ABS',
'ACOS',
'ASCII',
'ASIN',
'ATAN',
'BIT_LENGTH',
'BIT_COUNT',
'CEILING',
'CHAR_LENGTH',
'COS',
'COT',
'CRC32',
'DEGREES',
'EXP',
'FLOOR',
'INET_ATON',
'LENGTH',
'LN',
'LOG',
'LOG2',
'LOG10',
'OCT',
'ORD',
'RADIANS',
'RAND',
'ROUND',
'SQRT',
'STDDEV_POP',
'STDDEV_SAMP',
'TAN',
'TIME_TO_SEC',
'UNIX_TIMESTAMP',
'VAR_POP',
'VAR_SAMP',
),
'FUNC_SPATIAL' => array(
'GeomFromText',
'GeomFromWKB',
'GeomCollFromText',
'LineFromText',
'MLineFromText',
'PointFromText',
'MPointFromText',
'PolyFromText',
'MPolyFromText',
'GeomCollFromWKB',
'LineFromWKB',
'MLineFromWKB',
'PointFromWKB',
'MPointFromWKB',
'PolyFromWKB',
'MPolyFromWKB',
),
);
/**
* Default functions for above defined groups
*
* @global array $cfg['DefaultFunctions']
*/
$cfg['DefaultFunctions'] = array(
'FUNC_CHAR' => '',
'FUNC_DATE' => '',
'FUNC_NUMBER' => '',
'first_timestamp' => 'NOW',
'pk_char36' => 'UUID',
);
} // 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,
"= ''" => 1,
"!= ''" => 1
);
?> |
置顶卡
喧嚣卡
变色卡
千斤顶
显身卡
楼主