diff options
| author | Jeffrey Armstrong <jeff@approximatrix.com> | 2022-06-29 08:33:07 -0400 |
|---|---|---|
| committer | Jeffrey Armstrong <jeff@approximatrix.com> | 2022-06-29 08:33:07 -0400 |
| commit | fb7136be64188cab7db34ac3ad6c8f27098173de (patch) | |
| tree | 8660bbd7aec6a256dcaf672d5ffc4ac9c2d96fc4 /captain/sql | |
| parent | 6e59e791b7b4d1184e70378544b6ace433ab33aa (diff) | |
| download | levitating-fb7136be64188cab7db34ac3ad6c8f27098173de.tar.gz levitating-fb7136be64188cab7db34ac3ad6c8f27098173de.zip | |
Initial work to show artifacts on job pages.
Diffstat (limited to 'captain/sql')
| -rw-r--r-- | captain/sql/create.sql | 1 |
1 files changed, 1 insertions, 0 deletions
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)); |