I forgot about the file as I always create tables by hand.
I'll add one tomorrow. In short its an int called id, floats for lat, lon, bear and speed, datetime for date and varchar for the key. You can get the names from the .php files if you need it faster.