1 files changed, 4 insertions, 3 deletions
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)
         );
                 """
         )