Fixing schema bug and adding sqlite version of DB

Jonathan K. Kummerfeld · Jonathan K. Kummerfeld · commit 2905ab815b48 · 2020-10-08T09:43:16.000-05:00
diff --git a/data/restaurants-db.added-in-2020.sqlite b/data/restaurants-db.added-in-2020.sqlite
diff --git a/data/restaurants-schema.csv b/data/restaurants-schema.csv
@@ -10,6 +10,6 @@ LOCATION, HOUSE_NUMBER,  n, n, int(11)
 LOCATION, STREET_NAME,   n, n, varchar(255)
 LOCATION, CITY_NAME,     n, y, varchar(255)
 -, -, -, -, -
-GEOGRAPHIC, CITY_NAME, y, n, varchar(255)
+GEOGRAPHIC, CITY_NAME, y, y, varchar(255)
 GEOGRAPHIC, COUNTY,    n, n, varchar(255)
 GEOGRAPHIC, REGION,    n, n, varchar(255)
diff --git a/tools/create_restaurant_database.py b/tools/create_restaurant_database.py
@@ -33,7 +33,7 @@ def insert_into(cursor: sqlite3.Cursor,
                              HOUSE_NUMBER int(11),
                              STREET_NAME varchar(255),
                              CITY_NAME varchar(255),
-                             FOREIGN KEY (CITY_NAME) REFERENCES GEOGRAPHIC(CITY_NAME)
+                             FOREIGN KEY (RESTAURANT_ID) REFERENCES GEOGRAPHIC(RESTAURANT_ID)
                              ); """
 
 def main(input_path: str, output_path: str = "./restuarants.db"):
