--
-- Host: 172.31.36.35    Database: e3tmqtt
-- ------------------------------------------------------

 SET NAMES utf8 ;

--
-- Table structure for table `MQTT_AUTH_acl_log`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `MQTT_AUTH_acl_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `iduser` int DEFAULT NULL,
  `username` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clientid` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `topic` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acc` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mac_imei` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `result` int DEFAULT NULL,
  `idMQTT_acls` int DEFAULT NULL,
  `acl_topic` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rw` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `MQTT_AUTH_acl_log`
--

 SET character_set_client = utf8mb4 ;

--
-- Table structure for table `MQTT_AUTH_superuser_log`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `MQTT_AUTH_superuser_log` (
  `id` int NOT NULL,
  `date` datetime DEFAULT NULL,
  `iduser` int DEFAULT NULL,
  `username` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `result` int NOT NULL DEFAULT '0',
  `request` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `MQTT_AUTH_superuser_log`
--


--
-- Table structure for table `MQTT_acls`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `MQTT_acls` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `topic` varchar(450) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rw` int DEFAULT NULL COMMENT '0: no access (NULL) 1: read access (r) 2: write access (w) 3: read and write access (rw) 4: subscribe access (s) 5: read & subscribe access (rs) 6: write & subscribe access (ws) 7: read, write and subscribe access (rws)',
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `rw` (`rw`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `MQTT_acls`
--

 SET character_set_client = utf8mb4 ;

--
-- Table structure for table `commands_log`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `commands_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idplatform` int DEFAULT NULL,
  `idgroup` int DEFAULT NULL,
  `iddevice` int DEFAULT NULL,
  `command` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parameters` text COLLATE utf8mb4_unicode_ci,
  `request` text COLLATE utf8mb4_unicode_ci,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commands_log`
--

 SET character_set_client = utf8mb4 ;

--
-- Table structure for table `connections_log`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `connections_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idconnection` int DEFAULT NULL,
  `remoteAddress` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `connections` int DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `connections_log`
--


--
-- Table structure for table `dashboard_types`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `dashboard_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_types`
--

 SET character_set_client = utf8mb4 ;
 SET character_set_client = utf8mb4 ;
 SET character_set_client = utf8mb4 ;

--
-- Table structure for table `devices_types`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `devices_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iddashboard_type` int DEFAULT NULL,
  `datalogger_fields` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `measures_fields` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `events_fields` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `config_serial_response` text COLLATE utf8mb4_unicode_ci,
  `mqttsn` int DEFAULT '0',
  `config_device_request_allways` int DEFAULT '0',
  `config_params_request_allways` int DEFAULT '0',
  `config_output_request_allways` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `devices_types`
--

INSERT INTO `devices_types` VALUES (1,'Estandar 30W',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(2,'Especial 1000W',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(3,'Especial 130W',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(4,'Sensor Presion',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(5,'Bomba Sensor Presion y Caudal',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(6,'Bomba Sensor Presion, Caudal y Nivel',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(7,'Bomba Sensor Presion, Caudal y Contacto Magne',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(8,'Especial 20000W',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(9,'Bomba 2000W Sensor Presion y Caudal',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(10,'DEV',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(11,'CS40',2,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(12,'Bomba Sin Sensores',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(13,'Sensor Nivel',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(14,'Anemometro',7,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(15,'Trifasico',8,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(16,'Bombas Nivel, Caudal, FalloB1 y FalloB2',4,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(17,'UCC50_75A',10,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\npower_active_avg, power_active_min, power_active_max,\npower_reactive_avg, power_reactive_min, power_reactive_max,\npower_factor_avg, power_factor_min, power_factor_max,\nvoltage_avg,voltage_min,voltage_max,\ncurrent_avg,current_min,current_max,\ninput1_avg,input1_min,input1_max,\ninput2_avg,input2_min,input2_max,\ninput3_avg,input3_min,input3_max,\ninput4_avg,input4_min,input4_max,\ninput5_avg,input5_min,input5_max,\ninput6_avg,input6_min,input6_max,\ninput7_avg,input7_min,input7_max,\ninput8_avg,input8_min,input8_max,\ninput9_avg,input9_min,input9_max,\ninput10_avg,input10_min,input10_max,\npower_active1_avg,power_active1_min,power_active1_max,\npower_reactive1_avg,power_reactive1_min,power_reactive1_max,\npower_factor1_avg, power_factor1_min, power_factor1_max,\nvoltage1_avg,voltage1_min,voltage1_max,\ncurrent1_avg,current1_min,current1_max,\npower_active2_avg,power_active2_min,power_active2_max,\npower_reactive2_avg,power_reactive2_min,power_reactive2_max,\npower_factor2_avg, power_factor2_min, power_factor2_max,\nvoltage2_avg,voltage2_min,voltage2_max,\ncurrent2_avg,current2_min,current2_max,\npower_active3_avg,power_active3_min,power_active3_max,\npower_reactive3_avg,power_reactive3_min,power_reactive3_max,\npower_factor3_avg, power_factor3_min, power_factor3_max,\nvoltage3_avg,voltage3_min,voltage3_max,\ncurrent3_avg,current3_min,current3_max,\nenergy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(18,'Sensores Medicos',11,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(19,'LS408 DUST',5,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(20,'UCC50_15A',10,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\npower_active_avg, power_active_min, power_active_max,\npower_reactive_avg, power_reactive_min, power_reactive_max,\npower_factor_avg, power_factor_min, power_factor_max,\nvoltage_avg,voltage_min,voltage_max,\ncurrent_avg,current_min,current_max,\ninput1_avg,input1_min,input1_max,\ninput2_avg,input2_min,input2_max,\ninput3_avg,input3_min,input3_max,\ninput4_avg,input4_min,input4_max,\ninput5_avg,input5_min,input5_max,\ninput6_avg,input6_min,input6_max,\ninput7_avg,input7_min,input7_max,\ninput8_avg,input8_min,input8_max,\ninput9_avg,input9_min,input9_max,\ninput10_avg,input10_min,input10_max,\npower_active1_avg,power_active1_min,power_active1_max,\npower_reactive1_avg,power_reactive1_min,power_reactive1_max,\npower_factor1_avg, power_factor1_min, power_factor1_max,\nvoltage1_avg,voltage1_min,voltage1_max,\ncurrent1_avg,current1_min,current1_max,\npower_active2_avg,power_active2_min,power_active2_max,\npower_reactive2_avg,power_reactive2_min,power_reactive2_max,\npower_factor2_avg, power_factor2_min, power_factor2_max,\nvoltage2_avg,voltage2_min,voltage2_max,\ncurrent2_avg,current2_min,current2_max,\npower_active3_avg,power_active3_min,power_active3_max,\npower_reactive3_avg,power_reactive3_min,power_reactive3_max,\npower_factor3_avg, power_factor3_min, power_factor3_max,\nvoltage3_avg,voltage3_min,voltage3_max,\ncurrent3_avg,current3_min,current3_max,\nenergy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(21,'LB40_THHH',5,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(22,'Sensores',5,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(23,'LC40',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(24,'LB40',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(25,'LB40_DMMAAA',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(26,'LB40_DPTHLA',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(27,'LS40_THPL',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(28,'LB40_AAAAAA',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(29,'LC40_AAAA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(30,'LS40_THUL',13,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(31,'LP40_AA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n    power_active_avg, power_active_min, power_active_max,\n    current_avg, current_min, current_max,\n    input1_avg, input1_min, input1_max,\n    input2_avg, input2_min, input2_max','date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2',NULL,0,1,1,1),(32,'LB10_THHH',5,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(33,'LC10_A',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n  current_avg, current_min, current_max,\n  input1_avg, input1_min, input1_max,\n  input2_avg, input2_min, input2_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2',NULL,0,1,1,1),(34,'LB10_DMMAAA',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(35,'LB10_DPTHLA',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(36,'LS10_THPL',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(37,'LB10_AAAAAA',12,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(38,'LC10_AAAA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n current_avg, current_min, current_max,\n input1_avg, input1_min, input1_max,\n input2_avg, input2_min, input2_max,\n input3_avg, input3_min, input3_max,\n input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2;input3;input4',NULL,0,1,1,1),(39,'LS10_THUL',13,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(40,'LP10_AA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n    power_active_avg, power_active_min, power_active_max,\n    current_avg, current_min, current_max,\n    input1_avg, input1_min, input1_max,\n    input2_avg, input2_min, input2_max','date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2',NULL,0,1,1,1),(41,'LP40_T_Haverland',14,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\r    power_active_avg, power_active_min, power_active_max,\r    current_avg, current_min, current_max,\r    input1_avg, input1_min, input1_max,\r    input2_avg, input2_min, input2_max','date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2',NULL,0,1,1,1),(42,'SP40_AAAA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2;input3;input4',NULL,0,1,1,1),(43,'SP10_AAAA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;current;input1;input2;input3;input4',NULL,0,1,1,1),(44,'LS10_THR',13,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(45,'LS40_N',16,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(46,'LS10_N',16,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(47,'PLUG40_A',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(48,'PLUG10_A',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(49,'PEAK10_RHAT',13,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n    power_active_avg, power_active_min, power_active_max,\n    current_avg, current_min, current_max,\n    input1_avg, input1_min, input1_max,\n    input2_avg, input2_min, input2_max,\n    input3_avg, input3_min, input3_max,\n    input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(50,'LS10_TN',16,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n												 power_active_avg, power_active_min, power_active_max,\n												 power_reactive_avg, power_reactive_min, power_reactive_max,\n												 power_factor_avg, power_factor_min, power_factor_max,\n												 voltage_avg,voltage_min,voltage_max,\n												 current_avg,current_min,current_max,\n												 input1_avg,input1_min,input1_max,\n												 input2_avg,input2_min,input2_max,\n												 input3_avg,input3_min,input3_max,\n												 input4_avg,input4_min,input4_max,\n												 input5_avg,input5_min,input5_max,\n												 input6_avg,input6_min,input6_max,\n												 input7_avg,input7_min,input7_max,\n												 input8_avg,input8_min,input8_max,\n												 input9_avg,input9_min,input9_max,\n												 input10_avg,input10_min,input10_max,\n												 power_active1_avg,power_active1_min,power_active1_max,\n												 power_reactive1_avg,power_reactive1_min,power_reactive1_max,\n												 power_factor1_avg, power_factor1_min, power_factor1_max,\n												 voltage1_avg,voltage1_min,voltage1_max,\n												 current1_avg,current1_min,current1_max,\n												 power_active2_avg,power_active2_min,power_active2_max,\n												 power_reactive2_avg,power_reactive2_min,power_reactive2_max,\n												 power_factor2_avg, power_factor2_min, power_factor2_max,\n												 voltage2_avg,voltage2_min,voltage2_max,\n												 current2_avg,current2_min,current2_max,\n												 power_active3_avg,power_active3_min,power_active3_max,\n												 power_reactive3_avg,power_reactive3_min,power_reactive3_max,\n												 power_factor3_avg, power_factor3_min, power_factor3_max,\n												 voltage3_avg,voltage3_min,voltage3_max,\n												 current3_avg,current3_min,current3_max,\n												 energy_3phase','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;energy;energy_reactive;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total;energy_3phase',NULL,0,1,1,1),(51,'PEAK10_AAAAA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(52,'PEAK40_AAAA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n    power_active_avg, power_active_min, power_active_max,\n    current_avg, current_min, current_max,\n    input1_avg, input1_min, input1_max,\n    input2_avg, input2_min, input2_max,\n    input3_avg, input3_min, input3_max,\n    input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(53,'PEAK10_LHPT',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n    power_active_avg, power_active_min, power_active_max,\n    current_avg, current_min, current_max,\n    input1_avg, input1_min, input1_max,\n    input2_avg, input2_min, input2_max,\n    input3_avg, input3_min, input3_max,\n    input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(54,'POLE10_AAAA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(55,'POLE40_AAAA',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(56,'POLE40_A',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(57,'POLE10_A',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(58,'PEAK10_METEO',20,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;#DISCARD#;#DISCARD#;#DISCARD#;#DISCARD#','<serial_ans>\n  	<slave1>\n		<addr0>\n			<value5>input3_32bitsFLOATPART1</value5><value6>input3_32bitsFLOATPART2</value6>\n			<value7>input4_32bitsFLOATPART1</value7><value8>input4_32bitsFLOATPART2</value8>\n			<value9>input5_32bitsFLOATPART1</value9><value10>input5_32bitsFLOATPART2</value10>\n			<value11>input6_32bitsFLOATPART1</value11><value12>input6_32bitsFLOATPART2</value12>\n			<value13>input7_32bitsFLOATPART1</value13><value14>input7_32bitsFLOATPART2</value14>\n			<value15>input8_32bitsFLOATPART1</value15><value16>input8_32bitsFLOATPART2</value16>\n			<value17>input9_32bitsFLOATPART1</value17><value18>input9_32bitsFLOATPART2</value18>\n			<value19>input10_32bitsFLOATPART1</value19><value20>input10_32bitsFLOATPART2</value20>\n		</addr0>\n		<addr36>\n			<value1>input1_32bitsFLOATPART1</value1><value2>input1_32bitsFLOATPART2</value2>\n			<value3>input2_32bitsFLOATPART1</value3><value4>input2_32bitsFLOATPART2</value4>\n		</addr36>\n	</slave1>\n  </serial_ans>',0,1,1,1),(59,'PIPE20MBUS_TCP_AAAA',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;gross_measure',NULL,1,1,1,1),(60,'LS10_METEO_LUFFT_WS10',20,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\r    power_active_avg, power_active_min, power_active_max,\r    current_avg, current_min, current_max,\r    input1_avg, input1_min, input1_max,\r    input2_avg, input2_min, input2_max,\r    input3_avg, input3_min, input3_max,\r    input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;#DISCARD#;#DISCARD#;#DISCARD#;#DISCARD#','<serial_ans>\r    <slave1>\r   <addr0>\r    <value5>input3_32bitsFLOATPART1</value5><value6>input3_32bitsFLOATPART2</value6>\r    <value7>input4_32bitsFLOATPART1</value7><value8>input4_32bitsFLOATPART2</value8>\r    <value9>input5_32bitsFLOATPART1</value9><value10>input5_32bitsFLOATPART2</value10>\r    <value11>input6_32bitsFLOATPART1</value11><value12>input6_32bitsFLOATPART2</value12>\r    <value13>input7_32bitsFLOATPART1</value13><value14>input7_32bitsFLOATPART2</value14>\r    <value15>input8_32bitsFLOATPART1</value15><value16>input8_32bitsFLOATPART2</value16>\r    <value17>input9_32bitsFLOATPART1</value17><value18>input9_32bitsFLOATPART2</value18>\r    <value19>input10_32bitsFLOATPART1</value19><value20>input10_32bitsFLOATPART2</value20>\r   </addr0>\r   <addr36>\r    <value1>input1_32bitsFLOATPART1</value1><value2>input1_32bitsFLOATPART2</value2>\r    <value3>input2_32bitsFLOATPART1</value3><value4>input2_32bitsFLOATPART2</value4>\r   </addr36>\r  </slave1>\r   </serial_ans>',0,1,1,1),(63,'PARK20',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;input11;input12;input13;input14;input15;input16;input17',NULL,1,1,1,1),(64,'PIPE21',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(65,'PIPE20L',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(66,'PIPE20',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(67,'PIPE23',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(68,'PIPE20W',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(69,'PIPE20P',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(70,'PIPE20WQ',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(71,'POLE10_DMX',15,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(72,'PIPE20WQP',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(73,'PIPE20DUO',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(74,'PIPE20HUB',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(75,'PIPE20_PULSES',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(76,'PIPE20_UNE',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(77,'PIPE20_AC',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(78,'PIPE20L_MODBUS',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(79,'PIPE20L_PULSES',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(80,'PIPE20L_UNE',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(81,'PIPE20XL',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(82,'PIPE20XL_MODBUS',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(83,'PIPE20XL_PULSES',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(84,'PIPE20XL_UNE',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(85,'PIPE20XL_AC',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(86,'PIPE20P_MODBUS',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(87,'PIPE20P_PULSES',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(88,'PIPE20P_UNE',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(89,'PIPE20_THERMISTOR_TEMP',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(90,'PIPE20RT_MODBUS',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(91,'LANE20',12,'date,type,energy,switching_on,switch_on_time,connected_time,disconnections,power_active_avg,power_active_min,power_active_max,power_reactive_avg,power_reactive_min,power_reactive_max,power_factor_avg,power_factor_min,power_factor_max,voltage_avg,voltage_min,voltage_max,current_avg,current_min,current_max,input1_avg,input1_min,input1_max,input2_avg,input2_min,input2_max,input3_avg,input3_min,input3_max,input4_avg,input4_min,input4_max,input5_avg,input5_min,input5_max,input6_avg,input6_min,input6_max,input7_avg,input7_min,input7_max,input8_avg,input8_min,input8_max,input9_avg,input9_min,input9_max,input10_avg,input10_min,input10_max,power_active1_avg,power_active1_min,power_active1_max,power_reactive1_avg,power_reactive1_min,power_reactive1_max,power_factor1_avg,power_factor1_min,power_factor1_max,voltage1_avg,voltage1_min,voltage1_max,current1_avg,current1_min,current1_max,power_active2_avg,power_active2_min,power_active2_max,power_reactive2_avg,power_reactive2_min,power_reactive2_max,power_factor2_avg,power_factor2_min,power_factor2_max,voltage2_avg,voltage2_min,voltage2_max,current2_avg,current2_min,current2_max,power_active3_avg,power_active3_min,power_active3_max,power_reactive3_avg,power_reactive3_min,power_reactive3_max,power_factor3_avg,power_factor3_min,power_factor3_max,voltage3_avg,voltage3_min,voltage3_max,current3_avg,current3_min,current3_max,energy_3phase,energy_reactive_3phase,power_active_3phase_avg,power_active_3phase_min,power_active_3phase_max,power_reactive_3phase_avg,power_reactive_3phase_min,power_reactive_3phase_max,power_factor_3phase_avg,power_factor_3phase_min,power_factor_3phase_max,current_3phase_avg,current_3phase_min,current_3phase_max,THD_3phase_avg,THD_3phase_min,THD_3phase_max,THD1_avg,THD1_min,THD1_max,THD2_avg,THD2_min,THD2_max,THD3_avg,THD3_min,THD3_max,modbus_idslave','iddevice;date;switch_on_time;switching_on;voltage;voltage1;voltage2;voltage3;current;current1;current2;current3;power_active;power_active1;power_active2;power_active3;power_reactive;power_reactive1;power_reactive2;power_reactive3;energy;energy_3phase;energy_reactive;energy_reactive_3phase;power_factor;power_factor1;power_factor2;power_factor3;power_factor_total;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10','date;idtrigger_type;idmode;idstatus;dimmer;voltage;current;power_active;power_reactive;power_factor;input1;input2;input3;input4;input5;input6;input7;input8;input9;input10;voltage1;current1;power_active1;power_reactive1;power_factor1;voltage2;current2;power_active2;power_reactive2;power_factor2;voltage3;current3;power_active3;power_reactive3;power_factor3;power_factor_total',NULL,0,1,1,1),(92,'PIPE20PXL_SEVERN_TRENT',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(93,'PIPE20W',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(94,'PIPE20E',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(108,'PIPE20XL_SEVERN_TRENT ADDC',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(109,'PIPE20XL_PULSES ADDC',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(110,'PIPE20XL MBUS ADDC',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(111,'PIPE20XL_MODBUS ADDC',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(112,'PIPE20S_PULSES',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(113,'PIPE20HUB DM',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(114,'PIPE20HUB EU',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(115,'PIPE20DUO EURIDIS',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(116,'PIPE20XLMDAS',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(117,'PIPE20EDL',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(118,'PIPE20EEU',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(119,'PIPE20HUBMB',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(120,'PIPE20XLPUAS',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(121,'PIPE20DUODLST',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(122,'PIPE20DUOEUST',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(123,'PIPE20PMBMD',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(124,'PIPE20PMBMDAC',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(125,'PIPE20HUBEUWM',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(126,'PIPE20HUBDLWM',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(127,'PIPE20HUBWM',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(128,'PIPE20XLASAC',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(129,'PIPE20RT',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(130,'PIPE20PAS',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(131,'OMNI20WMB',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(132,'OMNI20EDL',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(135,'PIPE20RT_PU',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(136,'PIPE202PEMD',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1),(137,'OMNI20WUNE',1,'date, type, energy, switching_on, switch_on_time, connected_time, disconnections,\n   power_active_avg, power_active_min, power_active_max,\n   current_avg, current_min, current_max,\n   input1_avg, input1_min, input1_max,\n   input2_avg, input2_min, input2_max,\n   input3_avg, input3_min, input3_max,\n   input4_avg, input4_min, input4_max','iddevice;date;switch_on_time;switching_on;voltage;current;power_active;energy;input1;input2;input3;input4','date;idtrigger_type;idmode;idstatus;dimmer;power_active;current;input1;input2;input3;input4',NULL,0,1,1,1);

--
-- Table structure for table `groups`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idgroup` int DEFAULT NULL,
  `idplatform` int DEFAULT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent` int DEFAULT NULL,
  `lft` int NOT NULL,
  `rgt` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idgroup` (`idgroup`),
  KEY `idplatform` (`idplatform`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES (1,1,7,'Datakorum',0,1,20),(2,2,NULL,'Revisar',1,2,5),(3,3,NULL,'Production',1,6,7),(4,4,NULL,'Clients',1,8,9),(5,5,NULL,'Development',1,10,13),(6,6,NULL,'QA',1,14,15),(7,7,NULL,'TEST LAB RKBRG',1,16,17),(9,9,7,'Andreu',1,18,19),(10,10,9,'Andreu',1,0,0),(11,11,9,'Andreu',6,0,0),(16,16,NULL,'adsssssssssssssssssssssssssssssssssssssssssss',2,3,4),(17,17,NULL,'jbenedicto',5,11,12);

--
-- Table structure for table `messages_log`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `messages_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idconnection` int DEFAULT NULL,
  `remoteAddress` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `topic` varchar(450) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `idplatform` int DEFAULT NULL,
  `idgroup` int DEFAULT NULL,
  `iddevice` int DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=808 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages_log`
--


--
-- Table structure for table `platforms`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `platforms` (
  `id` int NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(450) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RESTWS_location` varchar(450) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `APPRESTWS_location` varchar(450) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `platforms`
--

INSERT INTO `platforms` VALUES (9,'TrangoQA','TrangoQA','http://ip-172-31-36-35.eu-west-1.compute.internal/restws','http://ip-172-31-36-35.eu-west-1.compute.internal/apprestws');

--
-- Table structure for table `server_log`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `server_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `server_log`
--

INSERT INTO `server_log` VALUES (1,'2024-11-13 01:29:11'),(2,'2024-11-15 05:59:40'),(3,'2024-11-17 23:06:29'),(4,'2024-11-19 11:45:44'),(5,'2024-11-19 12:11:33'),(6,'2024-11-19 12:22:10'),(7,'2024-11-19 13:57:48'),(8,'2024-11-19 14:00:40'),(9,'2024-11-19 14:10:13'),(10,'2024-11-19 14:10:14'),(11,'2024-11-19 14:10:14'),(12,'2024-11-19 14:10:14'),(13,'2024-11-19 14:10:14'),(14,'2024-11-19 14:34:40'),(15,'2024-11-19 14:34:41'),(16,'2024-11-19 14:34:42'),(17,'2024-11-19 14:34:43'),(18,'2024-11-19 14:34:45'),(19,'2024-11-19 14:37:13'),(20,'2024-11-19 14:37:14'),(21,'2024-11-19 14:37:16'),(22,'2024-11-19 14:37:17'),(23,'2024-11-19 14:37:18'),(24,'2024-11-19 14:37:58'),(25,'2024-11-19 14:39:14'),(26,'2024-11-19 14:41:00'),(27,'2024-11-19 14:41:05'),(28,'2024-11-19 14:42:13'),(29,'2024-11-20 01:30:50'),(30,'2024-11-20 01:31:09'),(31,'2024-11-20 06:17:24'),(32,'2024-11-20 06:17:27'),(33,'2024-11-20 07:02:12'),(34,'2024-11-20 07:05:24'),(35,'2024-11-20 07:06:22'),(36,'2024-11-20 07:12:58'),(37,'2024-11-26 05:04:01'),(38,'2024-11-27 05:04:01'),(39,'2024-11-27 07:03:17'),(40,'2024-11-27 08:39:08'),(41,'2024-11-27 09:55:34'),(42,'2024-11-27 10:00:51'),(43,'2024-11-27 10:00:52'),(44,'2024-11-27 10:00:53'),(45,'2024-11-27 10:00:55'),(46,'2024-11-27 10:00:56'),(47,'2024-11-27 10:03:26'),(48,'2024-11-27 10:10:07'),(49,'2024-11-27 10:12:21'),(50,'2024-11-27 10:24:25'),(51,'2024-11-27 10:24:27'),(52,'2024-11-27 10:41:41'),(53,'2024-11-27 14:53:43'),(54,'2024-11-27 14:58:38'),(55,'2024-11-27 15:00:48'),(56,'2024-11-27 15:03:40'),(57,'2024-11-27 15:05:50'),(58,'2024-11-27 15:06:06'),(59,'2024-11-27 15:08:03'),(60,'2024-11-27 15:08:53'),(61,'2024-11-27 15:08:53'),(62,'2024-11-28 05:04:01'),(63,'2024-11-28 08:07:05'),(64,'2024-11-29 05:04:01'),(65,'2024-11-30 05:04:02'),(66,'2024-12-01 05:04:02'),(67,'2024-12-02 05:04:01'),(68,'2024-12-03 05:04:01');


