adding in foreign key constraint actions. they currently only work with the abstract adapter so if other adapters override the foreignKeySQL method, they must also be modified