diff options
Diffstat (limited to 'initialize.sql')
| -rw-r--r-- | initialize.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/initialize.sql b/initialize.sql index 9698c69..c230f18 100644 --- a/initialize.sql +++ b/initialize.sql @@ -47,6 +47,15 @@ END; -- +-- TODO: Add a trigger to delete from here when a node for the sha1 is added. +CREATE TABLE IF NOT EXISTS orphan( + sha1 TEXT NOT NULL REFERENCES image(sha1) + path TEXT NOT NULL, + PRIMARY KEY (sha1) +) STRICT; + +-- + CREATE TABLE IF NOT EXISTS tag_space( id INTEGER NOT NULL, name TEXT NOT NULL, |