ALTER TABLE consumption_energy_measurements ADD COLUMN device_serial_number varchar(50);