jvdfF8MF

1/*
2entry_1_character_guid
3entry_3_item_guid
4entry_4_guild_id
5entry_5_pet_guid
6entry_7_mail_id
7entry_9_equipmentset_id
8entry_12_auction_id
9entry_13_voidstorage_id
10entry_14_garrison_id
11entry_15_garrison_building_id
12entry_16_garrison_follower_id
13entry_17_garrison_mission_id
14entry_18_garrison_workorder_id
15entry_19_petition_guid
16entry_20_instance_id
17entry_21_encounter_atempt_id
18entry_22_group_guid
19entry_23_ticket_id
20entry_24_corpse_guid
21entry_25_challenge_id
22entry_26_calendar_invites_id
23entry_27_calendar_events_id
24*/
25
26CREATE TABLE IF NOT EXISTS `max_values` (
27  `entry_1_character_guid` int(10) unsigned NOT NULL DEFAULT '0',
28  `entry_3_item_guid` int(10) unsigned NOT NULL DEFAULT '0',
29  `entry_4_guild_id` int(10) unsigned NOT NULL DEFAULT '0',
30  `entry_5_pet_guid` int(10) unsigned NOT NULL DEFAULT '0',
31  `entry_7_mail_id` int(10) unsigned NOT NULL DEFAULT '0',
32  `entry_9_equipmentset_id` int(10) unsigned NOT NULL DEFAULT '0',
33  `entry_12_auction_id` int(10) unsigned NOT NULL DEFAULT '0',
34  `entry_13_voidstorage_id` int(10) unsigned NOT NULL DEFAULT '0',
35  `entry_14_garrison_id` int(10) unsigned NOT NULL DEFAULT '0',
36  `entry_15_garrison_building_id` int(10) unsigned NOT NULL DEFAULT '0',
37  `entry_16_garrison_follower_id` int(10) unsigned NOT NULL DEFAULT '0',
38  `entry_17_garrison_mission_id` int(10) unsigned NOT NULL DEFAULT '0',
39  `entry_18_garrison_workorder_id` int(10) unsigned NOT NULL DEFAULT '0',
40  `entry_19_petition_guid` int(10) unsigned NOT NULL DEFAULT '0',
41  `entry_20_instance_id` int(10) unsigned NOT NULL DEFAULT '0',
42  `entry_21_encounter_atempt_id` int(10) unsigned NOT NULL DEFAULT '0',
43  `entry_22_group_guid` int(10) unsigned NOT NULL DEFAULT '0',
44  `entry_23_ticket_id` int(10) unsigned NOT NULL DEFAULT '0',
45  `entry_24_corpse_guid` int(10) unsigned NOT NULL DEFAULT '0',
46  `entry_25_challenge_id` int(10) unsigned NOT NULL DEFAULT '0',
47  `entry_26_calendar_invites_id` int(10) unsigned NOT NULL DEFAULT '0',
48  `entry_27_calendar_events_id` int(10) unsigned NOT NULL DEFAULT '0'
49) ENGINE=MyISAM;
50
51-- Fill values
52DELETE FROM `max_values`;
53INSERT INTO `max_values` 
54(`entry_1_character_guid`, `entry_3_item_guid`, `entry_4_guild_id`, `entry_5_pet_guid`, `entry_7_mail_id`, `entry_9_equipmentset_id`,
55`entry_12_auction_id`, `entry_13_voidstorage_id`, `entry_14_garrison_id`, `entry_15_garrison_building_id`, `entry_16_garrison_follower_id`, `entry_17_garrison_mission_id`,
56`entry_18_garrison_workorder_id`, `entry_19_petition_guid`, `entry_20_instance_id`, 
57`entry_21_encounter_atempt_id`, `entry_22_group_guid`, `entry_23_ticket_id`, `entry_24_corpse_guid`,
58`entry_25_challenge_id`, `entry_26_calendar_invites_id`, `entry_27_calendar_events_id`) 
59SELECT * FROM 
60(
61(SELECT IFNULL(max(guid), 0) FROM characters) entry_1_character_guid,
62(SELECT IFNULL(max(guid), 0) FROM item_instance) entry_3_item_guid,
63(SELECT IFNULL(max(guildid), 0) FROM guild) entry_4_guild_id,
64(SELECT IFNULL(max(id), 0) FROM character_pet) entry_5_pet_guid,
65(SELECT IFNULL(max(id), 0) FROM mail) entry_7_mail_id,
66(SELECT IFNULL(max(setguid), 0) FROM character_equipmentsets) entry_9_equipmentset_id,
67(SELECT IFNULL(max(id), 0) FROM auctionhouse) entry_12_auction_id,
68(SELECT IFNULL(max(itemId), 0) FROM character_void_storage) entry_13_voidstorage_id,
69(SELECT IFNULL(max(id), 0) FROM character_garrison) entry_14_garrison_id,
70(SELECT IFNULL(max(id), 0) FROM character_garrison_draenor_building) entry_15_garrison_building_id,
71(SELECT IFNULL(max(id), 0) FROM character_garrison_follower) entry_16_garrison_follower_id,
72(SELECT IFNULL(max(id), 0) FROM character_garrison_mission) entry_17_garrison_mission_id,
73(SELECT IFNULL(max(id), 0) FROM character_garrison_work_order) entry_18_garrison_workorder_id,
74(SELECT IFNULL(max(petitionguid), 0) FROM petition) entry_19_petition_guid,
75(SELECT IFNULL(max(id), 0) FROM instance) entry_20_instance_id,
76(SELECT IFNULL(max(attemptid), 0) FROM guild_encounter_data) entry_21_encounter_atempt_id,
77(SELECT IFNULL(max(guid), 0) FROM groups) entry_22_group_guid,
78(SELECT IFNULL(max(ticketId), 0) FROM gm_tickets) entry_23_ticket_id,
79(SELECT IFNULL(max(corpseGuid), 0) FROM corpse) entry_24_corpse_guid,
80(SELECT IFNULL(max(id), 0) FROM challenge) entry_25_challenge_id,
81(SELECT IFNULL(max(id), 0) FROM calendar_invites) entry_26_calendar_invites_id,
82(SELECT IFNULL(max(id), 0) FROM calendar_events) entry_27_calendar_events_id
83);
84
85-- Auction
86UPDATE auctionhouse SET id = id + (SELECT MAX(entry_12_auction_id) FROM `max_values`);
87UPDATE auctionhouse SET itemguid = itemguid + (SELECT MAX(entry_3_item_guid) FROM `max_values`);
88UPDATE auctionhouse SET itemowner = itemowner + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
89UPDATE auctionhouse SET buyguid = CASE buyguid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (buyguid + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END;
90
91-- Calendar
92UPDATE calendar_events SET 
93  id = id + (SELECT MAX(entry_27_calendar_events_id) FROM `max_values`),
94  creator = CASE creator WHEN null THEN (null) WHEN 0 THEN (0) ELSE (creator + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END;
95UPDATE calendar_invites SET 
96  id = id + (SELECT MAX(entry_26_calendar_invites_id) FROM `max_values`),
97  invitee = CASE invitee WHEN null THEN (null) WHEN 0 THEN (0) ELSE (invitee + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END,
98  sender = CASE sender WHEN null THEN (null) WHEN 0 THEN (0) ELSE (sender + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END;
99
100-- Challenge
101UPDATE challenge SET 
102  id = id + (SELECT MAX(entry_25_challenge_id) FROM `max_values`),
103  guildId = CASE guildId WHEN null THEN (null) WHEN 0 THEN (0) ELSE (guildId + (SELECT MAX(entry_4_guild_id) FROM `max_values`)) END;
104UPDATE challenge_member SET 
105  id = id + (SELECT MAX(entry_25_challenge_id) FROM `max_values`),
106  member = member + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
107UPDATE challenge_oplote_loot SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
108
109-- Character
110UPDATE characters SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
111UPDATE characters_boss_looted SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
112UPDATE character_account_data SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
113UPDATE character_achievement SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
114UPDATE character_achievement_count SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
115UPDATE character_achievement_progress SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
116UPDATE character_action SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
117UPDATE character_archaeology SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
118UPDATE character_archaeology_projects SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
119UPDATE character_archaeology_sites SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
120UPDATE character_arena_stats SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
121UPDATE character_artifact SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
122UPDATE character_artifact_bug SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
123UPDATE character_artifact_powers SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
124UPDATE character_aura SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
125UPDATE character_aura_effect SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
126UPDATE character_banned SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
127UPDATE character_battleground_data SET 
128  guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`),
129  instanceId = CASE instanceId WHEN null THEN (null) WHEN 0 THEN (0) ELSE (instanceId + (SELECT MAX(entry_20_instance_id) FROM `max_values`)) END;
130UPDATE character_battleground_data SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
131UPDATE character_battleground_random SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
132UPDATE character_boris SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
133UPDATE character_bracket_data SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
134UPDATE character_chest_timed_lockout SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
135UPDATE character_completed_challenges SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
136UPDATE character_currency SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
137UPDATE character_currency_caps SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
138UPDATE character_daily_loot_cooldown SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
139UPDATE character_declinedname SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
140UPDATE character_equipmentsets SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`),
141setguid = setguid + (SELECT MAX(entry_9_equipmentset_id) FROM `max_values`),
142item0 = CASE item0 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item0 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
143item1 = CASE item1 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item1 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
144item2 = CASE item2 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item2 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
145item3 = CASE item3 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item3 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
146item4 = CASE item4 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item4 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
147item5 = CASE item5 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item5 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
148item6 = CASE item6 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item6 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
149item7 = CASE item7 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item7 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
150item8 = CASE item8 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item8 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
151item9 = CASE item9 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item9 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
152item10 = CASE item10 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item10 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
153item11 = CASE item11 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item11 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
154item12 = CASE item12 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item12 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
155item13 = CASE item13 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item13 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
156item14 = CASE item14 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item14 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
157item15 = CASE item15 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item15 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
158item16 = CASE item16 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item16 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
159item17 = CASE item17 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item17 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END,
160item18 = CASE item18 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (item18 + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END;
161UPDATE character_garrison SET 
162  id = id + (SELECT MAX(entry_14_garrison_id) FROM max_values), 
163  character_guid = character_guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
164UPDATE character_garrison_broken_isles SET id = id + (SELECT MAX(entry_14_garrison_id) FROM max_values);
165UPDATE character_garrison_draenor SET id = id + (SELECT MAX(entry_14_garrison_id) FROM max_values);
166UPDATE character_garrison_draenor_building SET 
167  id = id + (SELECT MAX(entry_15_garrison_building_id) FROM max_values), 
168  garrison_id = garrison_id + (SELECT MAX(entry_14_garrison_id) FROM `max_values`), 
169  follower_assigned = CASE follower_assigned WHEN null THEN (null) WHEN 0 THEN (0) ELSE (follower_assigned + (SELECT MAX(entry_16_garrison_follower_id) FROM max_values)) END;
170UPDATE character_garrison_draenor_daily_tavern_data SET CharacterGuid = CharacterGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
171UPDATE character_garrison_draenor_weekly_tavern_data SET CharacterGuid = CharacterGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
172UPDATE character_garrison_follower SET 
173  id = id + (SELECT MAX(entry_16_garrison_follower_id) FROM max_values), 
174  garrison_id = garrison_id + (SELECT MAX(entry_14_garrison_id) FROM `max_values`);
175UPDATE character_garrison_mission SET 
176  id = id + (SELECT MAX(entry_17_garrison_mission_id) FROM max_values), 
177  garrison_id = garrison_id + (SELECT MAX(entry_14_garrison_id) FROM `max_values`);
178UPDATE character_garrison_talent SET garrison_id = garrison_id + (SELECT MAX(entry_14_garrison_id) FROM `max_values`);
179UPDATE character_garrison_work_order SET 
180  id = id + (SELECT MAX(entry_18_garrison_workorder_id) FROM `max_values`),
181  garrison_id = garrison_id + (SELECT MAX(entry_14_garrison_id) FROM `max_values`);
182UPDATE character_gifts SET 
183  guid = guid + (SELECT MAX(entry_1_character_guid)FROM `max_values`), 
184  item_guid = item_guid + (SELECT MAX(entry_3_item_guid)FROM `max_values`);
185UPDATE character_glyphs SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
186UPDATE character_homebind SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
187UPDATE character_instance SET 
188  guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`), 
189  instance = CASE instance WHEN null THEN (null) WHEN 0 THEN (0) ELSE (instance + (SELECT MAX(entry_20_instance_id) FROM `max_values`)) END;
190UPDATE character_inventory SET 
191  guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`), 
192  bag = CASE bag WHEN null THEN (null) WHEN 0 THEN (0) ELSE (bag + (SELECT MAX(entry_3_item_guid) FROM `max_values`)) END, 
193  item = item +(SELECT MAX(entry_3_item_guid) FROM `max_values`);
194UPDATE character_legendaries SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
195UPDATE character_lf_guild_params SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
196UPDATE character_nomi_recipes SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
197UPDATE character_personal_instance_lockout SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
198UPDATE character_pet SET 
199  id = id + (SELECT MAX(entry_5_pet_guid) FROM `max_values`), 
200  `owner` = `owner` + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
201UPDATE character_pet_declinedname SET 
202  id = id + (SELECT MAX(entry_5_pet_guid) FROM `max_values`), 
203  `owner` = `owner` + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
204UPDATE character_playerchoice_response_rewarded SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
205UPDATE character_pvp_info SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
206UPDATE character_pvp_season_reward_ranking SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
207UPDATE character_pvp_talent SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
208UPDATE character_queststatus SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
209UPDATE character_queststatus_daily SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
210UPDATE character_queststatus_monthly SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
211UPDATE character_queststatus_objective SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
212UPDATE character_queststatus_rewarded SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
213UPDATE character_queststatus_seasonal SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
214UPDATE character_queststatus_weekly SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
215UPDATE character_rates SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
216UPDATE character_reputation SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
217UPDATE character_sell_data SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
218UPDATE character_skills SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
219UPDATE character_spell SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
220UPDATE character_spell_charges SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
221UPDATE character_spell_cooldown SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
222UPDATE character_stats SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
223UPDATE character_stats_wod SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
224UPDATE character_talent SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
225UPDATE character_void_storage SET itemId = itemId + (SELECT MAX(entry_13_voidstorage_id) FROM `max_values`);
226UPDATE character_void_storage SET playerGuid = playerGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
227UPDATE character_void_storage SET creatorGuid = creatorGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
228UPDATE character_worldstates SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
229UPDATE character_world_quest_rewards SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
230
231UPDATE corpse SET 
232  corpseGuid = corpseGuid + (SELECT MAX(entry_24_corpse_guid) FROM `max_values`),
233  guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`),
234  instanceId = CASE instanceId WHEN null THEN (null) WHEN 0 THEN (0) ELSE (instanceId + (SELECT MAX(entry_20_instance_id) FROM `max_values`)) END;
235
236UPDATE creature_respawn SET instanceid = CASE instanceid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (instanceid + (SELECT MAX(entry_20_instance_id) FROM `max_values`)) END;
237
238UPDATE cuf_profile SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
239
240UPDATE daily_players_reports SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
241
242UPDATE encounter_damage_log SET attackerGuid = attackerGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
243
244UPDATE gameobject_respawn SET instanceid = CASE instanceid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (instanceid + (SELECT MAX(entry_20_instance_id) FROM `max_values`)) END;
245
246-- Gm
247UPDATE gm_tickets SET 
248  ticketId = ticketId + (SELECT MAX(entry_23_ticket_id) FROM `max_values`),
249  guid = guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`);
250
251-- Group
252UPDATE groups SET 
253  guid = guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`),
254  leaderGuid = leaderGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`),
255  looterGuid = CASE looterGuid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (looterGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END;
256UPDATE group_completed_challenges SET 
257  attempt_id = attempt_id + (SELECT MAX(entry_21_encounter_atempt_id) FROM `max_values`),
258  group_1_guid = CASE group_1_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (group_1_guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`)) END,
259  group_2_guid = CASE group_2_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (group_2_guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`)) END,
260  group_3_guid = CASE group_3_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (group_3_guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`)) END,
261  group_4_guid = CASE group_4_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (group_4_guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`)) END,
262  group_5_guid = CASE group_5_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (group_5_guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`)) END;
263UPDATE group_instance SET 
264  guid = guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`),
265  instance = CASE instance WHEN null THEN (null) WHEN 0 THEN (0) ELSE (instance + (SELECT MAX(entry_20_instance_id) FROM `max_values`)) END;
266UPDATE group_member SET 
267  guid = guid + (SELECT MAX(entry_22_group_guid) FROM `max_values`),
268  memberGuid = memberGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
269
270-- Guild
271UPDATE guild SET 
272  guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`),
273  leaderguid = leaderguid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
274UPDATE guild_achievement SET guildId = guildId + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
275UPDATE guild_achievement_progress SET guildId = guildId + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
276UPDATE guild_bank_eventlog SET 
277  guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`),
278  playerGuid = playerGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
279UPDATE guild_bank_item SET 
280  guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`),
281  item_guid = item_guid + (SELECT MAX(entry_3_item_guid) FROM `max_values`);
282UPDATE guild_bank_right SET guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
283UPDATE guild_bank_tab SET guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
284UPDATE guild_challenges SET guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
285UPDATE guild_completed_challenges SET 
286  guild_id = guild_id + (SELECT MAX(entry_4_guild_id) FROM `max_values`),
287  attempt_id = attempt_id + (SELECT MAX(entry_21_encounter_atempt_id) FROM `max_values`),
288  guild_1_guid = CASE guild_1_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (guild_1_guid + (SELECT MAX(entry_4_guild_id) FROM `max_values`)) END,
289  guild_2_guid = CASE guild_2_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (guild_2_guid + (SELECT MAX(entry_4_guild_id) FROM `max_values`)) END,
290  guild_3_guid = CASE guild_3_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (guild_3_guid + (SELECT MAX(entry_4_guild_id) FROM `max_values`)) END,
291  guild_4_guid = CASE guild_4_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (guild_4_guid + (SELECT MAX(entry_4_guild_id) FROM `max_values`)) END;
292UPDATE guild_encounter_data SET 
293  AttemptId = AttemptId + (SELECT MAX(entry_21_encounter_atempt_id) FROM `max_values`),
294  guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
295UPDATE guild_encounter_roster SET 
296  AttemptId = AttemptId + (SELECT MAX(entry_21_encounter_atempt_id) FROM `max_values`),
297  GuidLow = GuidLow + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
298UPDATE guild_eventlog SET 
299  guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`),
300  playerGuid1 = CASE playerGuid1 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (playerGuid1 + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END,
301  playerGuid2 = CASE playerGuid2 WHEN null THEN (null) WHEN 0 THEN (0) ELSE (playerGuid2 + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END;
302UPDATE guild_finder_applicant SET 
303  guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`), 
304  playerGuid = playerGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
305UPDATE guild_finder_guild_settings SET guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
306UPDATE guild_member SET 
307  guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`), 
308  guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
309UPDATE guild_news_log SET 
310  guild = guild + (SELECT MAX(entry_4_guild_id) FROM `max_values`),
311  playerGuid = CASE playerGuid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (playerGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END;
312UPDATE guild_rank SET guildid = guildid + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
313
314
315-- Instance
316UPDATE instance SET id = id + (SELECT MAX(entry_20_instance_id) FROM `max_values`);
317UPDATE instance_gameobject_looted SET instanceId = CASE instanceId WHEN null THEN (null) WHEN 0 THEN (0) ELSE (instanceId + (SELECT MAX(entry_20_instance_id) FROM `max_values`)) END;
318UPDATE instance_whitelist SET guildId = guildId + (SELECT MAX(entry_4_guild_id) FROM `max_values`);
319
320-- Item
321UPDATE item_gm_logs SET 
322  item_guid = item_guid + (SELECT MAX(entry_3_item_guid) FROM `max_values`),
323  player_guid = CASE player_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (player_guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END;
324UPDATE item_instance SET 
325  guid = guid + (SELECT MAX(entry_3_item_guid) FROM `max_values`),
326  owner_guid = CASE owner_guid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (owner_guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END, 
327  creatorGuid = CASE creatorGuid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (creatorGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END, 
328  giftCreatorGuid = CASE giftCreatorGuid WHEN null THEN (null) WHEN 0 THEN (0) ELSE (giftCreatorGuid + (SELECT MAX(entry_1_character_guid) FROM `max_values`)) END;
329UPDATE item_instance_gems SET itemguid = itemguid + (SELECT MAX(entry_3_item_guid) FROM `max_values`);
330UPDATE item_refund_instance SET 
331  item_guid = item_guid + (SELECT MAX(entry_3_item_guid) FROM `max_values`),
332  player_guid = player_guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
333UPDATE item_instance_transmog SET 
334  itemguid = itemguid + (SELECT MAX(entry_3_item_guid) FROM `max_values`);
335UPDATE item_relic_talent SET guid = guid + (SELECT MAX(entry_3_item_guid) FROM `max_values`);
336-- UPDATE item_soulbound_trade_data SET itemGuid = itemGuid + (SELECT MAX(entry_3_item_guid) FROM `max_values`);
337
338
339-- LFG Data
340
341-- Log
342
343-- Mail
344UPDATE mail SET 
345  id = id + (SELECT MAX(entry_7_mail_id) FROM `max_values`),
346  sender = sender + (SELECT MAX(entry_1_character_guid) FROM `max_values`),
347  receiver = receiver + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
348UPDATE mail_items SET 
349  mail_id = mail_id + (SELECT MAX(entry_7_mail_id) FROM `max_values`), 
350  item_guid = item_guid + (SELECT MAX(entry_3_item_guid) FROM `max_values`);
351
352-- Petition
353UPDATE petition SET 
354  ownerguid = ownerguid + (SELECT MAX(entry_1_character_guid) FROM `max_values`),
355  petitionguid = petitionguid + (SELECT MAX(entry_19_petition_guid) FROM `max_values`);
356UPDATE petition_sign SET 
357  ownerguid = ownerguid + (SELECT MAX(entry_1_character_guid) FROM `max_values`),
358  petitionguid = petitionguid + (SELECT MAX(entry_19_petition_guid) FROM `max_values`),
359  playerguid = playerguid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
360
361-- Pet
362UPDATE pet_aura SET guid = guid + (SELECT MAX(entry_5_pet_guid) FROM `max_values`);
363UPDATE pet_aura_effect SET guid = guid + (SELECT MAX(entry_5_pet_guid) FROM `max_values`);
364UPDATE pet_spell SET guid = guid + (SELECT MAX(entry_5_pet_guid) FROM `max_values`);
365UPDATE pet_spell_cooldown SET guid = guid + (SELECT MAX(entry_5_pet_guid) FROM `max_values`);
366
367UPDATE players_reports_status SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
368
369-- Store
370UPDATE store_gold SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
371UPDATE store_item SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
372UPDATE store_level SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
373UPDATE store_metier SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
374UPDATE store_profession SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
375UPDATE store_title SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
376
377
378-- Webshop
379UPDATE webshop_delivery_currency SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
380UPDATE webshop_delivery_gold SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
381UPDATE webshop_delivery_item SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
382UPDATE webshop_delivery_level SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
383UPDATE webshop_delivery_profession SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);
384UPDATE webshop_delivery_title SET guid = guid + (SELECT MAX(entry_1_character_guid) FROM `max_values`);