hi all! i am currently working on a community projekt the DB is a mySQL DB but i am not sure which engine to use i know that innoDB supports foreign keys which i really want i order to keep the data consistent since there will be a lots of insert, delete and update activity with forums and guestbooks and new users and so on and i know i can have different table types in the same DB
but from what i've learned myISAM is the fastest is this true second, i have followed some discussions here about foreign keys but i still have nog managed to create foreign keys i have a table users and another userTypes where tblUsers have columns userID, usertypeID, username, password... and tblUserType userTypeID, userType so i want userTypeID in tblUsers to be a foregn key referencing the userTypeID col in userTypes both tables are myISAM userID is indexed and primary key in tblUsers userTypeID is indexed and primary key in tblUserType userTypeID in both tables are int(10) what is wrong? my OS is win XP pro and i have mySQL 4.1 (not really sure exact version since i cannot reach the DB from where i am right now) thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
