| blob | d04847d91d7eb4120edfbaa4c0f793f391ce2eb8 |
1 -- Then update all tables
2 ALTER TABLE `areatrigger_involvedrelation`
3 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier',
4 CHANGE COLUMN `quest` `quest` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier';
5 ALTER TABLE `areatrigger_tavern`
6 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier';
7 ALTER TABLE `areatrigger_teleport`
8 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier',
9 CHANGE COLUMN `required_level` `required_level` tinyint unsigned NOT NULL DEFAULT 0,
10 CHANGE COLUMN `required_item` `required_item` mediumint unsigned NOT NULL DEFAULT 0,
11 CHANGE COLUMN `target_map` `target_map` smallint unsigned NOT NULL DEFAULT 0;
12 ALTER TABLE `battleground_template`
13 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL,
14 CHANGE COLUMN `MinPlayersPerTeam` `MinPlayersPerTeam` smallint unsigned NOT NULL DEFAULT 0,
15 CHANGE COLUMN `MaxPlayersPerTeam` `MaxPlayersPerTeam` smallint unsigned NOT NULL DEFAULT 0,
16 CHANGE COLUMN `MinLvl` `MinLvl` tinyint unsigned NOT NULL DEFAULT 0,
17 CHANGE COLUMN `MaxLvl` `MaxLvl` tinyint unsigned NOT NULL DEFAULT 0,
18 CHANGE COLUMN `AllianceStartLoc` `AllianceStartLoc` mediumint unsigned NOT NULL,
19 CHANGE COLUMN `HordeStartLoc` `HordeStartLoc` mediumint unsigned NOT NULL;
20 ALTER TABLE `battlemaster_entry`
21 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Entry of a creature',
22 CHANGE COLUMN `bg_template` `bg_template` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Battleground template id';
23 ALTER TABLE `command`
24 CHANGE COLUMN `security` `security` tinyint unsigned NOT NULL DEFAULT 0;
25 ALTER TABLE `creature`
26 CHANGE COLUMN `guid` `guid` integer unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
27 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Creature Identifier',
28 CHANGE COLUMN `map` `map` smallint unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier',
29 CHANGE COLUMN `modelid` `modelid` mediumint unsigned NOT NULL DEFAULT 0,
30 CHANGE COLUMN `equipment_id` `equipment_id` mediumint NOT NULL DEFAULT 0,
31 CHANGE COLUMN `spawntimesecs` `spawntimesecs` integer unsigned NOT NULL DEFAULT 120,
32 CHANGE COLUMN `currentwaypoint` `currentwaypoint` mediumint unsigned NOT NULL DEFAULT 0,
33 CHANGE COLUMN `curhealth` `curhealth` integer unsigned NOT NULL DEFAULT 1,
34 CHANGE COLUMN `curmana` `curmana` integer unsigned NOT NULL DEFAULT 0,
35 CHANGE COLUMN `DeathState` `DeathState` tinyint unsigned NOT NULL DEFAULT 0,
36 CHANGE COLUMN `MovementType` `MovementType` tinyint unsigned NOT NULL DEFAULT 0;
37 ALTER TABLE `creature_addon`
38 CHANGE COLUMN `guid` `guid` integer NOT NULL DEFAULT 0,
39 CHANGE COLUMN `mount` `mount` mediumint unsigned NOT NULL DEFAULT 0,
40 CHANGE COLUMN `bytes0` `bytes0` integer unsigned NOT NULL DEFAULT 0,
41 CHANGE COLUMN `bytes1` `bytes1` integer unsigned NOT NULL DEFAULT 0,
42 CHANGE COLUMN `bytes2` `bytes2` integer unsigned NOT NULL DEFAULT 0,
43 CHANGE COLUMN `emote` `emote` integer unsigned NOT NULL DEFAULT 0;
44 ALTER TABLE `creature_equip_template`
45 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Unique entry',
46 CHANGE COLUMN `equipmodel1` `equipmodel1` mediumint unsigned NOT NULL DEFAULT 0,
47 CHANGE COLUMN `equipmodel2` `equipmodel2` mediumint unsigned NOT NULL DEFAULT 0,
48 CHANGE COLUMN `equipmodel3` `equipmodel3` mediumint unsigned NOT NULL DEFAULT 0,
49 CHANGE COLUMN `equipinfo1` `equipinfo1` integer unsigned NOT NULL DEFAULT 0,
50 CHANGE COLUMN `equipinfo2` `equipinfo2` integer unsigned NOT NULL DEFAULT 0,
51 CHANGE COLUMN `equipinfo3` `equipinfo3` integer unsigned NOT NULL DEFAULT 0,
52 CHANGE COLUMN `equipslot1` `equipslot1` integer NOT NULL DEFAULT 0,
53 CHANGE COLUMN `equipslot2` `equipslot2` integer NOT NULL DEFAULT 0,
54 CHANGE COLUMN `equipslot3` `equipslot3` integer NOT NULL DEFAULT 0;
55 ALTER TABLE `creature_involvedrelation`
56 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier',
57 CHANGE COLUMN `quest` `quest` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier';
58 ALTER TABLE `creature_loot_template`
59 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
60 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
61 CHANGE COLUMN `QuestChanceOrGroup` `QuestChanceOrGroup` tinyint NOT NULL DEFAULT 0,
62 CHANGE COLUMN `mincount` `mincount` tinyint unsigned NOT NULL DEFAULT 1,
63 CHANGE COLUMN `maxcount` `maxcount` tinyint unsigned NOT NULL DEFAULT 1,
64 CHANGE COLUMN `freeforall` `freeforall` tinyint unsigned NOT NULL DEFAULT 0,
65 CHANGE COLUMN `lootcondition` `lootcondition` tinyint unsigned NOT NULL DEFAULT 0,
66 CHANGE COLUMN `condition_value1` `condition_value1` mediumint unsigned NOT NULL DEFAULT 0,
67 CHANGE COLUMN `condition_value2` `condition_value2` mediumint unsigned NOT NULL DEFAULT 0;
68 ALTER TABLE `creature_model_info`
69 CHANGE COLUMN `modelid` `modelid` mediumint unsigned NOT NULL DEFAULT 0,
70 CHANGE COLUMN `gender` `gender` tinyint unsigned NOT NULL DEFAULT 2,
71 CHANGE COLUMN `modelid_other_gender` `modelid_other_gender` mediumint unsigned NOT NULL DEFAULT 0;
72 UPDATE `creature_movement` SET `orientation`=0 WHERE `orientation` IS NULL;
73 UPDATE `creature_movement` SET `model1`=0 WHERE `model1` IS NULL;
74 UPDATE `creature_movement` SET `model2`=0 WHERE `model2` IS NULL;
75 ALTER TABLE `creature_movement`
76 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier',
77 CHANGE COLUMN `point` `point` mediumint unsigned NOT NULL DEFAULT 0,
78 CHANGE COLUMN `waittime` `waittime` integer unsigned NOT NULL DEFAULT 0,
79 CHANGE COLUMN `aiscript` `aiscript` varchar(128),
80 CHANGE COLUMN `emote` `emote` mediumint unsigned NOT NULL DEFAULT 0,
81 CHANGE COLUMN `spell` `spell` mediumint unsigned NOT NULL DEFAULT 0,
82 CHANGE COLUMN `wpguid` `wpguid` integer NOT NULL DEFAULT 0,
83 CHANGE COLUMN `orientation` `orientation` float NOT NULL DEFAULT 0,
84 CHANGE COLUMN `model1` `model1` mediumint NOT NULL DEFAULT 0,
85 CHANGE COLUMN `model2` `model2` mediumint NOT NULL DEFAULT 0;
86 ALTER TABLE `creature_onkill_reputation`
87 CHANGE COLUMN `creature_id` `creature_id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Creature Identifier',
88 CHANGE COLUMN `RewOnKillRepFaction1` `RewOnKillRepFaction1` smallint NOT NULL DEFAULT 0,
89 CHANGE COLUMN `RewOnKillRepFaction2` `RewOnKillRepFaction2` smallint NOT NULL DEFAULT 0,
90 CHANGE COLUMN `MaxStanding1` `MaxStanding1` tinyint NOT NULL DEFAULT 0,
91 CHANGE COLUMN `IsTeamAward1` `IsTeamAward1` tinyint NOT NULL DEFAULT 0,
92 CHANGE COLUMN `RewOnKillRepValue1` `RewOnKillRepValue1` mediumint NOT NULL DEFAULT 0,
93 CHANGE COLUMN `MaxStanding2` `MaxStanding2` tinyint NOT NULL DEFAULT 0,
94 CHANGE COLUMN `IsTeamAward2` `IsTeamAward2` tinyint NOT NULL DEFAULT 0,
95 CHANGE COLUMN `RewOnKillRepValue2` `RewOnKillRepValue2` mediumint NOT NULL DEFAULT 0,
96 CHANGE COLUMN `TeamDependent` `TeamDependent` tinyint unsigned NOT NULL DEFAULT 0;
97 ALTER TABLE `creature_questrelation`
98 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier',
99 CHANGE COLUMN `quest` `quest` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier';
100 ALTER TABLE `creature_respawn`
101 CHANGE COLUMN `guid` `guid` integer unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier',
102 CHANGE COLUMN `respawntime` `respawntime` bigint NOT NULL DEFAULT 0,
103 CHANGE COLUMN `instance` `instance` mediumint unsigned NOT NULL DEFAULT 0;
104 ALTER TABLE `creature_template`
105 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
106 CHANGE COLUMN `modelid_A` `modelid_A` mediumint unsigned NOT NULL DEFAULT 0,
107 CHANGE COLUMN `modelid_A2` `modelid_A2` mediumint unsigned NOT NULL DEFAULT 0,
108 CHANGE COLUMN `modelid_H` `modelid_H` mediumint unsigned NOT NULL DEFAULT 0,
109 CHANGE COLUMN `modelid_H2` `modelid_H2` mediumint unsigned NOT NULL DEFAULT 0,
110 CHANGE COLUMN `minlevel` `minlevel` tinyint unsigned NOT NULL DEFAULT 1,
111 CHANGE COLUMN `maxlevel` `maxlevel` tinyint unsigned NOT NULL DEFAULT 1,
112 CHANGE COLUMN `minhealth` `minhealth` integer unsigned NOT NULL DEFAULT 0,
113 CHANGE COLUMN `maxhealth` `maxhealth` integer unsigned NOT NULL DEFAULT 0,
114 CHANGE COLUMN `minmana` `minmana` integer unsigned NOT NULL DEFAULT 0,
115 CHANGE COLUMN `maxmana` `maxmana` integer unsigned NOT NULL DEFAULT 0,
116 CHANGE COLUMN `armor` `armor` mediumint unsigned NOT NULL DEFAULT 0,
117 CHANGE COLUMN `faction_A` `faction_A` smallint unsigned NOT NULL DEFAULT 0,
118 CHANGE COLUMN `faction_H` `faction_H` smallint unsigned NOT NULL DEFAULT 0,
119 CHANGE COLUMN `npcflag` `npcflag` integer unsigned NOT NULL DEFAULT 0,
120 CHANGE COLUMN `speed` `speed` float NOT NULL DEFAULT 1.0,
121 CHANGE COLUMN `scale` `scale` float NOT NULL DEFAULT 0,
122 CHANGE COLUMN `rank` `rank` tinyint unsigned NOT NULL DEFAULT 0,
123 CHANGE COLUMN `mindmg` `mindmg` float NOT NULL DEFAULT 0,
124 CHANGE COLUMN `maxdmg` `maxdmg` float NOT NULL DEFAULT 0,
125 CHANGE COLUMN `dmgschool` `dmgschool` tinyint NOT NULL DEFAULT 0,
126 CHANGE COLUMN `attackpower` `attackpower` integer unsigned NOT NULL DEFAULT 0,
127 CHANGE COLUMN `baseattacktime` `baseattacktime` integer unsigned NOT NULL DEFAULT 0,
128 CHANGE COLUMN `rangeattacktime` `rangeattacktime` integer unsigned NOT NULL DEFAULT 0,
129 CHANGE COLUMN `flags` `flags` integer unsigned NOT NULL DEFAULT 0,
130 CHANGE COLUMN `dynamicflags` `dynamicflags` integer unsigned NOT NULL DEFAULT 0,
131 CHANGE COLUMN `family` `family` tinyint NOT NULL DEFAULT 0,
132 CHANGE COLUMN `trainer_type` `trainer_type` tinyint NOT NULL DEFAULT 0,
133 CHANGE COLUMN `trainer_spell` `trainer_spell` mediumint unsigned NOT NULL DEFAULT 0,
134 CHANGE COLUMN `class` `class` tinyint unsigned NOT NULL DEFAULT 0,
135 CHANGE COLUMN `race` `race` tinyint unsigned NOT NULL DEFAULT 0,
136 CHANGE COLUMN `rangedattackpower` `rangedattackpower` smallint unsigned NOT NULL DEFAULT 0,
137 CHANGE COLUMN `type` `type` tinyint unsigned NOT NULL DEFAULT 0,
138 CHANGE COLUMN `civilian` `civilian` tinyint unsigned NOT NULL DEFAULT 0,
139 CHANGE COLUMN `flag1` `flag1` integer unsigned NOT NULL DEFAULT 0,
140 CHANGE COLUMN `lootid` `lootid` mediumint unsigned NOT NULL DEFAULT 0,
141 CHANGE COLUMN `pickpocketloot` `pickpocketloot` mediumint unsigned NOT NULL DEFAULT 0,
142 CHANGE COLUMN `skinloot` `skinloot` mediumint unsigned NOT NULL DEFAULT 0,
143 CHANGE COLUMN `resistance1` `resistance1` smallint unsigned NOT NULL DEFAULT 0,
144 CHANGE COLUMN `resistance2` `resistance2` smallint unsigned NOT NULL DEFAULT 0,
145 CHANGE COLUMN `resistance3` `resistance3` smallint unsigned NOT NULL DEFAULT 0,
146 CHANGE COLUMN `resistance4` `resistance4` smallint unsigned NOT NULL DEFAULT 0,
147 CHANGE COLUMN `resistance5` `resistance5` smallint unsigned NOT NULL DEFAULT 0,
148 CHANGE COLUMN `resistance6` `resistance6` smallint unsigned NOT NULL DEFAULT 0,
149 CHANGE COLUMN `spell1` `spell1` mediumint unsigned NOT NULL DEFAULT 0,
150 CHANGE COLUMN `spell2` `spell2` mediumint unsigned NOT NULL DEFAULT 0,
151 CHANGE COLUMN `spell3` `spell3` mediumint unsigned NOT NULL DEFAULT 0,
152 CHANGE COLUMN `spell4` `spell4` mediumint unsigned NOT NULL DEFAULT 0,
153 CHANGE COLUMN `mingold` `mingold` mediumint unsigned NOT NULL DEFAULT 0,
154 CHANGE COLUMN `maxgold` `maxgold` mediumint unsigned NOT NULL DEFAULT 0,
155 CHANGE COLUMN `AIName` `AIName` char(64) NOT NULL DEFAULT '',
156 CHANGE COLUMN `MovementType` `MovementType` tinyint unsigned NOT NULL DEFAULT 0,
157 CHANGE COLUMN `InhabitType` `InhabitType` tinyint unsigned NOT NULL DEFAULT 3,
158 CHANGE COLUMN `RacialLeader` `RacialLeader` tinyint unsigned NOT NULL DEFAULT 0,
159 CHANGE COLUMN `RegenHealth` `RegenHealth` tinyint unsigned NOT NULL DEFAULT 1,
160 CHANGE COLUMN `equipment_id` `equipment_id` mediumint unsigned NOT NULL DEFAULT 0,
161 CHANGE COLUMN `mechanic_immune_mask` `mechanic_immune_mask` integer unsigned NOT NULL DEFAULT 0,
162 CHANGE COLUMN `ScriptName` `ScriptName` char(64) NOT NULL DEFAULT '';
163 ALTER TABLE `creature_template_addon`
164 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
165 CHANGE COLUMN `mount` `mount` mediumint unsigned NOT NULL DEFAULT 0,
166 CHANGE COLUMN `bytes0` `bytes0` integer unsigned NOT NULL DEFAULT 0,
167 CHANGE COLUMN `bytes1` `bytes1` integer unsigned NOT NULL DEFAULT 0,
168 CHANGE COLUMN `bytes2` `bytes2` integer unsigned NOT NULL DEFAULT 0,
169 CHANGE COLUMN `emote` `emote` mediumint unsigned NOT NULL DEFAULT 0;
170 ALTER TABLE `disenchant_loot_template`
171 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Recommended id selection: item_level*100 + item_quality',
172 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
173 CHANGE COLUMN `QuestChanceOrGroup` `QuestChanceOrGroup` tinyint NOT NULL DEFAULT 0,
174 CHANGE COLUMN `mincount` `mincount` tinyint unsigned NOT NULL DEFAULT 1,
175 CHANGE COLUMN `maxcount` `maxcount` tinyint unsigned NOT NULL DEFAULT 1,
176 CHANGE COLUMN `freeforall` `freeforall` tinyint unsigned NOT NULL DEFAULT 0,
177 CHANGE COLUMN `lootcondition` `lootcondition` tinyint unsigned NOT NULL DEFAULT 0,
178 CHANGE COLUMN `condition_value1` `condition_value1` mediumint unsigned NOT NULL DEFAULT 0,
179 CHANGE COLUMN `condition_value2` `condition_value2` mediumint unsigned NOT NULL DEFAULT 0;
180 ALTER TABLE `event_scripts`
181 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
182 CHANGE COLUMN `delay` `delay` integer unsigned NOT NULL DEFAULT 0,
183 CHANGE COLUMN `command` `command` mediumint unsigned NOT NULL DEFAULT 0,
184 CHANGE COLUMN `datalong` `datalong` mediumint unsigned NOT NULL DEFAULT 0,
185 CHANGE COLUMN `datalong2` `datalong2` integer unsigned NOT NULL DEFAULT 0;
186 ALTER TABLE `exploration_basexp`
187 CHANGE COLUMN `level` `level` tinyint NOT NULL DEFAULT 0,
188 CHANGE COLUMN `basexp` `basexp` mediumint NOT NULL DEFAULT 0;
189 ALTER TABLE `fishing_loot_template`
190 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
191 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
192 CHANGE COLUMN `QuestChanceOrGroup` `QuestChanceOrGroup` tinyint NOT NULL DEFAULT 0,
193 CHANGE COLUMN `mincount` `mincount` tinyint unsigned NOT NULL DEFAULT 1,
194 CHANGE COLUMN `maxcount` `maxcount` tinyint unsigned NOT NULL DEFAULT 1,
195 CHANGE COLUMN `freeforall` `freeforall` tinyint unsigned NOT NULL DEFAULT 0,
196 CHANGE COLUMN `lootcondition` `lootcondition` tinyint unsigned NOT NULL DEFAULT 0,
197 CHANGE COLUMN `condition_value1` `condition_value1` mediumint unsigned NOT NULL DEFAULT 0,
198 CHANGE COLUMN `condition_value2` `condition_value2` mediumint unsigned NOT NULL DEFAULT 0;
199 ALTER TABLE `game_event_creature`
200 CHANGE COLUMN `guid` `guid` integer unsigned NOT NULL,
201 CHANGE COLUMN `event` `event` smallint NOT NULL DEFAULT 0 COMMENT 'Put negatives values to remove during event';
202 ALTER TABLE `game_event_creature_quest`
203 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
204 CHANGE COLUMN `quest` `quest` mediumint unsigned NOT NULL DEFAULT 0,
205 CHANGE COLUMN `event` `event` smallint unsigned NOT NULL DEFAULT 0;
206 ALTER TABLE `game_event_gameobject`
207 CHANGE COLUMN `guid` `guid` integer unsigned NOT NULL,
208 CHANGE COLUMN `event` `event` smallint NOT NULL DEFAULT 0 COMMENT 'Put negatives values to remove during event';
209 ALTER TABLE `game_event_model_equip`
210 CHANGE COLUMN `guid` `guid` integer unsigned NOT NULL DEFAULT 0,
211 CHANGE COLUMN `modelid` `modelid` mediumint unsigned NOT NULL DEFAULT 0,
212 CHANGE COLUMN `equipment_id` `equipment_id` mediumint unsigned NOT NULL DEFAULT 0,
213 CHANGE COLUMN `event` `event` smallint unsigned NOT NULL DEFAULT 0;
214 ALTER TABLE `game_graveyard_zone`
215 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
216 CHANGE COLUMN `ghost_zone` `ghost_zone` mediumint unsigned NOT NULL DEFAULT 0,
217 CHANGE COLUMN `faction` `faction` smallint unsigned NOT NULL DEFAULT 0;
218 ALTER TABLE `game_tele`
219 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL auto_increment,
220 CHANGE COLUMN `map` `map` smallint unsigned NOT NULL DEFAULT 0;
221 ALTER TABLE `game_weather`
222 CHANGE COLUMN `zone` `zone` mediumint unsigned NOT NULL DEFAULT 0,
223 CHANGE COLUMN `spring_rain_chance` `spring_rain_chance` tinyint unsigned NOT NULL DEFAULT 25,
224 CHANGE COLUMN `spring_snow_chance` `spring_snow_chance` tinyint unsigned NOT NULL DEFAULT 25,
225 CHANGE COLUMN `spring_storm_chance` `spring_storm_chance` tinyint unsigned NOT NULL DEFAULT 25,
226 CHANGE COLUMN `summer_rain_chance` `summer_rain_chance` tinyint unsigned NOT NULL DEFAULT 25,
227 CHANGE COLUMN `summer_snow_chance` `summer_snow_chance` tinyint unsigned NOT NULL DEFAULT 25,
228 CHANGE COLUMN `summer_storm_chance` `summer_storm_chance` tinyint unsigned NOT NULL DEFAULT 25,
229 CHANGE COLUMN `fall_rain_chance` `fall_rain_chance` tinyint unsigned NOT NULL DEFAULT 25,
230 CHANGE COLUMN `fall_snow_chance` `fall_snow_chance` tinyint unsigned NOT NULL DEFAULT 25,
231 CHANGE COLUMN `fall_storm_chance` `fall_storm_chance` tinyint unsigned NOT NULL DEFAULT 25,
232 CHANGE COLUMN `winter_rain_chance` `winter_rain_chance` tinyint unsigned NOT NULL DEFAULT 25,
233 CHANGE COLUMN `winter_snow_chance` `winter_snow_chance` tinyint unsigned NOT NULL DEFAULT 25,
234 CHANGE COLUMN `winter_storm_chance` `winter_storm_chance` tinyint unsigned NOT NULL DEFAULT 25;
235 ALTER TABLE `gameobject`
236 CHANGE COLUMN `guid` `guid` integer unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
237 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Gameobject Identifier',
238 CHANGE COLUMN `map` `map` smallint unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier',
239 CHANGE COLUMN `spawntimesecs` `spawntimesecs` integer NOT NULL DEFAULT 0,
240 CHANGE COLUMN `animprogress` `animprogress` tinyint unsigned NOT NULL DEFAULT 0,
241 CHANGE COLUMN `state` `state` tinyint unsigned NOT NULL DEFAULT 0;
242 ALTER TABLE `gameobject_involvedrelation`
243 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
244 CHANGE COLUMN `quest` `quest` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier';
245 ALTER TABLE `gameobject_loot_template`
246 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
247 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
248 CHANGE COLUMN `QuestChanceOrGroup` `QuestChanceOrGroup` tinyint NOT NULL DEFAULT 0,
249 CHANGE COLUMN `mincount` `mincount` tinyint unsigned NOT NULL DEFAULT 1,
250 CHANGE COLUMN `maxcount` `maxcount` tinyint unsigned NOT NULL DEFAULT 1,
251 CHANGE COLUMN `freeforall` `freeforall` tinyint unsigned NOT NULL DEFAULT 0,
252 CHANGE COLUMN `lootcondition` `lootcondition` tinyint unsigned NOT NULL DEFAULT 0,
253 CHANGE COLUMN `condition_value1` `condition_value1` mediumint unsigned NOT NULL DEFAULT 0,
254 CHANGE COLUMN `condition_value2` `condition_value2` mediumint unsigned NOT NULL DEFAULT 0;
255 ALTER TABLE `gameobject_questrelation`
256 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
257 CHANGE COLUMN `quest` `quest` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier';
258 ALTER TABLE `gameobject_respawn`
259 CHANGE COLUMN `guid` `guid` integer unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier',
260 CHANGE COLUMN `respawntime` `respawntime` bigint NOT NULL DEFAULT 0,
261 CHANGE COLUMN `instance` `instance` mediumint unsigned NOT NULL DEFAULT 0;
262 ALTER TABLE `gameobject_scripts`
263 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
264 CHANGE COLUMN `delay` `delay` integer unsigned NOT NULL DEFAULT 0,
265 CHANGE COLUMN `command` `command` mediumint unsigned NOT NULL DEFAULT 0,
266 CHANGE COLUMN `datalong` `datalong` mediumint unsigned NOT NULL DEFAULT 0,
267 CHANGE COLUMN `datalong2` `datalong2` integer unsigned NOT NULL DEFAULT 0;
268 ALTER TABLE `gameobject_template`
269 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
270 CHANGE COLUMN `type` `type` tinyint unsigned NOT NULL DEFAULT 0,
271 CHANGE COLUMN `displayId` `displayId` mediumint unsigned NOT NULL DEFAULT 0,
272 CHANGE COLUMN `name` `name` varchar(100) NOT NULL DEFAULT '',
273 CHANGE COLUMN `faction` `faction` smallint unsigned NOT NULL DEFAULT 0,
274 CHANGE COLUMN `flags` `flags` integer unsigned NOT NULL DEFAULT 0,
275 CHANGE COLUMN `data0` `data0` integer unsigned NOT NULL DEFAULT 0,
276 CHANGE COLUMN `data1` `data1` integer unsigned NOT NULL DEFAULT 0,
277 CHANGE COLUMN `data2` `data2` integer unsigned NOT NULL DEFAULT 0,
278 CHANGE COLUMN `data3` `data3` integer unsigned NOT NULL DEFAULT 0,
279 CHANGE COLUMN `data4` `data4` integer unsigned NOT NULL DEFAULT 0,
280 CHANGE COLUMN `data5` `data5` integer unsigned NOT NULL DEFAULT 0,
281 CHANGE COLUMN `data6` `data6` integer unsigned NOT NULL DEFAULT 0,
282 CHANGE COLUMN `data7` `data7` integer unsigned NOT NULL DEFAULT 0,
283 CHANGE COLUMN `data8` `data8` integer unsigned NOT NULL DEFAULT 0,
284 CHANGE COLUMN `data9` `data9` integer unsigned NOT NULL DEFAULT 0,
285 CHANGE COLUMN `data10` `data10` integer unsigned NOT NULL DEFAULT 0,
286 CHANGE COLUMN `data11` `data11` integer unsigned NOT NULL DEFAULT 0,
287 CHANGE COLUMN `data12` `data12` integer unsigned NOT NULL DEFAULT 0,
288 CHANGE COLUMN `data13` `data13` integer unsigned NOT NULL DEFAULT 0,
289 CHANGE COLUMN `data14` `data14` integer unsigned NOT NULL DEFAULT 0,
290 CHANGE COLUMN `data15` `data15` integer unsigned NOT NULL DEFAULT 0,
291 CHANGE COLUMN `data16` `data16` integer unsigned NOT NULL DEFAULT 0,
292 CHANGE COLUMN `data17` `data17` integer unsigned NOT NULL DEFAULT 0,
293 CHANGE COLUMN `data18` `data18` integer unsigned NOT NULL DEFAULT 0,
294 CHANGE COLUMN `data19` `data19` integer unsigned NOT NULL DEFAULT 0,
295 CHANGE COLUMN `data20` `data20` integer unsigned NOT NULL DEFAULT 0,
296 CHANGE COLUMN `data21` `data21` integer unsigned NOT NULL DEFAULT 0,
297 CHANGE COLUMN `data22` `data22` integer unsigned NOT NULL DEFAULT 0,
298 CHANGE COLUMN `data23` `data23` integer unsigned NOT NULL DEFAULT 0,
299 CHANGE COLUMN `ScriptName` `ScriptName` varchar(64) NOT NULL DEFAULT '';
300 ALTER TABLE `instance_template`
301 CHANGE COLUMN `map` `map` smallint unsigned NOT NULL,
302 CHANGE COLUMN `parent` `parent` integer unsigned NOT NULL,
303 CHANGE COLUMN `levelMin` `levelMin` tinyint unsigned NOT NULL DEFAULT 0,
304 CHANGE COLUMN `levelMax` `levelMax` tinyint unsigned NOT NULL DEFAULT 0,
305 CHANGE COLUMN `maxPlayers` `maxPlayers` tinyint unsigned NOT NULL DEFAULT 0,
306 CHANGE COLUMN `reset_delay` `reset_delay` integer unsigned NOT NULL DEFAULT 0,
307 CHANGE COLUMN `script` `script` varchar(128) NOT NULL DEFAULT '';
308 ALTER TABLE `item_enchantment_template`
309 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
310 CHANGE COLUMN `ench` `ench` mediumint unsigned NOT NULL DEFAULT 0;
311 ALTER TABLE `item_loot_template`
312 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
313 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
314 CHANGE COLUMN `QuestChanceOrGroup` `QuestChanceOrGroup` tinyint NOT NULL DEFAULT 0,
315 CHANGE COLUMN `mincount` `mincount` smallint unsigned NOT NULL DEFAULT 1,
316 CHANGE COLUMN `maxcount` `maxcount` smallint unsigned NOT NULL DEFAULT 1,
317 CHANGE COLUMN `freeforall` `freeforall` tinyint unsigned NOT NULL DEFAULT 0,
318 CHANGE COLUMN `lootcondition` `lootcondition` tinyint unsigned NOT NULL DEFAULT 0,
319 CHANGE COLUMN `condition_value1` `condition_value1` mediumint unsigned NOT NULL DEFAULT 0,
320 CHANGE COLUMN `condition_value2` `condition_value2` mediumint unsigned NOT NULL DEFAULT 0;
321 ALTER TABLE `item_template`
322 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
323 CHANGE COLUMN `class` `class` tinyint unsigned NOT NULL DEFAULT 0,
324 CHANGE COLUMN `subclass` `subclass` tinyint unsigned NOT NULL DEFAULT 0,
325 CHANGE COLUMN `unk0` `unk0` integer NOT NULL DEFAULT -1,
326 CHANGE COLUMN `name` `name` varchar(255) NOT NULL DEFAULT '',
327 CHANGE COLUMN `displayid` `displayid` mediumint unsigned NOT NULL DEFAULT 0,
328 CHANGE COLUMN `Quality` `Quality` tinyint unsigned NOT NULL DEFAULT 0,
329 CHANGE COLUMN `Flags` `Flags` integer unsigned NOT NULL DEFAULT 0,
330 CHANGE COLUMN `BuyCount` `BuyCount` tinyint unsigned NOT NULL DEFAULT 1,
331 CHANGE COLUMN `BuyPrice` `BuyPrice` integer unsigned NOT NULL DEFAULT 0,
332 CHANGE COLUMN `SellPrice` `SellPrice` integer unsigned NOT NULL DEFAULT 0,
333 CHANGE COLUMN `InventoryType` `InventoryType` tinyint unsigned NOT NULL DEFAULT 0,
334 CHANGE COLUMN `AllowableClass` `AllowableClass` mediumint NOT NULL DEFAULT -1,
335 CHANGE COLUMN `AllowableRace` `AllowableRace` mediumint NOT NULL DEFAULT -1,
336 CHANGE COLUMN `ItemLevel` `ItemLevel` tinyint unsigned NOT NULL DEFAULT 0,
337 CHANGE COLUMN `RequiredLevel` `RequiredLevel` tinyint unsigned NOT NULL DEFAULT 0,
338 CHANGE COLUMN `RequiredSkill` `RequiredSkill` smallint unsigned NOT NULL DEFAULT 0,
339 CHANGE COLUMN `RequiredSkillRank` `RequiredSkillRank` smallint unsigned NOT NULL DEFAULT 0,
340 CHANGE COLUMN `requiredspell` `requiredspell` mediumint unsigned NOT NULL DEFAULT 0,
341 CHANGE COLUMN `requiredhonorrank` `requiredhonorrank` mediumint unsigned NOT NULL DEFAULT 0,
342 CHANGE COLUMN `RequiredCityRank` `RequiredCityRank` mediumint unsigned NOT NULL DEFAULT 0,
343 CHANGE COLUMN `RequiredReputationFaction` `RequiredReputationFaction` smallint unsigned NOT NULL DEFAULT 0,
344 CHANGE COLUMN `RequiredReputationRank` `RequiredReputationRank` smallint unsigned NOT NULL DEFAULT 0,
345 CHANGE COLUMN `maxcount` `maxcount` smallint unsigned NOT NULL DEFAULT 0,
346 CHANGE COLUMN `stackable` `stackable` smallint unsigned NOT NULL DEFAULT 0,
347 CHANGE COLUMN `ContainerSlots` `ContainerSlots` tinyint unsigned NOT NULL DEFAULT 0,
348 CHANGE COLUMN `stat_type1` `stat_type1` tinyint unsigned NOT NULL DEFAULT 0,
349 CHANGE COLUMN `stat_value1` `stat_value1` smallint NOT NULL DEFAULT 0,
350 CHANGE COLUMN `stat_type2` `stat_type2` tinyint unsigned NOT NULL DEFAULT 0,
351 CHANGE COLUMN `stat_value2` `stat_value2` smallint NOT NULL DEFAULT 0,
352 CHANGE COLUMN `stat_type3` `stat_type3` tinyint unsigned NOT NULL DEFAULT 0,
353 CHANGE COLUMN `stat_value3` `stat_value3` smallint NOT NULL DEFAULT 0,
354 CHANGE COLUMN `stat_type4` `stat_type4` tinyint unsigned NOT NULL DEFAULT 0,
355 CHANGE COLUMN `stat_value4` `stat_value4` smallint NOT NULL DEFAULT 0,
356 CHANGE COLUMN `stat_type5` `stat_type5` tinyint unsigned NOT NULL DEFAULT 0,
357 CHANGE COLUMN `stat_value5` `stat_value5` smallint NOT NULL DEFAULT 0,
358 CHANGE COLUMN `stat_type6` `stat_type6` tinyint unsigned NOT NULL DEFAULT 0,
359 CHANGE COLUMN `stat_value6` `stat_value6` smallint NOT NULL DEFAULT 0,
360 CHANGE COLUMN `stat_type7` `stat_type7` tinyint unsigned NOT NULL DEFAULT 0,
361 CHANGE COLUMN `stat_value7` `stat_value7` smallint NOT NULL DEFAULT 0,
362 CHANGE COLUMN `stat_type8` `stat_type8` tinyint unsigned NOT NULL DEFAULT 0,
363 CHANGE COLUMN `stat_value8` `stat_value8` smallint NOT NULL DEFAULT 0,
364 CHANGE COLUMN `stat_type9` `stat_type9` tinyint unsigned NOT NULL DEFAULT 0,
365 CHANGE COLUMN `stat_value9` `stat_value9` smallint NOT NULL DEFAULT 0,
366 CHANGE COLUMN `stat_type10` `stat_type10` tinyint unsigned NOT NULL DEFAULT 0,
367 CHANGE COLUMN `stat_value10` `stat_value10` smallint NOT NULL DEFAULT 0,
368 CHANGE COLUMN `dmg_type1` `dmg_type1` tinyint unsigned NOT NULL DEFAULT 0,
369 CHANGE COLUMN `dmg_type2` `dmg_type2` tinyint unsigned NOT NULL DEFAULT 0,
370 CHANGE COLUMN `dmg_type3` `dmg_type3` tinyint unsigned NOT NULL DEFAULT 0,
371 CHANGE COLUMN `dmg_type4` `dmg_type4` tinyint unsigned NOT NULL DEFAULT 0,
372 CHANGE COLUMN `dmg_type5` `dmg_type5` tinyint unsigned NOT NULL DEFAULT 0,
373 CHANGE COLUMN `armor` `armor` smallint unsigned NOT NULL DEFAULT 0,
374 CHANGE COLUMN `holy_res` `holy_res` tinyint unsigned NOT NULL DEFAULT 0,
375 CHANGE COLUMN `fire_res` `fire_res` tinyint unsigned NOT NULL DEFAULT 0,
376 CHANGE COLUMN `nature_res` `nature_res` tinyint unsigned NOT NULL DEFAULT 0,
377 CHANGE COLUMN `frost_res` `frost_res` tinyint unsigned NOT NULL DEFAULT 0,
378 CHANGE COLUMN `shadow_res` `shadow_res` tinyint unsigned NOT NULL DEFAULT 0,
379 CHANGE COLUMN `arcane_res` `arcane_res` tinyint unsigned NOT NULL DEFAULT 0,
380 CHANGE COLUMN `delay` `delay` smallint unsigned NOT NULL DEFAULT 1000,
381 CHANGE COLUMN `ammo_type` `ammo_type` tinyint unsigned NOT NULL DEFAULT 0,
382 CHANGE COLUMN `spellid_1` `spellid_1` mediumint unsigned NOT NULL DEFAULT 0,
383 CHANGE COLUMN `spelltrigger_1` `spelltrigger_1` tinyint unsigned NOT NULL DEFAULT 0,
384 CHANGE COLUMN `spellcharges_1` `spellcharges_1` tinyint NOT NULL DEFAULT 0,
385 CHANGE COLUMN `spellcooldown_1` `spellcooldown_1` integer NOT NULL DEFAULT -1,
386 CHANGE COLUMN `spellcategory_1` `spellcategory_1` smallint unsigned NOT NULL DEFAULT 0,
387 CHANGE COLUMN `spellcategorycooldown_1` `spellcategorycooldown_1` integer NOT NULL DEFAULT -1,
388 CHANGE COLUMN `spellid_2` `spellid_2` mediumint unsigned NOT NULL DEFAULT 0,
389 CHANGE COLUMN `spelltrigger_2` `spelltrigger_2` tinyint unsigned NOT NULL DEFAULT 0,
390 CHANGE COLUMN `spellcharges_2` `spellcharges_2` tinyint NOT NULL DEFAULT 0,
391 CHANGE COLUMN `spellcooldown_2` `spellcooldown_2` integer NOT NULL DEFAULT -1,
392 CHANGE COLUMN `spellcategory_2` `spellcategory_2` smallint unsigned NOT NULL DEFAULT 0,
393 CHANGE COLUMN `spellcategorycooldown_2` `spellcategorycooldown_2` integer NOT NULL DEFAULT -1,
394 CHANGE COLUMN `spellid_3` `spellid_3` mediumint unsigned NOT NULL DEFAULT 0,
395 CHANGE COLUMN `spelltrigger_3` `spelltrigger_3` tinyint unsigned NOT NULL DEFAULT 0,
396 CHANGE COLUMN `spellcharges_3` `spellcharges_3` tinyint NOT NULL DEFAULT 0,
397 CHANGE COLUMN `spellcooldown_3` `spellcooldown_3` integer NOT NULL DEFAULT -1,
398 CHANGE COLUMN `spellcategory_3` `spellcategory_3` smallint unsigned NOT NULL DEFAULT 0,
399 CHANGE COLUMN `spellcategorycooldown_3` `spellcategorycooldown_3` integer NOT NULL DEFAULT -1,
400 CHANGE COLUMN `spellid_4` `spellid_4` mediumint unsigned NOT NULL DEFAULT 0,
401 CHANGE COLUMN `spelltrigger_4` `spelltrigger_4` tinyint unsigned NOT NULL DEFAULT 0,
402 CHANGE COLUMN `spellcharges_4` `spellcharges_4` tinyint NOT NULL DEFAULT 0,
403 CHANGE COLUMN `spellcooldown_4` `spellcooldown_4` integer NOT NULL DEFAULT -1,
404 CHANGE COLUMN `spellcategory_4` `spellcategory_4` smallint unsigned NOT NULL DEFAULT 0,
405 CHANGE COLUMN `spellcategorycooldown_4` `spellcategorycooldown_4` integer NOT NULL DEFAULT -1,
406 CHANGE COLUMN `spellid_5` `spellid_5` mediumint unsigned NOT NULL DEFAULT 0,
407 CHANGE COLUMN `spelltrigger_5` `spelltrigger_5` tinyint unsigned NOT NULL DEFAULT 0,
408 CHANGE COLUMN `spellcharges_5` `spellcharges_5` tinyint NOT NULL DEFAULT 0,
409 CHANGE COLUMN `spellcooldown_5` `spellcooldown_5` integer NOT NULL DEFAULT -1,
410 CHANGE COLUMN `spellcategory_5` `spellcategory_5` smallint unsigned NOT NULL DEFAULT 0,
411 CHANGE COLUMN `spellcategorycooldown_5` `spellcategorycooldown_5` integer NOT NULL DEFAULT -1,
412 CHANGE COLUMN `bonding` `bonding` tinyint unsigned NOT NULL DEFAULT 0,
413 CHANGE COLUMN `PageText` `PageText` mediumint unsigned NOT NULL DEFAULT 0,
414 CHANGE COLUMN `LanguageID` `LanguageID` tinyint unsigned NOT NULL DEFAULT 0,
415 CHANGE COLUMN `PageMaterial` `PageMaterial` tinyint unsigned NOT NULL DEFAULT 0,
416 CHANGE COLUMN `startquest` `startquest` mediumint unsigned NOT NULL DEFAULT 0,
417 CHANGE COLUMN `lockid` `lockid` mediumint unsigned NOT NULL DEFAULT 0,
418 CHANGE COLUMN `Material` `Material` tinyint NOT NULL DEFAULT 0,
419 CHANGE COLUMN `sheath` `sheath` tinyint unsigned NOT NULL DEFAULT 0,
420 CHANGE COLUMN `RandomProperty` `RandomProperty` mediumint unsigned NOT NULL DEFAULT 0,
421 CHANGE COLUMN `RandomSuffix` `RandomSuffix` mediumint unsigned NOT NULL DEFAULT 0,
422 CHANGE COLUMN `block` `block` mediumint unsigned NOT NULL DEFAULT 0,
423 CHANGE COLUMN `itemset` `itemset` mediumint unsigned NOT NULL DEFAULT 0,
424 CHANGE COLUMN `MaxDurability` `MaxDurability` smallint unsigned NOT NULL DEFAULT 0,
425 CHANGE COLUMN `area` `area` mediumint unsigned NOT NULL DEFAULT 0,
426 CHANGE COLUMN `Map` `Map` smallint NOT NULL DEFAULT 0,
427 CHANGE COLUMN `BagFamily` `BagFamily` mediumint NOT NULL DEFAULT 0,
428 CHANGE COLUMN `TotemCategory` `TotemCategory` tinyint NOT NULL DEFAULT 0,
429 CHANGE COLUMN `socketColor_1` `socketColor_1` tinyint NOT NULL DEFAULT 0,
430 CHANGE COLUMN `socketContent_1` `socketContent_1` mediumint NOT NULL DEFAULT 0,
431 CHANGE COLUMN `socketColor_2` `socketColor_2` tinyint NOT NULL DEFAULT 0,
432 CHANGE COLUMN `socketContent_2` `socketContent_2` mediumint NOT NULL DEFAULT 0,
433 CHANGE COLUMN `socketColor_3` `socketColor_3` tinyint NOT NULL DEFAULT 0,
434 CHANGE COLUMN `socketContent_3` `socketContent_3` mediumint NOT NULL DEFAULT 0,
435 CHANGE COLUMN `socketBonus` `socketBonus` mediumint NOT NULL DEFAULT 0,
436 CHANGE COLUMN `GemProperties` `GemProperties` mediumint NOT NULL DEFAULT 0,
437 CHANGE COLUMN `ExtendedCost` `ExtendedCost` mediumint NOT NULL DEFAULT 0,
438 CHANGE COLUMN `CondExtendedCost` `CondExtendedCost` mediumint unsigned NOT NULL DEFAULT 0,
439 CHANGE COLUMN `RequiredDisenchantSkill` `RequiredDisenchantSkill` smallint NOT NULL DEFAULT -1,
440 CHANGE COLUMN `ScriptName` `ScriptName` varchar(64) NOT NULL DEFAULT '',
441 CHANGE COLUMN `DisenchantID` `DisenchantID` mediumint unsigned NOT NULL DEFAULT 0,
442 CHANGE COLUMN `FoodType` `FoodType` tinyint unsigned NOT NULL DEFAULT 0,
443 CHANGE COLUMN `minMoneyLoot` `minMoneyLoot` integer unsigned NOT NULL DEFAULT 0,
444 CHANGE COLUMN `maxMoneyLoot` `maxMoneyLoot` integer unsigned NOT NULL DEFAULT 0,
445 CHANGE COLUMN `Duration` `Duration` integer NOT NULL DEFAULT 0 COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time';
446 ALTER TABLE `locales_creature`
447 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0;
448 ALTER TABLE `locales_gameobject`
449 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0;
450 ALTER TABLE `locales_item`
451 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0;
452 ALTER TABLE `locales_npc_text`
453 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0;
454 ALTER TABLE `locales_page_text`
455 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0;
456 ALTER TABLE `locales_quest`
457 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0;
458 ALTER TABLE `mangos_string`
459 CHANGE COLUMN `content_default` `content_default` text NOT NULL,
460 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0;
461 ALTER TABLE `npc_gossip`
462 CHANGE COLUMN `npc_guid` `npc_guid` integer unsigned NOT NULL DEFAULT 0,
463 CHANGE COLUMN `textid` `textid` mediumint unsigned NOT NULL DEFAULT 0;
464 ALTER TABLE `npc_gossip_textid`
465 CHANGE COLUMN `zoneid` `zoneid` smallint unsigned NOT NULL DEFAULT 0,
466 CHANGE COLUMN `action` `action` smallint unsigned NOT NULL DEFAULT 0,
467 CHANGE COLUMN `textid` `textid` mediumint unsigned NOT NULL DEFAULT 0;
468 ALTER TABLE `npc_option`
469 CHANGE COLUMN `id` `id` tinyint unsigned NOT NULL DEFAULT 0,
470 CHANGE COLUMN `gossip_id` `gossip_id` tinyint unsigned NOT NULL DEFAULT 0,
471 CHANGE COLUMN `npcflag` `npcflag` integer unsigned NOT NULL DEFAULT 0,
472 CHANGE COLUMN `icon` `icon` tinyint unsigned NOT NULL DEFAULT 0,
473 CHANGE COLUMN `action` `action` tinyint unsigned NOT NULL DEFAULT 0;
474 ALTER TABLE `npc_text`
475 CHANGE COLUMN `ID` `ID` mediumint unsigned NOT NULL DEFAULT 0,
476 CHANGE COLUMN `lang0` `lang0` tinyint unsigned NOT NULL DEFAULT 0,
477 CHANGE COLUMN `em0_0` `em0_0` smallint unsigned NOT NULL DEFAULT 0,
478 CHANGE COLUMN `em0_1` `em0_1` smallint unsigned NOT NULL DEFAULT 0,
479 CHANGE COLUMN `em0_2` `em0_2` smallint unsigned NOT NULL DEFAULT 0,
480 CHANGE COLUMN `em0_3` `em0_3` smallint unsigned NOT NULL DEFAULT 0,
481 CHANGE COLUMN `em0_4` `em0_4` smallint unsigned NOT NULL DEFAULT 0,
482 CHANGE COLUMN `em0_5` `em0_5` smallint unsigned NOT NULL DEFAULT 0,
483 CHANGE COLUMN `lang1` `lang1` tinyint unsigned NOT NULL DEFAULT 0,
484 CHANGE COLUMN `em1_0` `em1_0` smallint unsigned NOT NULL DEFAULT 0,
485 CHANGE COLUMN `em1_1` `em1_1` smallint unsigned NOT NULL DEFAULT 0,
486 CHANGE COLUMN `em1_2` `em1_2` smallint unsigned NOT NULL DEFAULT 0,
487 CHANGE COLUMN `em1_3` `em1_3` smallint unsigned NOT NULL DEFAULT 0,
488 CHANGE COLUMN `em1_4` `em1_4` smallint unsigned NOT NULL DEFAULT 0,
489 CHANGE COLUMN `em1_5` `em1_5` smallint unsigned NOT NULL DEFAULT 0,
490 CHANGE COLUMN `lang2` `lang2` tinyint unsigned NOT NULL DEFAULT 0,
491 CHANGE COLUMN `em2_0` `em2_0` smallint unsigned NOT NULL DEFAULT 0,
492 CHANGE COLUMN `em2_1` `em2_1` smallint unsigned NOT NULL DEFAULT 0,
493 CHANGE COLUMN `em2_2` `em2_2` smallint unsigned NOT NULL DEFAULT 0,
494 CHANGE COLUMN `em2_3` `em2_3` smallint unsigned NOT NULL DEFAULT 0,
495 CHANGE COLUMN `em2_4` `em2_4` smallint unsigned NOT NULL DEFAULT 0,
496 CHANGE COLUMN `em2_5` `em2_5` smallint unsigned NOT NULL DEFAULT 0,
497 CHANGE COLUMN `lang3` `lang3` tinyint unsigned NOT NULL DEFAULT 0,
498 CHANGE COLUMN `em3_0` `em3_0` smallint unsigned NOT NULL DEFAULT 0,
499 CHANGE COLUMN `em3_1` `em3_1` smallint unsigned NOT NULL DEFAULT 0,
500 CHANGE COLUMN `em3_2` `em3_2` smallint unsigned NOT NULL DEFAULT 0,
501 CHANGE COLUMN `em3_3` `em3_3` smallint unsigned NOT NULL DEFAULT 0,
502 CHANGE COLUMN `em3_4` `em3_4` smallint unsigned NOT NULL DEFAULT 0,
503 CHANGE COLUMN `em3_5` `em3_5` smallint unsigned NOT NULL DEFAULT 0,
504 CHANGE COLUMN `lang4` `lang4` tinyint unsigned NOT NULL DEFAULT 0,
505 CHANGE COLUMN `em4_0` `em4_0` smallint unsigned NOT NULL DEFAULT 0,
506 CHANGE COLUMN `em4_1` `em4_1` smallint unsigned NOT NULL DEFAULT 0,
507 CHANGE COLUMN `em4_2` `em4_2` smallint unsigned NOT NULL DEFAULT 0,
508 CHANGE COLUMN `em4_3` `em4_3` smallint unsigned NOT NULL DEFAULT 0,
509 CHANGE COLUMN `em4_4` `em4_4` smallint unsigned NOT NULL DEFAULT 0,
510 CHANGE COLUMN `em4_5` `em4_5` smallint unsigned NOT NULL DEFAULT 0,
511 CHANGE COLUMN `lang5` `lang5` tinyint unsigned NOT NULL DEFAULT 0,
512 CHANGE COLUMN `em5_0` `em5_0` smallint unsigned NOT NULL DEFAULT 0,
513 CHANGE COLUMN `em5_1` `em5_1` smallint unsigned NOT NULL DEFAULT 0,
514 CHANGE COLUMN `em5_2` `em5_2` smallint unsigned NOT NULL DEFAULT 0,
515 CHANGE COLUMN `em5_3` `em5_3` smallint unsigned NOT NULL DEFAULT 0,
516 CHANGE COLUMN `em5_4` `em5_4` smallint unsigned NOT NULL DEFAULT 0,
517 CHANGE COLUMN `em5_5` `em5_5` smallint unsigned NOT NULL DEFAULT 0,
518 CHANGE COLUMN `lang6` `lang6` tinyint unsigned NOT NULL DEFAULT 0,
519 CHANGE COLUMN `em6_0` `em6_0` smallint unsigned NOT NULL DEFAULT 0,
520 CHANGE COLUMN `em6_1` `em6_1` smallint unsigned NOT NULL DEFAULT 0,
521 CHANGE COLUMN `em6_2` `em6_2` smallint unsigned NOT NULL DEFAULT 0,
522 CHANGE COLUMN `em6_3` `em6_3` smallint unsigned NOT NULL DEFAULT 0,
523 CHANGE COLUMN `em6_4` `em6_4` smallint unsigned NOT NULL DEFAULT 0,
524 CHANGE COLUMN `em6_5` `em6_5` smallint unsigned NOT NULL DEFAULT 0,
525 CHANGE COLUMN `lang7` `lang7` tinyint unsigned NOT NULL DEFAULT 0,
526 CHANGE COLUMN `em7_0` `em7_0` smallint unsigned NOT NULL DEFAULT 0,
527 CHANGE COLUMN `em7_1` `em7_1` smallint unsigned NOT NULL DEFAULT 0,
528 CHANGE COLUMN `em7_2` `em7_2` smallint unsigned NOT NULL DEFAULT 0,
529 CHANGE COLUMN `em7_3` `em7_3` smallint unsigned NOT NULL DEFAULT 0,
530 CHANGE COLUMN `em7_4` `em7_4` smallint unsigned NOT NULL DEFAULT 0,
531 CHANGE COLUMN `em7_5` `em7_5` smallint unsigned NOT NULL DEFAULT 0;
532 ALTER TABLE `npc_trainer`
533 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
534 CHANGE COLUMN `spell` `spell` mediumint unsigned NOT NULL DEFAULT 0,
535 CHANGE COLUMN `spellcost` `spellcost` integer unsigned NOT NULL DEFAULT 0,
536 CHANGE COLUMN `reqskill` `reqskill` smallint unsigned NOT NULL DEFAULT 0,
537 CHANGE COLUMN `reqskillvalue` `reqskillvalue` smallint unsigned NOT NULL DEFAULT 0,
538 CHANGE COLUMN `reqlevel` `reqlevel` tinyint unsigned NOT NULL DEFAULT 0;
539 ALTER TABLE `npc_vendor`
540 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
541 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
542 CHANGE COLUMN `maxcount` `maxcount` tinyint unsigned NOT NULL DEFAULT 0,
543 CHANGE COLUMN `incrtime` `incrtime` integer unsigned NOT NULL DEFAULT 0;
544 ALTER TABLE `page_text`
545 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
546 CHANGE COLUMN `text` `text` longtext NOT NULL,
547 CHANGE COLUMN `next_page` `next_page` mediumint unsigned NOT NULL DEFAULT 0;
548 ALTER TABLE `pet_levelstats`
549 CHANGE COLUMN `creature_entry` `creature_entry` mediumint unsigned NOT NULL,
550 CHANGE COLUMN `level` `level` tinyint unsigned NOT NULL,
551 CHANGE COLUMN `hp` `hp` smallint unsigned NOT NULL,
552 CHANGE COLUMN `mana` `mana` smallint unsigned NOT NULL,
553 CHANGE COLUMN `armor` `armor` integer unsigned NOT NULL DEFAULT 0,
554 CHANGE COLUMN `str` `str` smallint unsigned NOT NULL,
555 CHANGE COLUMN `agi` `agi` smallint unsigned NOT NULL,
556 CHANGE COLUMN `sta` `sta` smallint unsigned NOT NULL,
557 CHANGE COLUMN `inte` `inte` smallint unsigned NOT NULL,
558 CHANGE COLUMN `spi` `spi` smallint unsigned NOT NULL;
559 ALTER TABLE `pet_name_generation`
560 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL auto_increment,
561 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
562 CHANGE COLUMN `half` `half` tinyint NOT NULL DEFAULT 0;
563 ALTER TABLE `petcreateinfo_spell`
564 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
565 CHANGE COLUMN `Spell1` `Spell1` mediumint unsigned NOT NULL DEFAULT 0,
566 CHANGE COLUMN `Spell2` `Spell2` mediumint unsigned NOT NULL DEFAULT 0,
567 CHANGE COLUMN `Spell3` `Spell3` mediumint unsigned NOT NULL DEFAULT 0,
568 CHANGE COLUMN `Spell4` `Spell4` mediumint unsigned NOT NULL DEFAULT 0,
569 CHANGE COLUMN `FamilyPassive` `FamilyPassive` mediumint unsigned NOT NULL DEFAULT 0;
570 ALTER TABLE `pickpocketing_loot_template`
571 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
572 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
573 CHANGE COLUMN `QuestChanceOrGroup` `QuestChanceOrGroup` tinyint NOT NULL DEFAULT 0,
574 CHANGE COLUMN `mincount` `mincount` tinyint unsigned NOT NULL DEFAULT 1,
575 CHANGE COLUMN `maxcount` `maxcount` tinyint unsigned NOT NULL DEFAULT 1,
576 CHANGE COLUMN `freeforall` `freeforall` tinyint unsigned NOT NULL DEFAULT 0,
577 CHANGE COLUMN `lootcondition` `lootcondition` tinyint unsigned NOT NULL DEFAULT 0,
578 CHANGE COLUMN `condition_value1` `condition_value1` mediumint unsigned NOT NULL DEFAULT 0,
579 CHANGE COLUMN `condition_value2` `condition_value2` mediumint unsigned NOT NULL DEFAULT 0;
580 ALTER TABLE `playercreateinfo`
581 CHANGE COLUMN `race` `race` tinyint unsigned NOT NULL DEFAULT 0,
582 CHANGE COLUMN `class` `class` tinyint unsigned NOT NULL DEFAULT 0,
583 CHANGE COLUMN `map` `map` smallint unsigned NOT NULL DEFAULT 0,
584 CHANGE COLUMN `zone` `zone` mediumint unsigned NOT NULL DEFAULT 0;
585 ALTER TABLE `playercreateinfo_action`
586 CHANGE COLUMN `race` `race` tinyint unsigned NOT NULL DEFAULT 0,
587 CHANGE COLUMN `class` `class` tinyint unsigned NOT NULL DEFAULT 0,
588 CHANGE COLUMN `button` `button` smallint unsigned NOT NULL DEFAULT 0,
589 CHANGE COLUMN `action` `action` smallint unsigned NOT NULL DEFAULT 0,
590 CHANGE COLUMN `type` `type` smallint unsigned NOT NULL DEFAULT 0,
591 CHANGE COLUMN `misc` `misc` smallint unsigned NOT NULL DEFAULT 0;
592 ALTER TABLE `playercreateinfo_item`
593 CHANGE COLUMN `race` `race` tinyint unsigned NOT NULL DEFAULT 0,
594 CHANGE COLUMN `class` `class` tinyint unsigned NOT NULL DEFAULT 0,
595 CHANGE COLUMN `itemid` `itemid` mediumint unsigned NOT NULL DEFAULT 0,
596 CHANGE COLUMN `amount` `amount` tinyint unsigned NOT NULL DEFAULT 1;
597 ALTER TABLE `playercreateinfo_skill`
598 CHANGE COLUMN `race` `race` tinyint unsigned NOT NULL DEFAULT 0,
599 CHANGE COLUMN `class` `class` tinyint unsigned NOT NULL DEFAULT 0,
600 CHANGE COLUMN `Skill` `Skill` smallint unsigned NOT NULL DEFAULT 0;
601 ALTER TABLE `playercreateinfo_spell`
602 CHANGE COLUMN `race` `race` tinyint unsigned NOT NULL DEFAULT 0,
603 CHANGE COLUMN `class` `class` tinyint unsigned NOT NULL DEFAULT 0,
604 CHANGE COLUMN `Spell` `Spell` mediumint unsigned NOT NULL DEFAULT 0,
605 CHANGE COLUMN `Active` `Active` tinyint unsigned NOT NULL DEFAULT 1;
606 -- here posted
607 ALTER TABLE `prospecting_loot_template`
608 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
609 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
610 CHANGE COLUMN `QuestChanceOrGroup` `QuestChanceOrGroup` tinyint NOT NULL DEFAULT 0,
611 CHANGE COLUMN `mincount` `mincount` tinyint unsigned NOT NULL DEFAULT 1,
612 CHANGE COLUMN `maxcount` `maxcount` tinyint unsigned NOT NULL DEFAULT 1,
613 CHANGE COLUMN `freeforall` `freeforall` tinyint unsigned NOT NULL DEFAULT 0,
614 CHANGE COLUMN `lootcondition` `lootcondition` tinyint unsigned NOT NULL DEFAULT 0,
615 CHANGE COLUMN `condition_value1` `condition_value1` mediumint unsigned NOT NULL DEFAULT 0,
616 CHANGE COLUMN `condition_value2` `condition_value2` mediumint unsigned NOT NULL DEFAULT 0;
617 ALTER TABLE `quest_end_scripts`
618 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
619 CHANGE COLUMN `delay` `delay` integer unsigned NOT NULL DEFAULT 0,
620 CHANGE COLUMN `command` `command` mediumint unsigned NOT NULL DEFAULT 0,
621 CHANGE COLUMN `datalong` `datalong` mediumint unsigned NOT NULL DEFAULT 0,
622 CHANGE COLUMN `datalong2` `datalong2` integer unsigned NOT NULL DEFAULT 0;
623 ALTER TABLE `quest_start_scripts`
624 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
625 CHANGE COLUMN `delay` `delay` integer unsigned NOT NULL DEFAULT 0,
626 CHANGE COLUMN `command` `command` mediumint unsigned NOT NULL DEFAULT 0,
627 CHANGE COLUMN `datalong` `datalong` mediumint unsigned NOT NULL DEFAULT 0,
628 CHANGE COLUMN `datalong2` `datalong2` integer unsigned NOT NULL DEFAULT 0;
629 ALTER TABLE `quest_template`
630 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
631 CHANGE COLUMN `ZoneOrSort` `ZoneOrSort` smallint NOT NULL DEFAULT 0,
632 CHANGE COLUMN `MinLevel` `MinLevel` tinyint unsigned NOT NULL DEFAULT 0,
633 CHANGE COLUMN `QuestLevel` `QuestLevel` tinyint unsigned NOT NULL DEFAULT 0,
634 CHANGE COLUMN `Type` `Type` smallint unsigned NOT NULL DEFAULT 0,
635 CHANGE COLUMN `RequiredRaces` `RequiredRaces` smallint unsigned NOT NULL DEFAULT 0,
636 CHANGE COLUMN `RequiredSkillValue` `RequiredSkillValue` smallint unsigned NOT NULL DEFAULT 0,
637 CHANGE COLUMN `RepObjectiveFaction` `RepObjectiveFaction` smallint unsigned NOT NULL DEFAULT 0,
638 CHANGE COLUMN `RepObjectiveValue` `RepObjectiveValue` mediumint NOT NULL DEFAULT 0,
639 CHANGE COLUMN `RequiredMinRepFaction` `RequiredMinRepFaction` smallint unsigned NOT NULL DEFAULT 0,
640 CHANGE COLUMN `RequiredMinRepValue` `RequiredMinRepValue` mediumint NOT NULL DEFAULT 0,
641 CHANGE COLUMN `RequiredMaxRepFaction` `RequiredMaxRepFaction` smallint unsigned NOT NULL DEFAULT 0,
642 CHANGE COLUMN `RequiredMaxRepValue` `RequiredMaxRepValue` mediumint NOT NULL DEFAULT 0,
643 CHANGE COLUMN `SuggestedPlayers` `SuggestedPlayers` tinyint unsigned NOT NULL DEFAULT 0,
644 CHANGE COLUMN `LimitTime` `LimitTime` integer unsigned NOT NULL DEFAULT 0,
645 CHANGE COLUMN `QuestFlags` `QuestFlags` smallint unsigned NOT NULL DEFAULT 0,
646 CHANGE COLUMN `SpecialFlags` `SpecialFlags` tinyint unsigned NOT NULL DEFAULT 0,
647 CHANGE COLUMN `PrevQuestId` `PrevQuestId` mediumint NOT NULL DEFAULT 0,
648 CHANGE COLUMN `NextQuestId` `NextQuestId` mediumint NOT NULL DEFAULT 0,
649 CHANGE COLUMN `ExclusiveGroup` `ExclusiveGroup` mediumint NOT NULL DEFAULT 0,
650 CHANGE COLUMN `NextQuestInChain` `NextQuestInChain` mediumint unsigned NOT NULL DEFAULT 0,
651 CHANGE COLUMN `SrcItemId` `SrcItemId` mediumint unsigned NOT NULL DEFAULT 0,
652 CHANGE COLUMN `SrcItemCount` `SrcItemCount` tinyint unsigned NOT NULL DEFAULT 0,
653 CHANGE COLUMN `SrcSpell` `SrcSpell` mediumint unsigned NOT NULL DEFAULT 0,
654 CHANGE COLUMN `ReqItemId1` `ReqItemId1` mediumint unsigned NOT NULL DEFAULT 0,
655 CHANGE COLUMN `ReqItemId2` `ReqItemId2` mediumint unsigned NOT NULL DEFAULT 0,
656 CHANGE COLUMN `ReqItemId3` `ReqItemId3` mediumint unsigned NOT NULL DEFAULT 0,
657 CHANGE COLUMN `ReqItemId4` `ReqItemId4` mediumint unsigned NOT NULL DEFAULT 0,
658 CHANGE COLUMN `ReqItemCount1` `ReqItemCount1` smallint unsigned NOT NULL DEFAULT 0,
659 CHANGE COLUMN `ReqItemCount2` `ReqItemCount2` smallint unsigned NOT NULL DEFAULT 0,
660 CHANGE COLUMN `ReqItemCount3` `ReqItemCount3` smallint unsigned NOT NULL DEFAULT 0,
661 CHANGE COLUMN `ReqItemCount4` `ReqItemCount4` smallint unsigned NOT NULL DEFAULT 0,
662 CHANGE COLUMN `ReqSourceId1` `ReqSourceId1` mediumint unsigned NOT NULL DEFAULT 0,
663 CHANGE COLUMN `ReqSourceId2` `ReqSourceId2` mediumint unsigned NOT NULL DEFAULT 0,
664 CHANGE COLUMN `ReqSourceId3` `ReqSourceId3` mediumint unsigned NOT NULL DEFAULT 0,
665 CHANGE COLUMN `ReqSourceId4` `ReqSourceId4` mediumint unsigned NOT NULL DEFAULT 0,
666 CHANGE COLUMN `ReqSourceCount1` `ReqSourceCount1` smallint unsigned NOT NULL DEFAULT 0,
667 CHANGE COLUMN `ReqSourceCount2` `ReqSourceCount2` smallint unsigned NOT NULL DEFAULT 0,
668 CHANGE COLUMN `ReqSourceCount3` `ReqSourceCount3` smallint unsigned NOT NULL DEFAULT 0,
669 CHANGE COLUMN `ReqSourceCount4` `ReqSourceCount4` smallint unsigned NOT NULL DEFAULT 0,
670 CHANGE COLUMN `ReqSourceRef1` `ReqSourceRef1` tinyint unsigned NOT NULL DEFAULT 0,
671 CHANGE COLUMN `ReqSourceRef2` `ReqSourceRef2` tinyint unsigned NOT NULL DEFAULT 0,
672 CHANGE COLUMN `ReqSourceRef3` `ReqSourceRef3` tinyint unsigned NOT NULL DEFAULT 0,
673 CHANGE COLUMN `ReqSourceRef4` `ReqSourceRef4` tinyint unsigned NOT NULL DEFAULT 0,
674 CHANGE COLUMN `ReqCreatureOrGOId1` `ReqCreatureOrGOId1` mediumint NOT NULL DEFAULT 0,
675 CHANGE COLUMN `ReqCreatureOrGOId2` `ReqCreatureOrGOId2` mediumint NOT NULL DEFAULT 0,
676 CHANGE COLUMN `ReqCreatureOrGOId3` `ReqCreatureOrGOId3` mediumint NOT NULL DEFAULT 0,
677 CHANGE COLUMN `ReqCreatureOrGOId4` `ReqCreatureOrGOId4` mediumint NOT NULL DEFAULT 0,
678 CHANGE COLUMN `ReqCreatureOrGOCount1` `ReqCreatureOrGOCount1` smallint unsigned NOT NULL DEFAULT 0,
679 CHANGE COLUMN `ReqCreatureOrGOCount2` `ReqCreatureOrGOCount2` smallint unsigned NOT NULL DEFAULT 0,
680 CHANGE COLUMN `ReqCreatureOrGOCount3` `ReqCreatureOrGOCount3` smallint unsigned NOT NULL DEFAULT 0,
681 CHANGE COLUMN `ReqCreatureOrGOCount4` `ReqCreatureOrGOCount4` smallint unsigned NOT NULL DEFAULT 0,
682 CHANGE COLUMN `ReqSpellCast1` `ReqSpellCast1` mediumint unsigned NOT NULL DEFAULT 0,
683 CHANGE COLUMN `ReqSpellCast2` `ReqSpellCast2` mediumint unsigned NOT NULL DEFAULT 0,
684 CHANGE COLUMN `ReqSpellCast3` `ReqSpellCast3` mediumint unsigned NOT NULL DEFAULT 0,
685 CHANGE COLUMN `ReqSpellCast4` `ReqSpellCast4` mediumint unsigned NOT NULL DEFAULT 0,
686 CHANGE COLUMN `RewChoiceItemId1` `RewChoiceItemId1` mediumint unsigned NOT NULL DEFAULT 0,
687 CHANGE COLUMN `RewChoiceItemId2` `RewChoiceItemId2` mediumint unsigned NOT NULL DEFAULT 0,
688 CHANGE COLUMN `RewChoiceItemId3` `RewChoiceItemId3` mediumint unsigned NOT NULL DEFAULT 0,
689 CHANGE COLUMN `RewChoiceItemId4` `RewChoiceItemId4` mediumint unsigned NOT NULL DEFAULT 0,
690 CHANGE COLUMN `RewChoiceItemId5` `RewChoiceItemId5` mediumint unsigned NOT NULL DEFAULT 0,
691 CHANGE COLUMN `RewChoiceItemId6` `RewChoiceItemId6` mediumint unsigned NOT NULL DEFAULT 0,
692 CHANGE COLUMN `RewChoiceItemCount1` `RewChoiceItemCount1` smallint unsigned NOT NULL DEFAULT 0,
693 CHANGE COLUMN `RewChoiceItemCount2` `RewChoiceItemCount2` smallint unsigned NOT NULL DEFAULT 0,
694 CHANGE COLUMN `RewChoiceItemCount3` `RewChoiceItemCount3` smallint unsigned NOT NULL DEFAULT 0,
695 CHANGE COLUMN `RewChoiceItemCount4` `RewChoiceItemCount4` smallint unsigned NOT NULL DEFAULT 0,
696 CHANGE COLUMN `RewChoiceItemCount5` `RewChoiceItemCount5` smallint unsigned NOT NULL DEFAULT 0,
697 CHANGE COLUMN `RewChoiceItemCount6` `RewChoiceItemCount6` smallint unsigned NOT NULL DEFAULT 0,
698 CHANGE COLUMN `RewItemId1` `RewItemId1` mediumint unsigned NOT NULL DEFAULT 0,
699 CHANGE COLUMN `RewItemId2` `RewItemId2` mediumint unsigned NOT NULL DEFAULT 0,
700 CHANGE COLUMN `RewItemId3` `RewItemId3` mediumint unsigned NOT NULL DEFAULT 0,
701 CHANGE COLUMN `RewItemId4` `RewItemId4` mediumint unsigned NOT NULL DEFAULT 0,
702 CHANGE COLUMN `RewItemCount1` `RewItemCount1` smallint unsigned NOT NULL DEFAULT 0,
703 CHANGE COLUMN `RewItemCount2` `RewItemCount2` smallint unsigned NOT NULL DEFAULT 0,
704 CHANGE COLUMN `RewItemCount3` `RewItemCount3` smallint unsigned NOT NULL DEFAULT 0,
705 CHANGE COLUMN `RewItemCount4` `RewItemCount4` smallint unsigned NOT NULL DEFAULT 0,
706 CHANGE COLUMN `RewRepFaction1` `RewRepFaction1` smallint unsigned NOT NULL DEFAULT 0 COMMENT 'faction id from Faction.dbc in this case',
707 CHANGE COLUMN `RewRepFaction2` `RewRepFaction2` smallint unsigned NOT NULL DEFAULT 0 COMMENT 'faction id from Faction.dbc in this case',
708 CHANGE COLUMN `RewRepFaction3` `RewRepFaction3` smallint unsigned NOT NULL DEFAULT 0 COMMENT 'faction id from Faction.dbc in this case',
709 CHANGE COLUMN `RewRepFaction4` `RewRepFaction4` smallint unsigned NOT NULL DEFAULT 0 COMMENT 'faction id from Faction.dbc in this case',
710 CHANGE COLUMN `RewRepFaction5` `RewRepFaction5` smallint unsigned NOT NULL DEFAULT 0 COMMENT 'faction id from Faction.dbc in this case',
711 CHANGE COLUMN `RewRepValue1` `RewRepValue1` mediumint NOT NULL DEFAULT 0,
712 CHANGE COLUMN `RewRepValue2` `RewRepValue2` mediumint NOT NULL DEFAULT 0,
713 CHANGE COLUMN `RewRepValue3` `RewRepValue3` mediumint NOT NULL DEFAULT 0,
714 CHANGE COLUMN `RewRepValue4` `RewRepValue4` mediumint NOT NULL DEFAULT 0,
715 CHANGE COLUMN `RewRepValue5` `RewRepValue5` mediumint NOT NULL DEFAULT 0,
716 CHANGE COLUMN `RewOrReqMoney` `RewOrReqMoney` integer NOT NULL DEFAULT 0,
717 CHANGE COLUMN `RewMoneyMaxLevel` `RewMoneyMaxLevel` integer unsigned NOT NULL DEFAULT 0,
718 CHANGE COLUMN `RewSpell` `RewSpell` mediumint unsigned NOT NULL DEFAULT 0,
719 CHANGE COLUMN `PointMapId` `PointMapId` smallint unsigned NOT NULL DEFAULT 0,
720 CHANGE COLUMN `PointOpt` `PointOpt` mediumint unsigned NOT NULL DEFAULT 0,
721 CHANGE COLUMN `DetailsEmote1` `DetailsEmote1` smallint unsigned NOT NULL DEFAULT 0,
722 CHANGE COLUMN `DetailsEmote2` `DetailsEmote2` smallint unsigned NOT NULL DEFAULT 0,
723 CHANGE COLUMN `DetailsEmote3` `DetailsEmote3` smallint unsigned NOT NULL DEFAULT 0,
724 CHANGE COLUMN `DetailsEmote4` `DetailsEmote4` smallint unsigned NOT NULL DEFAULT 0,
725 CHANGE COLUMN `IncompleteEmote` `IncompleteEmote` smallint unsigned NOT NULL DEFAULT 0,
726 CHANGE COLUMN `CompleteEmote` `CompleteEmote` smallint unsigned NOT NULL DEFAULT 0,
727 CHANGE COLUMN `OfferRewardEmote1` `OfferRewardEmote1` smallint unsigned NOT NULL DEFAULT 0,
728 CHANGE COLUMN `OfferRewardEmote2` `OfferRewardEmote2` smallint unsigned NOT NULL DEFAULT 0,
729 CHANGE COLUMN `OfferRewardEmote3` `OfferRewardEmote3` smallint unsigned NOT NULL DEFAULT 0,
730 CHANGE COLUMN `OfferRewardEmote4` `OfferRewardEmote4` smallint unsigned NOT NULL DEFAULT 0,
731 CHANGE COLUMN `StartScript` `StartScript` mediumint unsigned NOT NULL DEFAULT 0,
732 CHANGE COLUMN `CompleteScript` `CompleteScript` mediumint unsigned NOT NULL DEFAULT 0;
733 ALTER TABLE `skill_discovery_template`
734 CHANGE COLUMN `spellId` `spellId` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'SpellId of the discoverable spell',
735 CHANGE COLUMN `reqSpell` `reqSpell` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'spell requirement';
736 ALTER TABLE `skill_extra_item_template`
737 CHANGE COLUMN `spellId` `spellId` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'SpellId of the item creation spell',
738 CHANGE COLUMN `requiredSpecialization` `requiredSpecialization` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Specialization spell id',
739 CHANGE COLUMN `additionalMaxNum` `additionalMaxNum` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'max num of adds';
740 ALTER TABLE `skinning_loot_template`
741 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
742 CHANGE COLUMN `item` `item` mediumint unsigned NOT NULL DEFAULT 0,
743 CHANGE COLUMN `QuestChanceOrGroup` `QuestChanceOrGroup` tinyint NOT NULL DEFAULT 0,
744 CHANGE COLUMN `mincount` `mincount` tinyint unsigned NOT NULL DEFAULT 1,
745 CHANGE COLUMN `maxcount` `maxcount` tinyint unsigned NOT NULL DEFAULT 1,
746 CHANGE COLUMN `freeforall` `freeforall` tinyint unsigned NOT NULL DEFAULT 0,
747 CHANGE COLUMN `lootcondition` `lootcondition` tinyint unsigned NOT NULL DEFAULT 0,
748 CHANGE COLUMN `condition_value1` `condition_value1` mediumint unsigned NOT NULL DEFAULT 0,
749 CHANGE COLUMN `condition_value2` `condition_value2` mediumint unsigned NOT NULL DEFAULT 0;
750 ALTER TABLE `spell_affect`
751 CHANGE COLUMN `entry` `entry` smallint unsigned NOT NULL DEFAULT 0,
752 CHANGE COLUMN `effectId` `effectId` tinyint unsigned NOT NULL DEFAULT 0,
753 CHANGE COLUMN `SpellFamily` `SpellFamily` tinyint unsigned NOT NULL DEFAULT 0,
754 CHANGE COLUMN `SpellFamilyMask` `SpellFamilyMask` bigint unsigned NOT NULL DEFAULT 0,
755 CHANGE COLUMN `Charges` `Charges` smallint unsigned NOT NULL DEFAULT 0;
756 ALTER TABLE `spell_chain`
757 CHANGE COLUMN `spell_id` `spell_id` mediumint NOT NULL DEFAULT 0,
758 CHANGE COLUMN `prev_spell` `prev_spell` mediumint NOT NULL DEFAULT 0,
759 CHANGE COLUMN `first_spell` `first_spell` mediumint NOT NULL DEFAULT 0,
760 CHANGE COLUMN `rank` `rank` tinyint NOT NULL DEFAULT 0;
761 ALTER TABLE `spell_learn_skill`
762 CHANGE COLUMN `entry` `entry` smallint unsigned NOT NULL DEFAULT 0,
763 CHANGE COLUMN `SkillID` `SkillID` smallint NOT NULL DEFAULT 0,
764 CHANGE COLUMN `Value` `Value` smallint NOT NULL DEFAULT 0,
765 CHANGE COLUMN `MaxValue` `MaxValue` smallint NOT NULL DEFAULT 0;
766 ALTER TABLE `spell_learn_spell`
767 CHANGE COLUMN `entry` `entry` smallint unsigned NOT NULL DEFAULT 0,
768 CHANGE COLUMN `SpellID` `SpellID` smallint unsigned NOT NULL DEFAULT 0,
769 CHANGE COLUMN `IfNoSpell` `IfNoSpell` smallint unsigned NOT NULL DEFAULT 0;
770 ALTER TABLE `spell_proc_event`
771 CHANGE COLUMN `entry` `entry` smallint unsigned NOT NULL DEFAULT 0,
772 CHANGE COLUMN `SchoolMask` `SchoolMask` tinyint NOT NULL DEFAULT 0,
773 CHANGE COLUMN `Category` `Category` smallint NOT NULL DEFAULT 0,
774 CHANGE COLUMN `SkillID` `SkillID` smallint NOT NULL DEFAULT 0,
775 CHANGE COLUMN `SpellFamilyName` `SpellFamilyName` smallint unsigned NOT NULL DEFAULT 0,
776 CHANGE COLUMN `SpellFamilyMask` `SpellFamilyMask` bigint unsigned NOT NULL DEFAULT 0,
777 CHANGE COLUMN `procFlags` `procFlags` integer unsigned NOT NULL DEFAULT 0;
778 ALTER TABLE `spell_script_target`
779 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL,
780 CHANGE COLUMN `type` `type` tinyint unsigned NOT NULL DEFAULT 0,
781 CHANGE COLUMN `targetEntry` `targetEntry` mediumint unsigned NOT NULL DEFAULT 0;
782 ALTER TABLE `spell_scripts`
783 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0,
784 CHANGE COLUMN `delay` `delay` integer unsigned NOT NULL DEFAULT 0,
785 CHANGE COLUMN `command` `command` mediumint unsigned NOT NULL DEFAULT 0,
786 CHANGE COLUMN `datalong` `datalong` mediumint unsigned NOT NULL DEFAULT 0,
787 CHANGE COLUMN `datalong2` `datalong2` integer unsigned NOT NULL DEFAULT 0;
788 ALTER TABLE `spell_teleport`
789 CHANGE COLUMN `id` `id` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier',
790 CHANGE COLUMN `target_map` `target_map` smallint unsigned NOT NULL DEFAULT 0;
791 ALTER TABLE `spell_threat`
792 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL,
793 CHANGE COLUMN `Threat` `Threat` smallint NOT NULL;
794 ALTER TABLE `transports`
795 CHANGE COLUMN `entry` `entry` mediumint unsigned NOT NULL DEFAULT 0,
796 CHANGE COLUMN `period` `period` mediumint unsigned NOT NULL DEFAULT 0;
797 ALTER TABLE `uptime`
798 CHANGE COLUMN `starttime` `starttime` bigint unsigned NOT NULL DEFAULT 0,
799 CHANGE COLUMN `startstring` `startstring` varchar(64) NOT NULL DEFAULT '',
800 CHANGE COLUMN `uptime` `uptime` bigint unsigned NOT NULL DEFAULT 0,
801 CHANGE COLUMN `maxplayers` `maxplayers` smallint unsigned NOT NULL DEFAULT 0;