diff -r 42a0ab588a4f -r c09b67fd8323 bmsd/mysql.c --- a/bmsd/mysql.c Fri Oct 11 11:44:37 2019 +0200 +++ b/bmsd/mysql.c Fri Oct 11 13:38:31 2019 +0200 @@ -606,10 +606,10 @@ char *query = malloc(2560); snprintf(query, 2559, - "INSERT INTO mon_co2meters SET uuid='%s', alias='%s', node='%s', online='%d', mode='%s', " \ + "INSERT INTO mon_co2meters SET uuid='%s', alias='%s', node='%s', online='%d', mode='%s', alarm='%d', " \ "temperature_address='%s', temperature_state='%s', temperature='%.3f', " \ "pressure_state='%s', pressure_channel='%d', pressure_voltage='%.3f', pressure_zero='%.3f', pressure_bar='%.3f'", - co2meter->uuid, co2meter->alias, co2meter->node, co2meter->online ? 1:0, co2meter->mode, + co2meter->uuid, co2meter->alias, co2meter->node, co2meter->online ? 1:0, co2meter->mode, co2meter->alarm, co2meter->temperature_address, co2meter->temperature_state, co2meter->temperature, co2meter->pressure_state, co2meter->pressure_channel, co2meter->pressure_voltage, co2meter->pressure_zero, co2meter->pressure_bar); @@ -626,11 +626,11 @@ char *query = malloc(2560); snprintf(query, 2559, - "UPDATE mon_co2meters SET online='%d', mode='%s', " \ + "UPDATE mon_co2meters SET online='%d', mode='%s', alarm='%d', " \ "temperature_address='%s', temperature_state='%s', temperature='%.3f', " \ "pressure_state='%s', pressure_channel='%d', pressure_voltage='%.3f', pressure_zero='%.3f', pressure_bar='%.3f' " \ "WHERE uuid='%s'", - co2meter->online ? 1:0, co2meter->mode, + co2meter->online ? 1:0, co2meter->mode, co2meter->alarm, co2meter->temperature_address, co2meter->temperature_state, co2meter->temperature, co2meter->pressure_state, co2meter->pressure_channel, co2meter->pressure_voltage, co2meter->pressure_zero, co2meter->pressure_bar, co2meter->uuid);