phpMyAdmin and Relation Features

Has anyone made relational tables and/or foreign keys through phpMyAdmin? I know this can be done by creating a pma database and table, and adding the string to my config file. However, I can't access my PHP config file as it's part of Dreamhost's apache install. Any suggestions that don't involve compiling php in my own space? I've got two very simple tables and I want to establish a foreign key for one to the primary key of the other. Thanks!

Have you looked at the MySQL manual sections on foreign keys?

http://www.mysql.com/doc/en/example-Foreign_keys.html

http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html

I don't know if we have these Innodb tables available, although our MySQL version is late enough.

I may not see the subtlety of the question, but you can definitely create tables and (at least primary) keys in phpMyAdmin, and at the shell command line.

Good luck,

BobS

thanks for the response, bob. i've looked at those links before, i suppose i just wanted an easy way to create the foreign key, preferably through the phpMyAdmin interface. but here's to bad practice, i'll go without the fk.

evan