From fb7136be64188cab7db34ac3ad6c8f27098173de Mon Sep 17 00:00:00 2001 From: Jeffrey Armstrong Date: Wed, 29 Jun 2022 08:33:07 -0400 Subject: Initial work to show artifacts on job pages. --- captain/sql/create.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'captain/sql') diff --git a/captain/sql/create.sql b/captain/sql/create.sql index 323efd0..f8c674f 100644 --- a/captain/sql/create.sql +++ b/captain/sql/create.sql @@ -25,3 +25,4 @@ CREATE TABLE sessions(user INTEGER, session TEXT NOT NULL, accessed TEXT NOT NUL CREATE VIEW session_auth AS SELECT sessions.session, users.username, users.level FROM sessions INNER JOIN users ON sessions.user = users.id; +CREATE TABLE job_uploads(job INTEGER, category TEXT NOT NULL, filename TEXT NOT NULL, FOREIGN KEY(job) REFERENCES jobs(id)); -- cgit v1.2.3