Database schema required by CDbAuthManager

Karasko · July 19, 2010, 5:52pm

Hi, yii addicts

Should i obligatory use InnoDb engine (because i see definitions of references sql statement and delete cascade)

or it’s not obligatory ?

thanks

cyberpol · July 19, 2010, 6:29pm

There are people that uses myisam without problems…

Sniper · July 19, 2010, 6:49pm

no issues using MyISAM here!

Karasko · July 20, 2010, 3:25am

Thanks

Detonator · August 4, 2010, 10:31am

I think there should be InnoDB engine for this tables. It will be a better solution than using MyISAM. Furthermore schema foreign keys are used in template, but this feature is not supported by MyISAM.

Also implementation with foreign keys and primary indexes in fields of VARCHAR(64) type has some performance issues. And now I don’t know wether to use CDbAuthManager or not.