summaryrefslogtreecommitdiff
path: root/initialize.sql
diff options
context:
space:
mode:
authorPřemysl Eric Janouch <p@janouch.name>2023-12-21 23:58:32 +0100
committerPřemysl Eric Janouch <p@janouch.name>2023-12-21 23:58:32 +0100
commita3129ce9179ea8816c6442b73e61b7ba7bd2e49a (patch)
tree2a299f736ba4eaafdfb2ea62ac43c6d47bd726eb /initialize.sql
parent2b5e3bd4eade8010c036633e5c69a2ce79a5ba15 (diff)
downloadgallery-a3129ce9179ea8816c6442b73e61b7ba7bd2e49a.tar.gz
gallery-a3129ce9179ea8816c6442b73e61b7ba7bd2e49a.tar.xz
gallery-a3129ce9179ea8816c6442b73e61b7ba7bd2e49a.zip
WIP: FS to DB sync
Diffstat (limited to 'initialize.sql')
-rw-r--r--initialize.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/initialize.sql b/initialize.sql
index f439953..fc7d468 100644
--- a/initialize.sql
+++ b/initialize.sql
@@ -48,7 +48,7 @@ END;
--
CREATE TABLE IF NOT EXISTS orphan(
- sha1 TEXT NOT NULL REFERENCES image(sha1)
+ sha1 TEXT NOT NULL REFERENCES image(sha1),
path TEXT NOT NULL, -- last occurence within the database hierarchy
PRIMARY KEY (sha1)
) STRICT;