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, theory_generation 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
(,
);
ALTER STABLE jsfw.realtime_average_target ADD COLUMN theory_generation FLOAT;


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
);

CREATE STABLE IF NOT EXISTS jsfw.state_cause
(start_time TIMESTAMP, end_time TIMESTAMP, event NCHAR(30), advance_state NCHAR(30), after_state NCHAR(30), user_flag NCHAR(30), time INT UNSIGNED)
TAGS (station_id BINARY(30),equipment_id BINARY(30))