From 083739fd4e227b8323a50d29055327ce9c5bfa2d Mon Sep 17 00:00:00 2001 From: Přemysl Eric Janouch Date: Mon, 22 Jan 2024 19:29:51 +0100 Subject: gallery: implement AND/NOT for tag search --- initialize.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'initialize.sql') 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; -- cgit v1.2.3-70-g09d2