From accae0ce5037db08bfed13831c57bffe8f9f01e9 Mon Sep 17 00:00:00 2001 From: Nay Date: Sat, 29 Oct 2011 00:20:56 +0100 Subject: TDB 335.11.43 Move SQL updates to the directory old. --- .../2011_09_05_00_characters_character_quest_status.sql | 1 - sql/updates/characters/2011_09_28_00_characters_characters.sql | 9 --------- .../characters/2011_10_09_00_characters_character_aura.sql | 1 - 3 files changed, 11 deletions(-) delete mode 100644 sql/updates/characters/2011_09_05_00_characters_character_quest_status.sql delete mode 100644 sql/updates/characters/2011_09_28_00_characters_characters.sql delete mode 100644 sql/updates/characters/2011_10_09_00_characters_character_aura.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/2011_09_05_00_characters_character_quest_status.sql b/sql/updates/characters/2011_09_05_00_characters_character_quest_status.sql deleted file mode 100644 index 08ee801c9d1..00000000000 --- a/sql/updates/characters/2011_09_05_00_characters_character_quest_status.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `character_queststatus` ADD `playercount` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'; diff --git a/sql/updates/characters/2011_09_28_00_characters_characters.sql b/sql/updates/characters/2011_09_28_00_characters_characters.sql deleted file mode 100644 index 800afc60622..00000000000 --- a/sql/updates/characters/2011_09_28_00_characters_characters.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Replaces MATRON with PATRON title on MALE char. -UPDATE characters SET knownTitles = CONCAT( -SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 1), ' ', -1), ' ', -SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 2), ' ', -1), ' ', -SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 3), ' ', -1), ' ', -(SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 4), ' ', -1) | 512) &~256, ' ', -SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 5), ' ', -1), ' ', -SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 6), ' ', -1)) -WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 4), ' ', -1) & 256 AND gender = 0; diff --git a/sql/updates/characters/2011_10_09_00_characters_character_aura.sql b/sql/updates/characters/2011_10_09_00_characters_character_aura.sql deleted file mode 100644 index a8223fa06d6..00000000000 --- a/sql/updates/characters/2011_10_09_00_characters_character_aura.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `character_aura` WHERE `spell` = 73001; -- cgit v1.2.3