diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/2022-03-23-vn-length-votes-uncounted.sql | 6 |
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 |