I'm pleased to see I'm not the only one that trawled through the phpMyAdmin codebase looking for that information

In my copy (v3.3.9.2) a similar routine can be found in the "config.inc.php" script.
Code: Select all
// 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'
);
What's interesting(?) about the code being in this particular script is that there's some expectation on the part of the developers that you might want to edit these values.
M_G