Define foreign keys, db engine, and encoding

Sometimes it's necessary to manually delete users and/or groups directly in the database.  
Adding 'on delete' cascade actions and foreign keys ensure that no null references are left whenever users and/or groups are deleted.