Random sql cleanup.

--HG--
branch : trunk

7 files changed, 17 insertions, 5 deletions

diff --git a/sql/updates/7417_world_trinity_string.sql b/sql/updates/7417_world_trinity_string.sql
index 105be373309..fd8297c2828 100644
--- a/sql/updates/7417_world_trinity_string.sql
+++ b/sql/updates/7417_world_trinity_string.sql
@@ -1 +1,2 @@
-INSERT INTO trinity_string (entry, content_default) VALUES (5022, "Channel password not changed due to channel being marked public. GM Powers required.");
\ No newline at end of file
+DELETE FROM `trinity_string` WHERE `entry`=5022;
+INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES (5022, 'Channel password not changed due to channel being marked public. GM Powers required.');
diff --git a/sql/updates/7432_world_trinity_string.sql b/sql/updates/7432_world_trinity_string.sql
index 798cebb91be..9148a57788d 100644
--- a/sql/updates/7432_world_trinity_string.sql
+++ b/sql/updates/7432_world_trinity_string.sql
@@ -1 +1,2 @@
+DELETE FROM `trinity_string` WHERE `entry`=5008;
 INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES (5008,'This instance is closed.');
diff --git a/sql/updates/7446_world_areatrigger_scripts.sql b/sql/updates/7446_world_areatrigger_scripts.sql
index 5d69ebb0937..ff25dc60e79 100644
--- a/sql/updates/7446_world_areatrigger_scripts.sql
+++ b/sql/updates/7446_world_areatrigger_scripts.sql
@@ -1,3 +1,3 @@
--- areatrigger for Kelthuzads chamber center
+-- areatrigger for Kelthuzad chamber center
 DELETE FROM `areatrigger_scripts` WHERE `entry`=4112;
 INSERT INTO `areatrigger_scripts`(`entry`,`ScriptName`) VALUES(4112,'at_kelthuzad_center');
diff --git a/sql/updates/7500_world_scriptname.sql b/sql/updates/7500_world_scriptname.sql
index 5b309f48da7..9188d6121e5 100644
--- a/sql/updates/7500_world_scriptname.sql
+++ b/sql/updates/7500_world_scriptname.sql
@@ -1,2 +1,2 @@
 UPDATE `gameobject_template` SET `ScriptName`= 'go_amberpine_outhouse' WHERE `entry`=188666;
-UPDATE `creature_template` SET `ScriptName`= 'npc_outhouse_bunny' WHERE `entry`=27326;
\ No newline at end of file
+UPDATE `creature_template` SET `ScriptName`= 'npc_outhouse_bunny' WHERE `entry`=27326;
diff --git a/sql/updates/7547_world_vehicle_accessory.sql b/sql/updates/7547_world_vehicle_accessory.sql
index 0ae68a0c966..36270cf3db7 100644
--- a/sql/updates/7547_world_vehicle_accessory.sql
+++ b/sql/updates/7547_world_vehicle_accessory.sql
@@ -1,3 +1,4 @@
+DROP TABLE `vehicle_accessory`;
 CREATE TABLE `vehicle_accessory` (
         `entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
         `accessory_entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
@@ -36,4 +37,4 @@ INSERT INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`d
 (35635,35569,0,0, 'Eressea Dawnsinger''s Mount'),
 (35640,35571,0,0, 'Runok Wildmane''s Mount'),
 (35641,35570,0,0, 'Zul''tore''s Mount'),
-(35634,35617,0,0, 'Deathstalker Visceri''s Mount');
\ No newline at end of file
+(35634,35617,0,0, 'Deathstalker Visceri''s Mount');
diff --git a/sql/updates/7551_world_trinity_string.sql b/sql/updates/7551_world_trinity_string.sql
index 3fe54f47dca..153fc4bbcae 100644
--- a/sql/updates/7551_world_trinity_string.sql
+++ b/sql/updates/7551_world_trinity_string.sql
@@ -3,4 +3,4 @@ INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
 (1010, '-[         Account][   Character][             IP][Map][Zone][Exp][GMLev]-'),
 (1012, '-==================================================================-'),
 (1013, '-[%16s][%12s][%15s][%3d][%4d][%d][%d]-'),
-(1015, '-======================== Characters Online =======================-');
\ No newline at end of file
+(1015, '-======================== Characters Online =======================-');
diff --git a/sql/world.sql b/sql/world.sql
index f6c2c6b3976..67f03635b32 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -14893,7 +14893,10 @@ UNLOCK TABLES;
 --
 -- Table structure for table `vehicle_accessory`
 --
+
 DROP TABLE IF EXISTS `vehicle_accessory`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `vehicle_accessory` (
         `entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
         `accessory_entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
@@ -14906,9 +14909,14 @@ COLLATE=utf8_general_ci
 ENGINE=MyISAM
 ROW_FORMAT=FIXED
 AVG_ROW_LENGTH=0;
+/*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Dumping data for table `version`
+--
 
 LOCK TABLES `vehicle_accessory` WRITE;
+/*!40000 ALTER TABLE `vehicle_accessory` ENABLE KEYS */;
 INSERT INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`) VALUES
 (28782,28768,0,0, 'Acherus Deathcharger'),
 (28312,28319,7,1, 'Wintergrasp Siege Engine'),
@@ -14935,6 +14943,7 @@ INSERT INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`d
 (35640,35571,0,0, 'Runok Wildmane''s Mount'),
 (35641,35570,0,0, 'Zul''tore''s Mount'),
 (35634,35617,0,0, 'Deathstalker Visceri''s Mount');
+/*!40000 ALTER TABLE `vehicle_accessory` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `version`