Added support for removing blizz items from character creation info by adding entry to playercreateinfo_item with count -1

Added support for all class/all race in playercreateinfo_item by setting class/race to 0 (like currently playercreateinfo_spell)

--HG--
branch : trunk

2 files changed, 2 insertions, 1 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 5cf85d68cab..4ef57d79fdd 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -4105,7 +4105,7 @@ CREATE TABLE `playercreateinfo_item` (
   `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `itemid` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `amount` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `amount` tinyint(3) NOT NULL DEFAULT '1',
   KEY `playercreateinfo_race_class_index` (`race`,`class`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/8605_world_playercreateinfo_item.sql b/sql/updates/8605_world_playercreateinfo_item.sql
new file mode 100644
index 00000000000..c5d423c1744
--- /dev/null
+++ b/sql/updates/8605_world_playercreateinfo_item.sql
@@ -0,0 +1 @@
+ALTER TABLE `playercreateinfo_item` CHANGE `amount` `amount` tinyint(3) NOT NULL DEFAULT '1';