summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/updates/2022-03-23-vn-length-votes-uncounted.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/util/updates/2022-03-23-vn-length-votes-uncounted.sql b/util/updates/2022-03-23-vn-length-votes-uncounted.sql
new file mode 100644
index 00000000..fa24d44c
--- /dev/null
+++ b/util/updates/2022-03-23-vn-length-votes-uncounted.sql
@@ -0,0 +1,6 @@
+BEGIN;
+ALTER TABLE vn_length_votes ALTER COLUMN speed DROP NOT NULL;
+UPDATE vn_length_votes SET speed = NULL WHERE ignore;
+ALTER TABLE vn_length_votes DROP COLUMN ignore;
+COMMIT;
+\i sql/func.sql