cbbrowne/Schemaverse — comment on commit 90fe164f08e267ebb9b4bcd994b28bfab03ee3a0
File: create_schemaverse.sql line 430
By Abstrct:

MOVE_SHIPS() is going to need to update location, speed and direction. So those are the columns I would assume we want to be together. Target_speed, target_direction and destination are all user updatable so they would be best in their own table (ship_control). This should allow MOVE_SHIPS() and SHIP_COURSE_CONTROL() to be run at the same time without deadlocking.