diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-10-07 10:58:04 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-10-07 10:58:04 +0200 |
| commit | 293aa781aeca1a435b1482f68eb7c8a6b286b4e8 (patch) | |
| tree | 3f2f6f97183311376e49ecb7fc0e85e6fa9294c2 /sql/updates | |
| parent | aed90ab2044bcb051949c7204fe797a935bda680 (diff) | |
SQL: Fix wrong delete query
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/master/2021_10_07_00_auth.sql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/sql/updates/auth/master/2021_10_07_00_auth.sql b/sql/updates/auth/master/2021_10_07_00_auth.sql index fe488ac904d..dabafcf8538 100644 --- a/sql/updates/auth/master/2021_10_07_00_auth.sql +++ b/sql/updates/auth/master/2021_10_07_00_auth.sql @@ -1,7 +1,6 @@ -UPDATE `build_info` SET `mac64AuthSeed`='853F0F2985CEAED46DF422583CD07A7C' WHERE `build`=40120; - -DELETE FROM `build_info` WHERE `build`=40120; +DELETE FROM `build_info` WHERE `build` IN (40120,40443); INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES +(40120,9,1,0,NULL,NULL,'04F47EAEFD8BDEFE14AA0350EA336678','853F0F2985CEAED46DF422583CD07A7C',NULL,NULL), (40443,9,1,0,NULL,NULL,'8597BB43E8AB38C85504E8BFB72ABBF5',NULL,NULL,NULL); UPDATE `realmlist` SET `gamebuild`=40443 WHERE `gamebuild`=40120; |