-- Tabulas izveide skaitītāju numuriem
CREATE TABLE meter_meter
(
    id            INT AUTO_INCREMENT PRIMARY KEY,
    meter_number  VARCHAR(50) UNIQUE
);
-- Datu pievienošana no skaititaji, tikai unikālie un nenulles
INSERT INTO meter_meter (meter_number)
SELECT DISTINCT s.number
FROM skaititaji AS s
WHERE s.number IS NOT NULL;
-- Pagaidu tabula objektu nosaukumiem
CREATE TABLE meter_object_temp
(
    id           INT AUTO_INCREMENT PRIMARY KEY,
    object_name  VARCHAR(255)
);
-- Datu ievietošana no skaititaji tabulas
INSERT INTO meter_object_temp (object_name)
SELECT DISTINCT k.name
FROM skaititaji k
WHERE k.name IS NOT NULL;
-- Mērījumu datu tabulas definīcija
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
);
-- Ievieto mērījumus no avota tabulas
INSERT INTO meter_data (meter_number, value_from, value_to, difference, date_from, date_to)
SELECT 
    t.number,
    t.value_from,
    t.value_to,
    t.different,
    t.date_from,
    t.date_to
FROM skaititaji t
WHERE t.number IS NOT NULL;