From 877fc267df42e0ecfe358c0be91f3159a3e5cb70 Mon Sep 17 00:00:00 2001
From: Vincent-Michael <Vincent_Michael@gmx.de>
Date: Sun, 13 Jul 2014 00:26:03 +0200
Subject: DB/Player: Update player create info skills for 4.3.4

---
 .../2014_07_13_00_world_playercreateinfo_skills_434.sql    | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 sql/updates/world/2014_07_13_00_world_playercreateinfo_skills_434.sql

diff --git a/sql/updates/world/2014_07_13_00_world_playercreateinfo_skills_434.sql b/sql/updates/world/2014_07_13_00_world_playercreateinfo_skills_434.sql
new file mode 100644
index 00000000000..8320ccc5959
--- /dev/null
+++ b/sql/updates/world/2014_07_13_00_world_playercreateinfo_skills_434.sql
@@ -0,0 +1,14 @@
+UPDATE `playercreateinfo_skills` SET `raceMask` = 0 WHERE `skill` IN (45,46,160,173,226);
+-- Goblin
+UPDATE `playercreateinfo_skills` SET `raceMask` = `raceMask` | 256 WHERE `skill`=109; -- Language: Orcish
+-- Worgen
+UPDATE `playercreateinfo_skills` SET `raceMask` = `raceMask` | 2097152 WHERE `skill`=98; -- Language: Common
+
+DELETE FROM `playercreateinfo_skills` WHERE `skill` IN (790,792,789,791);
+INSERT INTO `playercreateinfo_skills` VALUES
+-- Goblin
+(256,0,790,0,'Racial - Goblin'),
+(256,0,792,0,'Language: Goblin'),
+-- Worgen
+(2097152,0,789,0,'Racial - Worgen'),
+(2097152,0,791,0,'Language: Worgen');
-- 
cgit v1.2.3