• Adds setpoints columns

ALTER TABLE teleport_battery_power_flash
ADD COLUMN setpoints_confirmed_active_power decimal(23,3) DEFAULT NULL AFTER available_active_power_discharge,
ADD COLUMN setpoints_confirmed_reactive_power_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_confirmed_active_power,
ADD COLUMN setpoints_confirmed_reactive_power_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_confirmed_reactive_power_reactive_power,
ADD COLUMN setpoints_confirmed_reactive_power_mode varchar(32) DEFAULT NULL AFTER setpoints_confirmed_reactive_power_power_factor,
ADD COLUMN setpoints_confirmed_deliver_fcr decimal(23,3) DEFAULT NULL AFTER setpoints_confirmed_reactive_power_mode,
ADD COLUMN setpoints_confirmed_charge_to_percentage decimal(7,4) DEFAULT NULL AFTER setpoints_confirmed_deliver_fcr,
ADD COLUMN setpoints_desired_active_power_cloud decimal(23,3) DEFAULT NULL AFTER setpoints_confirmed_charge_to_percentage,
ADD COLUMN setpoints_desired_active_power_active_control decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_cloud,
ADD COLUMN setpoints_desired_active_power_grid_operator decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_active_control,
ADD COLUMN setpoints_desired_active_power_modbus_server decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_grid_operator,
ADD COLUMN setpoints_desired_active_power_afrr_delta decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_modbus_server,
ADD COLUMN setpoints_desired_active_power_afrr_reference decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_afrr_delta,
ADD COLUMN setpoints_desired_reactive_power_cloud_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_modbus_server,
ADD COLUMN setpoints_desired_reactive_power_cloud_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_desired_reactive_power_cloud_reactive_power,
ADD COLUMN setpoints_desired_reactive_power_cloud_mode varchar(32) DEFAULT NULL AFTER setpoints_desired_reactive_power_cloud_power_factor,
ADD COLUMN setpoints_desired_reactive_power_grid_operator_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_desired_reactive_power_cloud_mode,
ADD COLUMN setpoints_desired_reactive_power_grid_operator_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_desired_reactive_power_grid_operator_reactive_power,
ADD COLUMN setpoints_desired_reactive_power_grid_operator_mode varchar(32) DEFAULT NULL AFTER setpoints_desired_reactive_power_grid_operator_power_factor,
ADD COLUMN setpoints_desired_charge_to_percentage_cloud decimal(7,4) DEFAULT NULL AFTER setpoints_desired_reactive_power_grid_operator_mode,
ADD COLUMN setpoints_desired_deliver_fcr_cloud decimal(23,3) DEFAULT NULL AFTER setpoints_desired_charge_to_percentage_cloud,
ADD COLUMN setpoints_effective_active_power decimal(23,3) DEFAULT NULL AFTER setpoints_desired_deliver_fcr_cloud,
ADD COLUMN setpoints_effective_reactive_power_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_effective_active_power,
ADD COLUMN setpoints_effective_reactive_power_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_effective_reactive_power_reactive_power,
ADD COLUMN setpoints_effective_reactive_power_mode varchar(32) DEFAULT NULL AFTER setpoints_effective_reactive_power_power_factor;

ALTER TABLE teleport_battery_power_flash COMMENT = '{"version":2}';