Database schema required by CDbAuthManager

Hi, yii addicts :rolleyes:

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

or it’s not obligatory ?


There are people that uses myisam without problems…

no issues using MyISAM here!

Thanks :-*

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. :huh: