summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-10-22 16:04:33 +0200
committerYorhel <git@yorhel.nl>2022-10-22 16:04:35 +0200
commit138944ced5a32236afa479c418a33dc7ae8cf9b5 (patch)
tree9b7a820ee1fa9a4fad4bbcca717f95f66d012c44 /util
parentbc9b1e24b65cf0151a71ade5aa498db528d4b9a3 (diff)
AdvSearch: Add option to exclude lie tags
https://vndb.org/t18886.24 The compact form encoding is a big ugly mess, I wouldn't be surprised if there's bugs.
Diffstat (limited to 'util')
-rw-r--r--util/updates/2022-10-22-tags_vn_inherit-lie.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/2022-10-22-tags_vn_inherit-lie.sql b/util/updates/2022-10-22-tags_vn_inherit-lie.sql
new file mode 100644
index 00000000..9ab1e329
--- /dev/null
+++ b/util/updates/2022-10-22-tags_vn_inherit-lie.sql
@@ -0,0 +1,4 @@
+ALTER TABLE tags_vn_inherit ADD COLUMN lie boolean;
+\i sql/func.sql
+SELECT tag_vn_calc(null);
+ALTER TABLE tags_vn_inherit ALTER COLUMN lie DROP NOT NULL;