gaia/资源文件/sql/taossql.sql

CREATE DATABASE IF NOT EXISTS fjjsfw UPDATE 2 cacheLast 1

DROP DATABASE fjjsfw;
CREATE DATABASE IF NOT EXISTS jsfw UPDATE 2 cacheLast 1
CREATE
STABLE IF NOT EXISTS jsfw.realtime_average_target
(time TIMESTAMP, wind_speed FLOAT, power FLOAT, generator_speed FLOAT, impeller_speed FLOAT, wind_direction FLOAT)
TAGS (station_id BINARY(30),equipment_id BINARY(30),uniform_code BINARY(20), description NCHAR(50))
CREATE TABLE realtime_average_target.USING realtime_average_target TAGS
(,
);



CREATE TABLE IF NOT EXISTS fjjsfw.realtime_average_target
(
    time            TIMESTAMP,
    equipment_id BINARY (30),
    wind_speed      FLOAT,
    power           FLOAT,
    generator_speed FLOAT,
    impeller_speed  FLOAT,
    wind_direction  FLOAT
);