· 9 years ago · Dec 13, 2016, 09:44 PM
1CREATE TABLE IF NOT EXISTS `updates_include` (
2 `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
3 `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
4 PRIMARY KEY (`path`)
5) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of directories where we want to include sql updates.';
6
7-- Dumping data for table hotfixes.updates_include: 3 rows
8DELETE FROM `updates_include`;
9/*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
10INSERT INTO `updates_include` (`path`, `state`) VALUES
11 ('$/sql/updates/hotfixes', 'RELEASED'),
12 ('$/sql/custom/hotfixes', 'RELEASED'),
13 ('$/sql/old/6.x/hotfixes', 'ARCHIVED');
14/*!40000 ALTER TABLE `updates_include` ENABLE KEYS */;
15
16
17-- Dumping structure for table hotfixes.vehicle
18CREATE TABLE IF NOT EXISTS `vehicle` (
19 `ID` int(10) unsigned NOT NULL DEFAULT '0',
20 `Flags` int(10) unsigned NOT NULL DEFAULT '0',
21 `TurnSpeed` float NOT NULL DEFAULT '0',
22 `PitchSpeed` float NOT NULL DEFAULT '0',
23 `PitchMin` float NOT NULL DEFAULT '0',
24 `PitchMax` float NOT NULL DEFAULT '0',
25 `MouseLookOffsetPitch` float NOT NULL DEFAULT '0',
26 `CameraFadeDistScalarMin` float NOT NULL DEFAULT '0',
27 `CameraFadeDistScalarMax` float NOT NULL DEFAULT '0',
28 `CameraPitchOffset` float NOT NULL DEFAULT '0',
29 `FacingLimitRight` float NOT NULL DEFAULT '0',
30 `FacingLimitLeft` float NOT NULL DEFAULT '0',
31 `MsslTrgtTurnLingering` float NOT NULL DEFAULT '0',
32 `MsslTrgtPitchLingering` float NOT NULL DEFAULT '0',
33 `MsslTrgtMouseLingering` float NOT NULL DEFAULT '0',
34 `MsslTrgtEndOpacity` float NOT NULL DEFAULT '0',
35 `MsslTrgtArcSpeed` float NOT NULL DEFAULT '0',
36 `MsslTrgtArcRepeat` float NOT NULL DEFAULT '0',
37 `MsslTrgtArcWidth` float NOT NULL DEFAULT '0',
38 `MsslTrgtImpactRadius1` float NOT NULL DEFAULT '0',
39 `MsslTrgtImpactRadius2` float NOT NULL DEFAULT '0',
40 `MsslTrgtArcTexture` text,
41 `MsslTrgtImpactTexture` text,
42 `MsslTrgtImpactModel1` text,
43 `MsslTrgtImpactModel2` text,
44 `CameraYawOffset` float NOT NULL DEFAULT '0',
45 `MsslTrgtImpactTexRadius` float NOT NULL DEFAULT '0',
46 `SeatID1` smallint(5) unsigned NOT NULL DEFAULT '0',
47 `SeatID2` smallint(5) unsigned NOT NULL DEFAULT '0',
48 `SeatID3` smallint(5) unsigned NOT NULL DEFAULT '0',
49 `SeatID4` smallint(5) unsigned NOT NULL DEFAULT '0',
50 `SeatID5` smallint(5) unsigned NOT NULL DEFAULT '0',
51 `SeatID6` smallint(5) unsigned NOT NULL DEFAULT '0',
52 `SeatID7` smallint(5) unsigned NOT NULL DEFAULT '0',
53 `SeatID8` smallint(5) unsigned NOT NULL DEFAULT '0',
54 `VehicleUIIndicatorID` smallint(5) unsigned NOT NULL DEFAULT '0',
55 `PowerDisplayID1` smallint(5) unsigned NOT NULL DEFAULT '0',
56 `PowerDisplayID2` smallint(5) unsigned NOT NULL DEFAULT '0',
57 `PowerDisplayID3` smallint(5) unsigned NOT NULL DEFAULT '0',
58 `FlagsB` tinyint(3) unsigned NOT NULL DEFAULT '0',
59 `UILocomotionType` tinyint(3) unsigned NOT NULL DEFAULT '0',
60 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
61 PRIMARY KEY (`ID`)
62) ENGINE=MyISAM DEFAULT CHARSET=utf8;
63
64-- Dumping data for table hotfixes.vehicle: 0 rows
65DELETE FROM `vehicle`;
66/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
67/*!40000 ALTER TABLE `vehicle` ENABLE KEYS */;
68
69
70-- Dumping structure for table hotfixes.vehicle_seat
71CREATE TABLE IF NOT EXISTS `vehicle_seat` (
72 `ID` int(10) unsigned NOT NULL DEFAULT '0',
73 `Flags1` int(10) unsigned NOT NULL DEFAULT '0',
74 `Flags2` int(10) unsigned NOT NULL DEFAULT '0',
75 `Flags3` int(10) unsigned NOT NULL DEFAULT '0',
76 `AttachmentOffsetX` float NOT NULL DEFAULT '0',
77 `AttachmentOffsetY` float NOT NULL DEFAULT '0',
78 `AttachmentOffsetZ` float NOT NULL DEFAULT '0',
79 `EnterPreDelay` float NOT NULL DEFAULT '0',
80 `EnterSpeed` float NOT NULL DEFAULT '0',
81 `EnterGravity` float NOT NULL DEFAULT '0',
82 `EnterMinDuration` float NOT NULL DEFAULT '0',
83 `EnterMaxDuration` float NOT NULL DEFAULT '0',
84 `EnterMinArcHeight` float NOT NULL DEFAULT '0',
85 `EnterMaxArcHeight` float NOT NULL DEFAULT '0',
86 `ExitPreDelay` float NOT NULL DEFAULT '0',
87 `ExitSpeed` float NOT NULL DEFAULT '0',
88 `ExitGravity` float NOT NULL DEFAULT '0',
89 `ExitMinDuration` float NOT NULL DEFAULT '0',
90 `ExitMaxDuration` float NOT NULL DEFAULT '0',
91 `ExitMinArcHeight` float NOT NULL DEFAULT '0',
92 `ExitMaxArcHeight` float NOT NULL DEFAULT '0',
93 `PassengerYaw` float NOT NULL DEFAULT '0',
94 `PassengerPitch` float NOT NULL DEFAULT '0',
95 `PassengerRoll` float NOT NULL DEFAULT '0',
96 `VehicleEnterAnimDelay` float NOT NULL DEFAULT '0',
97 `VehicleExitAnimDelay` float NOT NULL DEFAULT '0',
98 `CameraEnteringDelay` float NOT NULL DEFAULT '0',
99 `CameraEnteringDuration` float NOT NULL DEFAULT '0',
100 `CameraExitingDelay` float NOT NULL DEFAULT '0',
101 `CameraExitingDuration` float NOT NULL DEFAULT '0',
102 `CameraOffsetX` float NOT NULL DEFAULT '0',
103 `CameraOffsetY` float NOT NULL DEFAULT '0',
104 `CameraOffsetZ` float NOT NULL DEFAULT '0',
105 `CameraPosChaseRate` float NOT NULL DEFAULT '0',
106 `CameraFacingChaseRate` float NOT NULL DEFAULT '0',
107 `CameraEnteringZoom` float NOT NULL DEFAULT '0',
108 `CameraSeatZoomMin` float NOT NULL DEFAULT '0',
109 `CameraSeatZoomMax` float NOT NULL DEFAULT '0',
110 `UISkinFileDataID` int(10) unsigned NOT NULL DEFAULT '0',
111 `EnterAnimStart` smallint(6) NOT NULL DEFAULT '0',
112 `EnterAnimLoop` smallint(6) NOT NULL DEFAULT '0',
113 `RideAnimStart` smallint(6) NOT NULL DEFAULT '0',
114 `RideAnimLoop` smallint(6) NOT NULL DEFAULT '0',
115 `RideUpperAnimStart` smallint(6) NOT NULL DEFAULT '0',
116 `RideUpperAnimLoop` smallint(6) NOT NULL DEFAULT '0',
117 `ExitAnimStart` smallint(6) NOT NULL DEFAULT '0',
118 `ExitAnimLoop` smallint(6) NOT NULL DEFAULT '0',
119 `ExitAnimEnd` smallint(6) NOT NULL DEFAULT '0',
120 `VehicleEnterAnim` smallint(6) NOT NULL DEFAULT '0',
121 `VehicleExitAnim` smallint(6) NOT NULL DEFAULT '0',
122 `VehicleRideAnimLoop` smallint(6) NOT NULL DEFAULT '0',
123 `EnterAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0',
124 `RideAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0',
125 `ExitAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0',
126 `VehicleEnterAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0',
127 `VehicleRideAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0',
128 `VehicleExitAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0',
129 `CameraModeID` smallint(5) unsigned NOT NULL DEFAULT '0',
130 `AttachmentID` tinyint(4) NOT NULL DEFAULT '0',
131 `PassengerAttachmentID` tinyint(4) NOT NULL DEFAULT '0',
132 `VehicleEnterAnimBone` tinyint(4) NOT NULL DEFAULT '0',
133 `VehicleExitAnimBone` tinyint(4) NOT NULL DEFAULT '0',
134 `VehicleRideAnimLoopBone` tinyint(4) NOT NULL DEFAULT '0',
135 `VehicleAbilityDisplay` tinyint(3) unsigned NOT NULL DEFAULT '0',
136 `EnterUISoundID` int(10) unsigned NOT NULL DEFAULT '0',
137 `ExitUISoundID` int(10) unsigned NOT NULL DEFAULT '0',
138 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
139 PRIMARY KEY (`ID`)
140) ENGINE=MyISAM DEFAULT CHARSET=utf8;
141
142-- Dumping data for table hotfixes.vehicle_seat: 0 rows
143DELETE FROM `vehicle_seat`;
144/*!40000 ALTER TABLE `vehicle_seat` DISABLE KEYS */;
145/*!40000 ALTER TABLE `vehicle_seat` ENABLE KEYS */;
146
147
148-- Dumping structure for table hotfixes.wmo_area_table
149CREATE TABLE IF NOT EXISTS `wmo_area_table` (
150 `WMOGroupID` int(11) NOT NULL DEFAULT '0',
151 `AreaName` text,
152 `WMOID` smallint(6) NOT NULL DEFAULT '0',
153 `AmbienceID` smallint(5) unsigned NOT NULL DEFAULT '0',
154 `ZoneMusic` smallint(5) unsigned NOT NULL DEFAULT '0',
155 `IntroSound` smallint(5) unsigned NOT NULL DEFAULT '0',
156 `AreaTableID` smallint(5) unsigned NOT NULL DEFAULT '0',
157 `UWIntroSound` smallint(5) unsigned NOT NULL DEFAULT '0',
158 `UWAmbience` smallint(5) unsigned NOT NULL DEFAULT '0',
159 `NameSet` tinyint(4) NOT NULL DEFAULT '0',
160 `SoundProviderPref` tinyint(3) unsigned NOT NULL DEFAULT '0',
161 `SoundProviderPrefUnderwater` tinyint(3) unsigned NOT NULL DEFAULT '0',
162 `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
163 `ID` int(10) unsigned NOT NULL DEFAULT '0',
164 `UWZoneMusic` int(10) unsigned NOT NULL DEFAULT '0',
165 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
166 PRIMARY KEY (`ID`)
167) ENGINE=MyISAM DEFAULT CHARSET=utf8;
168
169-- Dumping data for table hotfixes.wmo_area_table: 0 rows
170DELETE FROM `wmo_area_table`;
171/*!40000 ALTER TABLE `wmo_area_table` DISABLE KEYS */;
172/*!40000 ALTER TABLE `wmo_area_table` ENABLE KEYS */;
173
174
175-- Dumping structure for table hotfixes.wmo_area_table_locale
176CREATE TABLE IF NOT EXISTS `wmo_area_table_locale` (
177 `ID` int(10) unsigned NOT NULL DEFAULT '0',
178 `locale` varchar(4) NOT NULL,
179 `AreaName_lang` text,
180 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
181 PRIMARY KEY (`ID`,`locale`)
182) ENGINE=MyISAM DEFAULT CHARSET=utf8;
183
184-- Dumping data for table hotfixes.wmo_area_table_locale: 0 rows
185DELETE FROM `wmo_area_table_locale`;
186/*!40000 ALTER TABLE `wmo_area_table_locale` DISABLE KEYS */;
187/*!40000 ALTER TABLE `wmo_area_table_locale` ENABLE KEYS */;
188
189
190-- Dumping structure for table hotfixes.world_map_area
191CREATE TABLE IF NOT EXISTS `world_map_area` (
192 `AreaName` text,
193 `LocLeft` float NOT NULL DEFAULT '0',
194 `LocRight` float NOT NULL DEFAULT '0',
195 `LocTop` float NOT NULL DEFAULT '0',
196 `LocBottom` float NOT NULL DEFAULT '0',
197 `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
198 `AreaID` smallint(5) unsigned NOT NULL DEFAULT '0',
199 `DisplayMapID` smallint(6) NOT NULL DEFAULT '0',
200 `DefaultDungeonFloor` smallint(6) NOT NULL DEFAULT '0',
201 `ParentWorldMapID` smallint(5) unsigned NOT NULL DEFAULT '0',
202 `Flags` smallint(5) unsigned NOT NULL DEFAULT '0',
203 `LevelRangeMin` tinyint(3) unsigned NOT NULL DEFAULT '0',
204 `LevelRangeMax` tinyint(3) unsigned NOT NULL DEFAULT '0',
205 `BountySetID` tinyint(3) unsigned NOT NULL DEFAULT '0',
206 `BountyBoardLocation` tinyint(3) unsigned NOT NULL DEFAULT '0',
207 `ID` int(10) unsigned NOT NULL DEFAULT '0',
208 `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
209 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
210 PRIMARY KEY (`ID`)
211) ENGINE=MyISAM DEFAULT CHARSET=utf8;
212
213-- Dumping data for table hotfixes.world_map_area: 0 rows
214DELETE FROM `world_map_area`;
215/*!40000 ALTER TABLE `world_map_area` DISABLE KEYS */;
216/*!40000 ALTER TABLE `world_map_area` ENABLE KEYS */;
217
218
219-- Dumping structure for table hotfixes.world_map_overlay
220CREATE TABLE IF NOT EXISTS `world_map_overlay` (
221 `ID` int(10) unsigned NOT NULL DEFAULT '0',
222 `TextureName` text,
223 `TextureWidth` smallint(5) unsigned NOT NULL DEFAULT '0',
224 `TextureHeight` smallint(5) unsigned NOT NULL DEFAULT '0',
225 `MapAreaID` int(10) unsigned NOT NULL DEFAULT '0',
226 `AreaID1` int(10) unsigned NOT NULL DEFAULT '0',
227 `AreaID2` int(10) unsigned NOT NULL DEFAULT '0',
228 `AreaID3` int(10) unsigned NOT NULL DEFAULT '0',
229 `AreaID4` int(10) unsigned NOT NULL DEFAULT '0',
230 `OffsetX` int(10) unsigned NOT NULL DEFAULT '0',
231 `OffsetY` int(10) unsigned NOT NULL DEFAULT '0',
232 `HitRectTop` int(10) unsigned NOT NULL DEFAULT '0',
233 `HitRectLeft` int(10) unsigned NOT NULL DEFAULT '0',
234 `HitRectBottom` int(10) unsigned NOT NULL DEFAULT '0',
235 `HitRectRight` int(10) unsigned NOT NULL DEFAULT '0',
236 `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
237 `Flags` int(10) unsigned NOT NULL DEFAULT '0',
238 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
239 PRIMARY KEY (`ID`)
240) ENGINE=MyISAM DEFAULT CHARSET=utf8;
241
242-- Dumping data for table hotfixes.world_map_overlay: 0 rows
243DELETE FROM `world_map_overlay`;
244/*!40000 ALTER TABLE `world_map_overlay` DISABLE KEYS */;
245/*!40000 ALTER TABLE `world_map_overlay` ENABLE KEYS */;
246
247
248-- Dumping structure for table hotfixes.world_map_transforms
249CREATE TABLE IF NOT EXISTS `world_map_transforms` (
250 `ID` int(10) unsigned NOT NULL DEFAULT '0',
251 `RegionMinX` float NOT NULL DEFAULT '0',
252 `RegionMinY` float NOT NULL DEFAULT '0',
253 `RegionMinZ` float NOT NULL DEFAULT '0',
254 `RegionMaxX` float NOT NULL DEFAULT '0',
255 `RegionMaxY` float NOT NULL DEFAULT '0',
256 `RegionMaxZ` float NOT NULL DEFAULT '0',
257 `RegionOffsetX` float NOT NULL DEFAULT '0',
258 `RegionOffsetY` float NOT NULL DEFAULT '0',
259 `RegionScale` float NOT NULL DEFAULT '0',
260 `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
261 `AreaID` smallint(5) unsigned NOT NULL DEFAULT '0',
262 `NewMapID` smallint(5) unsigned NOT NULL DEFAULT '0',
263 `NewDungeonMapID` smallint(5) unsigned NOT NULL DEFAULT '0',
264 `NewAreaID` smallint(5) unsigned NOT NULL DEFAULT '0',
265 `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
266 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
267 PRIMARY KEY (`ID`)
268) ENGINE=MyISAM DEFAULT CHARSET=utf8;
269
270-- Dumping data for table hotfixes.world_map_transforms: 0 rows
271DELETE FROM `world_map_transforms`;
272/*!40000 ALTER TABLE `world_map_transforms` DISABLE KEYS */;
273/*!40000 ALTER TABLE `world_map_transforms` ENABLE KEYS */;
274
275
276-- Dumping structure for table hotfixes.world_safe_locs
277CREATE TABLE IF NOT EXISTS `world_safe_locs` (
278 `ID` int(10) unsigned NOT NULL DEFAULT '0',
279 `LocX` float NOT NULL DEFAULT '0',
280 `LocY` float NOT NULL DEFAULT '0',
281 `LocZ` float NOT NULL DEFAULT '0',
282 `Facing` float NOT NULL DEFAULT '0',
283 `AreaName` text,
284 `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
285 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
286 PRIMARY KEY (`ID`)
287) ENGINE=MyISAM DEFAULT CHARSET=utf8;
288
289-- Dumping data for table hotfixes.world_safe_locs: 0 rows
290DELETE FROM `world_safe_locs`;
291/*!40000 ALTER TABLE `world_safe_locs` DISABLE KEYS */;
292/*!40000 ALTER TABLE `world_safe_locs` ENABLE KEYS */;
293
294
295-- Dumping structure for table hotfixes.world_safe_locs_locale
296CREATE TABLE IF NOT EXISTS `world_safe_locs_locale` (
297 `ID` int(10) unsigned NOT NULL DEFAULT '0',
298 `locale` varchar(4) NOT NULL,
299 `AreaName_lang` text,
300 `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
301 PRIMARY KEY (`ID`,`locale`)
302) ENGINE=MyISAM DEFAULT CHARSET=utf8;
303
304-- Dumping data for table hotfixes.world_safe_locs_locale: 0 rows
305DELETE FROM `world_safe_locs_locale`;
306/*!40000 ALTER TABLE `world_safe_locs_locale` DISABLE KEYS */;
307/*!40000 ALTER TABLE `world_safe_locs_locale` ENABLE KEYS */;
308/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
309/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
310/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;