4x/data/0doc/ruleengine/init.sql

3 lines
427 B
SQL

/*创建监测记录超级表*/
CREATE STABLE IF NOT EXISTS monitor_record (`ts` TIMESTAMP,`release_time` TIMESTAMP,`application_id` NCHAR(20),`alarm_value` DOUBLE ,`alarm_key` NCHAR(40),`alarm_type` int,`alarm_name` NCHAR(20),`alarm_rule` NCHAR(255),`level` int,`status` int,`monitor_indicator` NCHAR(20),`push_condition_id` NCHAR(20)) TAGS (`info` Json);
ALTER STABLE monitor_record ADD COLUMN `push_condition_id` NCHAR(20);