· 8 years ago · Dec 06, 2017, 01:00 PM
1-- promazavani
2
3TRUNCATE TABLE auctionhouse;
4TRUNCATE TABLE account_data;
5#--TRUNCATE TABLE account_tutorial;
6TRUNCATE TABLE arena_team;
7TRUNCATE TABLE arena_team_member;
8TRUNCATE TABLE arena_team_stats;
9TRUNCATE TABLE character_account_data;
10TRUNCATE TABLE character_aura;
11TRUNCATE TABLE character_battleground_data;
12#--TRUNCATE TABLE character_battleground_random;
13TRUNCATE TABLE character_declinedname;
14TRUNCATE TABLE character_equipmentsets;
15TRUNCATE TABLE character_gifts;
16TRUNCATE TABLE character_instance;
17TRUNCATE TABLE character_queststatus_daily;
18TRUNCATE TABLE character_queststatus_weekly;
19TRUNCATE TABLE character_talent;
20TRUNCATE TABLE character_social;
21TRUNCATE TABLE character_spell_cooldown;
22TRUNCATE TABLE character_stats;
23TRUNCATE TABLE character_talent;
24TRUNCATE TABLE character_ticket;
25TRUNCATE TABLE character_tutorial;
26TRUNCATE TABLE corpse;
27TRUNCATE TABLE data_backup;
28TRUNCATE TABLE groups;
29TRUNCATE TABLE group_instance;
30TRUNCATE TABLE group_member;
31TRUNCATE TABLE guild_bank_eventlog;
32TRUNCATE TABLE guild_eventlog;
33TRUNCATE TABLE instance;
34TRUNCATE TABLE instance_reset;
35TRUNCATE TABLE pet_aura;
36TRUNCATE TABLE pet_spell_cooldown;
37#--TRUNCATE TABLE item_refund_instance;
38#--TRUNCATE TABLE item_soulbound_trade_data;
39TRUNCATE TABLE petition;
40TRUNCATE TABLE petition_sign;
41
42
43-- mazani konec
44
45ALTER TABLE character_db_version CHANGE COLUMN required_9849_01_characters_saved_variables required_9974_01_characters_group BIT;
46
47ALTER TABLE groups
48 CHANGE COLUMN isRaid groupType TINYINT(1) UNSIGNED NOT NULL;
49
50/* now fixed bug in past can save raids as 1 (BG group) */
51UPDATE groups
52 SET groupType = 2 WHERE groupType = 1;ALTER TABLE character_db_version CHANGE COLUMN required_9974_01_characters_group required_10007_01_characters_pet_aura BIT;
53
54UPDATE `pet_aura` SET remaincharges = 0 WHERE remaincharges = 255;ALTER TABLE character_db_version CHANGE COLUMN required_10007_01_characters_pet_aura required_10051_01_characters_character_aura BIT;
55
56DELETE FROM character_aura WHERE spell = 58427;
57ALTER TABLE character_db_version CHANGE COLUMN required_10051_01_characters_character_aura required_10156_01_characters_character_aura BIT;
58
59DELETE FROM `character_aura`;
60ALTER TABLE `character_aura`
61 DROP COLUMN `effect_index`, DROP COLUMN `amount`, DROP COLUMN `maxduration`, DROP COLUMN `remaintime`;
62ALTER TABLE `character_aura`
63 ADD COLUMN `basepoints0` INT(11) NOT NULL DEFAULT '0',
64 ADD COLUMN `basepoints1` INT(11) NOT NULL DEFAULT '0',
65 ADD COLUMN `basepoints2` INT(11) NOT NULL DEFAULT '0',
66 ADD COLUMN `maxduration0` INT(11) NOT NULL DEFAULT '0',
67 ADD COLUMN `maxduration1` INT(11) NOT NULL DEFAULT '0',
68 ADD COLUMN `maxduration2` INT(11) NOT NULL DEFAULT '0',
69 ADD COLUMN `remaintime0` INT(11) NOT NULL DEFAULT '0',
70 ADD COLUMN `remaintime1` INT(11) NOT NULL DEFAULT '0',
71 ADD COLUMN `remaintime2` INT(11) NOT NULL DEFAULT '0',
72 ADD COLUMN `effIndexMask` INT(11) NOT NULL DEFAULT '0';ALTER TABLE character_db_version CHANGE COLUMN required_10156_01_characters_character_aura required_10156_02_characters_pet_aura bit;
73
74DELETE FROM `pet_aura`;
75ALTER TABLE `pet_aura`
76 DROP COLUMN `effect_index`, DROP COLUMN `amount`, DROP COLUMN `maxduration`, DROP COLUMN `remaintime`;
77ALTER TABLE `pet_aura`
78 ADD COLUMN `basepoints0` INT(11) NOT NULL DEFAULT '0',
79 ADD COLUMN `basepoints1` INT(11) NOT NULL DEFAULT '0',
80 ADD COLUMN `basepoints2` INT(11) NOT NULL DEFAULT '0',
81 ADD COLUMN `maxduration0` INT(11) NOT NULL DEFAULT '0',
82 ADD COLUMN `maxduration1` INT(11) NOT NULL DEFAULT '0',
83 ADD COLUMN `maxduration2` INT(11) NOT NULL DEFAULT '0',
84 ADD COLUMN `remaintime0` INT(11) NOT NULL DEFAULT '0',
85 ADD COLUMN `remaintime1` INT(11) NOT NULL DEFAULT '0',
86 ADD COLUMN `remaintime2` INT(11) NOT NULL DEFAULT '0',
87 ADD COLUMN `effIndexMask` INT(11) NOT NULL DEFAULT '0';ALTER TABLE character_db_version CHANGE COLUMN required_10156_02_characters_pet_aura required_10160_01_characters_character_aura bit;
88
89alter table `character_aura` drop primary key;
90alter table `character_aura` add primary key (`guid`,`spell`);ALTER TABLE character_db_version CHANGE COLUMN required_10160_01_characters_character_aura required_10160_02_characters_pet_aura bit;
91
92alter table `pet_aura` drop primary key;
93alter table `pet_aura` add primary key (`guid`,`spell`);ALTER TABLE character_db_version CHANGE COLUMN required_10160_02_characters_pet_aura required_10254_01_characters_auctionhouse bit;
94
95ALTER TABLE auctionhouse
96 ADD COLUMN houseid int(11) unsigned NOT NULL default '0' AFTER id;
97
98DROP TABLE IF EXISTS auction;
99RENAME TABLE auctionhouse TO auction;
100ALTER TABLE character_db_version CHANGE COLUMN required_10254_01_characters_auctionhouse required_10312_01_characters_character_aura bit;
101
102ALTER TABLE `character_aura` DROP PRIMARY KEY;
103ALTER TABLE `character_aura` ADD PRIMARY KEY (`guid`,`caster_guid`,`spell`);
104ALTER TABLE character_db_version CHANGE COLUMN required_10312_01_characters_character_aura required_10312_02_characters_pet_aura bit;
105
106ALTER TABLE `pet_aura` DROP PRIMARY KEY;
107ALTER TABLE `pet_aura` ADD PRIMARY KEY (`guid`,`caster_guid`,`spell`);
108ALTER TABLE character_db_version CHANGE COLUMN required_10312_02_characters_pet_aura required_10332_01_characters_character_aura bit;
109
110ALTER TABLE `character_aura`
111 ADD COLUMN `item_guid` int(11) unsigned NOT NULL default '0' AFTER `caster_guid`,
112 DROP PRIMARY KEY,
113 ADD PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`);
114
115ALTER TABLE character_db_version CHANGE COLUMN required_10332_01_characters_character_aura required_10332_02_characters_pet_aura bit;
116
117ALTER TABLE `pet_aura`
118 ADD COLUMN `item_guid` int(11) unsigned NOT NULL default '0' AFTER `caster_guid`,
119 DROP PRIMARY KEY,
120 ADD PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`);
121
122ALTER TABLE character_db_version CHANGE COLUMN required_10332_02_characters_pet_aura required_10503_01_characters_creature_respawn bit;
123
124DROP TABLE IF EXISTS `creature_respawn`;
125CREATE TABLE `creature_respawn` (
126 `guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
127 `respawntime` bigint(20) NOT NULL default '0',
128 `instance` mediumint(8) unsigned NOT NULL default '0',
129 PRIMARY KEY (`guid`,`instance`),
130 KEY `instance` (`instance`)
131) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
132ALTER TABLE character_db_version CHANGE COLUMN required_10503_01_characters_creature_respawn required_10503_02_characters_gameobject_respawn bit;
133
134DROP TABLE IF EXISTS `gameobject_respawn`;
135CREATE TABLE `gameobject_respawn` (
136 `guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
137 `respawntime` bigint(20) NOT NULL default '0',
138 `instance` mediumint(8) unsigned NOT NULL default '0',
139 PRIMARY KEY (`guid`,`instance`),
140 KEY `instance` (`instance`)
141) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
142ALTER TABLE character_db_version CHANGE COLUMN required_10503_02_characters_gameobject_respawn required_10568_01_characters_character_tutorial bit;
143
144ALTER TABLE `character_tutorial` DROP PRIMARY KEY;
145ALTER TABLE `character_tutorial` DROP COLUMN `realmid`;
146ALTER TABLE `character_tutorial` ADD PRIMARY KEY (`account`);
147ALTER TABLE `character_tutorial` DROP KEY `acc_key`;
148
149
150-- ================================
151-- == Character convertor z Mangosu rev:10179 ==
152-- == For Trinity Core 8877(3.3.5a) ===============
153-- ================================
154
155CREATE TABLE `addons` (
156 `name` varchar(120) NOT NULL default '',
157 `crc` int(32) unsigned NOT NULL default '0',
158 PRIMARY KEY (`name`)
159) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Addons';
160
161-- ----------------------------
162-- Records
163-- ----------------------------
164INSERT INTO `addons` VALUES ('Blizzard_AchievementUI', '1');
165INSERT INTO `addons` VALUES ('Blizzard_ArenaUI', '1');
166INSERT INTO `addons` VALUES ('Blizzard_AuctionUI', '1');
167INSERT INTO `addons` VALUES ('Blizzard_BarbershopUI', '1');
168INSERT INTO `addons` VALUES ('Blizzard_BattlefieldMinimap', '1');
169INSERT INTO `addons` VALUES ('Blizzard_BindingUI', '1');
170INSERT INTO `addons` VALUES ('Blizzard_Calendar', '1');
171INSERT INTO `addons` VALUES ('Blizzard_CombatLog', '1');
172INSERT INTO `addons` VALUES ('Blizzard_CombatText', '1');
173INSERT INTO `addons` VALUES ('Blizzard_DebugTools', '1');
174INSERT INTO `addons` VALUES ('Blizzard_GlyphUI', '1');
175INSERT INTO `addons` VALUES ('Blizzard_GMChatUI', '1');
176INSERT INTO `addons` VALUES ('Blizzard_GMSurveyUI', '1');
177INSERT INTO `addons` VALUES ('Blizzard_GuildBankUI', '1');
178INSERT INTO `addons` VALUES ('Blizzard_InspectUI', '1');
179INSERT INTO `addons` VALUES ('Blizzard_ItemSocketingUI', '1');
180INSERT INTO `addons` VALUES ('Blizzard_MacroUI', '1');
181INSERT INTO `addons` VALUES ('Blizzard_RaidUI', '1');
182INSERT INTO `addons` VALUES ('Blizzard_TalentUI', '1');
183INSERT INTO `addons` VALUES ('Blizzard_TimeManager', '1');
184INSERT INTO `addons` VALUES ('Blizzard_TokenUI', '1');
185INSERT INTO `addons` VALUES ('Blizzard_TradeSkillUI', '1');
186INSERT INTO `addons` VALUES ('Blizzard_TrainerUI', '1');
187
188
189-- Create Table(auctionhause)
190CREATE TABLE `auctionhousebot` (
191 `auctionhouse` int(11) NOT NULL default '0' COMMENT 'mapID of the auctionhouse.',
192 `name` char(25) default NULL COMMENT 'Text name of the auctionhouse.',
193 `minitems` int(11) default '0' COMMENT 'This is the minimum number of items you want to keep in the auction house. a 0 here will make it the same as the maximum.',
194 `maxitems` int(11) default '0' COMMENT 'This is the number of items you want to keep in the auction house.',
195 `percentgreytradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items',
196 `percentwhitetradegoods` int(11) default '27' COMMENT 'Sets the percentage of the White Trade Goods auction items',
197 `percentgreentradegoods` int(11) default '12' COMMENT 'Sets the percentage of the Green Trade Goods auction items',
198 `percentbluetradegoods` int(11) default '10' COMMENT 'Sets the percentage of the Blue Trade Goods auction items',
199 `percentpurpletradegoods` int(11) default '1' COMMENT 'Sets the percentage of the Purple Trade Goods auction items',
200 `percentorangetradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Orange Trade Goods auction items',
201 `percentyellowtradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Yellow Trade Goods auction items',
202 `percentgreyitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Grey auction items',
203 `percentwhiteitems` int(11) default '10' COMMENT 'Sets the percentage of the non trade White auction items',
204 `percentgreenitems` int(11) default '30' COMMENT 'Sets the percentage of the non trade Green auction items',
205 `percentblueitems` int(11) default '8' COMMENT 'Sets the percentage of the non trade Blue auction items',
206 `percentpurpleitems` int(11) default '2' COMMENT 'Sets the percentage of the non trade Purple auction items',
207 `percentorangeitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Orange auction items',
208 `percentyellowitems` int(11) default '0' COMMENT 'Sets the percentage of the non trade Yellow auction items',
209 `minpricegrey` int(11) default '100' COMMENT 'Minimum price of Grey items (percentage).',
210 `maxpricegrey` int(11) default '150' COMMENT 'Maximum price of Grey items (percentage).',
211 `minpricewhite` int(11) default '150' COMMENT 'Minimum price of White items (percentage).',
212 `maxpricewhite` int(11) default '250' COMMENT 'Maximum price of White items (percentage).',
213 `minpricegreen` int(11) default '800' COMMENT 'Minimum price of Green items (percentage).',
214 `maxpricegreen` int(11) default '1400' COMMENT 'Maximum price of Green items (percentage).',
215 `minpriceblue` int(11) default '1250' COMMENT 'Minimum price of Blue items (percentage).',
216 `maxpriceblue` int(11) default '1750' COMMENT 'Maximum price of Blue items (percentage).',
217 `minpricepurple` int(11) default '2250' COMMENT 'Minimum price of Purple items (percentage).',
218 `maxpricepurple` int(11) default '4550' COMMENT 'Maximum price of Purple items (percentage).',
219 `minpriceorange` int(11) default '3250' COMMENT 'Minimum price of Orange items (percentage).',
220 `maxpriceorange` int(11) default '5550' COMMENT 'Maximum price of Orange items (percentage).',
221 `minpriceyellow` int(11) default '5250' COMMENT 'Minimum price of Yellow items (percentage).',
222 `maxpriceyellow` int(11) default '6550' COMMENT 'Maximum price of Yellow items (percentage).',
223 `minbidpricegrey` int(11) default '70' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 70',
224 `maxbidpricegrey` int(11) default '100' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 100',
225 `minbidpricewhite` int(11) default '70' COMMENT 'Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 70',
226 `maxbidpricewhite` int(11) default '100' COMMENT 'Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 100',
227 `minbidpricegreen` int(11) default '80' COMMENT 'Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 80',
228 `maxbidpricegreen` int(11) default '100' COMMENT 'Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 100',
229 `minbidpriceblue` int(11) default '75' COMMENT 'Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 75',
230 `maxbidpriceblue` int(11) default '100' COMMENT 'Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 100',
231 `minbidpricepurple` int(11) default '80' COMMENT 'Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 80',
232 `maxbidpricepurple` int(11) default '100' COMMENT 'Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 100',
233 `minbidpriceorange` int(11) default '80' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 80',
234 `maxbidpriceorange` int(11) default '100' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 100',
235 `minbidpriceyellow` int(11) default '80' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 80',
236 `maxbidpriceyellow` int(11) default '100' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 100',
237 `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
238 `maxstackwhite` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
239 `maxstackgreen` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
240 `maxstackblue` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
241 `maxstackpurple` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
242 `maxstackorange` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
243 `maxstackyellow` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
244 `buyerpricegrey` int(11) default '1' COMMENT 'Multiplier to vendorprice when buying grey items from auctionhouse',
245 `buyerpricewhite` int(11) default '3' COMMENT 'Multiplier to vendorprice when buying white items from auctionhouse',
246 `buyerpricegreen` int(11) default '5' COMMENT 'Multiplier to vendorprice when buying green items from auctionhouse',
247 `buyerpriceblue` int(11) default '12' COMMENT 'Multiplier to vendorprice when buying blue items from auctionhouse',
248 `buyerpricepurple` int(11) default '15' COMMENT 'Multiplier to vendorprice when buying purple items from auctionhouse',
249 `buyerpriceorange` int(11) default '20' COMMENT 'Multiplier to vendorprice when buying orange items from auctionhouse',
250 `buyerpriceyellow` int(11) default '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse',
251 `buyerbiddinginterval` int(11) default '1' COMMENT 'Interval how frequently AHB bids on each AH. Time in minutes',
252 `buyerbidsperinterval` int(11) default '1' COMMENT 'number of bids to put in per bidding interval',
253 PRIMARY KEY (`auctionhouse`)
254) ENGINE=InnoDB DEFAULT CHARSET=utf8;
255
256-- ----------------------------
257-- Records
258-- ----------------------------
259INSERT INTO `auctionhousebot` VALUES ('2', 'Alliance', '0', '0', '0', '27', '12', '10', '1', '0', '0', '0', '10', '30', '8', '2', '0', '0', '100', '150', '150', '250', '800', '1400', '1250', '1750', '2250', '4550', '3250', '5550', '5250', '6550', '70', '100', '70', '100', '80', '100', '75', '100', '80', '100', '80', '100', '80', '100', '0', '0', '3', '2', '1', '1', '1', '1', '3', '5', '12', '15', '20', '22', '1', '1');
260INSERT INTO `auctionhousebot` VALUES ('6', 'Horde', '0', '0', '0', '27', '12', '10', '1', '0', '0', '0', '10', '30', '8', '2', '0', '0', '100', '150', '150', '250', '800', '1400', '1250', '1750', '2250', '4550', '3250', '5550', '5250', '6550', '70', '100', '70', '100', '80', '100', '75', '100', '80', '100', '80', '100', '80', '100', '0', '0', '3', '2', '1', '1', '1', '1', '3', '5', '12', '15', '20', '22', '1', '1');
261INSERT INTO `auctionhousebot` VALUES ('7', 'Neutral', '0', '0', '0', '27', '12', '10', '1', '0', '0', '0', '10', '30', '8', '2', '0', '0', '100', '150', '150', '250', '800', '1400', '1250', '1750', '2250', '4550', '3250', '5550', '5250', '6550', '70', '100', '70', '100', '80', '100', '75', '100', '80', '100', '80', '100', '80', '100', '0', '0', '3', '2', '1', '1', '1', '1', '3', '5', '12', '15', '20', '22', '1', '1');
262
263
264-- Create Table(channels)
265CREATE TABLE `channels` (
266 `m_name` text NOT NULL,
267 `m_team` int(10) unsigned NOT NULL,
268 `m_announce` tinyint(1) unsigned NOT NULL default '0',
269 `m_moderate` tinyint(1) unsigned NOT NULL default '0',
270 `m_public` tinyint(1) unsigned NOT NULL default '1',
271 `m_password` text,
272 `BannedList` longtext,
273 PRIMARY KEY (`m_name`(10),`m_team`)
274) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Channel System';
275
276-- Drop Table if exists(character_db_version,character_ticket,saved_variables,character_aura,pet_aura)
277DROP TABLE IF EXISTS `character_db_version`;
278
279DROP TABLE IF EXISTS `character_ticket`;
280
281DROP TABLE IF EXISTS `character_aura`;
282
283DROP TABLE IF EXISTS `pet_aura`;
284
285
286-- Alter Table-Drop(slot,glyph)
287-- Alter Table-Add(glyph1,glyph2,glyph3,glyph4,glyph5,glyph6)
288ALTER TABLE character_glyphs DROP PRIMARY KEY;
289ALTER TABLE `character_glyphs` DROP COLUMN `slot`;
290ALTER TABLE `character_glyphs` DROP COLUMN `glyph`;
291ALTER TABLE `character_glyphs` ADD `glyph1` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
292ALTER TABLE `character_glyphs` ADD `glyph2` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
293ALTER TABLE `character_glyphs` ADD `glyph3` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
294ALTER TABLE `character_glyphs` ADD `glyph4` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
295ALTER TABLE `character_glyphs` ADD `glyph5` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
296ALTER TABLE `character_glyphs` ADD `glyph6` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
297
298-- Alter Table-Add(instance_id,latency)
299ALTER TABLE `characters` ADD `instance_id` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
300
301ALTER TABLE `characters` ADD `latency` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
302
303
304-- Create Table(game_event_condition_save)
305CREATE TABLE `game_event_condition_save` (
306 `event_id` mediumint(8) unsigned NOT NULL,
307 `condition_id` mediumint(8) unsigned NOT NULL default '0',
308 `done` float default '0',
309 PRIMARY KEY (`event_id`,`condition_id`)
310) ENGINE=InnoDB DEFAULT CHARSET=utf8;
311
312
313-- Create Table(game_event_save)
314CREATE TABLE `game_event_save` (
315 `event_id` mediumint(8) unsigned NOT NULL,
316 `state` tinyint(3) unsigned NOT NULL default '1',
317 `next_start` timestamp NOT NULL default '0000-00-00 00:00:00',
318 PRIMARY KEY (`event_id`)
319) ENGINE=InnoDB DEFAULT CHARSET=utf8;
320
321
322-- Create Table(gm_tickets)
323CREATE TABLE `gm_tickets` (
324 `guid` int(10) NOT NULL auto_increment,
325 `playerGuid` int(11) unsigned NOT NULL default '0',
326 `name` varchar(15) NOT NULL,
327 `message` text NOT NULL,
328 `createtime` int(10) NOT NULL default '0',
329 `map` int(11) NOT NULL default '0',
330 `posX` float NOT NULL default '0',
331 `posY` float NOT NULL default '0',
332 `posZ` float NOT NULL default '0',
333 `timestamp` int(10) NOT NULL default '0',
334 `closed` int(10) NOT NULL default '0',
335 `assignedto` int(10) NOT NULL default '0',
336 `comment` text NOT NULL,
337 PRIMARY KEY (`guid`)
338) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
339
340
341-- Alter Table-Drop(groupid)
342ALTER TABLE `groups` DROP COLUMN `groupid`;
343
344ALTER TABLE `group_member`
345CHANGE `assistant` `memberFlags` tinyint(2) NOT NULL DEFAULT '0';
346
347
348-- Alter Table-Drop(deleteInfos_Account,deleteInfos_Name,deleteDate,mainTank,mainAssistant,groupid)
349-- Alter Table-Add(guid)
350ALTER TABLE `characters` DROP COLUMN `deleteInfos_Account`;
351
352ALTER TABLE `characters` DROP COLUMN `deleteInfos_Name`;
353
354ALTER TABLE `characters` DROP COLUMN `deleteDate`;
355
356ALTER TABLE `groups` DROP COLUMN `mainTank`;
357
358ALTER TABLE `groups` DROP COLUMN `mainAssistant`;
359
360ALTER TABLE `groups` DROP COLUMN `groupType`;
361
362ALTER TABLE `groups` ADD `groupType` mediumint(8) NOT NULL DEFAULT '0';
363
364
365-- Create Table(character_aura)
366CREATE TABLE `character_aura` (
367 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
368 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
369 `spell` int(11) unsigned NOT NULL default '0',
370 `effect_mask` tinyint(3) unsigned NOT NULL default '0',
371 `recalculate_mask` tinyint(3) unsigned NOT NULL default '0',
372 `stackcount` tinyint(3) unsigned NOT NULL default '1',
373 `amount0` int(11) NOT NULL default '0',
374 `amount1` int(11) NOT NULL default '0',
375 `amount2` int(11) NOT NULL default '0',
376 `base_amount0` int(11) NOT NULL default '0',
377 `base_amount1` int(11) NOT NULL default '0',
378 `base_amount2` int(11) NOT NULL default '0',
379 `maxduration` int(11) NOT NULL default '0',
380 `remaintime` int(11) NOT NULL default '0',
381 `remaincharges` tinyint(3) unsigned NOT NULL default '0',
382 PRIMARY KEY (`guid`,`caster_guid`,`spell`,`effect_mask`)
383) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
384
385-- Create Table(pet_aura)
386CREATE TABLE `pet_aura` (
387 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
388 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
389 `spell` int(11) unsigned NOT NULL default '0',
390 `effect_mask` tinyint(3) unsigned NOT NULL default '0',
391 `recalculate_mask` tinyint(3) unsigned NOT NULL default '0',
392 `stackcount` tinyint(3) unsigned NOT NULL default '1',
393 `amount0` int(11) NOT NULL default '0',
394 `amount1` int(11) NOT NULL default '0',
395 `amount2` int(11) NOT NULL default '0',
396 `base_amount0` int(11) NOT NULL default '0',
397 `base_amount1` int(11) NOT NULL default '0',
398 `base_amount2` int(11) NOT NULL default '0',
399 `maxduration` int(11) NOT NULL default '0',
400 `remaintime` int(11) NOT NULL default '0',
401 `remaincharges` tinyint(3) unsigned NOT NULL default '0',
402 PRIMARY KEY (`guid`,`spell`,`effect_mask`)
403) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
404
405-- Create Table(item_refund_instance)
406CREATE TABLE `item_refund_instance` (
407 `item_guid` int(11) unsigned NOT NULL COMMENT 'Item GUID',
408 `player_guid` int(11) unsigned NOT NULL COMMENT 'Player GUID',
409 `paidMoney` int(11) unsigned NOT NULL default '0',
410 `paidExtendedCost` int(11) unsigned NOT NULL default '0',
411 PRIMARY KEY (`item_guid`,`player_guid`)
412) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item Refund System';
413
414ALTER TABLE `saved_variables` CHANGE `NextArenaPointDistributionTime` `value` bigint(40) UNSIGNED NOT NULL DEFAULT '0',
415ADD COLUMN `entry` mediumint(11) UNSIGNED NOT NULL DEFAULT '0' FIRST,
416ADD COLUMN `comment` text NOT NULL,
417ADD PRIMARY KEY (`entry`),
418RENAME `worldstates`,
419ROW_FORMAT=DYNAMIC;
420
421-- Only posible value is NextArenaPointDistributionTime so make the conversion to custom worldstate
422UPDATE `worldstates` SET `entry`=20001, `comment`='NextArenaPointDistributionTime';
423
424
425-- Alter Table-Drop(current_rank,NextDailyQuestResetTime,NextWeeklyQuestResetTime,cleaning_flags,commnet)
426-- Alter Table-Add(zone,data,guid,time,comment)
427ALTER TABLE `corpse` ADD `zone` int(11) UNSIGNED NOT NULL DEFAULT 38 ;
428
429ALTER TABLE `corpse` ADD `data` longtext ;
430
431ALTER TABLE `group_member`
432CHANGE `groupid` `guild` int(11) NOT NULL DEFAULT '0';
433
434ALTER TABLE `character_talent` DROP COLUMN `current_rank`;
435
436ALTER TABLE `character_talent`
437CHANGE `talent_id` `spell` int(11) NOT NULL DEFAULT '0';
438
439ALTER TABLE `groups` ADD `guid` int(11) UNSIGNED NOT NULL DEFAULT 0 ;
440
441ALTER TABLE `group_instance`
442CHANGE `leaderGuid` `guid` int(11) NOT NULL DEFAULT '0';
443
444ALTER TABLE `character_queststatus_daily` ADD `time` bigint(20) UNSIGNED NOT NULL DEFAULT 0 ;
445
446ALTER TABLE `worldstates` DROP COLUMN `NextDailyQuestResetTime`;
447
448ALTER TABLE `worldstates` DROP COLUMN `NextWeeklyQuestResetTime`;
449
450ALTER TABLE `worldstates` DROP COLUMN `cleaning_flags`;
451
452ALTER TABLE `worldstates` DROP COLUMN `comment`;
453
454ALTER TABLE `worldstates` ADD `comment` text ;
455
456ALTER TABLE `group_member`
457CHANGE `guild` `guid` int(11) NOT NULL DEFAULT '0';
458
459
460-- Create Table(character_battleground_data)
461CREATE TABLE `character_battleground_random` (
462 `guid` int(11) unsigned NOT NULL default '0',
463 PRIMARY KEY (`guid`)
464) ENGINE=InnoDB DEFAULT CHARSET=utf8;
465
466
467-- old/3.3.5a/08971_characters_characters.sql
468ALTER TABLE `characters`
469 ADD COLUMN `deleteInfos_Account` int(11) UNSIGNED default NULL AFTER actionBars,
470 ADD COLUMN `deleteInfos_Name` varchar(12) default NULL AFTER deleteInfos_Account,
471 ADD COLUMN `deleteDate` bigint(20) default NULL AFTER deleteInfos_Name;
472
473-- old/3.3.5a/08986_characters_worldstates.sql
474DELETE FROM `worldstates` WHERE `entry`=20004;
475INSERT INTO `worldstates` (`entry`,`value`,`comment`) VALUES (20004,0, 'cleaning_flags');
476
477-- old/3.3.5a/09081_characters_characters.sql
478ALTER TABLE `characters` CHANGE `dungeon_difficulty` `instance_mode_mask` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 AFTER `instance_id`;
479
480-- old/3.3.5a/09090_characters_item_instance.sql
481-- Add new fields
482ALTER TABLE `item_instance`
483 ADD `creatorGuid` int(10) unsigned NOT NULL default '0' AFTER `owner_guid`,
484 ADD `giftCreatorGuid` int(10) unsigned NOT NULL default '0' AFTER `creatorGuid`,
485 ADD `count` int(10) unsigned NOT NULL default '1' AFTER `giftCreatorGuid`,
486 ADD `duration` int(10) unsigned NOT NULL AFTER `count`,
487 ADD `charges` text NOT NULL AFTER `duration`,
488 ADD `flags` int(10) unsigned NOT NULL default '0' AFTER `charges`,
489 ADD `enchantments` text NOT NULL AFTER `flags`,
490 ADD `randomPropertyId` int(11) NOT NULL default '0' AFTER `enchantments`,
491 ADD `durability` int(10) unsigned NOT NULL default '0' AFTER `randomPropertyId`,
492 ADD `playedTime` int(10) unsigned NOT NULL default '0' AFTER `durability`;
493
494-- Temporarily change delimiter to prevent SQL syntax errors
495DELIMITER ||
496
497-- Function to convert ints from unsigned to signed
498DROP FUNCTION IF EXISTS `uint32toint32`||
499CREATE FUNCTION `uint32toint32`(input INT(10) UNSIGNED) RETURNS INT(11) SIGNED DETERMINISTIC
500BEGIN
501 RETURN input;
502END||
503
504-- Restore original delimiter
505DELIMITER ;
506
507-- Move data to new fields
508UPDATE `item_instance` SET
509`creatorGuid` = SUBSTRING(`data`,
510length(SUBSTRING_INDEX(`data`,' ',10))+2,
511length(SUBSTRING_INDEX(`data`,' ',10+1))-length(SUBSTRING_INDEX(data,' ',10))-1),
512
513`giftCreatorGuid` = SUBSTRING(`data`,
514length(SUBSTRING_INDEX(`data`,' ',12))+2,
515length(SUBSTRING_INDEX(`data`,' ',12+1))-length(SUBSTRING_INDEX(data,' ',12))-1),
516
517`count` = SUBSTRING(`data`,
518length(SUBSTRING_INDEX(`data`,' ',14))+2,
519length(SUBSTRING_INDEX(`data`,' ',14+1))-length(SUBSTRING_INDEX(data,' ',14))-1),
520
521`duration` = SUBSTRING(`data`,
522length(SUBSTRING_INDEX(`data`,' ',15))+2,
523length(SUBSTRING_INDEX(`data`,' ',15+1))-length(SUBSTRING_INDEX(data,' ',15))-1),
524
525`charges` = CONCAT_WS(' ',
526uint32toint32(SUBSTRING(`data`,
527length(SUBSTRING_INDEX(`data`,' ',16))+2,
528length(SUBSTRING_INDEX(`data`,' ',16+1))-length(SUBSTRING_INDEX(data,' ',16))-1)),
529uint32toint32(SUBSTRING(`data`,
530length(SUBSTRING_INDEX(`data`,' ',17))+2,
531length(SUBSTRING_INDEX(`data`,' ',17+1))-length(SUBSTRING_INDEX(data,' ',17))-1)),
532uint32toint32(SUBSTRING(`data`,
533length(SUBSTRING_INDEX(`data`,' ',18))+2,
534length(SUBSTRING_INDEX(`data`,' ',18+1))-length(SUBSTRING_INDEX(data,' ',18))-1)),
535uint32toint32(SUBSTRING(`data`,
536length(SUBSTRING_INDEX(`data`,' ',19))+2,
537length(SUBSTRING_INDEX(`data`,' ',19+1))-length(SUBSTRING_INDEX(data,' ',19))-1)),
538uint32toint32(SUBSTRING(`data`,
539length(SUBSTRING_INDEX(`data`,' ',20))+2,
540length(SUBSTRING_INDEX(`data`,' ',20+1))-length(SUBSTRING_INDEX(data,' ',20))-1))),
541
542`flags` = SUBSTRING(`data`,
543length(SUBSTRING_INDEX(`data`,' ',21))+2,
544length(SUBSTRING_INDEX(`data`,' ',21+1))-length(SUBSTRING_INDEX(data,' ',21))-1),
545
546`enchantments` = SUBSTRING(`data`,
547length(SUBSTRING_INDEX(`data`,' ',22))+2,
548length(SUBSTRING_INDEX(`data`,' ',57+1))-length(SUBSTRING_INDEX(data,' ',22))-1),
549
550`randomPropertyId` = uint32toint32(SUBSTRING(`data`,
551length(SUBSTRING_INDEX(`data`,' ',59))+2,
552length(SUBSTRING_INDEX(`data`,' ',59+1))-length(SUBSTRING_INDEX(data,' ',59))-1)),
553
554`durability` = SUBSTRING(`data`,
555length(SUBSTRING_INDEX(`data`,' ',60))+2,
556length(SUBSTRING_INDEX(`data`,' ',60+1))-length(SUBSTRING_INDEX(data,' ',60))-1),
557
558`playedTime` = SUBSTRING(`data`,
559length(SUBSTRING_INDEX(`data`,' ',62))+2,
560length(SUBSTRING_INDEX(`data`,' ',62+1))-length(SUBSTRING_INDEX(data,' ',62))-1);
561
562-- Drop function
563DROP FUNCTION IF EXISTS `uint32toint32`;
564
565-- Fix heroic item flag
566UPDATE `item_instance` SET `flags`=`flags`&~0x8 WHERE
567SUBSTRING(`data`,
568length(SUBSTRING_INDEX(`data`,' ',3))+2,
569length(SUBSTRING_INDEX(`data`,' ',3+1))-length(SUBSTRING_INDEX(data,' ',3))-1)
570NOT IN (5043,5044,17302,17305,17308,21831);
571
572-- Drop old field
573ALTER TABLE `item_instance` DROP `data`;
574
575-- old/3.3.5a/09092_characters_corpse.sql
576ALTER TABLE `corpse`
577 ADD COLUMN `displayId` int(10) unsigned NOT NULL default '0' AFTER `phaseMask`,
578 ADD COLUMN `itemCache` text NOT NULL AFTER `displayId`,
579 ADD COLUMN `bytes1` int(10) unsigned NOT NULL default '0' AFTER `itemCache`,
580 ADD COLUMN `bytes2` int(10) unsigned NOT NULL default '0' AFTER `bytes1`,
581 ADD COLUMN `guild` int(10) unsigned NOT NULL default '0' AFTER `bytes2`,
582 ADD COLUMN `flags` int(10) unsigned NOT NULL default '0' AFTER `guild`,
583 ADD COLUMN `dynFlags` int(10) unsigned NOT NULL default '0' AFTER `flags`;
584
585UPDATE `corpse` SET
586`displayId` = SUBSTRING(`data`,
587length(SUBSTRING_INDEX(`data`,' ',10))+2,
588length(SUBSTRING_INDEX(`data`,' ',10+1))-length(SUBSTRING_INDEX(data,' ',10))-1),
589
590`itemCache` = SUBSTRING(`data`,
591length(SUBSTRING_INDEX(`data`,' ',11))+2,
592length(SUBSTRING_INDEX(`data`,' ',29+1))-length(SUBSTRING_INDEX(data,' ',11))-1),
593
594`bytes1` = SUBSTRING(`data`,
595length(SUBSTRING_INDEX(`data`,' ',30))+2,
596length(SUBSTRING_INDEX(`data`,' ',30+1))-length(SUBSTRING_INDEX(data,' ',30))-1),
597
598`bytes2` = SUBSTRING(`data`,
599length(SUBSTRING_INDEX(`data`,' ',31))+2,
600length(SUBSTRING_INDEX(`data`,' ',31+1))-length(SUBSTRING_INDEX(data,' ',31))-1),
601
602`guild` = SUBSTRING(`data`,
603length(SUBSTRING_INDEX(`data`,' ',32))+2,
604length(SUBSTRING_INDEX(`data`,' ',32+1))-length(SUBSTRING_INDEX(data,' ',32))-1),
605
606`flags` = SUBSTRING(`data`,
607length(SUBSTRING_INDEX(`data`,' ',33))+2,
608length(SUBSTRING_INDEX(`data`,' ',33+1))-length(SUBSTRING_INDEX(data,' ',33))-1),
609
610`dynFlags` = SUBSTRING(`data`,
611length(SUBSTRING_INDEX(`data`,' ',34))+2,
612length(SUBSTRING_INDEX(`data`,' ',34+1))-length(SUBSTRING_INDEX(data,' ',34))-1);
613
614ALTER TABLE `corpse` DROP `data`;
615
616-- old/3.3.5a/09160_characters_item_instance.sql
617SET @allowedFlags := 0x00000001 | 0x00000008 | 0x00000200 | 0x00001000 | 0x00008000 | 0x00010000;
618
619UPDATE `item_instance` SET `flags` = (`flags` & @allowedFlags);
620
621-- old/3.3.5a/09632_characters_arena_team_member.sql
622ALTER TABLE `arena_team_member`
623DROP COLUMN `personal_rating`;
624
625-- old/3.3.5a/09632_characters_arena_team_stats.sql
626UPDATE `arena_team_stats` SET `rating`=0;
627
628-- old/3.3.5a/09632_characters_character_arena_stats.sql
629CREATE TABLE `character_arena_stats` (
630`guid` int(10) NOT NULL ,
631`slot` smallint(1) NOT NULL ,
632`personal_rating` int(10) NOT NULL ,
633`matchmaker_rating` int(10) NOT NULL ,
634PRIMARY KEY (`guid`, `slot`)
635);
636
637
638-- old/3.3.5a/09668_characters_gm_subsurveys.sql
639DROP TABLE IF EXISTS `gm_subsurveys`;
640CREATE TABLE `gm_subsurveys` (
641 `surveyid` int(10) NOT NULL auto_increment,
642 `subsurveyid` int(11) UNSIGNED NOT NULL DEFAULT '0',
643 `rank` int(11) UNSIGNED NOT NULL DEFAULT '0',
644 `comment` longtext NOT NULL,
645 PRIMARY KEY (`surveyid`,`subsurveyid`)
646) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
647
648-- old/3.3.5a/09668_characters_gm_surveys.sql
649DROP TABLE IF EXISTS `gm_surveys`;
650CREATE TABLE `gm_surveys` (
651 `surveyid` int(10) NOT NULL auto_increment,
652 `player` int(11) UNSIGNED NOT NULL DEFAULT '0',
653 `mainSurvey` int(11) UNSIGNED NOT NULL DEFAULT '0',
654 `overall_comment` longtext NOT NULL,
655 `timestamp` int(11) NOT NULL DEFAULT '0',
656 PRIMARY KEY (`surveyid`)
657) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
658
659-- old/3.3.5a/09668_characters_gm_tickets.sql
660ALTER TABLE `gm_tickets` ADD COLUMN `completed` int(11) NOT NULL DEFAULT '0' AFTER `comment`;
661ALTER TABLE `gm_tickets` ADD COLUMN `escalated` int(11) NOT NULL DEFAULT '0' AFTER `completed`;
662ALTER TABLE `gm_tickets` ADD COLUMN `viewed` int(11) NOT NULL DEFAULT '0' AFTER `escalated`;
663
664-- old/3.3.5a/09668_characters_lag_reports.sql
665DROP TABLE IF EXISTS `lag_reports`;
666CREATE TABLE `lag_reports` (
667 `report_id` int(10) NOT NULL auto_increment,
668 `player` int(11) UNSIGNED NOT NULL DEFAULT '0',
669 `lag_type` int(10) NOT NULL DEFAULT '0',
670 `map` int(11) NOT NULL DEFAULT '0',
671 `posX` float NOT NULL default '0',
672 `posY` float NOT NULL default '0',
673 `posZ` float NOT NULL default '0',
674 PRIMARY KEY (`report_id`)
675) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
676
677-- old/3.3.5a/09708_characters_database.sql
678-- Set the correct engine
679ALTER TABLE `bugreport` ENGINE=InnoDB;
680ALTER TABLE `channels` ENGINE=InnoDB;
681
682
683-- old/3.3.5a/09716_characters_auctionhousebot.sql
684DROP TABLE `auctionhousebot`;
685
686
687-- old/3.3.5a/09758_characters_game_event_save.sql
688ALTER TABLE `game_event_save` ADD `next_start_timestamp` BIGINT(11) UNSIGNED NOT NULL DEFAULT '0';
689UPDATE `game_event_save` SET `next_start_timestamp` = UNIX_TIMESTAMP(`next_start`);
690ALTER TABLE `game_event_save` DROP `next_start`;
691ALTER TABLE `game_event_save` CHANGE `next_start_timestamp` `next_start` BIGINT(11) UNSIGNED NOT NULL DEFAULT '0';
692
693-- old/3.3.5a/09792_characters_groups.sql
694ALTER TABLE `groups` ADD INDEX ( `leaderGuid` );
695
696-- old/3.3.5a/09792_characters_instance_reset.sql
697ALTER TABLE `instance_reset` ADD INDEX ( `difficulty` );
698
699-- old/3.3.5a/09792_characters_instance.sql
700ALTER TABLE `instance` ADD INDEX ( `difficulty` );
701
702-- old/3.3.5a/09859_characters_group_member.sql
703ALTER TABLE `group_member` ADD `roles` smallint(6) unsigned NOT NULL default '0';
704
705-- old/3.3.5a/09911_characters_guild_bank_eventlog.sql
706ALTER TABLE `guild_bank_eventlog` CHANGE `ItemStackCount` `ItemStackCount` SMALLINT(4) UNSIGNED DEFAULT '0' NOT NULL;
707
708-- old/3.3.5a/09920_characters_pool_quest_save.sql
709DROP TABLE IF EXISTS `pool_quest_save`;
710CREATE TABLE `pool_quest_save` (
711 `pool_id` int(10) unsigned NOT NULL DEFAULT '0',
712 `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
713 PRIMARY KEY (`pool_id`,`quest_id`)
714) ENGINE=InnoDB DEFAULT CHARSET=utf8;
715
716-- old/3.3.5a/10000_characters_character_banned.sql
717DROP TABLE IF EXISTS `character_banned`;
718CREATE TABLE `character_banned` (
719 `guid` int(11) NOT NULL default '0' COMMENT 'Account id',
720 `bandate` bigint(40) NOT NULL default '0',
721 `unbandate` bigint(40) NOT NULL default '0',
722 `bannedby` varchar(50) NOT NULL,
723 `banreason` varchar(255) NOT NULL,
724 `active` tinyint(4) NOT NULL default '1',
725 PRIMARY KEY (`guid`,`bandate`)
726) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Ban List';
727
728-- old/3.3.5a/10030_characters_item_soulbound_trade_data.sql
729DROP TABLE IF EXISTS `item_soulbound_trade_data`;
730CREATE TABLE `item_soulbound_trade_data` (
731 `itemGuid` int(11) unsigned NOT NULL COMMENT 'Item GUID',
732 `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade',
733 PRIMARY KEY (`itemGuid`)
734) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item Refund System';
735
736-- old/3.3.5a/10084_characters_character_queststatus.sql
737UPDATE `character_queststatus` SET `itemcount1` = 0 WHERE `itemcount1` > 65535;
738UPDATE `character_queststatus` SET `itemcount2` = 0 WHERE `itemcount2` > 65535;
739UPDATE `character_queststatus` SET `itemcount3` = 0 WHERE `itemcount3` > 65535;
740UPDATE `character_queststatus` SET `itemcount4` = 0 WHERE `itemcount4` > 65535;
741
742ALTER TABLE `character_queststatus` CHANGE `status` `status` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0,
743CHANGE `mobcount1` `mobcount1` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0,
744CHANGE `mobcount2` `mobcount2` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0,
745CHANGE `mobcount3` `mobcount3` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0,
746CHANGE `mobcount4` `mobcount4` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0,
747CHANGE `itemcount1` `itemcount1` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0,
748CHANGE `itemcount2` `itemcount2` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0,
749CHANGE `itemcount3` `itemcount3` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0,
750CHANGE `itemcount4` `itemcount4` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0;
751
752-- old/3.3.5a/10241_characters_guilds.sql
753ALTER TABLE guild_rank CHANGE COLUMN rid rid TINYINT(1) UNSIGNED NOT NULL;
754ALTER TABLE guild_bank_right CHANGE COLUMN rid rid TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
755
756-- old/3.3.5a/10475_characters_creature_respawn.sql
757DROP TABLE IF EXISTS `creature_respawn`;
758CREATE TABLE `creature_respawn` (
759 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
760 `respawntime` int(10) unsigned NOT NULL DEFAULT '0',
761 `instance` mediumint(8) unsigned NOT NULL DEFAULT '0',
762 PRIMARY KEY (`guid`,`instance`),
763 KEY `instance` (`instance`)
764) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
765
766
767-- old/3.3.5a/10475_characters_gameobject_respawn.sql
768DROP TABLE IF EXISTS `gameobject_respawn`;
769CREATE TABLE `gameobject_respawn` (
770 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
771 `respawntime` int(10) unsigned NOT NULL DEFAULT '0',
772 `instance` mediumint(8) unsigned NOT NULL DEFAULT '0',
773 PRIMARY KEY (`guid`,`instance`),
774 KEY `instance` (`instance`)
775) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
776
777
778-- old/3.3.5a/10475_characters_character_banned.sql
779ALTER TABLE character_banned ENGINE = InnoDB;
780
781-- old/3.3.5a/10475_characters_reserved_name.sql
782DROP TABLE IF EXISTS `reserved_name`;
783CREATE TABLE `reserved_name` (
784 `name` varchar(12) NOT NULL DEFAULT '',
785 PRIMARY KEY (`name`)
786) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names';
787
788
789-- old/3.3.5a/10543_characters_group_member.sql
790ALTER TABLE `group_member`
791CHANGE `guid` `guid` INT(11) UNSIGNED NOT NULL,
792CHANGE `memberGuid` `memberGuid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
793CHANGE `memberFlags` `memberFlags` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
794CHANGE `subgroup` `subgroup` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
795CHANGE `roles` `roles` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
796
797-- old/3.3.5a/10548_characters_channel.sql
798ALTER TABLE `channels`
799DROP COLUMN `m_moderate`,
800CHANGE `m_name` `m_name` VARCHAR(128) NOT NULL,
801CHANGE `m_announce` `m_announce` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL,
802CHANGE `m_public` `m_ownership` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL,
803CHANGE `m_password` `m_password` VARCHAR(32) NULL,
804ADD COLUMN `last_used` INT(10) UNSIGNED NOT NULL AFTER `BannedList`;
805-- Set already existing/current channels to use current timestamp (saves them from being unneccesarily cleaned up)
806UPDATE `channels` SET last_used = UNIX_TIMESTAMP();
807
808-- old/3.3.5a/10654_characters_item_instance.sql
809-- Add new column to item_instance table
810ALTER TABLE `item_instance` ADD COLUMN `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `guid`;
811
812-- Set values for new column from corresponding columns in other tables
813UPDATE item_instance ii, auctionhouse ah
814SET ii.itemEntry = ah.item_template
815WHERE ii.guid = ah.itemguid;
816
817UPDATE item_instance ii, character_inventory ci
818SET ii.itemEntry = ci.item_template
819WHERE ii.guid = ci.item;
820
821UPDATE item_instance ii, guild_bank_item gbi
822SET ii.itemEntry = gbi.item_entry
823WHERE ii.guid = gbi.item_guid;
824
825UPDATE item_instance ii, mail_items mi
826SET ii.itemEntry = mi.item_template
827WHERE ii.guid = mi.item_guid;
828
829-- Remove unnecessary columns
830ALTER TABLE `auctionhouse` DROP COLUMN `item_template`;
831ALTER TABLE `character_inventory` DROP COLUMN `item_template`;
832ALTER TABLE `guild_bank_item` DROP COLUMN `item_entry`;
833ALTER TABLE `mail_items` DROP COLUMN `item_template`;
834
835-- Delete orphan records (use at your own risk)
836-- DELETE FROM item_instance WHERE itemEntry = 0;
837
838-- old/3.3.5a/10741_characters_character_aura.sql
839ALTER TABLE `character_aura`
840 ADD COLUMN `item_guid` bigint(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `caster_guid`,
841 DROP PRIMARY KEY,
842 ADD PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`,`effect_mask`);
843
844-- old/3.3.5a/10777_characters_creature_respawn.sql
845ALTER TABLE `creature_respawn` CHANGE COLUMN `respawntime` `respawntime` bigint(20) unsigned NOT NULL DEFAULT 0;
846
847-- old/3.3.5a/10777_characters_gameobject_respawn.sql
848ALTER TABLE `gameobject_respawn` CHANGE COLUMN `respawntime` `respawntime` bigint(20) unsigned NOT NULL DEFAULT 0;
849
850-- old/3.3.5a/10828_characters_character_queststatus.sql
851DROP TABLE IF EXISTS `character_queststatus_rewarded`;
852CREATE TABLE `character_queststatus_rewarded` (
853 `guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
854 `quest` int(10) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
855 PRIMARY KEY (`guid`,`quest`)
856) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
857
858INSERT INTO character_queststatus_rewarded SELECT guid, quest FROM character_queststatus WHERE rewarded = 1;
859DELETE FROM character_queststatus WHERE rewarded = 1;
860
861ALTER TABLE character_queststatus DROP COLUMN rewarded;
862
863
864-- old/3.3.5a/2011_01_19_0_characters_account_data.sql
865ALTER TABLE `account_data`
866CHANGE `account` `account` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
867CHANGE `type` `type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
868CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
869CHANGE `data` `data` BLOB NOT NULL;
870-- old/3.3.5a/2011_01_19_0_characters_addons.sql
871ALTER TABLE `addons`
872ROW_FORMAT=DEFAULT,
873CHANGE `crc` `crc` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
874-- old/3.3.5a/2011_01_19_0_characters_arena_team.sql
875ALTER TABLE `arena_team`
876CHANGE `name` `name` VARCHAR(24) NOT NULL,
877CHANGE `EmblemStyle` `EmblemStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
878CHANGE `BorderStyle` `BorderStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
879-- old/3.3.5a/2011_01_19_0_characters_auctionhouse.sql
880ALTER TABLE `auctionhouse`
881CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
882CHANGE `auctioneerguid` `auctioneerguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
883CHANGE `itemguid` `itemguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
884CHANGE `itemowner` `itemowner` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
885CHANGE `buyoutprice` `buyoutprice` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
886CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
887CHANGE `buyguid` `buyguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
888CHANGE `lastbid` `lastbid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
889CHANGE `startbid` `startbid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
890CHANGE `deposit` `deposit` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
891-- old/3.3.5a/2011_01_19_0_characters_bugreport.sql
892ALTER TABLE `bugreport`
893ROW_FORMAT=DEFAULT,
894CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identifier';
895-- old/3.3.5a/2011_01_19_0_characters_corpse.sql
896ALTER TABLE `corpse`
897ROW_FORMAT=DEFAULT,
898CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
899CHANGE `player` `player` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier',
900DROP COLUMN `zone`,
901CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Map Identifier',
902CHANGE `phaseMask` `phaseMask` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL,
903CHANGE `flags` `flags` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
904CHANGE `dynFlags` `dynFlags` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
905CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
906CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
907-- old/3.3.5a/2011_01_19_0_characters_creature_respawn.sql
908ALTER TABLE `creature_respawn`
909CHANGE `respawntime` `respawntime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
910CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
911-- old/3.3.5a/2011_01_19_0_characters_game_event_condition_save.sql
912ALTER TABLE `game_event_condition_save`
913CHANGE `event_id` `event_id` SMALLINT(5) UNSIGNED NOT NULL,
914CHANGE `condition_id` `condition_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
915-- old/3.3.5a/2011_01_19_0_characters_channels.sql
916ALTER TABLE `channels`
917ROW_FORMAT=DEFAULT,
918CHANGE `BannedList` `BannedList` TEXT,
919DROP PRIMARY KEY,
920ADD PRIMARY KEY (`m_name`, `m_team`);
921-- old/3.3.5a/2011_01_19_0_characters_character_account_data.sql
922ALTER TABLE `character_account_data`
923CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
924CHANGE `type` `type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
925CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
926CHANGE `data` `data` BLOB NOT NULL;
927-- old/3.3.5a/2011_01_19_0_characters_character_action.sql
928ALTER TABLE `character_action`
929ROW_FORMAT=DEFAULT,
930CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
931CHANGE `action` `action` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
932-- old/3.3.5a/2011_01_19_0_characters_character_achievement_progress.sql
933ALTER TABLE `character_achievement_progress`
934CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
935CHANGE `criteria` `criteria` SMALLINT(5) UNSIGNED NOT NULL,
936CHANGE `counter` `counter` INT(10) UNSIGNED NOT NULL,
937CHANGE `date` `date` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
938-- old/3.3.5a/2011_01_19_0_characters_character_achievement.sql
939ALTER TABLE `character_achievement`
940CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
941CHANGE `achievement` `achievement` SMALLINT(5) UNSIGNED NOT NULL,
942CHANGE `date` `date` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
943-- old/3.3.5a/2011_01_19_0_characters_character_arena_stats.sql
944ALTER TABLE `character_arena_stats`
945ENGINE=InnoDB,
946CHANGE `slot` `slot` TINYINT(3) NOT NULL;
947-- old/3.3.5a/2011_01_19_0_characters_character_aura.sql
948ALTER TABLE `character_aura`
949ROW_FORMAT=DEFAULT,
950CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
951CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
952-- old/3.3.5a/2011_01_19_0_characters_character_banned.sql
953ALTER TABLE `character_banned`
954ROW_FORMAT=DEFAULT,
955CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Account id',
956CHANGE `bandate` `bandate` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
957CHANGE `unbandate` `unbandate` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
958CHANGE `active` `active` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL;
959-- old/3.3.5a/2011_01_19_0_characters_character_battleground_data.sql
960ALTER TABLE `character_battleground_data`
961ROW_FORMAT=DEFAULT,
962CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
963CHANGE `instance_id` `instance_id` INT(10) UNSIGNED NOT NULL,
964CHANGE `team` `team` SMALLINT(5) UNSIGNED NOT NULL,
965CHANGE `join_map` `join_map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
966CHANGE `taxi_start` `taxi_start` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
967CHANGE `taxi_end` `taxi_end` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
968CHANGE `mount_spell` `mount_spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
969-- old/3.3.5a/2011_01_19_0_characters_character_battleground_random.sql
970ALTER TABLE `character_battleground_random`
971CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
972-- old/3.3.5a/2011_01_19_0_characters_character_declinedname.sql
973ALTER TABLE `character_declinedname`
974ROW_FORMAT=DEFAULT,
975CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier';
976-- old/3.3.5a/2011_01_19_0_characters_character_equipmentsets.sql
977ALTER TABLE `character_equipmentsets`
978CHANGE `guid` `guid` INT(10) DEFAULT '0' NOT NULL,
979CHANGE `setindex` `setindex` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
980CHANGE `name` `name` VARCHAR(31) NOT NULL,
981CHANGE `item0` `item0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
982CHANGE `item1` `item1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
983CHANGE `item2` `item2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
984CHANGE `item3` `item3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
985CHANGE `item4` `item4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
986CHANGE `item5` `item5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
987CHANGE `item6` `item6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
988CHANGE `item7` `item7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
989CHANGE `item8` `item8` INT(10) UNSIGNED NOT NULL DEFAULT '0',
990CHANGE `item9` `item9` INT(10) UNSIGNED NOT NULL DEFAULT '0',
991CHANGE `item10` `item10` INT(10) UNSIGNED NOT NULL DEFAULT '0',
992CHANGE `item11` `item11` INT(10) UNSIGNED NOT NULL DEFAULT '0',
993CHANGE `item12` `item12` INT(10) UNSIGNED NOT NULL DEFAULT '0',
994CHANGE `item13` `item13` INT(10) UNSIGNED NOT NULL DEFAULT '0',
995CHANGE `item14` `item14` INT(10) UNSIGNED NOT NULL DEFAULT '0',
996CHANGE `item15` `item15` INT(10) UNSIGNED NOT NULL DEFAULT '0',
997CHANGE `item16` `item16` INT(10) UNSIGNED NOT NULL DEFAULT '0',
998CHANGE `item17` `item17` INT(10) UNSIGNED NOT NULL DEFAULT '0',
999CHANGE `item18` `item18` INT(10) UNSIGNED NOT NULL DEFAULT '0';
1000-- old/3.3.5a/2011_01_19_0_characters_character_gifts.sql
1001ALTER TABLE `character_gifts`
1002CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1003CHANGE `item_guid` `item_guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1004CHANGE `entry` `entry` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1005CHANGE `flags` `flags` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1006-- old/3.3.5a/2011_01_19_0_characters_character_glyphs.sql
1007ALTER TABLE `character_glyphs`
1008CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
1009CHANGE `glyph1` `glyph1` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1010CHANGE `glyph2` `glyph2` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ,
1011CHANGE `glyph3` `glyph3` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ,
1012CHANGE `glyph4` `glyph4` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ,
1013CHANGE `glyph5` `glyph5` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ,
1014CHANGE `glyph6` `glyph6` SMALLINT(5) UNSIGNED DEFAULT '0' NULL ;
1015-- old/3.3.5a/2011_01_19_0_characters_character_homebind.sql
1016ALTER TABLE `character_homebind`
1017ROW_FORMAT=DEFAULT,
1018CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1019CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Map Identifier',
1020CHANGE `zone` `zone` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Zone Identifier';
1021-- old/3.3.5a/2011_01_19_0_characters_character_instance.sql
1022ALTER TABLE `character_instance`
1023CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1024CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1025CHANGE `permanent` `permanent` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
1026-- old/3.3.5a/2011_01_19_0_characters_character_inventory.sql
1027ALTER TABLE `character_inventory`
1028ROW_FORMAT=DEFAULT,
1029CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1030CHANGE `bag` `bag` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1031CHANGE `item` `item` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Item Global Unique Identifier';
1032-- old/3.3.5a/2011_01_19_0_characters_character_pet_declinedname.sql
1033ALTER TABLE `character_pet_declinedname`
1034ROW_FORMAT=DEFAULT,
1035CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1036CHANGE `owner` `owner` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1037-- old/3.3.5a/2011_01_19_0_characters_character_pet.sql
1038ALTER TABLE `character_pet`
1039ROW_FORMAT=DEFAULT,
1040CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1041CHANGE `entry` `entry` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1042CHANGE `owner` `owner` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1043CHANGE `modelid` `modelid` INT(10) UNSIGNED DEFAULT '0' NULL ,
1044CHANGE `CreatedBySpell` `CreatedBySpell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
1045CHANGE `level` `level` SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL,
1046CHANGE `exp` `exp` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1047CHANGE `Reactstate` `Reactstate` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1048CHANGE `name` `name` VARCHAR(21) DEFAULT 'Pet' NOT NULL,
1049CHANGE `renamed` `renamed` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1050CHANGE `slot` `slot` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1051CHANGE `curhealth` `curhealth` INT(10) UNSIGNED DEFAULT '1' NOT NULL,
1052CHANGE `curmana` `curmana` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1053CHANGE `curhappiness` `curhappiness` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1054CHANGE `savetime` `savetime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1055CHANGE `resettalents_cost` `resettalents_cost` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1056CHANGE `resettalents_time` `resettalents_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1057CHANGE `abdata` `abdata` TEXT NULL;
1058-- old/3.3.5a/2011_01_19_0_characters_character_queststatus_daily.sql
1059ALTER TABLE `character_queststatus_daily`
1060ROW_FORMAT=DEFAULT,
1061CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1062CHANGE `quest` `quest` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Quest Identifier',
1063CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1064-- old/3.3.5a/2011_01_19_0_characters_character_queststatus.sql
1065ALTER TABLE `character_queststatus`
1066ROW_FORMAT=DEFAULT,
1067CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1068CHANGE `quest` `quest` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Quest Identifier',
1069CHANGE `status` `status` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1070CHANGE `explored` `explored` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1071CHANGE `timer` `timer` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1072CHANGE `mobcount1` `mobcount1` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1073CHANGE `mobcount2` `mobcount2` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1074CHANGE `mobcount3` `mobcount3` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1075CHANGE `mobcount4` `mobcount4` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1076CHANGE `itemcount1` `itemcount1` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1077CHANGE `itemcount2` `itemcount2` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1078CHANGE `itemcount3` `itemcount3` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1079CHANGE `itemcount4` `itemcount4` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
1080-- old/3.3.5a/2011_01_19_0_characters_character_queststatus_weekly.sql
1081ALTER TABLE `character_queststatus_weekly`
1082ROW_FORMAT=DEFAULT,
1083CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1084CHANGE `quest` `quest` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Quest Identifier';
1085-- old/3.3.5a/2011_01_19_0_characters_character_reputation.sql
1086ALTER TABLE `character_reputation`
1087ROW_FORMAT=DEFAULT,
1088CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1089CHANGE `faction` `faction` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1090CHANGE `flags` `flags` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
1091-- old/3.3.5a/2011_01_19_0_characters_character_skills.sql
1092ALTER TABLE `character_skills`
1093ROW_FORMAT=DEFAULT,
1094CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL COMMENT 'Global Unique Identifier',
1095CHANGE `skill` `skill` SMALLINT(5) UNSIGNED NOT NULL,
1096CHANGE `value` `value` SMALLINT(5) UNSIGNED NOT NULL,
1097CHANGE `max` `max` SMALLINT(5) UNSIGNED NOT NULL;
1098-- old/3.3.5a/2011_01_19_0_characters_character_social.sql
1099ALTER TABLE `character_social`
1100ROW_FORMAT=DEFAULT,
1101CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier',
1102CHANGE `friend` `friend` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Friend Global Unique Identifier',
1103CHANGE `flags` `flags` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Friend Flags',
1104DROP INDEX `guid`,
1105DROP INDEX `guid_flags`,
1106DROP INDEX `friend_flags`;
1107-- old/3.3.5a/2011_01_19_0_characters_character_spell_cooldown.sql
1108ALTER TABLE `character_spell_cooldown`
1109CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier, Low part',
1110CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Spell Identifier',
1111CHANGE `item` `item` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Item Identifier',
1112CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1113-- old/3.3.5a/2011_01_19_0_characters_character_spell.sql
1114ALTER TABLE `character_spell`
1115ROW_FORMAT=DEFAULT,
1116CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1117CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Spell Identifier';
1118-- old/3.3.5a/2011_01_19_0_characters_characters.sql
1119ALTER TABLE `characters`
1120ROW_FORMAT=DEFAULT,
1121CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1122CHANGE `account` `account` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Account Identifier',
1123CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Map Identifier',
1124CHANGE `instance_id` `instance_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1125CHANGE `instance_mode_mask` `instance_mode_mask` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1126CHANGE `taximask` `taximask` TEXT NOT NULL,
1127CHANGE `totaltime` `totaltime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1128CHANGE `leveltime` `leveltime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1129CHANGE `logout_time` `logout_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1130CHANGE `resettalents_cost` `resettalents_cost` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1131CHANGE `resettalents_time` `resettalents_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1132CHANGE `transguid` `transguid` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
1133CHANGE `extra_flags` `extra_flags` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1134CHANGE `stable_slots` `stable_slots` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1135CHANGE `at_login` `at_login` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1136CHANGE `zone` `zone` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1137CHANGE `death_expire_time` `death_expire_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1138CHANGE `watchedFaction` `watchedFaction` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1139CHANGE `latency` `latency` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
1140CHANGE `deleteInfos_Account` `deleteInfos_Account` INT(10) UNSIGNED NULL ,
1141CHANGE `deleteDate` `deleteDate` INT(10) UNSIGNED NULL ;
1142-- old/3.3.5a/2011_01_19_0_characters_character_stats.sql
1143ALTER TABLE `character_stats`
1144CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier, Low part';
1145-- old/3.3.5a/2011_01_19_0_characters_character_talent.sql
1146ALTER TABLE `character_talent`
1147CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
1148CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED NOT NULL;
1149-- old/3.3.5a/2011_01_19_0_characters_character_tutorial.sql
1150ALTER TABLE `character_tutorial`
1151ROW_FORMAT=DEFAULT,
1152CHANGE `account` `account` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Account Identifier',
1153DROP PRIMARY KEY,
1154ADD PRIMARY KEY (`account`),
1155DROP `realmid`,
1156CHANGE `tut0` `tut0` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1157CHANGE `tut1` `tut1` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1158CHANGE `tut2` `tut2` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1159CHANGE `tut3` `tut3` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1160CHANGE `tut4` `tut4` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1161CHANGE `tut5` `tut5` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1162CHANGE `tut6` `tut6` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1163CHANGE `tut7` `tut7` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1164DROP KEY `acc_key`;
1165
1166
1167
1168-- old/3.3.5a/2011_01_20_0_characters_game_event_save.sql
1169ALTER TABLE `game_event_save`
1170CHANGE `event_id` `event_id` SMALLINT(5) UNSIGNED NOT NULL,
1171CHANGE `next_start` `next_start` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1172-- old/3.3.5a/2011_01_20_0_characters_gameobject_respawn.sql
1173ALTER TABLE `gameobject_respawn`
1174CHANGE `respawntime` `respawntime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1175CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1176-- old/3.3.5a/2011_01_20_0_characters_gm_subsurveys.sql
1177ALTER TABLE `gm_subsurveys`
1178ROW_FORMAT=DEFAULT,
1179CHANGE `surveyid` `surveyid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1180CHANGE `subsurveyid` `subsurveyid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1181CHANGE `rank` `rank` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1182CHANGE `comment` `comment` TEXT NOT NULL;
1183-- old/3.3.5a/2011_01_20_0_characters_gm_surveys.sql
1184ALTER TABLE `gm_surveys`
1185ROW_FORMAT=DEFAULT,
1186CHANGE `surveyid` `surveyid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1187CHANGE `player` `player` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1188CHANGE `mainSurvey` `mainSurvey` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1189CHANGE `timestamp` `timestamp` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1190-- old/3.3.5a/2011_01_20_0_characters_gm_tickets.sql
1191ALTER TABLE `gm_tickets`
1192ROW_FORMAT=DEFAULT,
1193CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1194CHANGE `playerGuid` `playerGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1195CHANGE `name` `name` VARCHAR(12) NOT NULL,
1196CHANGE `createtime` `createtime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1197CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1198CHANGE `timestamp` `timestamp` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1199CHANGE `closed` `closed` INT(11) DEFAULT '0' NOT NULL,
1200CHANGE `assignedto` `assignedto` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1201CHANGE `completed` `completed` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1202CHANGE `escalated` `escalated` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1203CHANGE `viewed` `viewed` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
1204-- old/3.3.5a/2011_01_20_0_characters_group_instance.sql
1205ALTER TABLE `group_instance`
1206CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1207CHANGE `instance` `instance` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1208CHANGE `permanent` `permanent` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
1209-- old/3.3.5a/2011_01_20_0_characters_group_member.sql
1210ALTER TABLE `group_member`
1211ROW_FORMAT=DEFAULT,
1212CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
1213CHANGE `memberGuid` `memberGuid` INT(10) UNSIGNED NOT NULL;
1214-- old/3.3.5a/2011_01_20_0_characters_groups.sql
1215ALTER TABLE `groups`
1216ROW_FORMAT=DEFAULT,
1217CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
1218CHANGE `leaderGuid` `leaderGuid` INT(10) UNSIGNED NOT NULL,
1219CHANGE `lootMethod` `lootMethod` TINYINT(3) UNSIGNED NOT NULL,
1220CHANGE `looterGuid` `looterGuid` INT(10) UNSIGNED NOT NULL,
1221CHANGE `lootThreshold` `lootThreshold` TINYINT(3) UNSIGNED NOT NULL,
1222CHANGE `icon1` `icon1` INT(10) UNSIGNED NOT NULL,
1223CHANGE `icon2` `icon2` INT(10) UNSIGNED NOT NULL,
1224CHANGE `icon3` `icon3` INT(10) UNSIGNED NOT NULL,
1225CHANGE `icon4` `icon4` INT(10) UNSIGNED NOT NULL,
1226CHANGE `icon5` `icon5` INT(10) UNSIGNED NOT NULL,
1227CHANGE `icon6` `icon6` INT(10) UNSIGNED NOT NULL,
1228CHANGE `icon7` `icon7` INT(10) UNSIGNED NOT NULL,
1229CHANGE `icon8` `icon8` INT(10) UNSIGNED NOT NULL,
1230CHANGE `groupType` `groupType` TINYINT(3) UNSIGNED NOT NULL,
1231CHANGE `raiddifficulty` `raiddifficulty` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
1232-- old/3.3.5a/2011_01_20_0_characters_guild_bank_eventlog.sql
1233ALTER TABLE `guild_bank_eventlog`
1234CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Guild Identificator',
1235CHANGE `LogGuid` `LogGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Log record identificator - auxiliary column',
1236CHANGE `PlayerGuid` `PlayerGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1237CHANGE `ItemOrMoney` `ItemOrMoney` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1238CHANGE `ItemStackCount` `ItemStackCount` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
1239CHANGE `DestTabId` `DestTabId` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Destination Tab Id',
1240CHANGE `TimeStamp` `TimeStamp` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Event UNIX time';
1241-- old/3.3.5a/2011_01_20_0_characters_guild_bank_item.sql
1242ALTER TABLE `guild_bank_item`
1243CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1244CHANGE `TabId` `TabId` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1245CHANGE `item_guid` `item_guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1246-- old/3.3.5a/2011_01_20_0_characters_guild_bank_right.sql
1247ALTER TABLE `guild_bank_right`
1248CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1249CHANGE `TabId` `TabId` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1250CHANGE `rid` `rid` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1251CHANGE `SlotPerDay` `SlotPerDay` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1252-- old/3.3.5a/2011_01_20_0_characters_guild_bank_tab.sql
1253ALTER TABLE `guild_bank_tab`
1254CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1255CHANGE `TabId` `TabId` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1256CHANGE `TabName` `TabName` VARCHAR(16) DEFAULT '' NOT NULL,
1257CHANGE `TabText` `TabText` VARCHAR(500) NULL;
1258-- old/3.3.5a/2011_01_20_0_characters_guild_eventlog.sql
1259ALTER TABLE `guild_eventlog`
1260CHANGE `guildid` `guildid` INT(10) UNSIGNED NOT NULL COMMENT 'Guild Identificator',
1261CHANGE `LogGuid` `LogGuid` INT(10) UNSIGNED NOT NULL COMMENT 'Log record identificator - auxiliary column',
1262CHANGE `EventType` `EventType` TINYINT(3) UNSIGNED NOT NULL COMMENT 'Event type',
1263CHANGE `PlayerGuid1` `PlayerGuid1` INT(10) UNSIGNED NOT NULL COMMENT 'Player 1',
1264CHANGE `PlayerGuid2` `PlayerGuid2` INT(10) UNSIGNED NOT NULL COMMENT 'Player 2',
1265CHANGE `NewRank` `NewRank` TINYINT(3) UNSIGNED NOT NULL COMMENT 'New rank(in case promotion/demotion)',
1266CHANGE `TimeStamp` `TimeStamp` INT(10) UNSIGNED NOT NULL COMMENT 'Event UNIX time';
1267-- old/3.3.5a/2011_01_20_0_characters_guild_member.sql
1268ALTER TABLE `guild_member`
1269ROW_FORMAT=DEFAULT,
1270CHANGE `guildid` `guildid` INT(10) UNSIGNED NOT NULL COMMENT 'Guild Identificator',
1271CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL,
1272CHANGE `rank` `rank` TINYINT(3) UNSIGNED NOT NULL,
1273CHANGE `pnote` `pnote` varchar(31) NOT NULL DEFAULT '',
1274CHANGE `offnote` `offnote` varchar(31) NOT NULL DEFAULT '',
1275CHANGE `BankResetTimeMoney` `BankResetTimeMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1276CHANGE `BankRemMoney` `BankRemMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1277CHANGE `BankResetTimeTab0` `BankResetTimeTab0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1278CHANGE `BankRemSlotsTab0` `BankRemSlotsTab0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1279CHANGE `BankResetTimeTab1` `BankResetTimeTab1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1280CHANGE `BankRemSlotsTab1` `BankRemSlotsTab1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1281CHANGE `BankResetTimeTab2` `BankResetTimeTab2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1282CHANGE `BankRemSlotsTab2` `BankRemSlotsTab2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1283CHANGE `BankResetTimeTab3` `BankResetTimeTab3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1284CHANGE `BankRemSlotsTab3` `BankRemSlotsTab3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1285CHANGE `BankResetTimeTab4` `BankResetTimeTab4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1286CHANGE `BankRemSlotsTab4` `BankRemSlotsTab4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1287CHANGE `BankResetTimeTab5` `BankResetTimeTab5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
1288CHANGE `BankRemSlotsTab5` `BankRemSlotsTab5` INT(10) UNSIGNED NOT NULL DEFAULT '0';
1289-- old/3.3.5a/2011_01_20_0_characters_guild_rank.sql
1290ALTER TABLE `guild_rank`
1291ROW_FORMAT=DEFAULT,
1292CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1293CHANGE `rid` `rid` TINYINT(3) UNSIGNED NOT NULL,
1294CHANGE `rname` `rname` VARCHAR(15) DEFAULT '' NOT NULL,
1295CHANGE `rights` `rights` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
1296CHANGE `BankMoneyPerDay` `BankMoneyPerDay` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1297-- old/3.3.5a/2011_01_20_0_characters_guild.sql
1298ALTER TABLE `guild`
1299ROW_FORMAT=DEFAULT,
1300CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1301CHANGE `name` `name` VARCHAR(24) DEFAULT '' NOT NULL,
1302CHANGE `leaderguid` `leaderguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1303CHANGE `EmblemStyle` `EmblemStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1304CHANGE `EmblemColor` `EmblemColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1305CHANGE `BorderStyle` `BorderStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1306CHANGE `BorderColor` `BorderColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1307CHANGE `BackgroundColor` `BackgroundColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1308CHANGE `motd` `motd` VARCHAR(128) DEFAULT '' NOT NULL,
1309CHANGE `createdate` `createdate` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1310CHANGE `BankMoney` `BankMoney` BIGINT(20) UNSIGNED DEFAULT '0' NOT NULL;
1311-- old/3.3.5a/2011_01_20_0_characters_instance_reset.sql
1312ALTER TABLE `instance_reset`
1313CHANGE `mapid` `mapid` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1314CHANGE `difficulty` `difficulty` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1315CHANGE `resettime` `resettime` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1316-- old/3.3.5a/2011_01_20_0_characters_instance.sql
1317ALTER TABLE `instance`
1318CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1319CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1320CHANGE `resettime` `resettime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1321CHANGE `difficulty` `difficulty` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1322CHANGE `data` `data` TINYTEXT NOT NULL;
1323-- old/3.3.5a/2011_01_20_0_characters_item_instance.sql
1324ALTER TABLE `item_instance`
1325ROW_FORMAT=DEFAULT,
1326CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1327CHANGE `owner_guid` `owner_guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1328CHANGE `charges` `charges` TINYTEXT,
1329CHANGE `duration` `duration` INT(10) DEFAULT '0' NOT NULL,
1330CHANGE `flags` `flags` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
1331CHANGE `randomPropertyId` `randomPropertyId` SMALLINT(5) DEFAULT '0' NOT NULL,
1332CHANGE `durability` `durability` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1333CHANGE `text` `text` TEXT NULL;
1334
1335-- old/3.3.5a/2011_01_20_0_characters_item_refund_instance.sql
1336ALTER TABLE `item_refund_instance`
1337ROW_FORMAT=DEFAULT,
1338CHANGE `item_guid` `item_guid` INT(10) UNSIGNED NOT NULL COMMENT 'Item GUID',
1339CHANGE `player_guid` `player_guid` INT(10) UNSIGNED NOT NULL COMMENT 'Player GUID',
1340CHANGE `paidMoney` `paidMoney` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1341CHANGE `paidExtendedCost` `paidExtendedCost` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
1342-- old/3.3.5a/2011_01_20_0_characters_item_soulbound_trace_data.sql
1343ALTER TABLE `item_soulbound_trade_data`
1344ROW_FORMAT=DEFAULT,
1345CHANGE `itemGuid` `itemGuid` INT(10) UNSIGNED NOT NULL COMMENT 'Item GUID';
1346-- old/3.3.5a/2011_01_20_0_characters_lag_reports.sql
1347ALTER TABLE `lag_reports`
1348ROW_FORMAT=DEFAULT,
1349CHANGE `report_id` `report_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1350CHANGE `player` `player` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1351CHANGE `lag_type` `lag_type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
1352CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
1353-- old/3.3.5a/2011_01_20_0_characters_mail_items.sql
1354ALTER TABLE `mail_items`
1355CHANGE `mail_id` `mail_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1356CHANGE `item_guid` `item_guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1357CHANGE `receiver` `receiver` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier';
1358-- old/3.3.5a/2011_01_20_0_characters_mail.sql
1359ALTER TABLE `mail`
1360ROW_FORMAT=DEFAULT,
1361CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Identifier',
1362CHANGE `mailTemplateId` `mailTemplateId` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
1363CHANGE `sender` `sender` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier',
1364CHANGE `receiver` `receiver` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Character Global Unique Identifier',
1365CHANGE `expire_time` `expire_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1366CHANGE `deliver_time` `deliver_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1367CHANGE `money` `money` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1368CHANGE `cod` `cod` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1369
1370
1371-- old/3.3.5a/2011_01_20_0_characters_pet_aura.sql
1372ALTER TABLE `pet_aura`
1373ROW_FORMAT=DEFAULT,
1374CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1375CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
1376CHANGE `amount0` `amount0` MEDIUMINT(8) NOT NULL,
1377CHANGE `amount1` `amount1` MEDIUMINT(8) NOT NULL,
1378CHANGE `amount2` `amount2` MEDIUMINT(8) NOT NULL,
1379CHANGE `base_amount0` `base_amount0` MEDIUMINT(8) NOT NULL,
1380CHANGE `base_amount1` `base_amount1` MEDIUMINT(8) NOT NULL,
1381CHANGE `base_amount2` `base_amount2` MEDIUMINT(8) NOT NULL;
1382-- old/3.3.5a/2011_01_20_0_characters_petition_sign.sql
1383ALTER TABLE `petition_sign`
1384ROW_FORMAT=DEFAULT,
1385CHANGE `petitionguid` `petitionguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1386CHANGE `playerguid` `playerguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1387CHANGE `player_account` `player_account` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1388CHANGE `type` `type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
1389-- old/3.3.5a/2011_01_20_0_characters_petition.sql
1390ALTER TABLE `petition`
1391ROW_FORMAT=DEFAULT,
1392CHANGE `name` `name` VARCHAR(24) NOT NULL,
1393CHANGE `type` `type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
1394-- old/3.3.5a/2011_01_20_0_characters_pet_spell_cooldown.sql
1395ALTER TABLE `pet_spell_cooldown`
1396CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier, Low part',
1397CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Spell Identifier',
1398CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
1399-- old/3.3.5a/2011_01_20_0_characters_pet_spell.sql
1400ALTER TABLE `pet_spell`
1401ROW_FORMAT=DEFAULT,
1402CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Global Unique Identifier',
1403CHANGE `spell` `spell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Spell Identifier',
1404CHANGE `active` `active` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
1405-- old/3.3.5a/2011_01_20_0_characters_worldstates.sql
1406ALTER TABLE `worldstates`
1407ROW_FORMAT=DEFAULT,
1408CHANGE `entry` `entry` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1409CHANGE `value` `value` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
1410CHANGE `comment` `comment` TINYTEXT;
1411
1412-- old/3.3.5a/2011_01_22_1_characters_character_inventory.sql
1413ALTER TABLE `character_inventory`
1414ADD UNIQUE KEY (`guid`,`bag`,`slot`);
1415
1416-- old/3.3.5a/2011_01_24_0_characters_account_instance_times.sql
1417--
1418-- Table structure for table `account_instance_times`
1419--
1420DROP TABLE IF EXISTS `account_instance_times`;
1421CREATE TABLE `account_instance_times` (
1422 `accountId` int(10) unsigned NOT NULL,
1423 `instanceId` int(10) unsigned NOT NULL DEFAULT '0',
1424 `releaseTime` bigint(20) unsigned NOT NULL DEFAULT '0',
1425 PRIMARY KEY (`accountId`,`instanceId`)
1426) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1427
1428-- .2011_02_03_0_characters_instance.sql
1429ALTER TABLE `instance` ADD COLUMN `completedEncounters` int(10) unsigned NOT NULL DEFAULT '0' AFTER `difficulty`;
1430-- .2011_02_24_0_characters_account_data.sql
1431ALTER TABLE `account_data` CHANGE COLUMN `account` `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier';
1432-- .2011_02_24_1_characters_character_tutorial.sql
1433RENAME TABLE `character_tutorial` TO `account_tutorial`;
1434ALTER TABLE `account_tutorial` CHANGE COLUMN `account` `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier';