Skip to content
Teleport

Migration script

  • MySQL
  • Solar power
  • v5 to v6
ALTER TABLE teleport_solar_power
ADD COLUMN available_active_power decimal(23,3) DEFAULT NULL AFTER active_power;


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


ALTER TABLE teleport_solar_power_inverters
ADD COLUMN apparent_power decimal(23,3) DEFAULT NULL AFTER reactive_power,
ADD COLUMN frequency decimal(7,2) DEFAULT NULL AFTER power_factor,
ADD COLUMN voltage_phase_l1 decimal(23,3) DEFAULT NULL AFTER generated_energy,
ADD COLUMN voltage_phase_l2 decimal(23,3) DEFAULT NULL AFTER voltage_phase_l1,
ADD COLUMN voltage_phase_l3 decimal(23,3) DEFAULT NULL AFTER voltage_phase_l2,
ADD COLUMN voltage_line_l1 decimal(23,3) DEFAULT NULL AFTER voltage_phase_l3,
ADD COLUMN voltage_line_l2 decimal(23,3) DEFAULT NULL AFTER voltage_line_l1,
ADD COLUMN voltage_line_l3 decimal(23,3) DEFAULT NULL AFTER voltage_line_l2,
ADD COLUMN current_phase_l1 decimal(23,3) DEFAULT NULL AFTER voltage_line_l3,
ADD COLUMN current_phase_l2 decimal(23,3) DEFAULT NULL AFTER current_phase_l1,
ADD COLUMN current_phase_l3 decimal(23,3) DEFAULT NULL AFTER current_phase_l2,
ADD COLUMN current_line_l1 decimal(23,3) DEFAULT NULL AFTER current_phase_l3,
ADD COLUMN current_line_l2 decimal(23,3) DEFAULT NULL AFTER current_line_l1,
ADD COLUMN current_line_l3 decimal(23,3) DEFAULT NULL AFTER current_line_l2;


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