1 ALTER TABLE `areatrigger_template` MODIFY COLUMN `required_level` tinyint(3) unsigned NOT NULL default '0';
2 ALTER TABLE `item_template` MODIFY COLUMN `DisenchantID` int(11) unsigned NOT NULL default '0';
4 ALTER TABLE `auctionhouse` MODIFY COLUMN `id` int(11) unsigned NOT NULL default '0';
6 ALTER TABLE `corpse` MODIFY COLUMN `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier';
8 ALTER TABLE `creature_template`
9 MODIFY COLUMN `rangedattackpower` smallint(5) unsigned NOT NULL default '0',
10 MODIFY COLUMN `type` tinyint(3) unsigned default '0';
12 ALTER TABLE `disenchant_loot_template` MODIFY COLUMN `entry` int(11) unsigned NOT NULL default '0' COMMENT 'Recommended id selection: item_level*100 + item_quality';
14 UPDATE `item_template` SET `stat_type1`='0' WHERE `stat_type1`<'0';
15 UPDATE `item_template` SET `stat_type2`='0' WHERE `stat_type2`<'0';
16 UPDATE `item_template` SET `stat_type3`='0' WHERE `stat_type3`<'0';
17 UPDATE `item_template` SET `stat_type4`='0' WHERE `stat_type4`<'0';
18 UPDATE `item_template` SET `stat_type5`='0' WHERE `stat_type5`<'0';
19 UPDATE `item_template` SET `stat_type6`='0' WHERE `stat_type6`<'0';
20 UPDATE `item_template` SET `stat_type7`='0' WHERE `stat_type7`<'0';
21 UPDATE `item_template` SET `stat_type8`='0' WHERE `stat_type8`<'0';
22 UPDATE `item_template` SET `stat_type9`='0' WHERE `stat_type9`<'0';
23 UPDATE `item_template` SET `stat_type10`='0' WHERE `stat_type10`<'0';
25 ALTER TABLE `item_template`
26 MODIFY COLUMN `AllowableClass` mediumint(9) NOT NULL default '0',
27 MODIFY COLUMN `AllowableRace` mediumint(9) NOT NULL default '0',
28 MODIFY COLUMN `stat_type1` tinyint(4) unsigned NOT NULL default '0',
29 MODIFY COLUMN `stat_value1` smallint(6) NOT NULL default '0',
30 MODIFY COLUMN `stat_type2` tinyint(4) unsigned NOT NULL default '0',
31 MODIFY COLUMN `stat_value2` smallint(6) NOT NULL default '0',
32 MODIFY COLUMN `stat_type3` tinyint(4) unsigned NOT NULL default '0',
33 MODIFY COLUMN `stat_value3` smallint(6) NOT NULL default '0',
34 MODIFY COLUMN `stat_type4` tinyint(4) unsigned NOT NULL default '0',
35 MODIFY COLUMN `stat_value4` smallint(6) NOT NULL default '0',
36 MODIFY COLUMN `stat_type5` tinyint(4) unsigned NOT NULL default '0',
37 MODIFY COLUMN `stat_value5` smallint(6) NOT NULL default '0',
38 MODIFY COLUMN `stat_type6` tinyint(4) unsigned NOT NULL default '0',
39 MODIFY COLUMN `stat_value6` smallint(6) NOT NULL default '0',
40 MODIFY COLUMN `stat_type7` tinyint(4) unsigned NOT NULL default '0',
41 MODIFY COLUMN `stat_value7` smallint(6) NOT NULL default '0',
42 MODIFY COLUMN `stat_type8` tinyint(4) unsigned NOT NULL default '0',
43 MODIFY COLUMN `stat_value8` smallint(6) NOT NULL default '0',
44 MODIFY COLUMN `stat_type9` tinyint(4) unsigned NOT NULL default '0',
45 MODIFY COLUMN `stat_value9` smallint(6) NOT NULL default '0',
46 MODIFY COLUMN `stat_type10` tinyint(4) unsigned NOT NULL default '0',
47 MODIFY COLUMN `stat_value10` smallint(6) NOT NULL default '0',
48 MODIFY COLUMN `dmg_type1` tinyint(3) unsigned NOT NULL default '0',
49 MODIFY COLUMN `dmg_type2` tinyint(3) unsigned NOT NULL default '0',
50 MODIFY COLUMN `dmg_type3` tinyint(3) unsigned NOT NULL default '0',
51 MODIFY COLUMN `dmg_type4` tinyint(3) unsigned NOT NULL default '0',
52 MODIFY COLUMN `dmg_type5` tinyint(3) unsigned NOT NULL default '0',
53 MODIFY COLUMN `Material` int(30) NOT NULL default '0';
55 ALTER TABLE `pet_name_generation` ENGINE=MyISAM, DEFAULT CHARSET=utf8;
56 ALTER TABLE `pet_name_generation` MODIFY COLUMN `word` tinytext NOT NULL;
58 ALTER TABLE `quest_template`
59 MODIFY COLUMN `ReqSourceId1` int(11) unsigned NOT NULL default '0',
60 MODIFY COLUMN `ReqSourceId2` int(11) unsigned NOT NULL default '0',
61 MODIFY COLUMN `ReqSourceId3` int(11) unsigned NOT NULL default '0',
62 MODIFY COLUMN `ReqSourceId4` int(11) unsigned NOT NULL default '0',
63 MODIFY COLUMN `RewRepFaction1` int(11) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
64 MODIFY COLUMN `RewRepFaction2` int(11) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
65 MODIFY COLUMN `RewRepFaction3` int(11) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
66 MODIFY COLUMN `RewRepFaction4` int(11) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
67 MODIFY COLUMN `RewRepFaction5` int(11) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case';
69 ALTER TABLE `scripts` ENGINE=MyISAM, DEFAULT CHARSET=utf8;
70 ALTER TABLE `scripts` MODIFY COLUMN `datatext` text NOT NULL;
72 ALTER TABLE `spell_proc_event` ENGINE=MyISAM, DEFAULT CHARSET=utf8;
74 ALTER TABLE `spell_scripts` ENGINE=MyISAM, DEFAULT CHARSET=utf8;