-- Izveido tabulu meter_meter
CREATE TABLE meter_meter (
    id INT AUTO_INCREMENT PRIMARY KEY,
    meter_number VARCHAR(50) UNIQUE
);

-- Aizpilda tabulu ar unikālajiem skaitītāju numuriem no skaititaji
INSERT INTO meter_meter (meter_number)
SELECT DISTINCT number
FROM skaititaji
WHERE number IS NOT NULL;



-- Izveido pagaidu objektu tabulu
CREATE TABLE meter_object_temp (
    id INT AUTO_INCREMENT PRIMARY KEY,
    object_name VARCHAR(255)
);

-- Aizpilda to ar unikālajām vietām no skaititaji
INSERT INTO meter_object_temp (object_name)
SELECT DISTINCT name
FROM skaititaji
WHERE name IS NOT NULL;



-- Izveido tabulu ar mērījumu datiem
CREATE TABLE meter_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    meter_number VARCHAR(50),
    value_from INT,
    value_to INT,
    difference INT,
    date_from DATE,
    date_to DATE
);

-- Aizpilda to ar mērījumu datiem no skaititaji
INSERT INTO meter_data (meter_number, value_from, value_to, difference, date_from, date_to)
SELECT number, value_from, value_to, different, date_from, date_to
FROM skaititaji
WHERE number IS NOT NULL;