I have two tables: Users and Friendships.
The actions I have in the website are:
Always use InnoDB unless you specifically want to include a
FULLTEXT index on a particular table. Only InnoDB enforces foreign keys, and the more referential integrity you can build into the database the better off everyone's going to be.