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 | |
| parent | aed90ab2044bcb051949c7204fe797a935bda680 (diff) | |
SQL: Fix wrong delete query
| -rw-r--r-- | sql/base/auth_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_10_07_00_auth.sql | 5 |
2 files changed, 3 insertions, 4 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 9140eb6a3ae..f0d28e3b050 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -2425,7 +2425,7 @@ INSERT INTO `updates` VALUES ('2021_08_19_00_auth.sql','DE008EDFB1FEBA49567E245A64BFE70DA72D9E7B','RELEASED','2021-08-19 10:58:58',0), ('2021_09_02_00_auth.sql','907344F4F0113A13D5E0A1D95E2C3E4C4150090C','RELEASED','2021-09-02 12:38:08',0), ('2021_09_10_00_auth.sql','DE94812ABC7B395C6C3405FB6718A8AF2C9F8FEC','RELEASED','2021-09-10 12:18:54',0), -('2021_10_07_00_auth.sql','A0DB6FB339D42D75B716C673397E4565C97E2886','RELEASED','2021-10-07 10:32:05',0); +('2021_10_07_00_auth.sql','45F2D92E28382F0CBE1F9B3A97693C0CC69E50BC','RELEASED','2021-10-07 10:32:05',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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; |