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.