diff options
| author | Přemysl Eric Janouch <p@janouch.name> | 2023-12-12 05:57:04 +0100 |
|---|---|---|
| committer | Přemysl Eric Janouch <p@janouch.name> | 2023-12-12 05:57:04 +0100 |
| commit | 39e7cce65fdb49f624bc3dccd4ef279db7f7b389 (patch) | |
| tree | b0b4f7702cbe5b192819947102c3f7a4e3fddc7e /initialize.sql | |
| parent | e0283d0f1b16b919c34ff703f1302f7e0186c118 (diff) | |
| download | gallery-39e7cce65fdb49f624bc3dccd4ef279db7f7b389.tar.gz gallery-39e7cce65fdb49f624bc3dccd4ef279db7f7b389.tar.xz gallery-39e7cce65fdb49f624bc3dccd4ef279db7f7b389.zip | |
Add a tag import command
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), |