diff options
| author | Přemysl Eric Janouch <p@janouch.name> | 2024-01-22 19:29:51 +0100 |
|---|---|---|
| committer | Přemysl Eric Janouch <p@janouch.name> | 2024-01-22 19:52:35 +0100 |
| commit | 083739fd4e227b8323a50d29055327ce9c5bfa2d (patch) | |
| tree | 86e7fb22530e4dac108625650b8c4eba072c4b08 /initialize.sql | |
| parent | 4f174972e3f3040f78f87f2b96a0e7bfc94fed6e (diff) | |
| download | gallery-083739fd4e227b8323a50d29055327ce9c5bfa2d.tar.gz gallery-083739fd4e227b8323a50d29055327ce9c5bfa2d.tar.xz gallery-083739fd4e227b8323a50d29055327ce9c5bfa2d.zip | |
gallery: implement AND/NOT for tag search
Diffstat (limited to 'initialize.sql')
| -rw-r--r-- | initialize.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/initialize.sql b/initialize.sql index 5a54a7f..292c50b 100644 --- a/initialize.sql +++ b/initialize.sql @@ -76,7 +76,7 @@ CREATE TABLE IF NOT EXISTS tag_space( id INTEGER NOT NULL, name TEXT NOT NULL, description TEXT, - CHECK (name NOT LIKE '%:%'), + CHECK (name NOT LIKE '%:%' AND name NOT LIKE '-%'), PRIMARY KEY (id) ) STRICT; |