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

[Marc Delisle]

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.

-- 
Marc Delisle
http://infomarc.info