CREATE TABLE GPSPointsDataType
(
    nodeId BIGINT UNSIGNED DEFAULT NULL,
    field VARCHAR(50) 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

) ENGINE=BLACKHOLE CHARSET=UTF8 COMMENT="GPS Points datatype";
