New Tables default to MyISAM

Questions related to using nuBuilder Forte.

New Tables default to MyISAM

Postby benritter » Fri Sep 11, 2020 4:00 am

Hi,
I was having trouble setting up foreign keys, subform to parent form. And After doing some research I found that tables created in nubuilder forte are made in MyISAM storage engine by default. I have done a re-install of nubuilder once already, and I believe the first time I installed it, new tables WERE defaulting to InnoDB. But MyISAM doesn't support foreign keys. To fix, I went into phpMyadmin, select a table, click "Operations" at the top and change the storage engine. Then you can setup foreign keys with an sql statement or phpMyadmin gives you a handy GUI for it under table structure/relation view.
benritter
 
Posts: 24
Joined: Thu Aug 27, 2020 6:08 am

Re: New Tables default to MyISAM

Postby admin » Fri Sep 11, 2020 4:35 am

ben,

nuBuilder allows you to use any field as a foreign key even if it is not recognised as so by the Mysql database.

In other words, you don't need to create foreign keys within MySQL/PHPMyAdmin for nuBuilder to work.


Steven
admin
Site Admin
 
Posts: 3350
Joined: Mon Jun 15, 2009 9:53 am


Return to General



cron