From 43a3ad32f9a17b23f211f61c28e37296ac4447f9 Mon Sep 17 00:00:00 2001 From: unwox Date: Mon, 16 Jun 2025 22:16:40 +0600 Subject: move tags from filter onto a separate page --- bin/fetch.fnl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'bin/fetch.fnl') diff --git a/bin/fetch.fnl b/bin/fetch.fnl index 583b48a..bc7a827 100644 --- a/bin/fetch.fnl +++ b/bin/fetch.fnl @@ -60,10 +60,11 @@ CREATE TABLE IF NOT EXISTS product_tags( product TEXT NOT NULL REFERENCES products(url), - tag DATETIME NOT NULL REFERENCES tags(title) + tag TEXT NOT NULL REFERENCES tags(title) ); CREATE UNIQUE INDEX IF NOT EXISTS product_tags_idx ON product_tags(product, tag); + CREATE INDEX IF NOT EXISTS product_tags_tag_idx ON product_tags(tag); CREATE TABLE IF NOT EXISTS tags( title TEXT NOT NULL PRIMARY KEY, -- cgit v1.2.3