From ff101cd100ed6f11afcaeab0ace160b58da80d6f Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 11 Apr 2015 18:58:13 +0200 Subject: Core/Battle.net: Query optimizations part2 - made all queries asynchronous --- sql/base/auth_database.sql | 1 - sql/updates/auth/2015_04_11_01_auth.sql | 1 + 2 files changed, 1 insertion(+), 1 deletion(-) create mode 100644 sql/updates/auth/2015_04_11_01_auth.sql (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 866088cf4ac..ca4e56f75e7 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -180,7 +180,6 @@ CREATE TABLE `battlenet_account_bans` ( `unbandate` int(10) unsigned NOT NULL DEFAULT '0', `bannedby` varchar(50) NOT NULL, `banreason` varchar(255) NOT NULL, - `active` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`,`bandate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List'; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/auth/2015_04_11_01_auth.sql b/sql/updates/auth/2015_04_11_01_auth.sql new file mode 100644 index 00000000000..3d205b86298 --- /dev/null +++ b/sql/updates/auth/2015_04_11_01_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `battlenet_account_bans` DROP COLUMN `active`; -- cgit v1.2.3