diff options
| author | Yorhel <git@yorhel.nl> | 2021-08-03 11:01:00 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2021-08-03 11:01:00 +0200 |
| commit | 82267a30fd0e9d46e7be76204f34c232b438b874 (patch) | |
| tree | 7c343c07bb4dc486b8a4acce1439384f02f4834a /util | |
| parent | b268c00f603563c810ee3a5b3321e06420d2d7af (diff) | |
VNLengthVote: Fix migration script + no need to query DB when !$canvote
Diffstat (limited to 'util')
| -rw-r--r-- | util/updates/2021-08-03-vnlength-speed.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/updates/2021-08-03-vnlength-speed.sql b/util/updates/2021-08-03-vnlength-speed.sql index 06644129..f2809a59 100644 --- a/util/updates/2021-08-03-vnlength-speed.sql +++ b/util/updates/2021-08-03-vnlength-speed.sql @@ -1,4 +1,4 @@ -ALTER TABLE vn_length_votes ADD COLUMN speed smallint NOT NULL; +ALTER TABLE vn_length_votes ADD COLUMN speed smallint NOT NULL DEFAULT 0; ALTER TABLE vn_length_votes ALTER COLUMN speed DROP DEFAULT; ALTER TABLE vn_length_votes ADD COLUMN notes2 text NOT NULL DEFAULT ''; UPDATE vn_length_votes SET notes2 = notes; |