libraries/config.values.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Database with allowed values for configuration stored in the $cfg array,
   5  * used by setup script and user preferences to generate forms.
   6  *
   7  * @package PhpMyAdmin
   8  */
   9
  10 if (!defined('PHPMYADMIN')) {
  11     exit;
  12 }
  13
  14 /**
  15  * Value meaning:
  16  * o array - select field, array contains allowed values
  17  * o string - type override
  18  *
  19  * Use normal array, paths won't be expanded
  20  */
  21 $cfg_db = array();
  22
  23 $cfg_db['Servers'] = array(
  24     1 => array(
  25         'port'         => 'integer',
  26         'connect_type' => array('tcp', 'socket'),
  27         'auth_type'    => array('config', 'http', 'signon', 'cookie'),
  28         'AllowDeny'    => array(
  29             'order' => array('', 'deny,allow', 'allow,deny', 'explicit')
  30         ),
  31         'only_db'      => 'array'
  32     )
  33 );
  34 $cfg_db['RecodingEngine'] = array('auto', 'iconv', 'recode', 'mb', 'none');
  35 $cfg_db['OBGzip'] = array('auto', true, false);
  36 $cfg_db['MemoryLimit'] = 'short_string';
  37 $cfg_db['NavigationLogoLinkWindow'] = array('main', 'new');
  38 $cfg_db['NavigationTreeDefaultTabTable'] = array(
  39     'structure' => __('Structure'), // fields list
  40     'sql' => __('SQL'),             // SQL form
  41     'search' => __('Search'),       // search page
  42     'insert' => __('Insert'),       // insert row page
  43     'browse' => __('Browse')        // browse page
  44 );
  45 $cfg_db['NavigationTreeDefaultTabTable2'] = array(
  46     '' => '', //don't display
  47     'structure' => __('Structure'), // fields list
  48     'sql' => __('SQL'),             // SQL form
  49     'search' => __('Search'),       // search page
  50     'insert' => __('Insert'),       // insert row page
  51     'browse' => __('Browse')        // browse page
  52 );
  53 $cfg_db['NavigationTreeDbSeparator'] = 'short_string';
  54 $cfg_db['NavigationTreeTableSeparator'] = 'short_string';
  55 $cfg_db['TableNavigationLinksMode'] = array(
  56     'icons' => __('Icons'),
  57     'text'  => __('Text'),
  58     'both'  => __('Both')
  59 );
  60 $cfg_db['MaxRows'] = array(25, 50, 100, 250, 500);
  61 $cfg_db['Order'] = array('ASC', 'DESC', 'SMART');
  62 $cfg_db['RowActionLinks'] = array(
  63     'none'  => __('Nowhere'),
  64     'left'  => __('Left'),
  65     'right' => __('Right'),
  66     'both'  => __('Both')
  67 );
  68 $cfg_db['TablePrimaryKeyOrder'] = array(
  69     'NONE'  => __('None'),
  70     'ASC'   => __('Ascending'),
  71     'DESC'  => __('Descending')
  72 );
  73 $cfg_db['ProtectBinary'] = array(false, 'blob', 'noblob', 'all');
  74 $cfg_db['CharEditing'] = array('input', 'textarea');
  75 $cfg_db['TabsMode'] = array(
  76     'icons' => __('Icons'),
  77     'text'  => __('Text'),
  78     'both'  => __('Both')
  79 );
  80 $cfg_db['PDFDefaultPageSize'] = array(
  81     'A3'     => 'A3',
  82     'A4'     => 'A4',
  83     'A5'     => 'A5',
  84     'letter' => 'letter',
  85     'legal'  => 'legal'
  86 );
  87 $cfg_db['ActionLinksMode'] = array(
  88     'icons' => __('Icons'),
  89     'text'  => __('Text'),
  90     'both'  => __('Both')
  91 );
  92 $cfg_db['GridEditing'] = array(
  93     'click' => __('Click'),
  94     'double-click' => __('Double click'),
  95     'disabled' => __('Disabled'),
  96 );
  97 $cfg_db['RelationalDisplay'] = array(
  98     'K' => __('key'),
  99     'D' => __('display column')
 100 );
 101 $cfg_db['DefaultTabServer'] = array(
 102     // the welcome page (recommended for multiuser setups)
 103     'welcome' => __('Welcome'),
 104     'databases' => __('Databases'),    // list of databases
 105     'status' => __('Status'),          // runtime information
 106     'variables' => __('Variables'),    // MySQL server variables
 107     'privileges' => __('Privileges')   // user management
 108 );
 109 $cfg_db['DefaultTabDatabase'] = array(
 110     'structure' => __('Structure'),   // tables list
 111     'sql' => __('SQL'),               // SQL form
 112     'search' => __('Search'),         // search query
 113     'operations' => __('Operations')  // operations on database
 114 );
 115 $cfg_db['DefaultTabTable'] = array(
 116     'structure' => __('Structure'),  // fields list
 117     'sql' => __('SQL'),              // SQL form
 118     'search' => __('Search'),        // search page
 119     'insert' => __('Insert'),        // insert row page
 120     'browse' => __('Browse')         // browse page
 121 );
 122 $cfg_db['InitialSlidersState'] = array(
 123     'open'     => __('Open'),
 124     'closed'   => __('Closed'),
 125     'disabled' => __('Disabled')
 126 );
 127 $cfg_db['SendErrorReports'] = array(
 128     'ask'     => __('Ask before sending error reports'),
 129     'always'   => __('Always send error reports'),
 130     'never' => __('Never send error reports')
 131 );
 132 $cfg_db['DefaultForeignKeyChecks'] = array(
 133     'default'   => __('Server default'),
 134     'enable'    => __('Enable'),
 135     'disable'   => __('Disable')
 136 );
 137 $cfg_db['Import']['format'] = array(
 138     'csv',    // CSV
 139     'docsql', // DocSQL
 140     'ldi',    // CSV using LOAD DATA
 141     'sql'     // SQL
 142 );
 143 $cfg_db['Import']['charset'] = array_merge(
 144     array(''),
 145     $GLOBALS['cfg']['AvailableCharsets']
 146 );
 147 $cfg_db['Import']['sql_compatibility']
 148     = $cfg_db['Export']['sql_compatibility'] = array(
 149         'NONE', 'ANSI', 'DB2', 'MAXDB', 'MYSQL323',
 150         'MYSQL40', 'MSSQL', 'ORACLE',
 151         // removed; in MySQL 5.0.33, this produces exports that
 152         // can't be read by POSTGRESQL (see our bug #1596328)
 153         //'POSTGRESQL',
 154         'TRADITIONAL'
 155     );
 156 $cfg_db['Import']['csv_terminated'] = 'short_string';
 157 $cfg_db['Import']['csv_enclosed'] = 'short_string';
 158 $cfg_db['Import']['csv_escaped'] = 'short_string';
 159 $cfg_db['Import']['ldi_terminated'] = 'short_string';
 160 $cfg_db['Import']['ldi_enclosed'] = 'short_string';
 161 $cfg_db['Import']['ldi_escaped'] = 'short_string';
 162 $cfg_db['Import']['ldi_local_option'] = array('auto', true, false);
 163 $cfg_db['Export']['_sod_select'] = array(
 164     'structure'          => __('structure'),
 165     'data'               => __('data'),
 166     'structure_and_data' => __('structure and data')
 167 );
 168 $cfg_db['Export']['method'] = array(
 169     'quick'          => __('Quick - display only the minimal options to configure'),
 170     'custom'         => __('Custom - display all possible options to configure'),
 171     'custom-no-form' => __(
 172         'Custom - like above, but without the quick/custom choice'
 173     ),
 174 );
 175 $cfg_db['Export']['format'] = array(
 176     'codegen', 'csv', 'excel', 'htmlexcel','htmlword', 'latex', 'ods',
 177     'odt', 'pdf', 'sql', 'texytext', 'xml', 'yaml'
 178 );
 179 $cfg_db['Export']['compression'] = array('none', 'zip', 'gzip');
 180 $cfg_db['Export']['charset'] = array_merge(
 181     array(''),
 182     $GLOBALS['cfg']['AvailableCharsets']
 183 );
 184 $cfg_db['Export']['codegen_format'] = array(
 185     '#', 'NHibernate C# DO', 'NHibernate XML'
 186 );
 187 $cfg_db['Export']['csv_separator'] = 'short_string';
 188 $cfg_db['Export']['csv_terminated'] = 'short_string';
 189 $cfg_db['Export']['csv_enclosed'] = 'short_string';
 190 $cfg_db['Export']['csv_escaped'] = 'short_string';
 191 $cfg_db['Export']['csv_null'] = 'short_string';
 192 $cfg_db['Export']['excel_null'] = 'short_string';
 193 $cfg_db['Export']['excel_edition'] = array(
 194     'win'           => 'Windows',
 195     'mac_excel2003' => 'Excel 2003 / Macintosh',
 196     'mac_excel2008' => 'Excel 2008 / Macintosh'
 197 );
 198 $cfg_db['Export']['sql_structure_or_data'] = $cfg_db['Export']['_sod_select'];
 199 $cfg_db['Export']['sql_type'] = array('INSERT', 'UPDATE', 'REPLACE');
 200 $cfg_db['Export']['sql_insert_syntax'] = array(
 201     'complete' => __('complete inserts'),
 202     'extended' => __('extended inserts'),
 203     'both'     => __('both of the above'),
 204     'none'     => __('neither of the above')
 205 );
 206 $cfg_db['Export']['htmlword_structure_or_data'] = $cfg_db['Export']['_sod_select'];
 207 $cfg_db['Export']['htmlword_null'] = 'short_string';
 208 $cfg_db['Export']['ods_null'] = 'short_string';
 209 $cfg_db['Export']['odt_null'] = 'short_string';
 210 $cfg_db['Export']['odt_structure_or_data'] = $cfg_db['Export']['_sod_select'];
 211 $cfg_db['Export']['texytext_structure_or_data'] = $cfg_db['Export']['_sod_select'];
 212 $cfg_db['Export']['texytext_null'] = 'short_string';
 213
 214 /**
 215  * Default values overrides
 216  * Use only full paths
 217  */
 218 $cfg_db['_overrides'] = array();
 219
 220 /**
 221  * Basic validator assignments (functions from libraries/config/Validator.php
 222  * and 'validators' object in js/config.js)
 223  * Use only full paths and form ids
 224  */
 225 $cfg_db['_validators'] = array(
 226     'CharTextareaCols' => 'validatePositiveNumber',
 227     'CharTextareaRows' => 'validatePositiveNumber',
 228     'ExecTimeLimit' => 'validateNonNegativeNumber',
 229     'Export/sql_max_query_size' => 'validatePositiveNumber',
 230     'FirstLevelNavigationItems' => 'validatePositiveNumber',
 231     'ForeignKeyMaxLimit' => 'validatePositiveNumber',
 232     'Import/csv_enclosed' => array(array('validateByRegex', '/^.?$/')),
 233     'Import/csv_escaped' => array(array('validateByRegex', '/^.$/')),
 234     'Import/csv_terminated' => array(array('validateByRegex', '/^.$/')),
 235     'Import/ldi_enclosed' => array(array('validateByRegex', '/^.?$/')),
 236     'Import/ldi_escaped' => array(array('validateByRegex', '/^.$/')),
 237     'Import/ldi_terminated' => array(array('validateByRegex', '/^.$/')),
 238     'Import/skip_queries' => 'validateNonNegativeNumber',
 239     'InsertRows' => 'validatePositiveNumber',
 240     'NumRecentTables' => 'validateNonNegativeNumber',
 241     'NumFavoriteTables' => 'validateNonNegativeNumber',
 242     'LimitChars' => 'validatePositiveNumber',
 243     'LoginCookieValidity' => 'validatePositiveNumber',
 244     'LoginCookieStore' => 'validateNonNegativeNumber',
 245     'MaxDbList' => 'validatePositiveNumber',
 246     'MaxNavigationItems' => 'validatePositiveNumber',
 247     'MaxCharactersInDisplayedSQL' => 'validatePositiveNumber',
 248     'MaxRows' => 'validatePositiveNumber',
 249     'MaxTableList' => 'validatePositiveNumber',
 250     'MemoryLimit' => array(array('validateByRegex', '/^(-1|(\d+(?:[kmg])?))$/i')),
 251     'NavigationTreeTableLevel' => 'validatePositiveNumber',
 252     'QueryHistoryMax' => 'validatePositiveNumber',
 253     'RepeatCells' => 'validateNonNegativeNumber',
 254     'Server' => 'validateServer',
 255     'Server_pmadb' => 'validatePMAStorage',
 256     'Servers/1/port' => 'validatePortNumber',
 257     'Servers/1/hide_db' => 'validateRegex',
 258     'TextareaCols' => 'validatePositiveNumber',
 259     'TextareaRows' => 'validatePositiveNumber',
 260     'TrustedProxies' => 'validateTrustedProxies');
 261
 262 /**
 263  * Additional validators used for user preferences
 264  */
 265 $cfg_db['_userValidators'] = array(
 266     'MaxDbList'       => array(
 267         array('validateUpperBound', 'value:MaxDbList')
 268     ),
 269     'MaxTableList'    => array(
 270         array('validateUpperBound', 'value:MaxTableList')
 271     ),
 272     'QueryHistoryMax' => array(
 273         array('validateUpperBound', 'value:QueryHistoryMax')
 274     )
 275 );