[Phpmyadmin-devel] MySQL 4.1 and column comments

Marc Delisle DelislMa at CollegeSherbrooke.qc.ca
Mon Nov 29 05:29:02 CET 2004

Michal Čihař a écrit:

> Hi
> On Monday 29 November 2004 12:08, Garvin Hicking wrote:
>>I'd vote for using the 4.1 internal structure, if available instead of our
>>internal one. We'd need to abstract all calls to fetching comments to be
>>replacable with a SQLquery to get column comments. There's much depending
>>on column comments (like "show table aliases in left frame" option and
>>embedding comments in SQL dump), so I don't think a user should be able to
>>enter differing comments in our infrastructure or the MySQL one. I also
>>don't think it's necessary to offer the user a switch to use either
>>Or does anyone think there'll be a need that a user wants to store his
>>comments in PMA DB instead of MySQL 4.1?
> I'd say same for relation stuff :-). Why do we provide both ways to define 
> them?
Because AFAIK, foreign key constraints are only supported in InnoDB.


More information about the Developers mailing list