ruuvi-tables.sql

CREATE TABLE IF NOT EXISTS Sensors (
MAC_Address    INT     PRIMARY KEY     NOT NULL,
Name           TEXT                    NOT NULL,
Location       TEXT                    NOT NULL);

CREATE TABLE IF NOT EXISTS Readings (
MAC_Address    INT          NOT NULL references sensors (MAC_Address),
Tempurature    REAL         NOT NULL,
Humidity       REAL         NOT NULL,
Pressure       REAL         NOT NULL,
Read_Time      TIMESTAMP);