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

Piotr Przybylski a écrit :

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.

Piotr, Agreed for all this.