CREATE TABLE
    `device_water_level_log` (
        `id_log` INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
        `id_device` VARCHAR(20) CHARACTER SET ascii COLLATE ascii_general_ci,
        `time` DATETIME NOT NULL,
        `water_level` DECIMAL(10, 3),
        `flow` DECIMAL(10, 3)
    );