Add missing foreign key declarations for roles

This branch adds an migration containing foreign key constraints for the roles and member roles tables.