khyznh/script/sql/taos.sql

create database khyznh;
use khyznh;
CREATE STABLE `gps_data` (`ts` TIMESTAMP, `speed` DOUBLE, `lat` DOUBLE, `lng` DOUBLE, `alt` DOUBLE) TAGS (`devicecode` VARCHAR(64), `groupid` INT);
CREATE STABLE `count_data` (`ts` TIMESTAMP, `incount` INT, `outcount` INT) TAGS (`devicecode` VARCHAR(64), `groupid` INT);