Gossamer Forum
Home : Products : DBMan SQL : Development, Plugins and Globals :

Is relationships created in MySQL compatible with GLinks?

Quote Reply
Is relationships created in MySQL compatible with GLinks?
Hi There,

I just want to know, if I created a relationship between two tables, can I reference it using the GLinks table object, eg $DB->table('table1','table2') ? Or should I use the editor object first to manually recreate the relationship?

Regards


Sacrifice is not about what you lose,
it is about what you gain in the process.
Quote Reply
Re: [EZFrag] Is relationships created in MySQL compatible with GLinks? In reply to
I killed 500k braincells trying to figure this one out, so I did it by hand.

First, I created the MySQL tables manually.
then I created empty definition files.
I then edited the db_nav.html template in the admin template folder and added the tables.
Taking turns with each table, I re-synced the tables, updating the definition files.
Then I manually edited the definition files to add the foreign key references.


Sacrifice is not about what you lose,
it is about what you gain in the process.