drop database kinotracker;
create database kinotracker;
use kinotracker;

create table sensor_data (
  id      INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
  datum   DATETIME NOT NULL,
  node    varchar(32) NOT NULL,
  gateway varchar(32) NOT NULL,
  lat     DECIMAL(10,8) NOT NULL,
  lon     DECIMAL(11,8) NOT NULL,
  alt     int NOT NULL,
  hdop    int NOT NULL
);
