From 39e7cce65fdb49f624bc3dccd4ef279db7f7b389 Mon Sep 17 00:00:00 2001 From: Přemysl Eric Janouch Date: Tue, 12 Dec 2023 05:57:04 +0100 Subject: Add a tag import command --- initialize.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'initialize.sql') diff --git a/initialize.sql b/initialize.sql index 706580d..36af2aa 100644 --- a/initialize.sql +++ b/initialize.sql @@ -10,7 +10,7 @@ CREATE INDEX IF NOT EXISTS image__dhash ON image(dhash); -- --- NOTE: This table requires garbage collection. +-- NOTE: This table requires garbage collection. Perhaps as a trigger. CREATE TABLE IF NOT EXISTS directory( id INTEGER NOT NULL, -- unique ID name TEXT NOT NULL, -- basename @@ -50,7 +50,7 @@ INSERT INTO tag_space(id, name, description) VALUES(0, '', 'User-defined tags') ON CONFLICT DO NOTHING; --- NOTE: This table requires garbage collection. +-- NOTE: This table requires garbage collection. Perhaps as a trigger. CREATE TABLE IF NOT EXISTS tag( id INTEGER NOT NULL, space INTEGER NOT NULL REFERENCES tag_space(id), -- cgit v1.2.3-70-g09d2