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 DATABASE IF NOT EXISTS jsfw CACHEMODEL 'both'

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, blade_angle FLOAT, engine_direction FLOAT, wind_deviation 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;*/
ALTER STABLE jsfw.realtime_average_target ADD COLUMN blade_angle FLOAT;
ALTER STABLE jsfw.realtime_average_target ADD COLUMN engine_direction FLOAT;
ALTER STABLE jsfw.realtime_average_target ADD COLUMN wind_deviation 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))


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

@2.6版本taos-定边

CREATE DATABASE IF NOT EXISTS jsfw_db UPDATE 2;
create stable if not exists pointci (ts timestamp,val double)
tags (description nchar(100),station binary(20),category binary(20),facility binary(20),uniformcode binary(20));

create stable if not exists jsfw_db.state_point (ts timestamp,val tinyint,status tinyint,time int) tags (description nchar(100));