From df7e05fea4a14d6749eb476ae4e66b4f2a771a19 Mon Sep 17 00:00:00 2001 From: root Date: Sat, 5 Feb 2022 18:40:27 +0000 Subject: Working on a few last features. --- sql.py | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'sql.py') diff --git a/sql.py b/sql.py index 38d40e1..7276ff9 100644 --- a/sql.py +++ b/sql.py @@ -47,10 +47,11 @@ class db: """ CREATE TABLE weather ( date text not null, + time integer not null, temperature real, - wind real, - PRIMARY KEY (date), - FOREIGN KEY (date) REFERENCES temperature(date) + PRIMARY KEY (date, times), + FOREIGN KEY (date) REFERENCES temperature(date), + FOREIGN KEY (time) REFERENCES temperature(time) ); """ ) -- cgit v1.2.3