Skip to content
Teleport

Migration script

  • PostgreSQL
  • Battery power
  • v5 to v6
ALTER TABLE teleport_battery_power
ADD COLUMN calculated_energy_usable_capacity_charge decimal(23,3),
ADD COLUMN calculated_energy_usable_capacity_discharge decimal(23,3),
ADD COLUMN calculated_energy_usable_capacity_charge_at_nominal_power decimal(23,3),
ADD COLUMN calculated_energy_usable_capacity_discharge_at_nominal_power decimal(23,3),
ADD COLUMN calculated_energy_usable_energy_charge decimal(23,3),
ADD COLUMN calculated_energy_usable_energy_discharge decimal(23,3),
ADD COLUMN calculated_energy_usable_energy_charge_at_nominal_power decimal(23,3),
ADD COLUMN calculated_energy_usable_energy_discharge_at_nominal_power decimal(23,3);


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