diff options
| -rw-r--r-- | sql/updates/world/2012_09_09_05_world_guild_rewards_434.sql | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/sql/updates/world/2012_09_09_05_world_guild_rewards_434.sql b/sql/updates/world/2012_09_09_05_world_guild_rewards_434.sql index e69de29bb2d..b05b9d959c7 100644 --- a/sql/updates/world/2012_09_09_05_world_guild_rewards_434.sql +++ b/sql/updates/world/2012_09_09_05_world_guild_rewards_434.sql @@ -0,0 +1,53 @@ +DROP TABLE IF EXISTS `guild_rewards`; +CREATE TABLE `guild_rewards` ( + `entry` int(10) unsigned NOT NULL DEFAULT '0', + `standing` tinyint(3) unsigned DEFAULT '0', + `racemask` int(11) DEFAULT '0', + `price` bigint(20) unsigned DEFAULT '0', + `achievement` int(10) unsigned DEFAULT '0', + PRIMARY KEY (`entry`) +) engine=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `guild_rewards` values +(69209, 4, -1, 1250000, 0), +(69210, 5, -1, 2500000, 0), +(63353, 5, 946, 1500000, 4989), +(63352, 5, 2098253, 1500000, 4989), +(63207, 5, 946, 3000000, 4945), +(63206, 5, 2098253, 3000000, 4945), +(65274, 6, 946, 5000000, 5035), +(65360, 6, 2098253, 5000000, 5035), +(65362, 5, 946, 3000000, 5179), +(65364, 6, 946, 5000000, 5201), +(65361, 5, 2098253, 3000000, 5031), +(65363, 6, 2098253, 5000000, 5201), +(63138, 7, -1, 3000000, 5812), +(63398, 6, 0, 3000000, 5144), +(63359, 5, 2098253, 1500000, 4860), +(64398, 5, 2098253, 2000000, 5143), +(64399, 5, 2098253, 3000000, 5422), +(64400, 5, 946, 1500000, 4860), +(64401, 5, 946, 2000000, 5143), +(64402, 5, 946, 3000000, 5422), +(62800, 5, 0, 1500000, 5036), +(62799, 5, 0, 1500000, 5467), +(65435, 5, 0, 1500000, 5465), +(65498, 5, 0, 1500000, 5024), +(62286, 4, 0, 100000000, 4943), +(68136, 6, 2098253, 200000000, 5152), +(62287, 6, 946, 200000000, 5158), +(69892, 5, 0, 12000000, 4944), +(62038, 5, 0, 12000000, 4944), +(62039, 5, 0, 12000000, 4944), +(62040, 5, 0, 12000000, 4944), +(69887, 5, 0, 15000000, 4946), +(61958, 5, 0, 15000000, 4946), +(61942, 5, 0, 15000000, 4946), +(61937, 5, 0, 15000000, 4946), +(61936, 5, 0, 15000000, 4946), +(61935, 5, 0, 15000000, 4946), +(61931, 5, 0, 15000000, 4946), +(67107, 7, 946, 15000000, 5492), +(62298, 7, 2098253, 15000000, 4912), +(63125, 7, 0, 30000000, 4988), +(71033, 7, 0, 15000000, 5840); |