From 477e58f32137cbede732998f24fed96ca43fd0fa Mon Sep 17 00:00:00 2001
From: teacher <none@none>
Date: Sat, 12 Dec 2009 15:27:10 +0100
Subject: Renamed sql update files to proper Trinity naming standard. Moved
 files prior to 6381_world_script_texts.sql to 3.1.3_old folder.

--HG--
branch : trunk
---
 sql/updates/5860_characters.sql | 6 ------
 1 file changed, 6 deletions(-)
 delete mode 100644 sql/updates/5860_characters.sql

(limited to 'sql/updates/5860_characters.sql')

diff --git a/sql/updates/5860_characters.sql b/sql/updates/5860_characters.sql
deleted file mode 100644
index c8927604025..00000000000
--- a/sql/updates/5860_characters.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- Remove watch flag (1) from characters that are watching a faction from the opposing team
--- since r5857, these factions will no longer be flagged for watching if they are from the opposing team
--- all we need to do is clean up the data from when it was still bugged.
--- NOTE: running this may take a while depending on the size of your character database
-UPDATE `character_reputation` SET `flags` = `flags` &~ 1 WHERE `guid` IN (SELECT `guid` from `characters` WHERE `race` IN(3,7,1,4,11)) AND `faction` IN(1052,1067,1124,947);
-UPDATE `character_reputation` SET `flags` = `flags` &~ 1 WHERE `guid` IN (SELECT `guid` from `characters` WHERE `race` IN(2,6,8,5,10)) AND `faction` IN(1126,946,978);
-- 
cgit v1.2.3

