diff options
| author | Jeffrey Armstrong <jeff@approximatrix.com> | 2022-06-29 08:40:04 -0400 |
|---|---|---|
| committer | Jeffrey Armstrong <jeff@approximatrix.com> | 2022-06-29 08:40:04 -0400 |
| commit | 10247d7db2aaffdc617066fa261de8df6454e966 (patch) | |
| tree | a5a17fde9904b27e57fa51357cbd8ae1cfe0f8d9 /captain/sql | |
| parent | 6f681035a7c7125a72ce04d6881c1579bdb96d09 (diff) | |
| parent | fb7136be64188cab7db34ac3ad6c8f27098173de (diff) | |
| download | levitating-10247d7db2aaffdc617066fa261de8df6454e966.tar.gz levitating-10247d7db2aaffdc617066fa261de8df6454e966.zip | |
Merge branch 'artifacts'
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)); |