summaryrefslogtreecommitdiff
path: root/util/updates/update_2.17.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-01-03 20:36:39 +0100
committerYorhel <git@yorhel.nl>2011-01-03 21:35:40 +0100
commitdf6dc445df2f73381829b8af8db606cea67f589d (patch)
tree7e88dbf3d20420b08791371c33578496a7e59fc4 /util/updates/update_2.17.sql
parent5894b1f62abbe8837067bdf34a559d78e0a5f3a5 (diff)
SQL: Added tags_vn.ignore column and updated queries to respect this
This is the first step in adding support for overruling tag votes by moderators. Also removed some unused options from dbTagStats(); the tag-vote-stats-by-user pages have been removed in the previous VNDB update, which was the only page using these additional options.
Diffstat (limited to 'util/updates/update_2.17.sql')
-rw-r--r--util/updates/update_2.17.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/util/updates/update_2.17.sql b/util/updates/update_2.17.sql
new file mode 100644
index 00000000..54487d0a
--- /dev/null
+++ b/util/updates/update_2.17.sql
@@ -0,0 +1,8 @@
+
+-- tag overrule feature
+ALTER TABLE tags_vn ADD COLUMN ignore boolean NOT NULL DEFAULT false;
+
+
+-- load new function(s)
+\i util/sql/func.sql
+