Skip to main content
Topic: y u no fk? xD (Read 2069 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

y u no fk? xD

Just noticed Elkarte still uses MyISAM as the storage engine, thus I can't add any foreign keys on my members column. Hopefully I can still add a trigger...

Is Elkarte 2.0 going to use InnoDB?
LiveGallery - Simple gallery addon for ElkArte

Re: y u no fk? xD

Reply #1

Wouldn't converting the table to Innodb work?  I've been reading up on how databses work recently.  Keys are one area where knowledge is thin. 

 

Re: y u no fk? xD

Reply #2

Yes, that would work,, but it'll be slow with thousands of members. Would be out of scope for an addon.
LiveGallery - Simple gallery addon for ElkArte