From 1d8e558f39d693ee89f4fe0f36a27900a9e1bd1a Mon Sep 17 00:00:00 2001 From: Nay Date: Wed, 8 Aug 2012 18:53:08 +0100 Subject: SQL: Correct SQL errors in an auth update file and character_database.sql (thanks Sinzia/Bio) Closes #7333 --- sql/base/characters_database.sql | 4 ++-- sql/updates/auth/2012_07_23_00_auth_realmlist_434.sql | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 0fa9c1cb313..330b6936104 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1144,7 +1144,7 @@ CREATE TABLE `character_void_storage` ( -- Dumping data for table `character_void_storage` -- -LOCK TABLES `character_set_client` WRITE; +LOCK TABLES `character_void_storage` WRITE; /*!40000 ALTER TABLE `character_void_storage` DISABLE KEYS */; /*!40000 ALTER TABLE `character_void_storage` ENABLE KEYS */; UNLOCK TABLES; @@ -2352,4 +2352,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2012-07-30 17:01:47 +-- Dump completed on 2012-08-08 18:51:30 diff --git a/sql/updates/auth/2012_07_23_00_auth_realmlist_434.sql b/sql/updates/auth/2012_07_23_00_auth_realmlist_434.sql index 565174e258b..121e97f5837 100644 --- a/sql/updates/auth/2012_07_23_00_auth_realmlist_434.sql +++ b/sql/updates/auth/2012_07_23_00_auth_realmlist_434.sql @@ -1 +1 @@ -UPDATE `realmlist` SET `gamebuild`=15595 WHERE `id`=1 +UPDATE `realmlist` SET `gamebuild`=15595 WHERE `id`=1; -- cgit v1.2.3