From 083739fd4e227b8323a50d29055327ce9c5bfa2d Mon Sep 17 00:00:00 2001
From: Přemysl Eric Janouch <p@janouch.name>
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

