summaryrefslogtreecommitdiff
path: root/util/sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/sql')
-rw-r--r--util/sql/func.sql1
-rw-r--r--util/sql/schema.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql
index 0248c69a..2f87bdb9 100644
--- a/util/sql/func.sql
+++ b/util/sql/func.sql
@@ -103,6 +103,7 @@ BEGIN
WITH RECURSIVE tags_vn_all(lvl, tag, vid, uid, vote, spoiler, meta) AS (
SELECT 15, tag, vid, uid, vote, spoiler, false
FROM tags_vn
+ WHERE NOT ignore
UNION ALL
SELECT lvl-1, tp.parent, ta.vid, ta.uid, ta.vote, ta.spoiler, t.meta
FROM tags_vn_all ta
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 676d6400..2a3a394a 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -217,6 +217,7 @@ CREATE TABLE tags_vn (
vote smallint NOT NULL DEFAULT 3 CHECK (vote >= -3 AND vote <= 3 AND vote <> 0),
spoiler smallint CHECK(spoiler >= 0 AND spoiler <= 2),
date timestamptz NOT NULL DEFAULT NOW(),
+ ignore boolean NOT NULL DEFAULT false,
PRIMARY KEY(tag, vid, uid)
);