[Phpmyadmin-devel] MySQL 4.1 and column comments

[Marc Delisle]

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
>>infrastructure.
>>
>>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.

Marc