9 lines
255 B
SQL
9 lines
255 B
SQL
-- Add migration script here
|
|
CREATE TABLE Values (
|
|
timestamp TIMESTAMP NOT NULL,
|
|
value FLOAT NOT NULL,
|
|
value_id INT NOT NULL,
|
|
device_id MACADDR NOT NULL,
|
|
active_errors INT NOT NULL,
|
|
FOREIGN KEY (device_id) REFERENCES Devices(ID)
|
|
); |