Changing primary key for states and adding a new foreign key constraint.