More mysql updates

Adding an ID column (primary key) to Resident Rotation to make updates and maintenance easier.