diff options
Diffstat (limited to 'initialize.sql')
| -rw-r--r-- | initialize.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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), |