Skip to content
Teleport

Migration script

  • PostgreSQL
  • Battery power
  • v4 to v5
ALTER TABLE teleport_battery_power
ADD COLUMN recent_setpoint_statistics_min decimal(23,3) DEFAULT NULL,
ADD COLUMN recent_setpoint_statistics_max decimal(23,3) DEFAULT NULL,
ADD COLUMN recent_setpoint_statistics_active_power_min decimal(23,3) DEFAULT NULL,
ADD COLUMN recent_setpoint_statistics_active_power_max decimal(23,3) DEFAULT NULL,
ADD COLUMN recent_setpoint_statistics_reactive_power_min decimal(23,3) DEFAULT NULL,
ADD COLUMN recent_setpoint_statistics_reactive_power_max decimal(23,3) DEFAULT NULL,
ADD COLUMN setpoints_desired_deliver_fcr_modbus_server decimal(23,3) DEFAULT NULL,
ADD COLUMN setpoints_effective_deliver_fcr decimal(23,3) DEFAULT NULL,
ADD COLUMN cellular_signal_quality decimal(7,2) DEFAULT NULL;


ALTER TABLE teleport_battery_power_bess_rack
ADD COLUMN rack_status varchar(32) DEFAULT NULL,
ADD COLUMN state_of_charge decimal(7,4) DEFAULT NULL,
ADD COLUMN cell_temperature_min decimal(6,2) DEFAULT NULL,
ADD COLUMN cell_temperature_cell_id_min int DEFAULT NULL,
ADD COLUMN cell_temperature_max decimal(6,2) DEFAULT NULL,
ADD COLUMN cell_temperature_cell_id_max int DEFAULT NULL,
ADD COLUMN cell_voltage_min decimal(6,3) DEFAULT NULL,
ADD COLUMN cell_voltage_cell_id_min int DEFAULT NULL,
ADD COLUMN cell_voltage_max decimal(6,3) DEFAULT NULL,
ADD COLUMN cell_voltage_cell_id_max int DEFAULT NULL,
ADD COLUMN cell_voltage_average decimal(6,3) DEFAULT NULL;


COMMENT ON TABLE teleport_battery_power IS '{"version":5}';
COMMENT ON TABLE teleport_battery_power_bess IS '{"version":5}';
COMMENT ON TABLE teleport_battery_power_bess_rack IS '{"version":5}';