From fcd660b240a7a0d499bc1bb27860f136745a9098 Mon Sep 17 00:00:00 2001
From: teacher <none@none>
Date: Fri, 9 Apr 2010 15:41:01 +0200
Subject: Changed recent spell_difficulty_dbc table creation to CHARSET=utf8.
 Added recent sql updates to world.sql...

--HG--
branch : trunk
---
 sql/updates/7815_world_spelldifficulty_dbc.sql |  2 +-
 sql/world.sql                                  | 29 ++++++++++++++++++++++++++
 2 files changed, 30 insertions(+), 1 deletion(-)

(limited to 'sql')

diff --git a/sql/updates/7815_world_spelldifficulty_dbc.sql b/sql/updates/7815_world_spelldifficulty_dbc.sql
index 2c91beaefbb..b6fb3cec898 100644
--- a/sql/updates/7815_world_spelldifficulty_dbc.sql
+++ b/sql/updates/7815_world_spelldifficulty_dbc.sql
@@ -6,4 +6,4 @@ CREATE TABLE `spelldifficulty_dbc` (
   `spellid2` int(11) unsigned NOT NULL DEFAULT '0',
   `spellid3` int(11) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/sql/world.sql b/sql/world.sql
index d7cb7ec3dad..4d3f4c5ab91 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -14218,6 +14218,35 @@ INSERT INTO `spell_threat` VALUES (78,20),(284,39),(285,59),(770,108),(1608,78),
 /*!40000 ALTER TABLE `spell_threat` ENABLE KEYS */;
 UNLOCK TABLES;
 
+--
+-- Table structure for table `spell_difficulty_dbc`
+--
+
+DROP TABLE IF EXISTS `spelldifficulty_dbc`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spelldifficulty_dbc` (
+  `id` int(11) unsigned NOT NULL DEFAULT '0',
+  `spellid0` int(11) unsigned NOT NULL DEFAULT '0',
+  `spellid1` int(11) unsigned NOT NULL DEFAULT '0',
+  `spellid2` int(11) unsigned NOT NULL DEFAULT '0',
+  `spellid3` int(11) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `spell_difficulty_dbc`
+--
+
+LOCK TABLES `spell_difficulty_dbc` WRITE;
+/*!40000 ALTER TABLE `spell_difficulty_dbc` DISABLE KEYS */;
+INSERT INTO `spell_difficulty_dbc` VALUES 
+(3000,47772,56935,0,0), -- Magus Telestra - Ice Nova
+(3001,47773,56934,0,0); -- Magus Telestra - Fire Bomb
+/*!40000 ALTER TABLE `spell_difficulty_dbc` ENABLE KEYS */;
+UNLOCK TABLES;
+
 --
 -- Table structure for table `transport_events`
 --
-- 
cgit v1.2.3