Skip to content
Teleport

Migration script

  • MySQL
  • Solar power flash
  • v1 to v2
ALTER TABLE teleport_solar_power_flash
ADD COLUMN available_active_power decimal(23,3) DEFAULT NULL AFTER active_power,
ADD COLUMN setpoints_desired_active_power_limit_afrr_padding decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_limit_afrr_delta,
ADD COLUMN setpoints_desired_reactive_power_active_control_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_desired_reactive_power_grid_operator_mode,
ADD COLUMN setpoints_desired_reactive_power_active_control_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_desired_reactive_power_active_control_reactive_power,
ADD COLUMN setpoints_desired_reactive_power_active_control_mode varchar(32) DEFAULT NULL AFTER setpoints_desired_reactive_power_active_control_power_factor;


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