MySQL rooms for a game - intermediate directions like northeast?
 

I'm trying to conceive a game where there are rooms in a mysql database and each room has directions that point to other rooms, which enables players to traverse the rooms. My problem is not traversing the rooms, but constructing them. If you're only using north, south, east, west, then when...