Skip to content
Teleport

Migration script

  • PostgreSQL
  • Solar power
  • v2 to v3
ALTER TABLE teleport_solar_power
ADD COLUMN reactive_power decimal(23,3),
ADD COLUMN power_factor decimal(5, 4),
ADD COLUMN setpoints_confirmed_active_power_limit_percentage decimal(4,1),
ADD COLUMN setpoints_confirmed_active_power_limit decimal(23, 3),
ADD COLUMN setpoints_confirmed_reactive_power_reactive_power decimal(23,3),
ADD COLUMN setpoints_confirmed_reactive_power_power_factor decimal(5,4),
ADD COLUMN setpoints_confirmed_reactive_power_mode varchar(32),
ADD COLUMN setpoints_desired_active_power_limit_cloud decimal(23, 3),
ADD COLUMN setpoints_desired_active_power_limit_active_control decimal(23, 3),
ADD COLUMN setpoints_desired_active_power_limit_grid_operator decimal(23, 3),
ADD COLUMN setpoints_desired_active_power_limit_modbus_server decimal(23, 3),
ADD COLUMN setpoints_desired_active_power_limit_afrr_delta decimal(23, 3),
ADD COLUMN setpoints_desired_active_power_limit_afrr_reference decimal(23, 3),
ADD COLUMN setpoints_desired_reactive_power_cloud_reactive_power decimal(23,3),
ADD COLUMN setpoints_desired_reactive_power_cloud_power_factor decimal(5,4),
ADD COLUMN setpoints_desired_reactive_power_cloud_mode varchar(32),
ADD COLUMN setpoints_desired_reactive_power_grid_operator_reactive_power decimal(23,3),
ADD COLUMN setpoints_desired_reactive_power_grid_operator_power_factor decimal(5,4),
ADD COLUMN setpoints_desired_reactive_power_grid_operator_mode varchar(32),
ADD COLUMN setpoints_effective_active_power_limit decimal(23, 3),
ADD COLUMN setpoints_effective_reactive_power_reactive_power decimal(23,3),
ADD COLUMN setpoints_effective_reactive_power_power_factor decimal(5,4),
ADD COLUMN setpoints_effective_reactive_power_mode varchar(32);


-- 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_inverters
ADD COLUMN reactive_power decimal(23,3),
ADD COLUMN power_factor decimal(5, 4),
ADD COLUMN setpoints_confirmed_active_power_limit_percentage decimal(4,1),
ADD COLUMN setpoints_confirmed_active_power_limit decimal(23, 3),
ADD COLUMN setpoints_confirmed_reactive_power_reactive_power decimal(23,3),
ADD COLUMN setpoints_confirmed_reactive_power_power_factor decimal(5,4),
ADD COLUMN setpoints_confirmed_reactive_power_mode varchar(32);


-- 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
DROP COLUMN active_power_limit_percentage;


COMMENT ON TABLE teleport_solar_power IS '{"version":3}';
COMMENT ON TABLE teleport_solar_power_inverters IS '{"version":3}';