commit 7fac138e7c03ad906cb8cf863af760311239236f from: Aleksey Ryndin date: Sun Oct 13 14:28:43 2024 UTC Del unused DB schema part 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():