mid int(10) unsigned not null default '0', pid int(10) unsigned not null default '0', ...
What makes it worse is that MySQL does not enforce boolean semantics for such columns: even a column declared as BOOLEAN can still store any value in the TINYINT range, yet the default streaming path ...