tinytext columns cause schema inspector loop when adding an index on these columns
Some columns (I didn't check all, these are probably just some of them), like
define itself as
<columname> tinytext NOT NULL
First minor problem: BLOB-type columns (like BLOB and TEXT and their differnet sizes) are not not-nullable (specifying
NOT NULL on them has no effect at all).
When adding an index on these columns like
CREATE TABLE sys_category ( INDEX my_title_index (title(100)) );
The schema inspector will create the index first, but then always suggests to drop and recreate it, in an endless loop.
Why are these columns
tinytext anyways? Instead of
varchar(255)? tinytext is not Unicode-aware (it can only store 255 bytes, not 255 characters). Also it is a BLOB-type, which means usually it is way slower than varchar on lookup-time (depending on lots of factors, but it can never be faster than varchar, and usally it's really slower).
I marked this as v9, but I assume it's like this in any version.