create database if not exists xiuosiot vgroups 10 replica 3 cachemodel 'last_row' cachesize 32;
use xiuosiot; 
create stable M168_LoRa_FM100 (ts timestamp,co2 float,so2 float, temperature float, humidity float) tags(company binary(32),location binary(64));
create stable RV400_NPU16T_5G_AR100(ts timestamp,co2 float,so2 float, temperature float, humidity float) tags(company binary(32),location binary(64));
create stable RV400_NPU4T_5G_SR100(ts timestamp,co2 float,so2 float, temperature float, humidity float) tags(company binary(32),location binary(64));
create stable M528_A800_5G_HM100(ts timestamp,co2 float,so2 float, temperature float, humidity float) tags(company binary(32),location binary(64));
create stable RV400_4G_FR100(ts timestamp,co2 float,so2 float, temperature float, humidity float) tags(company binary(32),location binary(64));
create table A000001 using M168_LoRa_FM100 tags("dsd","zhejiang.xiaoshan");
create table A000005 using RV400_NPU16T_5G_AR100 tags("dsd","zhejiang.xiaoshan");
create table A000006 using RV400_NPU4T_5G_SR100 tags("dsd","zhejiang.xiaoshan");
create table A000007 using M168_LoRa_FM100 tags("dsd","zhejiang.xiaoshan");
create table A000008 using M528_A800_5G_HM100 tags("dsd","zhejiang.xiaoshan");
create table A000009 using RV400_NPU16T_5G_AR100 tags("dsd","zhejiang.xiaoshan");
create table A000010 using RV400_4G_FR100 tags("dsd","zhejiang.xiaoshan");
create table S01 using M168_LoRa_FM100 tags("hxgg","zhejiang.xiaoshan");
create table S02 using M528_A800_5G_HM100 tags("hxgg","zhejiang.xiaoshan");
create table S03 using M168_LoRa_FM100 tags("hxgg","zhejiang.xiaoshan");
create table S05 using M168_LoRa_FM100 tags("hxgg","zhejiang.xiaoshan");
create table jxsd_1500(ts timestamp,v1 int,v2 int ,v3 int ,v4 int, v5 int,v6 int ,v7 int ,v8 int,v9 int,v10 int ,v11 int ,v12 int,v13 int,v14 int ,v15 int ,v16 int,v17 int,v18 int ,v19 int ,v20 int,v21 int,v22 int ,v23 int ,v24 int,v25 int,v26 int ,v27 int ,v28 int,v29 int,v30 int ,v31 int ,v32 int,v33 int,v34 int ,v35 int ,v36 int,v37 int,v38 int ,v39 int ,v40 int,v41 int ,v42 int,v43 int,v44 int ,v45 int ,v46 int,v47 int,v48 int ,v49 int ,v50 int,v51 int ,v52 int,v53 int,v54 int ,v55 int ,v56 int,v57 int,v58 int ,v59 int ,v60 int,v61 int ,v62 int,v63 int,v64 int ,v65 int ,v66 int,v67 int,v68 int ,v69 int ,v70 int,v71 int ,v72 int)





