I wish to link all the tables of database using foreign keys. Right
now I have been able to link all the tables manually, partially
through SQL file and partially through phpmyadmin. I wish to do all
this in an automated way.
See  to have a clear view of database design and linking.
The problem I am facing is that whenever a user clicks on add new
trait, a new table is created(by SQL query behind) but I am unable to
link that automatically to material table using foreign key constraint
by coding in the SQL file. I can do that by adding index in phpmyadmin
for that . But that's not what is required. See the code of SQL
file in  which I import to create tables required for MediaWiki
extension. You can also see the foreign key constraints added in 
at the last.
" Eat Sleep Conquer Repeat "
|• Problem creating Index through SQL file||Albert Coder||4 Jul 2014|