Commit Diff


commit - a0cb657e5a71361f57f2ddd8fafadec12dd800fb
commit + 7fac138e7c03ad906cb8cf863af760311239236f
blob - e88c537ebddf4ea8b45cb2ebf2574f87155859f3
blob + 77995b9386d798e6a40beaa9d6506da82c5d68af
--- lonk.py
+++ lonk.py
@@ -253,33 +253,11 @@ def db_create_schema(db_con):
                 url TEXT NOT NULL,
                 mime TEXT,
                 alt_text TEXT,
-                FOREIGN KEY (client_id) REFERENCES client (client_id),
-                FOREIGN KEY (convoy_id) REFERENCES convoy (convoy_id)
-            )
-        """
-    )
-    db_con.execute(
-        """
-        CREATE TABLE
-            xonker (
-                xonker_id INTEGER PRIMARY KEY,
-                client_id INTEGER,
-                convoy_id INTEGER,
-                url TEXT NOT NULL,
                 FOREIGN KEY (client_id) REFERENCES client (client_id),
                 FOREIGN KEY (convoy_id) REFERENCES convoy (convoy_id)
-            )
-        """
-    )
-    db_con.execute(
-        """
-        CREATE TABLE
-            meta (
-                db_schema_version INTEGER
             )
         """
     )
-    db_con.execute("INSERT INTO meta(db_schema_version) VALUES (?)", (1, ))
 
 
 def db_connect():