commit - a0cb657e5a71361f57f2ddd8fafadec12dd800fb
commit + 7fac138e7c03ad906cb8cf863af760311239236f
blob - e88c537ebddf4ea8b45cb2ebf2574f87155859f3
blob + 77995b9386d798e6a40beaa9d6506da82c5d68af
--- lonk.py
+++ lonk.py
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():