CREATE TABLE sensorData (
    id              INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    DeviceRef       VARCHAR(30) NOT NULL,
    liveLocation    VARCHAR(30) NOT NULL,
    temperature     decimal(5,2),
    humidity        decimal(5,2),
    voltage1        decimal(5,2),
    current1        decimal(5,2),
    pf1             decimal(5,2),
    freq1           decimal(5,2),
    voltage2        decimal(5,2),
    current2        decimal(5,2),
    pf2             decimal(5,2),
    freq2           decimal(5,2),
    tms             TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
