Skip to content
Teleport

Migration script

  • MySQL
  • Solar power
  • v4 to v5
ALTER TABLE teleport_solar_power
ADD COLUMN reactive_power decimal(23,3) DEFAULT NULL AFTER active_power,
ADD COLUMN power_factor decimal(5, 4) DEFAULT NULL AFTER reactive_power,
ADD COLUMN setpoints_confirmed_active_power_limit_percentage decimal(4,1) DEFAULT NULL AFTER active_power_limit_percentage,
ADD COLUMN setpoints_confirmed_active_power_limit decimal(23, 3) DEFAULT NULL AFTER setpoints_confirmed_active_power_limit_percentage,
ADD COLUMN setpoints_confirmed_reactive_power_reactive_power decimal(23, 3) DEFAULT NULL AFTER setpoints_confirmed_active_power_limit,
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_desired_active_power_limit_cloud decimal(23, 3) DEFAULT NULL AFTER setpoints_confirmed_reactive_power_mode,
ADD COLUMN setpoints_desired_active_power_limit_active_control decimal(23, 3) DEFAULT NULL AFTER setpoints_desired_active_power_limit_cloud,
ADD COLUMN setpoints_desired_active_power_limit_grid_operator decimal(23, 3) DEFAULT NULL AFTER setpoints_desired_active_power_limit_active_control,
ADD COLUMN setpoints_desired_active_power_limit_modbus_server decimal(23, 3) DEFAULT NULL AFTER setpoints_desired_active_power_limit_grid_operator,
ADD COLUMN setpoints_desired_active_power_limit_afrr_delta decimal(23, 3) DEFAULT NULL AFTER setpoints_desired_active_power_limit_modbus_server,
ADD COLUMN setpoints_desired_active_power_limit_afrr_reference decimal(23, 3) DEFAULT NULL AFTER setpoints_desired_active_power_limit_afrr_delta,
ADD COLUMN setpoints_desired_reactive_power_cloud_reactive_power decimal(23, 3) DEFAULT NULL AFTER setpoints_desired_active_power_limit_afrr_reference,
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_effective_active_power_limit decimal(23, 3) DEFAULT NULL AFTER setpoints_desired_reactive_power_grid_operator_mode,
ADD COLUMN setpoints_effective_reactive_power_reactive_power decimal(23, 3) DEFAULT NULL AFTER setpoints_effective_active_power_limit,
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;


-- The `active_power_limit_percentage` field is deprecated and replaced by `setpoints_confirmed_active_power_limit_percentage`.
-- Existing values are migrated accordingly to ensure a consistent representation of active power limits in percentage form.
-- This change improves standardization and flexibility in power control settings.
UPDATE teleport_solar_power
SET setpoints_confirmed_active_power_limit_percentage = active_power_limit_percentage;


ALTER TABLE teleport_solar_power
DROP COLUMN active_power_limit_percentage;


ALTER TABLE teleport_solar_power COMMENT = '{"version":5}';


ALTER TABLE teleport_solar_power_inverters
ADD COLUMN reactive_power decimal(23,3) DEFAULT NULL AFTER active_power,
ADD COLUMN power_factor decimal(5, 4) DEFAULT NULL AFTER reactive_power,
ADD COLUMN setpoints_confirmed_active_power_limit_percentage decimal(4,1) DEFAULT NULL AFTER active_power_limit_percentage,
ADD COLUMN setpoints_confirmed_active_power_limit decimal(23, 3) DEFAULT NULL AFTER setpoints_confirmed_active_power_limit_percentage,
ADD COLUMN setpoints_confirmed_reactive_power_reactive_power decimal(23, 3) DEFAULT NULL AFTER setpoints_confirmed_active_power_limit,
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;


-- The `active_power_limit_percentage` field is deprecated and replaced by `setpoints_confirmed_active_power_limit_percentage`.
-- Existing values are migrated accordingly to ensure a consistent representation of active power limits in percentage form.
-- This change improves standardization and flexibility in power control settings.
UPDATE teleport_solar_power_inverters
SET setpoints_confirmed_active_power_limit_percentage = active_power_limit_percentage;


ALTER TABLE teleport_solar_power_inverters
ADD COLUMN id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST,
DROP COLUMN active_power_limit_percentage;


ALTER TABLE teleport_solar_power_inverters COMMENT = '{"version":5}';