[8332] Add non-unique key `accid` for `realmcharacters` table for speedup queries by this field. Author: rilex

    Just note about related _not_ mangos bug: this table _expected_ to have primary key by pair (`realmid`,`acctid`).
    If used DB not have it for table, then this wrongly setup of DB.

--HG--
branch : trunk

1 files changed, 4 insertions, 0 deletions

diff --git a/sql/updates/4859_8332_01_realmd_realmcharacters.sql b/sql/updates/4859_8332_01_realmd_realmcharacters.sql
new file mode 100644
index 00000000000..c7adb23d890
--- /dev/null
+++ b/sql/updates/4859_8332_01_realmd_realmcharacters.sql
@@ -0,0 +1,4 @@
+-- ALTER TABLE realmd_db_version CHANGE COLUMN required_7938_01_realmd_account required_8332_01_realmd_realmcharacters bit;
+
+ALTER TABLE realmcharacters
+  ADD KEY (acctid);