/**
* mysql settings
*/
// column types;
// varchar, tinyint, text and date are listed first, based on estimated popularity
$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'
);
// atributes
$cfg['attributetypes'] = array(
'',
'binary',
'unsigned',
'unsigned zerofill'
);
// available functions
if ($cfg['showfunctionfields']) {
$cfg['functions'] = array(
'ascii',
'char',
'soundex',
'lcase',
'ucase',
'now',
'password',
'md5',
'encrypt',
'rand',
'last_insert_id',
'count',
'avg',
'sum',
'curdate',
'curtime',
'from_days',
'from_unixtime',
'period_add',
'period_diff',
'to_days',
'unix_timestamp',
'user',
'weekday',
'concat'
);
// which column types will be mapped to which group?
$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' => 'fu
