Core/Misc:

Clearing compile errors since UpdateFields were changed:
- Completely remove ammo (Cataclysm change)
- Revert some changes with power/maxpower and only store the 5 needed powers in db (the rest is useless)
- Remove GuildId from corpse
- Move PLAYER_GUILDID to character db (removed updatefield)

Note: Compile is still not working as we need to change currency handling

3 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/characters/2011_11_25_03_characters_character_stats.sql b/sql/updates/characters/2011_11_25_03_characters_character_stats.sql
new file mode 100644
index 00000000000..5f41b6e40db
--- /dev/null
+++ b/sql/updates/characters/2011_11_25_03_characters_character_stats.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `character_stats`
+DROP COLUMN `maxpower6`,
+DROP COLUMN `maxpower7`,
+DROP COLUMN `maxpower8`,
+DROP COLUMN `maxpower9`,
+DROP COLUMN `maxpower10`,
+DROP COLUMN `maxpower11`;
diff --git a/sql/updates/characters/2011_11_25_03_characters_characters.sql b/sql/updates/characters/2011_11_25_03_characters_characters.sql
new file mode 100644
index 00000000000..cede344b6bf
--- /dev/null
+++ b/sql/updates/characters/2011_11_25_03_characters_characters.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `characters`
+DROP COLUMN `power6`,
+DROP COLUMN `power7`,
+DROP COLUMN `power8`,
+DROP COLUMN `power9`,
+DROP COLUMN `power10`,
+DROP COLUMN `power11`,
+DROP COLUMN `ammoId`,
+ADD COLUMN `guildId` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `grantableLevels`;
diff --git a/sql/updates/characters/2011_11_25_03_characters_corpse.sql b/sql/updates/characters/2011_11_25_03_characters_corpse.sql
new file mode 100644
index 00000000000..e1823602b65
--- /dev/null
+++ b/sql/updates/characters/2011_11_25_03_characters_corpse.sql
@@ -0,0 +1 @@
+ALTER TABLE `corpse` DROP COLUMN `guildId`;