6 files changed, 236 insertions, 9 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 0528f355c81..b920bcba8cd 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1232,6 +1232,31 @@ LOCK TABLES `character_spell` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `character_spell_charges`
+--
+
+DROP TABLE IF EXISTS `character_spell_charges`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `character_spell_charges` (
+  `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
+  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier',
+  `rechargeStart` int(10) unsigned NOT NULL DEFAULT '0',
+  `rechargeEnd` int(10) unsigned NOT NULL DEFAULT '0',
+  KEY `idx_guid` (`guid`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `character_spell_charges`
+--
+
+LOCK TABLES `character_spell_charges` WRITE;
+/*!40000 ALTER TABLE `character_spell_charges` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_spell_charges` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `character_spell_cooldown`
 --
 
@@ -1240,7 +1265,7 @@ DROP TABLE IF EXISTS `character_spell_cooldown`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_spell_cooldown` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
-  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
+  `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
   `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
   `time` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`spell`)
@@ -1795,8 +1820,6 @@ CREATE TABLE `guild` (
   `createdate` int(10) unsigned NOT NULL DEFAULT '0',
   `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0',
   `level` int(10) unsigned DEFAULT '1',
-  `experience` bigint(20) unsigned DEFAULT '0',
-  `todayExperience` bigint(20) unsigned DEFAULT '0',
   PRIMARY KEY (`guildid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1932,8 +1955,8 @@ CREATE TABLE `guild_bank_right` (
   `guildid` bigint(20) unsigned NOT NULL DEFAULT '0',
   `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `rid` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `gbright` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `SlotPerDay` int(10) unsigned NOT NULL DEFAULT '0',
+  `gbright` tinyint(3) NOT NULL DEFAULT '0',
+  `SlotPerDay` int(10) NOT NULL DEFAULT '0',
   PRIMARY KEY (`guildid`,`TabId`,`rid`),
   KEY `guildid_key` (`guildid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -2576,6 +2599,31 @@ LOCK TABLES `pet_spell` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `pet_spell_charges`
+--
+
+DROP TABLE IF EXISTS `pet_spell_charges`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `pet_spell_charges` (
+  `guid` int(10) unsigned NOT NULL,
+  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier',
+  `rechargeStart` int(10) unsigned NOT NULL DEFAULT '0',
+  `rechargeEnd` int(10) unsigned NOT NULL DEFAULT '0',
+  KEY `idx_guid` (`guid`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `pet_spell_charges`
+--
+
+LOCK TABLES `pet_spell_charges` WRITE;
+/*!40000 ALTER TABLE `pet_spell_charges` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pet_spell_charges` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `pet_spell_cooldown`
 --
 
@@ -2584,7 +2632,7 @@ DROP TABLE IF EXISTS `pet_spell_cooldown`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `pet_spell_cooldown` (
   `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
-  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
+  `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
   `time` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`spell`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -2610,8 +2658,7 @@ CREATE TABLE `petition` (
   `ownerguid` bigint(20) unsigned NOT NULL,
   `petitionguid` bigint(20) unsigned DEFAULT '0',
   `name` varchar(24) NOT NULL,
-  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`ownerguid`,`type`),
+  PRIMARY KEY (`ownerguid`),
   UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2637,7 +2684,6 @@ CREATE TABLE `petition_sign` (
   `petitionguid` bigint(20) unsigned NOT NULL DEFAULT '0',
   `playerguid` bigint(20) unsigned NOT NULL DEFAULT '0',
   `player_account` int(10) unsigned NOT NULL DEFAULT '0',
-  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`petitionguid`,`playerguid`),
   KEY `Idx_playerguid` (`playerguid`),
   KEY `Idx_ownerguid` (`ownerguid`)
diff --git a/sql/updates/characters/2015_02_13_00_characters.sql b/sql/updates/characters/2015_02_13_00_characters.sql
new file mode 100644
index 00000000000..1ed83e4e762
--- /dev/null
+++ b/sql/updates/characters/2015_02_13_00_characters.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `guild` DROP COLUMN `experience`, DROP COLUMN `todayExperience`;
+
+ALTER TABLE `guild_bank_right` MODIFY COLUMN `gbright` mediumint(3) NOT NULL DEFAULT 0; -- temp type, can hold all values
+UPDATE `guild_bank_right` SET `gbright` = -1 WHERE `gbright` = 255;
+ALTER TABLE `guild_bank_right` MODIFY COLUMN `gbright` tinyint(3) NOT NULL DEFAULT 0;
+
+ALTER TABLE `guild_bank_right` MODIFY COLUMN `SlotPerDay` bigint(10) NOT NULL DEFAULT 0; -- temp type, can hold all values
+UPDATE `guild_bank_right` SET `SlotPerDay` = -1 WHERE `SlotPerDay` = 4294967295;
+ALTER TABLE `guild_bank_right` MODIFY COLUMN `SlotPerDay` int(10) NOT NULL DEFAULT 0;
diff --git a/sql/updates/characters/2015_02_13_01_characters.sql b/sql/updates/characters/2015_02_13_01_characters.sql
new file mode 100644
index 00000000000..52b7a7e4c2a
--- /dev/null
+++ b/sql/updates/characters/2015_02_13_01_characters.sql
@@ -0,0 +1,5 @@
+DELETE FROM `petition` WHERE `type` != 10; -- delete all non guild petitions
+ALTER TABLE `petition` DROP COLUMN `type`, DROP PRIMARY KEY, ADD PRIMARY KEY (`ownerguid`);
+
+DELETE FROM `petition_sign` WHERE `type` != 10; -- delete all non guild petition signs
+ALTER TABLE `petition_sign` DROP COLUMN `type`;
diff --git a/sql/updates/characters/2015_02_17_00_characters.sql b/sql/updates/characters/2015_02_17_00_characters.sql
new file mode 100644
index 00000000000..ebf539c9a40
--- /dev/null
+++ b/sql/updates/characters/2015_02_17_00_characters.sql
@@ -0,0 +1,28 @@
+--
+-- Table structure for table `character_spell_charges`
+--
+
+DROP TABLE IF EXISTS `character_spell_charges`;
+CREATE TABLE `character_spell_charges` (
+  `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
+  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier',
+  `rechargeStart` int(10) unsigned NOT NULL DEFAULT '0',
+  `rechargeEnd` int(10) unsigned NOT NULL DEFAULT '0',
+  KEY `idx_guid` (`guid`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `pet_spell_charges`
+--
+
+DROP TABLE IF EXISTS `pet_spell_charges`;
+CREATE TABLE `pet_spell_charges` (
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
+  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier',
+  `rechargeStart` int(10) unsigned NOT NULL DEFAULT '0',
+  `rechargeEnd` int(10) unsigned NOT NULL DEFAULT '0',
+  KEY `idx_guid` (`guid`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+ALTER TABLE `character_spell_cooldown` CHANGE `spell` `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier';
+ALTER TABLE `pet_spell_cooldown` CHANGE `spell` `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier';
diff --git a/sql/updates/world/2015_02_13_00_world.sql b/sql/updates/world/2015_02_13_00_world.sql
new file mode 100644
index 00000000000..f510682f090
--- /dev/null
+++ b/sql/updates/world/2015_02_13_00_world.sql
@@ -0,0 +1,135 @@
+DROP TABLE IF EXISTS `guild_xp_for_level`;
+
+ALTER TABLE `guild_rewards` CHANGE COLUMN `entry` `ItemID` mediumint(8) UNSIGNED NOT NULL DEFAULT 0;
+ALTER TABLE `guild_rewards` CHANGE COLUMN `standing` `MinGuildRep` tinyint(3) UNSIGNED NULL DEFAULT 0;
+ALTER TABLE `guild_rewards` CHANGE COLUMN `racemask` `RaceMask` int(11) NULL DEFAULT 0;
+ALTER TABLE `guild_rewards` CHANGE COLUMN `price` `Cost` bigint(20) UNSIGNED NULL DEFAULT 0;
+ALTER TABLE `guild_rewards` DROP COLUMN `achievement`;
+
+TRUNCATE TABLE `guild_rewards`;
+INSERT IGNORE INTO `guild_rewards` (`ItemID`, `MinGuildRep`, `RaceMask`, `Cost`) VALUES
+(89194, 5, -1, 1500000),
+(89195, 7, -1, 2000000),
+(114968, 6, 0, 3000000),
+(116666, 7, -1, 40000000),
+(63206, 5, 18875469, 3000000),
+(63207, 5, 33555378, 3000000),
+(65435, 5, 0, 1500000),
+(85666, 7, -1, 30000000),
+(67107, 7, 33555378, 15000000),
+(69887, 4, 0, 15000000),
+(69888, 5, -1, 17500000),
+(69892, 4, 0, 12000000),
+(71033, 7, 0, 15000000),
+(65498, 5, 0, 1500000),
+(120352, 7, 0, 1000000),
+(64398, 5, 18875469, 2000000),
+(64399, 5, 18875469, 3000000),
+(64400, 5, 33555378, 1500000),
+(64401, 5, 33555378, 2000000),
+(64402, 5, 33555378, 3000000),
+(61931, 4, 0, 15000000),
+(61935, 4, 0, 15000000),
+(61936, 4, 0, 15000000),
+(61937, 4, 0, 15000000),
+(61942, 4, 0, 15000000),
+(65274, 6, 33555378, 5000000),
+(61958, 4, 0, 15000000),
+(85508, 5, -1, 1000000),
+(85509, 5, -1, 1000000),
+(85510, 5, -1, 1000000),
+(63352, 5, 18875469, 1500000),
+(63353, 5, 33555378, 1500000),
+(62799, 5, 0, 1500000),
+(62800, 5, 0, 1500000),
+(63359, 5, 18875469, 1500000),
+(69209, 4, -1, 1250000),
+(69210, 5, -1, 2500000),
+(62286, 4, 0, 100000000),
+(62287, 6, 33555378, 200000000),
+(63398, 6, 0, 3000000),
+(63125, 7, 0, 30000000),
+(62298, 7, 18875469, 15000000),
+(62023, 5, -1, 17500000),
+(62024, 5, -1, 17500000),
+(62025, 5, -1, 17500000),
+(62026, 5, -1, 17500000),
+(62027, 5, -1, 17500000),
+(62029, 5, -1, 17500000),
+(63138, 7, -1, 3000000),
+(65360, 6, 18875469, 5000000),
+(65361, 5, 18875469, 3000000),
+(62038, 4, 0, 12000000),
+(65362, 5, 33555378, 3000000),
+(62039, 4, 0, 12000000),
+(65363, 6, 18875469, 5000000),
+(62040, 4, 0, 12000000),
+(65364, 6, 33555378, 5000000),
+(68136, 6, 18875469, 200000000),
+(89190, 5, -1, 1500000),
+(89191, 7, -1, 2000000),
+(89192, 5, -1, 1500000),
+(89193, 7, -1, 2000000);
+
+DROP TABLE IF EXISTS `guild_rewards_req_achievements`;
+CREATE TABLE `guild_rewards_req_achievements` (
+  `ItemID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `AchievementRequired` mediumint(8) unsigned DEFAULT '0',
+  PRIMARY KEY (`ItemID`,`AchievementRequired`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT IGNORE INTO `guild_rewards_req_achievements` (`ItemID`, `AchievementRequired`) VALUES
+(89194, 6681),
+(89190, 6681),
+(89192, 6681),
+(89191, 6644),
+(89191, 6664),
+(89193, 6644),
+(89193, 6664),
+(89195, 6644),
+(89195, 6664),
+(114968, 9651),
+(116666, 9669),
+(65435, 5465),
+(85666, 6682),
+(69888, 6626),
+(62023, 6626),
+(62024, 6626),
+(62025, 6626),
+(62026, 6626),
+(62027, 6626),
+(62029, 6626),
+(71033, 5840),
+(65498, 5024),
+(120352, 9388),
+(64398, 5143),
+(64401, 5143),
+(64399, 5422),
+(64402, 5422),
+(64400, 4860),
+(63359, 4860),
+(65274, 5035),
+(65360, 5035),
+(85508, 7448),
+(85509, 7448),
+(85510, 7448),
+(85508, 7449),
+(85509, 7449),
+(85510, 7449),
+(63352, 4989),
+(63353, 4989),
+(62799, 5467),
+(62800, 5036),
+(62286, 5196),
+(62287, 5158),
+(62287, 4949),
+(68136, 5152),
+(68136, 4949),
+(65361, 5031),
+(65362, 5179),
+(65363, 5201),
+(65364, 5201),
+(63398, 5144),
+(63125, 4988),
+(63138, 5812),
+(63138, 5892);
diff --git a/sql/updates/world/2015_02_18_00_world.sql b/sql/updates/world/2015_02_18_00_world.sql
new file mode 100644
index 00000000000..6a4c12347a3
--- /dev/null
+++ b/sql/updates/world/2015_02_18_00_world.sql
@@ -0,0 +1,4 @@
+-- 
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND  `SourceGroup`=1 AND `SourceEntry`=52654;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
+(13, 1, 52654, 0, 0, 31, 0, 3, 28823, 0, 0, 0, 0, '', 'Temper only target Volkhan\'s Anvil');