CREATE TABLE GPSPointDataType
(
    nodeId BIGINT UNSIGNED DEFAULT NULL,
    lng DECIMAL(15,12) DEFAULT NULL,
    lat DECIMAL(15,12) DEFAULT NULL,
    alt DECIMAL(6,1) DEFAULT NULL,
    accuracy DECIMAL(6,2) DEFAULT NULL,
    ts BIGINT UNSIGNED DEFAULT NULL,
    PRIMARY KEY ( nodeId )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Single GPS point datatype";
