diff options
| author | Yorhel <git@yorhel.nl> | 2022-03-23 15:30:57 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2022-03-23 15:31:08 +0100 |
| commit | 8676f6d16acbbc2899f5d1d4afcda2040e05413a (patch) | |
| tree | 7f775c3d0e905b7747f61401912a17d8235ab599 /util | |
| parent | 1d433bb7c7da67fb03cec048fac1ac28f06f319b (diff) | |
VN length voting: remove ignore flag and allow speed=NULL for uncounted votes
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 |