move tags from filter onto a separate page

1 files changed, 2 insertions, 1 deletions

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,