MQ0AuUmg

1-- Volcando estructura para tabla hotfixes_legion.world_boss_lockout
2CREATE TABLE IF NOT EXISTS `world_boss_lockout` (
3  `ID` int(10) unsigned NOT NULL DEFAULT '0',
4  `Name` text,
5  `QuestID` smallint(5) unsigned NOT NULL DEFAULT '0',
6  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
7  PRIMARY KEY (`ID`)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8;
9
10-- Volcando datos para la tabla hotfixes_legion.world_boss_lockout: 0 rows
11DELETE FROM `world_boss_lockout`;
12/*!40000 ALTER TABLE `world_boss_lockout` DISABLE KEYS */;
13/*!40000 ALTER TABLE `world_boss_lockout` ENABLE KEYS */;
14
15-- Volcando estructura para tabla hotfixes_legion.world_boss_lockout_locale
16CREATE TABLE IF NOT EXISTS `world_boss_lockout_locale` (
17  `ID` int(10) unsigned NOT NULL DEFAULT '0',
18  `locale` varchar(4) NOT NULL,
19  `Name_lang` text,
20  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
21  PRIMARY KEY (`ID`,`locale`)
22) ENGINE=MyISAM DEFAULT CHARSET=utf8;
23
24-- Volcando datos para la tabla hotfixes_legion.world_boss_lockout_locale: 0 rows
25DELETE FROM `world_boss_lockout_locale`;
26/*!40000 ALTER TABLE `world_boss_lockout_locale` DISABLE KEYS */;
27/*!40000 ALTER TABLE `world_boss_lockout_locale` ENABLE KEYS */;
28
29-- Volcando estructura para tabla hotfixes_legion.world_effect
30CREATE TABLE IF NOT EXISTS `world_effect` (
31  `ID` int(10) unsigned NOT NULL DEFAULT '0',
32  `TargetEntry` int(10) unsigned NOT NULL DEFAULT '0',
33  `PlayerConditionID` smallint(5) unsigned NOT NULL DEFAULT '0',
34  `QuestFeedbackEffectID` smallint(5) unsigned NOT NULL DEFAULT '0',
35  `CombatConditionID` smallint(5) unsigned NOT NULL DEFAULT '0',
36  `TargetType` tinyint(3) unsigned NOT NULL DEFAULT '0',
37  `DisplayCondition` tinyint(3) unsigned NOT NULL DEFAULT '0',
38  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
39  PRIMARY KEY (`ID`)
40) ENGINE=MyISAM DEFAULT CHARSET=utf8;
41
42-- Volcando datos para la tabla hotfixes_legion.world_effect: 0 rows
43DELETE FROM `world_effect`;
44/*!40000 ALTER TABLE `world_effect` DISABLE KEYS */;
45/*!40000 ALTER TABLE `world_effect` ENABLE KEYS */;
46
47-- Volcando estructura para tabla hotfixes_legion.world_map_area
48CREATE TABLE IF NOT EXISTS `world_map_area` (
49  `AreaName` text,
50  `LocLeft` float NOT NULL DEFAULT '0',
51  `LocRight` float NOT NULL DEFAULT '0',
52  `LocTop` float NOT NULL DEFAULT '0',
53  `LocBottom` float NOT NULL DEFAULT '0',
54  `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
55  `AreaID` smallint(5) unsigned NOT NULL DEFAULT '0',
56  `DisplayMapID` smallint(6) NOT NULL DEFAULT '0',
57  `DefaultDungeonFloor` smallint(6) NOT NULL DEFAULT '0',
58  `ParentWorldMapID` smallint(5) unsigned NOT NULL DEFAULT '0',
59  `Flags` smallint(5) unsigned NOT NULL DEFAULT '0',
60  `LevelRangeMin` tinyint(3) unsigned NOT NULL DEFAULT '0',
61  `LevelRangeMax` tinyint(3) unsigned NOT NULL DEFAULT '0',
62  `BountySetID` tinyint(3) unsigned NOT NULL DEFAULT '0',
63  `BountyBoardLocation` tinyint(3) unsigned NOT NULL DEFAULT '0',
64  `ID` int(10) unsigned NOT NULL DEFAULT '0',
65  `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
66  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
67  PRIMARY KEY (`ID`)
68) ENGINE=MyISAM DEFAULT CHARSET=utf8;
69
70-- Volcando datos para la tabla hotfixes_legion.world_map_area: 0 rows
71DELETE FROM `world_map_area`;
72/*!40000 ALTER TABLE `world_map_area` DISABLE KEYS */;
73/*!40000 ALTER TABLE `world_map_area` ENABLE KEYS */;
74
75-- Volcando estructura para tabla hotfixes_legion.world_map_overlay
76CREATE TABLE IF NOT EXISTS `world_map_overlay` (
77  `ID` int(10) unsigned NOT NULL DEFAULT '0',
78  `TextureName` text,
79  `TextureWidth` smallint(5) unsigned NOT NULL DEFAULT '0',
80  `TextureHeight` smallint(5) unsigned NOT NULL DEFAULT '0',
81  `MapAreaID` int(10) unsigned NOT NULL DEFAULT '0',
82  `AreaID1` int(10) unsigned NOT NULL DEFAULT '0',
83  `AreaID2` int(10) unsigned NOT NULL DEFAULT '0',
84  `AreaID3` int(10) unsigned NOT NULL DEFAULT '0',
85  `AreaID4` int(10) unsigned NOT NULL DEFAULT '0',
86  `OffsetX` int(11) NOT NULL DEFAULT '0',
87  `OffsetY` int(11) NOT NULL DEFAULT '0',
88  `HitRectTop` int(11) NOT NULL DEFAULT '0',
89  `HitRectLeft` int(11) NOT NULL DEFAULT '0',
90  `HitRectBottom` int(11) NOT NULL DEFAULT '0',
91  `HitRectRight` int(11) NOT NULL DEFAULT '0',
92  `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
93  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
94  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
95  PRIMARY KEY (`ID`)
96) ENGINE=MyISAM DEFAULT CHARSET=utf8;
97
98-- Volcando datos para la tabla hotfixes_legion.world_map_overlay: 0 rows
99DELETE FROM `world_map_overlay`;
100/*!40000 ALTER TABLE `world_map_overlay` DISABLE KEYS */;
101/*!40000 ALTER TABLE `world_map_overlay` ENABLE KEYS */;
102
103-- Volcando estructura para tabla hotfixes_legion.world_map_transforms
104CREATE TABLE IF NOT EXISTS `world_map_transforms` (
105  `ID` int(10) unsigned NOT NULL DEFAULT '0',
106  `RegionMinX` float NOT NULL DEFAULT '0',
107  `RegionMinY` float NOT NULL DEFAULT '0',
108  `RegionMinZ` float NOT NULL DEFAULT '0',
109  `RegionMaxX` float NOT NULL DEFAULT '0',
110  `RegionMaxY` float NOT NULL DEFAULT '0',
111  `RegionMaxZ` float NOT NULL DEFAULT '0',
112  `RegionOffsetX` float NOT NULL DEFAULT '0',
113  `RegionOffsetY` float NOT NULL DEFAULT '0',
114  `RegionScale` float NOT NULL DEFAULT '0',
115  `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
116  `AreaID` smallint(5) unsigned NOT NULL DEFAULT '0',
117  `NewMapID` smallint(5) unsigned NOT NULL DEFAULT '0',
118  `NewDungeonMapID` smallint(5) unsigned NOT NULL DEFAULT '0',
119  `NewAreaID` smallint(5) unsigned NOT NULL DEFAULT '0',
120  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
121  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
122  PRIMARY KEY (`ID`)
123) ENGINE=MyISAM DEFAULT CHARSET=utf8;
124
125-- Volcando datos para la tabla hotfixes_legion.world_map_transforms: 0 rows
126DELETE FROM `world_map_transforms`;
127/*!40000 ALTER TABLE `world_map_transforms` DISABLE KEYS */;
128/*!40000 ALTER TABLE `world_map_transforms` ENABLE KEYS */;
129
130-- Volcando estructura para tabla hotfixes_legion.world_safe_locs
131CREATE TABLE IF NOT EXISTS `world_safe_locs` (
132  `ID` int(10) unsigned NOT NULL DEFAULT '0',
133  `LocX` float NOT NULL DEFAULT '0',
134  `LocY` float NOT NULL DEFAULT '0',
135  `LocZ` float NOT NULL DEFAULT '0',
136  `Facing` float NOT NULL DEFAULT '0',
137  `AreaName` text,
138  `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
139  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
140  PRIMARY KEY (`ID`)
141) ENGINE=MyISAM DEFAULT CHARSET=utf8;
142
143-- Volcando datos para la tabla hotfixes_legion.world_safe_locs: 0 rows
144DELETE FROM `world_safe_locs`;
145/*!40000 ALTER TABLE `world_safe_locs` DISABLE KEYS */;
146/*!40000 ALTER TABLE `world_safe_locs` ENABLE KEYS */;
147
148-- Volcando estructura para tabla hotfixes_legion.world_safe_locs_locale
149CREATE TABLE IF NOT EXISTS `world_safe_locs_locale` (
150  `ID` int(10) unsigned NOT NULL DEFAULT '0',
151  `locale` varchar(4) NOT NULL,
152  `AreaName_lang` text,
153  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
154  PRIMARY KEY (`ID`,`locale`)
155) ENGINE=MyISAM DEFAULT CHARSET=utf8;
156
157-- Volcando datos para la tabla hotfixes_legion.world_safe_locs_locale: 0 rows
158DELETE FROM `world_safe_locs_locale`;
159/*!40000 ALTER TABLE `world_safe_locs_locale` DISABLE KEYS */;
160/*!40000 ALTER TABLE `world_safe_locs_locale` ENABLE KEYS */;
161
162/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
163/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
164/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;