[Phpmyadmin-devel] Proposed changes to create_tables.sql (mainly pma_recent and pma_uiprefs)

[Piotr Przybylski]

Hi,

I was looking at create_tables.sql and spotted some places we can
change to simplify this file. If possible, I would like to change
these:

1) Remove all charset and collation overrides for columns which
specify utf8/utf8_bin, as they already inherit that from table
settings (concerns pma_recent, pma_uiprefs and pma_tracking).
2) Remove "DEFAULT CHARACTER SET utf8 COLLATE utf8_bin" for all
tables, as this is default setting in 'phpmyadmin' database. Unless we
think that our users have their databases incorrectly created.
3) Change BLOB to TEXT in pma_recent and pma_table_uiprefs - they
store text data (JSON), not binary data.

-- 
Regards,
Piotr Przybylski