From 8ac05aff2dc2adf94604bc5ce94d489c7311693d Mon Sep 17 00:00:00 2001
From: Nay <dnpd.dd@gmail.com>
Date: Sun, 30 Sep 2012 15:43:05 +0100
Subject: SQL: Rename SQL merged in PR

---
 ..._09_27_01_world_player_factionchange_titles.sql | 32 ----------------------
 ..._09_30_01_world_player_factionchange_titles.sql | 32 ++++++++++++++++++++++
 2 files changed, 32 insertions(+), 32 deletions(-)
 delete mode 100644 sql/updates/world/2012_09_27_01_world_player_factionchange_titles.sql
 create mode 100644 sql/updates/world/2012_09_30_01_world_player_factionchange_titles.sql

(limited to 'sql')

diff --git a/sql/updates/world/2012_09_27_01_world_player_factionchange_titles.sql b/sql/updates/world/2012_09_27_01_world_player_factionchange_titles.sql
deleted file mode 100644
index 99d7fc871d8..00000000000
--- a/sql/updates/world/2012_09_27_01_world_player_factionchange_titles.sql
+++ /dev/null
@@ -1,32 +0,0 @@
--- Title converter
-DROP TABLE IF EXISTS `player_factionchange_titles`;
-CREATE TABLE `player_factionchange_titles` (
- `alliance_id` int(8) NOT NULL,
- `horde_id` int(8) NOT NULL,
- PRIMARY KEY (`alliance_id`,`horde_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-DELETE FROM `player_factionchange_titles` WHERE `alliance_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,48,75,113,126,146,147,148,149);
-INSERT INTO `player_factionchange_titles` (`alliance_id`,`horde_id`) VALUES
-(1, 15),
-(2, 16),
-(3, 17),
-(4, 18),
-(5, 19),
-(6, 20),
-(7, 21),
-(8, 22),
-(9, 23),
-(10, 24),
-(11, 25),
-(12, 26),
-(13, 27),
-(14, 28),
-(48, 47),
-(75, 76),
-(113, 153),
-(126, 127),
-(146, 152),
-(147, 154),
-(148, 151),
-(149, 150);
diff --git a/sql/updates/world/2012_09_30_01_world_player_factionchange_titles.sql b/sql/updates/world/2012_09_30_01_world_player_factionchange_titles.sql
new file mode 100644
index 00000000000..99d7fc871d8
--- /dev/null
+++ b/sql/updates/world/2012_09_30_01_world_player_factionchange_titles.sql
@@ -0,0 +1,32 @@
+-- Title converter
+DROP TABLE IF EXISTS `player_factionchange_titles`;
+CREATE TABLE `player_factionchange_titles` (
+ `alliance_id` int(8) NOT NULL,
+ `horde_id` int(8) NOT NULL,
+ PRIMARY KEY (`alliance_id`,`horde_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DELETE FROM `player_factionchange_titles` WHERE `alliance_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,48,75,113,126,146,147,148,149);
+INSERT INTO `player_factionchange_titles` (`alliance_id`,`horde_id`) VALUES
+(1, 15),
+(2, 16),
+(3, 17),
+(4, 18),
+(5, 19),
+(6, 20),
+(7, 21),
+(8, 22),
+(9, 23),
+(10, 24),
+(11, 25),
+(12, 26),
+(13, 27),
+(14, 28),
+(48, 47),
+(75, 76),
+(113, 153),
+(126, 127),
+(146, 152),
+(147, 154),
+(148, 151),
+(149, 150);
-- 
cgit v1.2.3