Foreign Key

nithish

How do I create a column with foreign key?

R_J

Vanilla doesn't use foreign keys, that might be the reason why foreign keys are not directly supported in the database classes. But you can always use raw SQL (if you know what you are doing 😀)

$px = Gdn::structure()->databasePrefix();
$queryString = "ALTER TABLE {$px}Comment ADD FOREIGN KEY (DiscussionID) REFERENCES {$px}Discussion(DiscussionID);";
Gdn::sql()->query($queryString);

nithish

https://open.vanillaforums.com/discussion/comment/258665#Comment_258665

Thanks, I'll try that out!

nithish

$Structure = GDN::Structure();

$Structure->table('FK_TEST')

->column('DiscussionID', 'int', false)

 ->set();

$px = Gdn::structure()->databasePrefix();

$queryString = "ALTER TABLE {$px}FK_TEST ADD  FOREIGN KEY (DiscussionID) REFERENCES {$px}Discussion(DiscussionID);";

Gdn::sql()->query($queryString);

@R_J I ran above queries but I keep getting => errno:150 "Foreign key constraint is incorrectly formatted"

R_J

https://xrstf.de/2016/01/mysql-foreign-key-constraint-is-incorrectly-formed/