[Phpmyadmin-devel] MySQL 4.1 and column comments

[Alexander M. Turek]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there,

Garvin Hicking wrote:
> 
>>By "switch" I meant this: suppose someone already has comments in pmadb. Does
>>he have to reenter them in the MySQL structure?
> 
> Oh, that's a very important thing, I nearly forgot. Maybe it would be the best
> way to make getComments() fetch both PMA-data and MySQL 4.1 data. I don't know
> aobut the performance impact though, but that way we could use data from both
> worlds". We could even emit a warning if MySQL 4.1 is found AND there is comment
> data fetched from the PMADB: "Please use migrate your PMAdb data to the new
> MySQL 4.1 structure using [link]this command[/link]. Any future stored comments
> are saved in MySQL 4.1 format only".

This would be the way to go, imho. And on top of that, we could safely
remove the field for column comments from create_tables_4.1.2+.sql.

Regards,

AMT
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQFBq9cd8c/ssWf/SMcRAn+5AKCIJ2co5jBnoP26+/PQ4jPEcjwaLwCgrtYo
m4rPgqvy2+l7FhDXxNGfVYM=
=iFI+
-----END PGP SIGNATURE-----