1 | -- MySQL dump 10.11 |
---|
2 | -- |
---|
3 | -- Host: localhost Database: world |
---|
4 | -- ------------------------------------------------------ |
---|
5 | -- Server version 5.0.34-log |
---|
6 | |
---|
7 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
---|
8 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
---|
9 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
---|
10 | /*!40101 SET NAMES utf8 */; |
---|
11 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
---|
12 | /*!40103 SET TIME_ZONE='+00:00' */; |
---|
13 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
---|
14 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
---|
15 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
---|
16 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
---|
17 | |
---|
18 | -- |
---|
19 | -- Table structure for table `areatrigger_involvedrelation` |
---|
20 | -- |
---|
21 | |
---|
22 | DROP TABLE IF EXISTS `areatrigger_involvedrelation`; |
---|
23 | CREATE TABLE `areatrigger_involvedrelation` ( |
---|
24 | `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier', |
---|
25 | `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', |
---|
26 | PRIMARY KEY (`id`) |
---|
27 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; |
---|
28 | |
---|
29 | -- |
---|
30 | -- Dumping data for table `areatrigger_involvedrelation` |
---|
31 | -- |
---|
32 | |
---|
33 | LOCK TABLES `areatrigger_involvedrelation` WRITE; |
---|
34 | /*!40000 ALTER TABLE `areatrigger_involvedrelation` DISABLE KEYS */; |
---|
35 | /*!40000 ALTER TABLE `areatrigger_involvedrelation` ENABLE KEYS */; |
---|
36 | UNLOCK TABLES; |
---|
37 | |
---|
38 | -- |
---|
39 | -- Table structure for table `areatrigger_scripts` |
---|
40 | -- |
---|
41 | |
---|
42 | DROP TABLE IF EXISTS `areatrigger_scripts`; |
---|
43 | CREATE TABLE `areatrigger_scripts` ( |
---|
44 | `entry` mediumint(8) NOT NULL, |
---|
45 | `ScriptName` char(64) NOT NULL, |
---|
46 | PRIMARY KEY (`entry`) |
---|
47 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
48 | |
---|
49 | -- |
---|
50 | -- Dumping data for table `areatrigger_scripts` |
---|
51 | -- |
---|
52 | |
---|
53 | LOCK TABLES `areatrigger_scripts` WRITE; |
---|
54 | /*!40000 ALTER TABLE `areatrigger_scripts` DISABLE KEYS */; |
---|
55 | /*!40000 ALTER TABLE `areatrigger_scripts` ENABLE KEYS */; |
---|
56 | UNLOCK TABLES; |
---|
57 | |
---|
58 | -- |
---|
59 | -- Table structure for table `areatrigger_tavern` |
---|
60 | -- |
---|
61 | |
---|
62 | DROP TABLE IF EXISTS `areatrigger_tavern`; |
---|
63 | CREATE TABLE `areatrigger_tavern` ( |
---|
64 | `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier', |
---|
65 | `name` text, |
---|
66 | PRIMARY KEY (`id`) |
---|
67 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; |
---|
68 | |
---|
69 | -- |
---|
70 | -- Dumping data for table `areatrigger_tavern` |
---|
71 | -- |
---|
72 | |
---|
73 | LOCK TABLES `areatrigger_tavern` WRITE; |
---|
74 | /*!40000 ALTER TABLE `areatrigger_tavern` DISABLE KEYS */; |
---|
75 | /*!40000 ALTER TABLE `areatrigger_tavern` ENABLE KEYS */; |
---|
76 | UNLOCK TABLES; |
---|
77 | |
---|
78 | -- |
---|
79 | -- Table structure for table `areatrigger_teleport` |
---|
80 | -- |
---|
81 | |
---|
82 | DROP TABLE IF EXISTS `areatrigger_teleport`; |
---|
83 | CREATE TABLE `areatrigger_teleport` ( |
---|
84 | `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier', |
---|
85 | `name` text, |
---|
86 | `required_level` tinyint(3) unsigned NOT NULL default '0', |
---|
87 | `required_item` mediumint(8) unsigned NOT NULL default '0', |
---|
88 | `required_item2` mediumint(8) unsigned NOT NULL default '0', |
---|
89 | `heroic_key` mediumint(8) unsigned NOT NULL default '0', |
---|
90 | `heroic_key2` mediumint(8) unsigned NOT NULL default '0', |
---|
91 | `required_quest_done` int(11) unsigned NOT NULL default '0', |
---|
92 | `required_failed_text` text, |
---|
93 | `target_map` smallint(5) unsigned NOT NULL default '0', |
---|
94 | `target_position_x` float NOT NULL default '0', |
---|
95 | `target_position_y` float NOT NULL default '0', |
---|
96 | `target_position_z` float NOT NULL default '0', |
---|
97 | `target_orientation` float NOT NULL default '0', |
---|
98 | PRIMARY KEY (`id`), |
---|
99 | FULLTEXT KEY `name` (`name`) |
---|
100 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; |
---|
101 | |
---|
102 | -- |
---|
103 | -- Dumping data for table `areatrigger_teleport` |
---|
104 | -- |
---|
105 | |
---|
106 | LOCK TABLES `areatrigger_teleport` WRITE; |
---|
107 | /*!40000 ALTER TABLE `areatrigger_teleport` DISABLE KEYS */; |
---|
108 | /*!40000 ALTER TABLE `areatrigger_teleport` ENABLE KEYS */; |
---|
109 | UNLOCK TABLES; |
---|
110 | |
---|
111 | -- |
---|
112 | -- Table structure for table `battleground_template` |
---|
113 | -- |
---|
114 | |
---|
115 | DROP TABLE IF EXISTS `battleground_template`; |
---|
116 | CREATE TABLE `battleground_template` ( |
---|
117 | `id` mediumint(8) unsigned NOT NULL, |
---|
118 | `MinPlayersPerTeam` smallint(5) unsigned NOT NULL default '0', |
---|
119 | `MaxPlayersPerTeam` smallint(5) unsigned NOT NULL default '0', |
---|
120 | `MinLvl` tinyint(3) unsigned NOT NULL default '0', |
---|
121 | `MaxLvl` tinyint(3) unsigned NOT NULL default '0', |
---|
122 | `AllianceStartLoc` mediumint(8) unsigned NOT NULL, |
---|
123 | `AllianceStartO` float NOT NULL, |
---|
124 | `HordeStartLoc` mediumint(8) unsigned NOT NULL, |
---|
125 | `HordeStartO` float NOT NULL, |
---|
126 | PRIMARY KEY (`id`) |
---|
127 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
128 | |
---|
129 | -- |
---|
130 | -- Dumping data for table `battleground_template` |
---|
131 | -- |
---|
132 | |
---|
133 | LOCK TABLES `battleground_template` WRITE; |
---|
134 | /*!40000 ALTER TABLE `battleground_template` DISABLE KEYS */; |
---|
135 | /*!40000 ALTER TABLE `battleground_template` ENABLE KEYS */; |
---|
136 | UNLOCK TABLES; |
---|
137 | |
---|
138 | -- |
---|
139 | -- Table structure for table `battlemaster_entry` |
---|
140 | -- |
---|
141 | |
---|
142 | DROP TABLE IF EXISTS `battlemaster_entry`; |
---|
143 | CREATE TABLE `battlemaster_entry` ( |
---|
144 | `entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Entry of a creature', |
---|
145 | `bg_template` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Battleground template id', |
---|
146 | PRIMARY KEY (`entry`) |
---|
147 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
148 | |
---|
149 | -- |
---|
150 | -- Dumping data for table `battlemaster_entry` |
---|
151 | -- |
---|
152 | |
---|
153 | LOCK TABLES `battlemaster_entry` WRITE; |
---|
154 | /*!40000 ALTER TABLE `battlemaster_entry` DISABLE KEYS */; |
---|
155 | /*!40000 ALTER TABLE `battlemaster_entry` ENABLE KEYS */; |
---|
156 | UNLOCK TABLES; |
---|
157 | |
---|
158 | -- |
---|
159 | -- Table structure for table `command` |
---|
160 | -- |
---|
161 | |
---|
162 | DROP TABLE IF EXISTS `command`; |
---|
163 | CREATE TABLE `command` ( |
---|
164 | `name` varchar(50) NOT NULL default '', |
---|
165 | `security` tinyint(3) unsigned NOT NULL default '0', |
---|
166 | `help` longtext, |
---|
167 | PRIMARY KEY (`name`) |
---|
168 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Chat System'; |
---|
169 | |
---|
170 | -- |
---|
171 | -- Dumping data for table `command` |
---|
172 | -- |
---|
173 | |
---|
174 | LOCK TABLES `command` WRITE; |
---|
175 | /*!40000 ALTER TABLE `command` DISABLE KEYS */; |
---|
176 | /*!40000 ALTER TABLE `command` ENABLE KEYS */; |
---|
177 | UNLOCK TABLES; |
---|
178 | |
---|
179 | -- |
---|
180 | -- Table structure for table `creature` |
---|
181 | -- |
---|
182 | |
---|
183 | DROP TABLE IF EXISTS `creature`; |
---|
184 | CREATE TABLE `creature` ( |
---|
185 | `guid` int(10) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier', |
---|
186 | `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Creature Identifier', |
---|
187 | `map` smallint(5) unsigned NOT NULL default '0' COMMENT 'Map Identifier', |
---|
188 | `spawnMask` tinyint(3) unsigned NOT NULL default '1', |
---|
189 | `modelid` mediumint(8) unsigned NOT NULL default '0', |
---|
190 | `equipment_id` mediumint(9) NOT NULL default '0', |
---|
191 | `position_x` float NOT NULL default '0', |
---|
192 | `position_y` float NOT NULL default '0', |
---|
193 | `position_z` float NOT NULL default '0', |
---|
194 | `orientation` float NOT NULL default '0', |
---|
195 | `spawntimesecs` int(10) unsigned NOT NULL default '120', |
---|
196 | `spawndist` float NOT NULL default '5', |
---|
197 | `currentwaypoint` mediumint(8) unsigned NOT NULL default '0', |
---|
198 | `curhealth` int(10) unsigned NOT NULL default '1', |
---|
199 | `curmana` int(10) unsigned NOT NULL default '0', |
---|
200 | `DeathState` tinyint(3) unsigned NOT NULL default '0', |
---|
201 | `MovementType` tinyint(3) unsigned NOT NULL default '0', |
---|
202 | PRIMARY KEY (`guid`), |
---|
203 | KEY `idx_map` (`map`), |
---|
204 | KEY `idx_id` (`id`) |
---|
205 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System'; |
---|
206 | |
---|
207 | -- |
---|
208 | -- Dumping data for table `creature` |
---|
209 | -- |
---|
210 | |
---|
211 | LOCK TABLES `creature` WRITE; |
---|
212 | /*!40000 ALTER TABLE `creature` DISABLE KEYS */; |
---|
213 | /*!40000 ALTER TABLE `creature` ENABLE KEYS */; |
---|
214 | UNLOCK TABLES; |
---|
215 | |
---|
216 | -- |
---|
217 | -- Table structure for table `creature_addon` |
---|
218 | -- |
---|
219 | |
---|
220 | DROP TABLE IF EXISTS `creature_addon`; |
---|
221 | CREATE TABLE `creature_addon` ( |
---|
222 | `guid` int(10) unsigned NOT NULL default '0', |
---|
223 | `mount` mediumint(8) unsigned NOT NULL default '0', |
---|
224 | `bytes0` int(10) unsigned NOT NULL default '0', |
---|
225 | `bytes1` int(10) unsigned NOT NULL default '0', |
---|
226 | `bytes2` int(10) unsigned NOT NULL default '0', |
---|
227 | `emote` int(10) unsigned NOT NULL default '0', |
---|
228 | `moveflags` int(10) unsigned NOT NULL default '0', |
---|
229 | `auras` text, |
---|
230 | PRIMARY KEY (`guid`) |
---|
231 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
232 | |
---|
233 | -- |
---|
234 | -- Dumping data for table `creature_addon` |
---|
235 | -- |
---|
236 | |
---|
237 | LOCK TABLES `creature_addon` WRITE; |
---|
238 | /*!40000 ALTER TABLE `creature_addon` DISABLE KEYS */; |
---|
239 | /*!40000 ALTER TABLE `creature_addon` ENABLE KEYS */; |
---|
240 | UNLOCK TABLES; |
---|
241 | |
---|
242 | -- |
---|
243 | -- Table structure for table `creature_equip_template` |
---|
244 | -- |
---|
245 | |
---|
246 | DROP TABLE IF EXISTS `creature_equip_template`; |
---|
247 | CREATE TABLE `creature_equip_template` ( |
---|
248 | `entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Unique entry', |
---|
249 | `equipmodel1` mediumint(8) unsigned NOT NULL default '0', |
---|
250 | `equipmodel2` mediumint(8) unsigned NOT NULL default '0', |
---|
251 | `equipmodel3` mediumint(8) unsigned NOT NULL default '0', |
---|
252 | `equipinfo1` int(10) unsigned NOT NULL default '0', |
---|
253 | `equipinfo2` int(10) unsigned NOT NULL default '0', |
---|
254 | `equipinfo3` int(10) unsigned NOT NULL default '0', |
---|
255 | `equipslot1` int(11) NOT NULL default '0', |
---|
256 | `equipslot2` int(11) NOT NULL default '0', |
---|
257 | `equipslot3` int(11) NOT NULL default '0', |
---|
258 | PRIMARY KEY (`entry`) |
---|
259 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Equipment)'; |
---|
260 | |
---|
261 | -- |
---|
262 | -- Dumping data for table `creature_equip_template` |
---|
263 | -- |
---|
264 | |
---|
265 | LOCK TABLES `creature_equip_template` WRITE; |
---|
266 | /*!40000 ALTER TABLE `creature_equip_template` DISABLE KEYS */; |
---|
267 | /*!40000 ALTER TABLE `creature_equip_template` ENABLE KEYS */; |
---|
268 | UNLOCK TABLES; |
---|
269 | |
---|
270 | -- |
---|
271 | -- Table structure for table `creature_involvedrelation` |
---|
272 | -- |
---|
273 | |
---|
274 | DROP TABLE IF EXISTS `creature_involvedrelation`; |
---|
275 | CREATE TABLE `creature_involvedrelation` ( |
---|
276 | `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier', |
---|
277 | `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', |
---|
278 | PRIMARY KEY (`id`,`quest`) |
---|
279 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; |
---|
280 | |
---|
281 | -- |
---|
282 | -- Dumping data for table `creature_involvedrelation` |
---|
283 | -- |
---|
284 | |
---|
285 | LOCK TABLES `creature_involvedrelation` WRITE; |
---|
286 | /*!40000 ALTER TABLE `creature_involvedrelation` DISABLE KEYS */; |
---|
287 | /*!40000 ALTER TABLE `creature_involvedrelation` ENABLE KEYS */; |
---|
288 | UNLOCK TABLES; |
---|
289 | |
---|
290 | -- |
---|
291 | -- Table structure for table `creature_loot_template` |
---|
292 | -- |
---|
293 | |
---|
294 | DROP TABLE IF EXISTS `creature_loot_template`; |
---|
295 | CREATE TABLE `creature_loot_template` ( |
---|
296 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
297 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
298 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
299 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
300 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
301 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
302 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
303 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
304 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
305 | PRIMARY KEY (`entry`,`item`) |
---|
306 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; |
---|
307 | |
---|
308 | -- |
---|
309 | -- Dumping data for table `creature_loot_template` |
---|
310 | -- |
---|
311 | |
---|
312 | LOCK TABLES `creature_loot_template` WRITE; |
---|
313 | /*!40000 ALTER TABLE `creature_loot_template` DISABLE KEYS */; |
---|
314 | /*!40000 ALTER TABLE `creature_loot_template` ENABLE KEYS */; |
---|
315 | UNLOCK TABLES; |
---|
316 | |
---|
317 | -- |
---|
318 | -- Table structure for table `creature_model_info` |
---|
319 | -- |
---|
320 | |
---|
321 | DROP TABLE IF EXISTS `creature_model_info`; |
---|
322 | CREATE TABLE `creature_model_info` ( |
---|
323 | `modelid` mediumint(8) unsigned NOT NULL default '0', |
---|
324 | `bounding_radius` float NOT NULL default '0', |
---|
325 | `combat_reach` float NOT NULL default '0', |
---|
326 | `gender` tinyint(3) unsigned NOT NULL default '2', |
---|
327 | `modelid_other_gender` mediumint(8) unsigned NOT NULL default '0', |
---|
328 | PRIMARY KEY (`modelid`) |
---|
329 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Model related info)'; |
---|
330 | |
---|
331 | -- |
---|
332 | -- Dumping data for table `creature_model_info` |
---|
333 | -- |
---|
334 | |
---|
335 | LOCK TABLES `creature_model_info` WRITE; |
---|
336 | /*!40000 ALTER TABLE `creature_model_info` DISABLE KEYS */; |
---|
337 | /*!40000 ALTER TABLE `creature_model_info` ENABLE KEYS */; |
---|
338 | UNLOCK TABLES; |
---|
339 | |
---|
340 | -- |
---|
341 | -- Table structure for table `creature_movement` |
---|
342 | -- |
---|
343 | |
---|
344 | DROP TABLE IF EXISTS `creature_movement`; |
---|
345 | CREATE TABLE `creature_movement` ( |
---|
346 | `id` int(10) unsigned NOT NULL COMMENT 'Creature GUID', |
---|
347 | `point` mediumint(8) unsigned NOT NULL default '0', |
---|
348 | `position_x` float NOT NULL default '0', |
---|
349 | `position_y` float NOT NULL default '0', |
---|
350 | `position_z` float NOT NULL default '0', |
---|
351 | `waittime` int(10) unsigned NOT NULL default '0', |
---|
352 | `text1` text, |
---|
353 | `text2` text, |
---|
354 | `text3` text, |
---|
355 | `text4` text, |
---|
356 | `text5` text, |
---|
357 | `emote` mediumint(8) unsigned NOT NULL default '0', |
---|
358 | `spell` mediumint(8) unsigned NOT NULL default '0', |
---|
359 | `wpguid` int(11) NOT NULL default '0', |
---|
360 | `orientation` float NOT NULL default '0', |
---|
361 | `model1` mediumint(9) NOT NULL default '0', |
---|
362 | `model2` mediumint(9) NOT NULL default '0', |
---|
363 | PRIMARY KEY (`id`,`point`) |
---|
364 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; |
---|
365 | |
---|
366 | -- |
---|
367 | -- Dumping data for table `creature_movement` |
---|
368 | -- |
---|
369 | |
---|
370 | LOCK TABLES `creature_movement` WRITE; |
---|
371 | /*!40000 ALTER TABLE `creature_movement` DISABLE KEYS */; |
---|
372 | /*!40000 ALTER TABLE `creature_movement` ENABLE KEYS */; |
---|
373 | UNLOCK TABLES; |
---|
374 | |
---|
375 | -- |
---|
376 | -- Table structure for table `creature_onkill_reputation` |
---|
377 | -- |
---|
378 | |
---|
379 | DROP TABLE IF EXISTS `creature_onkill_reputation`; |
---|
380 | CREATE TABLE `creature_onkill_reputation` ( |
---|
381 | `creature_id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Creature Identifier', |
---|
382 | `RewOnKillRepFaction1` smallint(6) NOT NULL default '0', |
---|
383 | `RewOnKillRepFaction2` smallint(6) NOT NULL default '0', |
---|
384 | `MaxStanding1` tinyint(4) NOT NULL default '0', |
---|
385 | `IsTeamAward1` tinyint(4) NOT NULL default '0', |
---|
386 | `RewOnKillRepValue1` mediumint(9) NOT NULL default '0', |
---|
387 | `MaxStanding2` tinyint(4) NOT NULL default '0', |
---|
388 | `IsTeamAward2` tinyint(4) NOT NULL default '0', |
---|
389 | `RewOnKillRepValue2` mediumint(9) NOT NULL default '0', |
---|
390 | `TeamDependent` tinyint(3) unsigned NOT NULL default '0', |
---|
391 | PRIMARY KEY (`creature_id`) |
---|
392 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain'; |
---|
393 | |
---|
394 | -- |
---|
395 | -- Dumping data for table `creature_onkill_reputation` |
---|
396 | -- |
---|
397 | |
---|
398 | LOCK TABLES `creature_onkill_reputation` WRITE; |
---|
399 | /*!40000 ALTER TABLE `creature_onkill_reputation` DISABLE KEYS */; |
---|
400 | /*!40000 ALTER TABLE `creature_onkill_reputation` ENABLE KEYS */; |
---|
401 | UNLOCK TABLES; |
---|
402 | |
---|
403 | -- |
---|
404 | -- Table structure for table `creature_questrelation` |
---|
405 | -- |
---|
406 | |
---|
407 | DROP TABLE IF EXISTS `creature_questrelation`; |
---|
408 | CREATE TABLE `creature_questrelation` ( |
---|
409 | `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier', |
---|
410 | `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', |
---|
411 | PRIMARY KEY (`id`,`quest`) |
---|
412 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; |
---|
413 | |
---|
414 | -- |
---|
415 | -- Dumping data for table `creature_questrelation` |
---|
416 | -- |
---|
417 | |
---|
418 | LOCK TABLES `creature_questrelation` WRITE; |
---|
419 | /*!40000 ALTER TABLE `creature_questrelation` DISABLE KEYS */; |
---|
420 | /*!40000 ALTER TABLE `creature_questrelation` ENABLE KEYS */; |
---|
421 | UNLOCK TABLES; |
---|
422 | |
---|
423 | -- |
---|
424 | -- Table structure for table `creature_respawn` |
---|
425 | -- |
---|
426 | |
---|
427 | DROP TABLE IF EXISTS `creature_respawn`; |
---|
428 | CREATE TABLE `creature_respawn` ( |
---|
429 | `guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
430 | `respawntime` bigint(20) NOT NULL default '0', |
---|
431 | `instance` mediumint(8) unsigned NOT NULL default '0', |
---|
432 | PRIMARY KEY (`guid`,`instance`), |
---|
433 | KEY `instance` (`instance`) |
---|
434 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System'; |
---|
435 | |
---|
436 | -- |
---|
437 | -- Dumping data for table `creature_respawn` |
---|
438 | -- |
---|
439 | |
---|
440 | LOCK TABLES `creature_respawn` WRITE; |
---|
441 | /*!40000 ALTER TABLE `creature_respawn` DISABLE KEYS */; |
---|
442 | /*!40000 ALTER TABLE `creature_respawn` ENABLE KEYS */; |
---|
443 | UNLOCK TABLES; |
---|
444 | |
---|
445 | -- |
---|
446 | -- Table structure for table `creature_template` |
---|
447 | -- |
---|
448 | |
---|
449 | DROP TABLE IF EXISTS `creature_template`; |
---|
450 | CREATE TABLE `creature_template` ( |
---|
451 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
452 | `heroic_entry` mediumint(8) unsigned NOT NULL default '0', |
---|
453 | `modelid_A` mediumint(8) unsigned NOT NULL default '0', |
---|
454 | `modelid_A2` mediumint(8) unsigned NOT NULL default '0', |
---|
455 | `modelid_H` mediumint(8) unsigned NOT NULL default '0', |
---|
456 | `modelid_H2` mediumint(8) unsigned NOT NULL default '0', |
---|
457 | `name` char(100) NOT NULL default '0', |
---|
458 | `subname` char(100) default NULL, |
---|
459 | `IconName` char(100) default NULL, |
---|
460 | `minlevel` tinyint(3) unsigned NOT NULL default '1', |
---|
461 | `maxlevel` tinyint(3) unsigned NOT NULL default '1', |
---|
462 | `minhealth` int(10) unsigned NOT NULL default '0', |
---|
463 | `maxhealth` int(10) unsigned NOT NULL default '0', |
---|
464 | `minmana` int(10) unsigned NOT NULL default '0', |
---|
465 | `maxmana` int(10) unsigned NOT NULL default '0', |
---|
466 | `armor` mediumint(8) unsigned NOT NULL default '0', |
---|
467 | `faction_A` smallint(5) unsigned NOT NULL default '0', |
---|
468 | `faction_H` smallint(5) unsigned NOT NULL default '0', |
---|
469 | `npcflag` int(10) unsigned NOT NULL default '0', |
---|
470 | `speed` float default '1', |
---|
471 | `scale` float NOT NULL default '1', |
---|
472 | `rank` tinyint(3) unsigned NOT NULL default '0', |
---|
473 | `mindmg` float NOT NULL default '0', |
---|
474 | `maxdmg` float NOT NULL default '0', |
---|
475 | `dmgschool` tinyint(4) NOT NULL default '0', |
---|
476 | `attackpower` int(10) unsigned NOT NULL default '0', |
---|
477 | `baseattacktime` int(10) unsigned NOT NULL default '0', |
---|
478 | `rangeattacktime` int(10) unsigned NOT NULL default '0', |
---|
479 | `flags` int(10) unsigned NOT NULL default '0', |
---|
480 | `dynamicflags` int(10) unsigned NOT NULL default '0', |
---|
481 | `family` tinyint(4) NOT NULL default '0', |
---|
482 | `trainer_type` tinyint(4) NOT NULL default '0', |
---|
483 | `trainer_spell` mediumint(8) unsigned NOT NULL default '0', |
---|
484 | `class` tinyint(3) unsigned NOT NULL default '0', |
---|
485 | `race` tinyint(3) unsigned NOT NULL default '0', |
---|
486 | `minrangedmg` float NOT NULL default '0', |
---|
487 | `maxrangedmg` float NOT NULL default '0', |
---|
488 | `rangedattackpower` smallint(5) unsigned NOT NULL default '0', |
---|
489 | `type` tinyint(3) unsigned NOT NULL default '0', |
---|
490 | `flag1` int(10) unsigned NOT NULL default '0', |
---|
491 | `lootid` mediumint(8) unsigned NOT NULL default '0', |
---|
492 | `pickpocketloot` mediumint(8) unsigned NOT NULL default '0', |
---|
493 | `skinloot` mediumint(8) unsigned NOT NULL default '0', |
---|
494 | `resistance1` smallint(5) NOT NULL default '0', |
---|
495 | `resistance2` smallint(5) NOT NULL default '0', |
---|
496 | `resistance3` smallint(5) NOT NULL default '0', |
---|
497 | `resistance4` smallint(5) NOT NULL default '0', |
---|
498 | `resistance5` smallint(5) NOT NULL default '0', |
---|
499 | `resistance6` smallint(5) NOT NULL default '0', |
---|
500 | `spell1` mediumint(8) unsigned NOT NULL default '0', |
---|
501 | `spell2` mediumint(8) unsigned NOT NULL default '0', |
---|
502 | `spell3` mediumint(8) unsigned NOT NULL default '0', |
---|
503 | `spell4` mediumint(8) unsigned NOT NULL default '0', |
---|
504 | `PetSpellDataId` mediumint(8) unsigned NOT NULL default '0', |
---|
505 | `mingold` mediumint(8) unsigned NOT NULL default '0', |
---|
506 | `maxgold` mediumint(8) unsigned NOT NULL default '0', |
---|
507 | `AIName` char(64) NOT NULL default '', |
---|
508 | `MovementType` tinyint(3) unsigned NOT NULL default '0', |
---|
509 | `InhabitType` tinyint(3) unsigned NOT NULL default '3', |
---|
510 | `RacialLeader` tinyint(3) unsigned NOT NULL default '0', |
---|
511 | `RegenHealth` tinyint(3) unsigned NOT NULL default '1', |
---|
512 | `equipment_id` mediumint(8) unsigned NOT NULL default '0', |
---|
513 | `mechanic_immune_mask` int(10) unsigned NOT NULL default '0', |
---|
514 | `flags_extra` int(10) unsigned NOT NULL default '0', |
---|
515 | `ScriptName` char(64) NOT NULL default '', |
---|
516 | PRIMARY KEY (`entry`), |
---|
517 | KEY `idx_name` (`name`) |
---|
518 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; |
---|
519 | |
---|
520 | -- |
---|
521 | -- Dumping data for table `creature_template` |
---|
522 | -- |
---|
523 | |
---|
524 | LOCK TABLES `creature_template` WRITE; |
---|
525 | /*!40000 ALTER TABLE `creature_template` DISABLE KEYS */; |
---|
526 | /*!40000 ALTER TABLE `creature_template` ENABLE KEYS */; |
---|
527 | UNLOCK TABLES; |
---|
528 | |
---|
529 | -- |
---|
530 | -- Table structure for table `creature_template_addon` |
---|
531 | -- |
---|
532 | |
---|
533 | DROP TABLE IF EXISTS `creature_template_addon`; |
---|
534 | CREATE TABLE `creature_template_addon` ( |
---|
535 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
536 | `mount` mediumint(8) unsigned NOT NULL default '0', |
---|
537 | `bytes0` int(10) unsigned NOT NULL default '0', |
---|
538 | `bytes1` int(10) unsigned NOT NULL default '0', |
---|
539 | `bytes2` int(10) unsigned NOT NULL default '0', |
---|
540 | `emote` mediumint(8) unsigned NOT NULL default '0', |
---|
541 | `moveflags` int(10) unsigned NOT NULL default '0', |
---|
542 | `auras` text, |
---|
543 | PRIMARY KEY (`entry`) |
---|
544 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
545 | |
---|
546 | -- |
---|
547 | -- Dumping data for table `creature_template_addon` |
---|
548 | -- |
---|
549 | |
---|
550 | LOCK TABLES `creature_template_addon` WRITE; |
---|
551 | /*!40000 ALTER TABLE `creature_template_addon` DISABLE KEYS */; |
---|
552 | /*!40000 ALTER TABLE `creature_template_addon` ENABLE KEYS */; |
---|
553 | UNLOCK TABLES; |
---|
554 | |
---|
555 | -- |
---|
556 | -- Table structure for table `custom_texts` |
---|
557 | -- |
---|
558 | |
---|
559 | DROP TABLE IF EXISTS `custom_texts`; |
---|
560 | CREATE TABLE `custom_texts` ( |
---|
561 | `entry` mediumint(8) NOT NULL, |
---|
562 | `content_default` text NOT NULL, |
---|
563 | `content_loc1` text, |
---|
564 | `content_loc2` text, |
---|
565 | `content_loc3` text, |
---|
566 | `content_loc4` text, |
---|
567 | `content_loc5` text, |
---|
568 | `content_loc6` text, |
---|
569 | `content_loc7` text, |
---|
570 | `content_loc8` text, |
---|
571 | `sound` mediumint(8) unsigned NOT NULL default '0', |
---|
572 | `type` tinyint(3) unsigned NOT NULL default '0', |
---|
573 | `language` tinyint(3) unsigned NOT NULL default '0', |
---|
574 | `comment` text, |
---|
575 | PRIMARY KEY (`entry`) |
---|
576 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts'; |
---|
577 | |
---|
578 | -- |
---|
579 | -- Dumping data for table `custom_texts` |
---|
580 | -- |
---|
581 | |
---|
582 | LOCK TABLES `custom_texts` WRITE; |
---|
583 | /*!40000 ALTER TABLE `custom_texts` DISABLE KEYS */; |
---|
584 | /*!40000 ALTER TABLE `custom_texts` ENABLE KEYS */; |
---|
585 | UNLOCK TABLES; |
---|
586 | |
---|
587 | -- |
---|
588 | -- Table structure for table `db_version` |
---|
589 | -- |
---|
590 | |
---|
591 | DROP TABLE IF EXISTS `db_version`; |
---|
592 | CREATE TABLE `db_version` ( |
---|
593 | `version` varchar(120) default NULL |
---|
594 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; |
---|
595 | |
---|
596 | -- |
---|
597 | -- Dumping data for table `db_version` |
---|
598 | -- |
---|
599 | |
---|
600 | LOCK TABLES `db_version` WRITE; |
---|
601 | /*!40000 ALTER TABLE `db_version` DISABLE KEYS */; |
---|
602 | /*!40000 ALTER TABLE `db_version` ENABLE KEYS */; |
---|
603 | UNLOCK TABLES; |
---|
604 | |
---|
605 | -- |
---|
606 | -- Table structure for table `disenchant_loot_template` |
---|
607 | -- |
---|
608 | |
---|
609 | DROP TABLE IF EXISTS `disenchant_loot_template`; |
---|
610 | CREATE TABLE `disenchant_loot_template` ( |
---|
611 | `entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Recommended id selection: item_level*100 + item_quality', |
---|
612 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
613 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
614 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
615 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
616 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
617 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
618 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
619 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
620 | PRIMARY KEY (`entry`,`item`) |
---|
621 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; |
---|
622 | |
---|
623 | -- |
---|
624 | -- Dumping data for table `disenchant_loot_template` |
---|
625 | -- |
---|
626 | |
---|
627 | LOCK TABLES `disenchant_loot_template` WRITE; |
---|
628 | /*!40000 ALTER TABLE `disenchant_loot_template` DISABLE KEYS */; |
---|
629 | /*!40000 ALTER TABLE `disenchant_loot_template` ENABLE KEYS */; |
---|
630 | UNLOCK TABLES; |
---|
631 | |
---|
632 | -- |
---|
633 | -- Table structure for table `event_scripts` |
---|
634 | -- |
---|
635 | |
---|
636 | DROP TABLE IF EXISTS `event_scripts`; |
---|
637 | CREATE TABLE `event_scripts` ( |
---|
638 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
639 | `delay` int(10) unsigned NOT NULL default '0', |
---|
640 | `command` mediumint(8) unsigned NOT NULL default '0', |
---|
641 | `datalong` mediumint(8) unsigned NOT NULL default '0', |
---|
642 | `datalong2` int(10) unsigned NOT NULL default '0', |
---|
643 | `datatext` text NOT NULL, |
---|
644 | `x` float NOT NULL default '0', |
---|
645 | `y` float NOT NULL default '0', |
---|
646 | `z` float NOT NULL default '0', |
---|
647 | `o` float NOT NULL default '0' |
---|
648 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
649 | |
---|
650 | -- |
---|
651 | -- Dumping data for table `event_scripts` |
---|
652 | -- |
---|
653 | |
---|
654 | LOCK TABLES `event_scripts` WRITE; |
---|
655 | /*!40000 ALTER TABLE `event_scripts` DISABLE KEYS */; |
---|
656 | /*!40000 ALTER TABLE `event_scripts` ENABLE KEYS */; |
---|
657 | UNLOCK TABLES; |
---|
658 | |
---|
659 | -- |
---|
660 | -- Table structure for table `eventai_localized_texts` |
---|
661 | -- |
---|
662 | |
---|
663 | DROP TABLE IF EXISTS `eventai_localized_texts`; |
---|
664 | CREATE TABLE `eventai_localized_texts` ( |
---|
665 | `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier', |
---|
666 | `locale_1` varchar(255) NOT NULL default '', |
---|
667 | `locale_2` varchar(255) NOT NULL default '', |
---|
668 | `locale_3` varchar(255) NOT NULL default '', |
---|
669 | `locale_4` varchar(255) NOT NULL default '', |
---|
670 | `locale_5` varchar(255) NOT NULL default '', |
---|
671 | `locale_6` varchar(255) NOT NULL default '', |
---|
672 | `locale_7` varchar(255) NOT NULL default '', |
---|
673 | `locale_8` varchar(255) NOT NULL default '', |
---|
674 | `comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment', |
---|
675 | PRIMARY KEY (`id`) |
---|
676 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Localized Text'; |
---|
677 | |
---|
678 | -- |
---|
679 | -- Dumping data for table `eventai_localized_texts` |
---|
680 | -- |
---|
681 | |
---|
682 | LOCK TABLES `eventai_localized_texts` WRITE; |
---|
683 | /*!40000 ALTER TABLE `eventai_localized_texts` DISABLE KEYS */; |
---|
684 | /*!40000 ALTER TABLE `eventai_localized_texts` ENABLE KEYS */; |
---|
685 | UNLOCK TABLES; |
---|
686 | |
---|
687 | -- |
---|
688 | -- Table structure for table `eventai_scripts` |
---|
689 | -- |
---|
690 | |
---|
691 | DROP TABLE IF EXISTS `eventai_scripts`; |
---|
692 | CREATE TABLE `eventai_scripts` ( |
---|
693 | `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier', |
---|
694 | `creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier', |
---|
695 | `event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type', |
---|
696 | `event_inverse_phase_mask` int(11) NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in', |
---|
697 | `event_chance` int(3) unsigned NOT NULL default '100', |
---|
698 | `event_flags` int(3) unsigned NOT NULL default '0', |
---|
699 | `event_param1` int(11) NOT NULL default '0', |
---|
700 | `event_param2` int(11) NOT NULL default '0', |
---|
701 | `event_param3` int(11) NOT NULL default '0', |
---|
702 | `event_param4` int(11) NOT NULL default '0', |
---|
703 | `action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', |
---|
704 | `action1_param1` int(11) NOT NULL default '0', |
---|
705 | `action1_param2` int(11) NOT NULL default '0', |
---|
706 | `action1_param3` int(11) NOT NULL default '0', |
---|
707 | `action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', |
---|
708 | `action2_param1` int(11) NOT NULL default '0', |
---|
709 | `action2_param2` int(11) NOT NULL default '0', |
---|
710 | `action2_param3` int(11) NOT NULL default '0', |
---|
711 | `action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type', |
---|
712 | `action3_param1` int(11) NOT NULL default '0', |
---|
713 | `action3_param2` int(11) NOT NULL default '0', |
---|
714 | `action3_param3` int(11) NOT NULL default '0', |
---|
715 | `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment', |
---|
716 | PRIMARY KEY (`id`) |
---|
717 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts'; |
---|
718 | |
---|
719 | -- |
---|
720 | -- Dumping data for table `eventai_scripts` |
---|
721 | -- |
---|
722 | |
---|
723 | LOCK TABLES `eventai_scripts` WRITE; |
---|
724 | /*!40000 ALTER TABLE `eventai_scripts` DISABLE KEYS */; |
---|
725 | /*!40000 ALTER TABLE `eventai_scripts` ENABLE KEYS */; |
---|
726 | UNLOCK TABLES; |
---|
727 | |
---|
728 | -- |
---|
729 | -- Table structure for table `eventai_summons` |
---|
730 | -- |
---|
731 | |
---|
732 | DROP TABLE IF EXISTS `eventai_summons`; |
---|
733 | CREATE TABLE `eventai_summons` ( |
---|
734 | `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Location Identifier', |
---|
735 | `position_x` float NOT NULL default '0', |
---|
736 | `position_y` float NOT NULL default '0', |
---|
737 | `position_z` float NOT NULL default '0', |
---|
738 | `orientation` float NOT NULL default '0', |
---|
739 | `spawntimesecs` int(11) unsigned NOT NULL default '120', |
---|
740 | `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment', |
---|
741 | PRIMARY KEY (`id`) |
---|
742 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations'; |
---|
743 | |
---|
744 | -- |
---|
745 | -- Dumping data for table `eventai_summons` |
---|
746 | -- |
---|
747 | |
---|
748 | LOCK TABLES `eventai_summons` WRITE; |
---|
749 | /*!40000 ALTER TABLE `eventai_summons` DISABLE KEYS */; |
---|
750 | /*!40000 ALTER TABLE `eventai_summons` ENABLE KEYS */; |
---|
751 | UNLOCK TABLES; |
---|
752 | |
---|
753 | -- |
---|
754 | -- Table structure for table `eventai_texts` |
---|
755 | -- |
---|
756 | |
---|
757 | DROP TABLE IF EXISTS `eventai_texts`; |
---|
758 | CREATE TABLE `eventai_texts` ( |
---|
759 | `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier', |
---|
760 | `text` varchar(255) NOT NULL default '', |
---|
761 | `comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment', |
---|
762 | PRIMARY KEY (`id`) |
---|
763 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Texts used in EventAI'; |
---|
764 | |
---|
765 | -- |
---|
766 | -- Dumping data for table `eventai_texts` |
---|
767 | -- |
---|
768 | |
---|
769 | LOCK TABLES `eventai_texts` WRITE; |
---|
770 | /*!40000 ALTER TABLE `eventai_texts` DISABLE KEYS */; |
---|
771 | /*!40000 ALTER TABLE `eventai_texts` ENABLE KEYS */; |
---|
772 | UNLOCK TABLES; |
---|
773 | |
---|
774 | -- |
---|
775 | -- Table structure for table `exploration_basexp` |
---|
776 | -- |
---|
777 | |
---|
778 | DROP TABLE IF EXISTS `exploration_basexp`; |
---|
779 | CREATE TABLE `exploration_basexp` ( |
---|
780 | `level` tinyint(4) NOT NULL default '0', |
---|
781 | `basexp` mediumint(9) NOT NULL default '0', |
---|
782 | PRIMARY KEY (`level`) |
---|
783 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Exploration System'; |
---|
784 | |
---|
785 | -- |
---|
786 | -- Dumping data for table `exploration_basexp` |
---|
787 | -- |
---|
788 | |
---|
789 | LOCK TABLES `exploration_basexp` WRITE; |
---|
790 | /*!40000 ALTER TABLE `exploration_basexp` DISABLE KEYS */; |
---|
791 | /*!40000 ALTER TABLE `exploration_basexp` ENABLE KEYS */; |
---|
792 | UNLOCK TABLES; |
---|
793 | |
---|
794 | -- |
---|
795 | -- Table structure for table `fishing_loot_template` |
---|
796 | -- |
---|
797 | |
---|
798 | DROP TABLE IF EXISTS `fishing_loot_template`; |
---|
799 | CREATE TABLE `fishing_loot_template` ( |
---|
800 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
801 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
802 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
803 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
804 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
805 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
806 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
807 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
808 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
809 | PRIMARY KEY (`entry`,`item`) |
---|
810 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; |
---|
811 | |
---|
812 | -- |
---|
813 | -- Dumping data for table `fishing_loot_template` |
---|
814 | -- |
---|
815 | |
---|
816 | LOCK TABLES `fishing_loot_template` WRITE; |
---|
817 | /*!40000 ALTER TABLE `fishing_loot_template` DISABLE KEYS */; |
---|
818 | /*!40000 ALTER TABLE `fishing_loot_template` ENABLE KEYS */; |
---|
819 | UNLOCK TABLES; |
---|
820 | |
---|
821 | -- |
---|
822 | -- Table structure for table `game_event` |
---|
823 | -- |
---|
824 | |
---|
825 | DROP TABLE IF EXISTS `game_event`; |
---|
826 | CREATE TABLE `game_event` ( |
---|
827 | `entry` mediumint(8) unsigned NOT NULL COMMENT 'Entry of the game event', |
---|
828 | `start_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before', |
---|
829 | `end_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler', |
---|
830 | `occurence` bigint(20) unsigned NOT NULL default '5184000' COMMENT 'Delay in minutes between occurences of the event', |
---|
831 | `length` bigint(20) unsigned NOT NULL default '2592000' COMMENT 'Length in minutes of the event', |
---|
832 | `description` varchar(255) default NULL COMMENT 'Description of the event displayed in console', |
---|
833 | `world_event` tinyint(3) unsigned NOT NULL default '0' COMMENT '0 if normal event, 1 if world event', |
---|
834 | PRIMARY KEY (`entry`) |
---|
835 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
836 | |
---|
837 | -- |
---|
838 | -- Dumping data for table `game_event` |
---|
839 | -- |
---|
840 | |
---|
841 | LOCK TABLES `game_event` WRITE; |
---|
842 | /*!40000 ALTER TABLE `game_event` DISABLE KEYS */; |
---|
843 | /*!40000 ALTER TABLE `game_event` ENABLE KEYS */; |
---|
844 | UNLOCK TABLES; |
---|
845 | |
---|
846 | -- |
---|
847 | -- Table structure for table `game_event_condition` |
---|
848 | -- |
---|
849 | |
---|
850 | DROP TABLE IF EXISTS `game_event_condition`; |
---|
851 | CREATE TABLE `game_event_condition` ( |
---|
852 | `event_id` mediumint(8) unsigned NOT NULL default '0', |
---|
853 | `condition_id` mediumint(8) unsigned NOT NULL default '0', |
---|
854 | `req_num` float default '0', |
---|
855 | `max_world_state_field` smallint(5) unsigned NOT NULL default '0', |
---|
856 | `done_world_state_field` smallint(5) unsigned NOT NULL default '0', |
---|
857 | `description` varchar(25) NOT NULL default '', |
---|
858 | PRIMARY KEY (`event_id`,`condition_id`) |
---|
859 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
860 | |
---|
861 | -- |
---|
862 | -- Dumping data for table `game_event_condition` |
---|
863 | -- |
---|
864 | |
---|
865 | LOCK TABLES `game_event_condition` WRITE; |
---|
866 | /*!40000 ALTER TABLE `game_event_condition` DISABLE KEYS */; |
---|
867 | /*!40000 ALTER TABLE `game_event_condition` ENABLE KEYS */; |
---|
868 | UNLOCK TABLES; |
---|
869 | |
---|
870 | -- |
---|
871 | -- Table structure for table `game_event_creature` |
---|
872 | -- |
---|
873 | |
---|
874 | DROP TABLE IF EXISTS `game_event_creature`; |
---|
875 | CREATE TABLE `game_event_creature` ( |
---|
876 | `guid` int(10) unsigned NOT NULL, |
---|
877 | `event` smallint(6) NOT NULL default '0' COMMENT 'Put negatives values to remove during event', |
---|
878 | PRIMARY KEY (`guid`,`event`) |
---|
879 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
880 | |
---|
881 | -- |
---|
882 | -- Dumping data for table `game_event_creature` |
---|
883 | -- |
---|
884 | |
---|
885 | LOCK TABLES `game_event_creature` WRITE; |
---|
886 | /*!40000 ALTER TABLE `game_event_creature` DISABLE KEYS */; |
---|
887 | /*!40000 ALTER TABLE `game_event_creature` ENABLE KEYS */; |
---|
888 | UNLOCK TABLES; |
---|
889 | |
---|
890 | -- |
---|
891 | -- Table structure for table `game_event_creature_quest` |
---|
892 | -- |
---|
893 | |
---|
894 | DROP TABLE IF EXISTS `game_event_creature_quest`; |
---|
895 | CREATE TABLE `game_event_creature_quest` ( |
---|
896 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
897 | `quest` mediumint(8) unsigned NOT NULL default '0', |
---|
898 | `event` smallint(5) unsigned NOT NULL default '0', |
---|
899 | PRIMARY KEY (`quest`,`event`,`id`) |
---|
900 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
901 | |
---|
902 | -- |
---|
903 | -- Dumping data for table `game_event_creature_quest` |
---|
904 | -- |
---|
905 | |
---|
906 | LOCK TABLES `game_event_creature_quest` WRITE; |
---|
907 | /*!40000 ALTER TABLE `game_event_creature_quest` DISABLE KEYS */; |
---|
908 | /*!40000 ALTER TABLE `game_event_creature_quest` ENABLE KEYS */; |
---|
909 | UNLOCK TABLES; |
---|
910 | |
---|
911 | -- |
---|
912 | -- Table structure for table `game_event_gameobject` |
---|
913 | -- |
---|
914 | |
---|
915 | DROP TABLE IF EXISTS `game_event_gameobject`; |
---|
916 | CREATE TABLE `game_event_gameobject` ( |
---|
917 | `guid` int(10) unsigned NOT NULL, |
---|
918 | `event` smallint(6) NOT NULL default '0' COMMENT 'Put negatives values to remove during event', |
---|
919 | PRIMARY KEY (`guid`,`event`) |
---|
920 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
921 | |
---|
922 | -- |
---|
923 | -- Dumping data for table `game_event_gameobject` |
---|
924 | -- |
---|
925 | |
---|
926 | LOCK TABLES `game_event_gameobject` WRITE; |
---|
927 | /*!40000 ALTER TABLE `game_event_gameobject` DISABLE KEYS */; |
---|
928 | /*!40000 ALTER TABLE `game_event_gameobject` ENABLE KEYS */; |
---|
929 | UNLOCK TABLES; |
---|
930 | |
---|
931 | -- |
---|
932 | -- Table structure for table `game_event_gameobject_quest` |
---|
933 | -- |
---|
934 | |
---|
935 | DROP TABLE IF EXISTS `game_event_gameobject_quest`; |
---|
936 | CREATE TABLE `game_event_gameobject_quest` ( |
---|
937 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
938 | `quest` mediumint(8) unsigned NOT NULL default '0', |
---|
939 | `event` smallint(5) unsigned NOT NULL default '0', |
---|
940 | PRIMARY KEY (`quest`,`event`,`id`) |
---|
941 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
942 | |
---|
943 | -- |
---|
944 | -- Dumping data for table `game_event_gameobject_quest` |
---|
945 | -- |
---|
946 | |
---|
947 | LOCK TABLES `game_event_gameobject_quest` WRITE; |
---|
948 | /*!40000 ALTER TABLE `game_event_gameobject_quest` DISABLE KEYS */; |
---|
949 | /*!40000 ALTER TABLE `game_event_gameobject_quest` ENABLE KEYS */; |
---|
950 | UNLOCK TABLES; |
---|
951 | |
---|
952 | -- |
---|
953 | -- Table structure for table `game_event_model_equip` |
---|
954 | -- |
---|
955 | |
---|
956 | DROP TABLE IF EXISTS `game_event_model_equip`; |
---|
957 | CREATE TABLE `game_event_model_equip` ( |
---|
958 | `guid` int(10) unsigned NOT NULL default '0', |
---|
959 | `modelid` mediumint(8) unsigned NOT NULL default '0', |
---|
960 | `equipment_id` mediumint(8) unsigned NOT NULL default '0', |
---|
961 | `event` smallint(5) unsigned NOT NULL default '0', |
---|
962 | PRIMARY KEY (`guid`) |
---|
963 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
964 | |
---|
965 | -- |
---|
966 | -- Dumping data for table `game_event_model_equip` |
---|
967 | -- |
---|
968 | |
---|
969 | LOCK TABLES `game_event_model_equip` WRITE; |
---|
970 | /*!40000 ALTER TABLE `game_event_model_equip` DISABLE KEYS */; |
---|
971 | /*!40000 ALTER TABLE `game_event_model_equip` ENABLE KEYS */; |
---|
972 | UNLOCK TABLES; |
---|
973 | |
---|
974 | -- |
---|
975 | -- Table structure for table `game_event_npc_gossip` |
---|
976 | -- |
---|
977 | |
---|
978 | DROP TABLE IF EXISTS `game_event_npc_gossip`; |
---|
979 | CREATE TABLE `game_event_npc_gossip` ( |
---|
980 | `guid` int(10) unsigned NOT NULL, |
---|
981 | `event_id` mediumint(8) unsigned NOT NULL default '0', |
---|
982 | `textid` mediumint(8) unsigned NOT NULL default '0', |
---|
983 | PRIMARY KEY (`guid`) |
---|
984 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
985 | |
---|
986 | -- |
---|
987 | -- Dumping data for table `game_event_npc_gossip` |
---|
988 | -- |
---|
989 | |
---|
990 | LOCK TABLES `game_event_npc_gossip` WRITE; |
---|
991 | /*!40000 ALTER TABLE `game_event_npc_gossip` DISABLE KEYS */; |
---|
992 | /*!40000 ALTER TABLE `game_event_npc_gossip` ENABLE KEYS */; |
---|
993 | UNLOCK TABLES; |
---|
994 | |
---|
995 | -- |
---|
996 | -- Table structure for table `game_event_npc_vendor` |
---|
997 | -- |
---|
998 | |
---|
999 | DROP TABLE IF EXISTS `game_event_npc_vendor`; |
---|
1000 | CREATE TABLE `game_event_npc_vendor` ( |
---|
1001 | `event` mediumint(8) unsigned NOT NULL default '0', |
---|
1002 | `guid` mediumint(8) unsigned NOT NULL default '0', |
---|
1003 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
1004 | `maxcount` mediumint(8) unsigned NOT NULL default '0', |
---|
1005 | `incrtime` mediumint(8) unsigned NOT NULL default '0', |
---|
1006 | `ExtendedCost` mediumint(8) unsigned NOT NULL default '0', |
---|
1007 | PRIMARY KEY (`guid`,`item`) |
---|
1008 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1009 | |
---|
1010 | -- |
---|
1011 | -- Dumping data for table `game_event_npc_vendor` |
---|
1012 | -- |
---|
1013 | |
---|
1014 | LOCK TABLES `game_event_npc_vendor` WRITE; |
---|
1015 | /*!40000 ALTER TABLE `game_event_npc_vendor` DISABLE KEYS */; |
---|
1016 | /*!40000 ALTER TABLE `game_event_npc_vendor` ENABLE KEYS */; |
---|
1017 | UNLOCK TABLES; |
---|
1018 | |
---|
1019 | -- |
---|
1020 | -- Table structure for table `game_event_npcflag` |
---|
1021 | -- |
---|
1022 | |
---|
1023 | DROP TABLE IF EXISTS `game_event_npcflag`; |
---|
1024 | CREATE TABLE `game_event_npcflag` ( |
---|
1025 | `guid` mediumint(8) unsigned NOT NULL default '0', |
---|
1026 | `event_id` mediumint(8) unsigned NOT NULL default '0', |
---|
1027 | `npcflag` int(10) unsigned NOT NULL default '0', |
---|
1028 | PRIMARY KEY (`guid`,`event_id`) |
---|
1029 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1030 | |
---|
1031 | -- |
---|
1032 | -- Dumping data for table `game_event_npcflag` |
---|
1033 | -- |
---|
1034 | |
---|
1035 | LOCK TABLES `game_event_npcflag` WRITE; |
---|
1036 | /*!40000 ALTER TABLE `game_event_npcflag` DISABLE KEYS */; |
---|
1037 | /*!40000 ALTER TABLE `game_event_npcflag` ENABLE KEYS */; |
---|
1038 | UNLOCK TABLES; |
---|
1039 | |
---|
1040 | -- |
---|
1041 | -- Table structure for table `game_event_prerequisite` |
---|
1042 | -- |
---|
1043 | |
---|
1044 | DROP TABLE IF EXISTS `game_event_prerequisite`; |
---|
1045 | CREATE TABLE `game_event_prerequisite` ( |
---|
1046 | `event_id` mediumint(8) unsigned NOT NULL, |
---|
1047 | `prerequisite_event` mediumint(8) unsigned NOT NULL, |
---|
1048 | PRIMARY KEY (`event_id`,`prerequisite_event`) |
---|
1049 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1050 | |
---|
1051 | -- |
---|
1052 | -- Dumping data for table `game_event_prerequisite` |
---|
1053 | -- |
---|
1054 | |
---|
1055 | LOCK TABLES `game_event_prerequisite` WRITE; |
---|
1056 | /*!40000 ALTER TABLE `game_event_prerequisite` DISABLE KEYS */; |
---|
1057 | /*!40000 ALTER TABLE `game_event_prerequisite` ENABLE KEYS */; |
---|
1058 | UNLOCK TABLES; |
---|
1059 | |
---|
1060 | -- |
---|
1061 | -- Table structure for table `game_event_quest_condition` |
---|
1062 | -- |
---|
1063 | |
---|
1064 | DROP TABLE IF EXISTS `game_event_quest_condition`; |
---|
1065 | CREATE TABLE `game_event_quest_condition` ( |
---|
1066 | `quest` mediumint(8) unsigned NOT NULL default '0', |
---|
1067 | `event_id` mediumint(8) unsigned NOT NULL default '0', |
---|
1068 | `condition_id` mediumint(8) unsigned NOT NULL default '0', |
---|
1069 | `num` float default '0', |
---|
1070 | PRIMARY KEY (`quest`) |
---|
1071 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1072 | |
---|
1073 | -- |
---|
1074 | -- Dumping data for table `game_event_quest_condition` |
---|
1075 | -- |
---|
1076 | |
---|
1077 | LOCK TABLES `game_event_quest_condition` WRITE; |
---|
1078 | /*!40000 ALTER TABLE `game_event_quest_condition` DISABLE KEYS */; |
---|
1079 | /*!40000 ALTER TABLE `game_event_quest_condition` ENABLE KEYS */; |
---|
1080 | UNLOCK TABLES; |
---|
1081 | |
---|
1082 | -- |
---|
1083 | -- Table structure for table `game_graveyard_zone` |
---|
1084 | -- |
---|
1085 | |
---|
1086 | DROP TABLE IF EXISTS `game_graveyard_zone`; |
---|
1087 | CREATE TABLE `game_graveyard_zone` ( |
---|
1088 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
1089 | `ghost_zone` mediumint(8) unsigned NOT NULL default '0', |
---|
1090 | `faction` smallint(5) unsigned NOT NULL default '0', |
---|
1091 | PRIMARY KEY (`id`,`ghost_zone`) |
---|
1092 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System'; |
---|
1093 | |
---|
1094 | -- |
---|
1095 | -- Dumping data for table `game_graveyard_zone` |
---|
1096 | -- |
---|
1097 | |
---|
1098 | LOCK TABLES `game_graveyard_zone` WRITE; |
---|
1099 | /*!40000 ALTER TABLE `game_graveyard_zone` DISABLE KEYS */; |
---|
1100 | /*!40000 ALTER TABLE `game_graveyard_zone` ENABLE KEYS */; |
---|
1101 | UNLOCK TABLES; |
---|
1102 | |
---|
1103 | -- |
---|
1104 | -- Table structure for table `game_tele` |
---|
1105 | -- |
---|
1106 | |
---|
1107 | DROP TABLE IF EXISTS `game_tele`; |
---|
1108 | CREATE TABLE `game_tele` ( |
---|
1109 | `id` mediumint(8) unsigned NOT NULL auto_increment, |
---|
1110 | `position_x` float NOT NULL default '0', |
---|
1111 | `position_y` float NOT NULL default '0', |
---|
1112 | `position_z` float NOT NULL default '0', |
---|
1113 | `orientation` float NOT NULL default '0', |
---|
1114 | `map` smallint(5) unsigned NOT NULL default '0', |
---|
1115 | `name` varchar(100) NOT NULL default '', |
---|
1116 | PRIMARY KEY (`id`) |
---|
1117 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Tele Command'; |
---|
1118 | |
---|
1119 | -- |
---|
1120 | -- Dumping data for table `game_tele` |
---|
1121 | -- |
---|
1122 | |
---|
1123 | LOCK TABLES `game_tele` WRITE; |
---|
1124 | /*!40000 ALTER TABLE `game_tele` DISABLE KEYS */; |
---|
1125 | /*!40000 ALTER TABLE `game_tele` ENABLE KEYS */; |
---|
1126 | UNLOCK TABLES; |
---|
1127 | |
---|
1128 | -- |
---|
1129 | -- Table structure for table `game_weather` |
---|
1130 | -- |
---|
1131 | |
---|
1132 | DROP TABLE IF EXISTS `game_weather`; |
---|
1133 | CREATE TABLE `game_weather` ( |
---|
1134 | `zone` mediumint(8) unsigned NOT NULL default '0', |
---|
1135 | `spring_rain_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1136 | `spring_snow_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1137 | `spring_storm_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1138 | `summer_rain_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1139 | `summer_snow_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1140 | `summer_storm_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1141 | `fall_rain_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1142 | `fall_snow_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1143 | `fall_storm_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1144 | `winter_rain_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1145 | `winter_snow_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1146 | `winter_storm_chance` tinyint(3) unsigned NOT NULL default '25', |
---|
1147 | PRIMARY KEY (`zone`) |
---|
1148 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System'; |
---|
1149 | |
---|
1150 | -- |
---|
1151 | -- Dumping data for table `game_weather` |
---|
1152 | -- |
---|
1153 | |
---|
1154 | LOCK TABLES `game_weather` WRITE; |
---|
1155 | /*!40000 ALTER TABLE `game_weather` DISABLE KEYS */; |
---|
1156 | /*!40000 ALTER TABLE `game_weather` ENABLE KEYS */; |
---|
1157 | UNLOCK TABLES; |
---|
1158 | |
---|
1159 | -- |
---|
1160 | -- Table structure for table `gameobject` |
---|
1161 | -- |
---|
1162 | |
---|
1163 | DROP TABLE IF EXISTS `gameobject`; |
---|
1164 | CREATE TABLE `gameobject` ( |
---|
1165 | `guid` int(10) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier', |
---|
1166 | `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Gameobject Identifier', |
---|
1167 | `map` smallint(5) unsigned NOT NULL default '0' COMMENT 'Map Identifier', |
---|
1168 | `spawnMask` tinyint(3) unsigned NOT NULL default '1', |
---|
1169 | `position_x` float NOT NULL default '0', |
---|
1170 | `position_y` float NOT NULL default '0', |
---|
1171 | `position_z` float NOT NULL default '0', |
---|
1172 | `orientation` float NOT NULL default '0', |
---|
1173 | `rotation0` float NOT NULL default '0', |
---|
1174 | `rotation1` float NOT NULL default '0', |
---|
1175 | `rotation2` float NOT NULL default '0', |
---|
1176 | `rotation3` float NOT NULL default '0', |
---|
1177 | `spawntimesecs` int(11) NOT NULL default '0', |
---|
1178 | `animprogress` tinyint(3) unsigned NOT NULL default '0', |
---|
1179 | `state` tinyint(3) unsigned NOT NULL default '0', |
---|
1180 | PRIMARY KEY (`guid`) |
---|
1181 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System'; |
---|
1182 | |
---|
1183 | -- |
---|
1184 | -- Dumping data for table `gameobject` |
---|
1185 | -- |
---|
1186 | |
---|
1187 | LOCK TABLES `gameobject` WRITE; |
---|
1188 | /*!40000 ALTER TABLE `gameobject` DISABLE KEYS */; |
---|
1189 | /*!40000 ALTER TABLE `gameobject` ENABLE KEYS */; |
---|
1190 | UNLOCK TABLES; |
---|
1191 | |
---|
1192 | -- |
---|
1193 | -- Table structure for table `gameobject_involvedrelation` |
---|
1194 | -- |
---|
1195 | |
---|
1196 | DROP TABLE IF EXISTS `gameobject_involvedrelation`; |
---|
1197 | CREATE TABLE `gameobject_involvedrelation` ( |
---|
1198 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
1199 | `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', |
---|
1200 | PRIMARY KEY (`id`,`quest`) |
---|
1201 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1202 | |
---|
1203 | -- |
---|
1204 | -- Dumping data for table `gameobject_involvedrelation` |
---|
1205 | -- |
---|
1206 | |
---|
1207 | LOCK TABLES `gameobject_involvedrelation` WRITE; |
---|
1208 | /*!40000 ALTER TABLE `gameobject_involvedrelation` DISABLE KEYS */; |
---|
1209 | /*!40000 ALTER TABLE `gameobject_involvedrelation` ENABLE KEYS */; |
---|
1210 | UNLOCK TABLES; |
---|
1211 | |
---|
1212 | -- |
---|
1213 | -- Table structure for table `gameobject_loot_template` |
---|
1214 | -- |
---|
1215 | |
---|
1216 | DROP TABLE IF EXISTS `gameobject_loot_template`; |
---|
1217 | CREATE TABLE `gameobject_loot_template` ( |
---|
1218 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1219 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
1220 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
1221 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
1222 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
1223 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
1224 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
1225 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
1226 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
1227 | PRIMARY KEY (`entry`,`item`) |
---|
1228 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; |
---|
1229 | |
---|
1230 | -- |
---|
1231 | -- Dumping data for table `gameobject_loot_template` |
---|
1232 | -- |
---|
1233 | |
---|
1234 | LOCK TABLES `gameobject_loot_template` WRITE; |
---|
1235 | /*!40000 ALTER TABLE `gameobject_loot_template` DISABLE KEYS */; |
---|
1236 | /*!40000 ALTER TABLE `gameobject_loot_template` ENABLE KEYS */; |
---|
1237 | UNLOCK TABLES; |
---|
1238 | |
---|
1239 | -- |
---|
1240 | -- Table structure for table `gameobject_questrelation` |
---|
1241 | -- |
---|
1242 | |
---|
1243 | DROP TABLE IF EXISTS `gameobject_questrelation`; |
---|
1244 | CREATE TABLE `gameobject_questrelation` ( |
---|
1245 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
1246 | `quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', |
---|
1247 | PRIMARY KEY (`id`,`quest`) |
---|
1248 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1249 | |
---|
1250 | -- |
---|
1251 | -- Dumping data for table `gameobject_questrelation` |
---|
1252 | -- |
---|
1253 | |
---|
1254 | LOCK TABLES `gameobject_questrelation` WRITE; |
---|
1255 | /*!40000 ALTER TABLE `gameobject_questrelation` DISABLE KEYS */; |
---|
1256 | /*!40000 ALTER TABLE `gameobject_questrelation` ENABLE KEYS */; |
---|
1257 | UNLOCK TABLES; |
---|
1258 | |
---|
1259 | -- |
---|
1260 | -- Table structure for table `gameobject_respawn` |
---|
1261 | -- |
---|
1262 | |
---|
1263 | DROP TABLE IF EXISTS `gameobject_respawn`; |
---|
1264 | CREATE TABLE `gameobject_respawn` ( |
---|
1265 | `guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
1266 | `respawntime` bigint(20) NOT NULL default '0', |
---|
1267 | `instance` mediumint(8) unsigned NOT NULL default '0', |
---|
1268 | PRIMARY KEY (`guid`,`instance`), |
---|
1269 | KEY `instance` (`instance`) |
---|
1270 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System'; |
---|
1271 | |
---|
1272 | -- |
---|
1273 | -- Dumping data for table `gameobject_respawn` |
---|
1274 | -- |
---|
1275 | |
---|
1276 | LOCK TABLES `gameobject_respawn` WRITE; |
---|
1277 | /*!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS */; |
---|
1278 | /*!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS */; |
---|
1279 | UNLOCK TABLES; |
---|
1280 | |
---|
1281 | -- |
---|
1282 | -- Table structure for table `gameobject_scripts` |
---|
1283 | -- |
---|
1284 | |
---|
1285 | DROP TABLE IF EXISTS `gameobject_scripts`; |
---|
1286 | CREATE TABLE `gameobject_scripts` ( |
---|
1287 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
1288 | `delay` int(10) unsigned NOT NULL default '0', |
---|
1289 | `command` mediumint(8) unsigned NOT NULL default '0', |
---|
1290 | `datalong` mediumint(8) unsigned NOT NULL default '0', |
---|
1291 | `datalong2` int(10) unsigned NOT NULL default '0', |
---|
1292 | `datatext` text NOT NULL, |
---|
1293 | `x` float NOT NULL default '0', |
---|
1294 | `y` float NOT NULL default '0', |
---|
1295 | `z` float NOT NULL default '0', |
---|
1296 | `o` float NOT NULL default '0' |
---|
1297 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1298 | |
---|
1299 | -- |
---|
1300 | -- Dumping data for table `gameobject_scripts` |
---|
1301 | -- |
---|
1302 | |
---|
1303 | LOCK TABLES `gameobject_scripts` WRITE; |
---|
1304 | /*!40000 ALTER TABLE `gameobject_scripts` DISABLE KEYS */; |
---|
1305 | /*!40000 ALTER TABLE `gameobject_scripts` ENABLE KEYS */; |
---|
1306 | UNLOCK TABLES; |
---|
1307 | |
---|
1308 | -- |
---|
1309 | -- Table structure for table `gameobject_template` |
---|
1310 | -- |
---|
1311 | |
---|
1312 | DROP TABLE IF EXISTS `gameobject_template`; |
---|
1313 | CREATE TABLE `gameobject_template` ( |
---|
1314 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1315 | `type` tinyint(3) unsigned NOT NULL default '0', |
---|
1316 | `displayId` mediumint(8) unsigned NOT NULL default '0', |
---|
1317 | `name` varchar(100) NOT NULL default '', |
---|
1318 | `castBarCaption` varchar(100) NOT NULL default '', |
---|
1319 | `faction` smallint(5) unsigned NOT NULL default '0', |
---|
1320 | `flags` int(10) unsigned NOT NULL default '0', |
---|
1321 | `size` float NOT NULL default '1', |
---|
1322 | `data0` int(10) unsigned NOT NULL default '0', |
---|
1323 | `data1` int(10) unsigned NOT NULL default '0', |
---|
1324 | `data2` int(10) unsigned NOT NULL default '0', |
---|
1325 | `data3` int(10) unsigned NOT NULL default '0', |
---|
1326 | `data4` int(10) unsigned NOT NULL default '0', |
---|
1327 | `data5` int(10) unsigned NOT NULL default '0', |
---|
1328 | `data6` int(10) unsigned NOT NULL default '0', |
---|
1329 | `data7` int(10) unsigned NOT NULL default '0', |
---|
1330 | `data8` int(10) unsigned NOT NULL default '0', |
---|
1331 | `data9` int(10) unsigned NOT NULL default '0', |
---|
1332 | `data10` int(10) unsigned NOT NULL default '0', |
---|
1333 | `data11` int(10) unsigned NOT NULL default '0', |
---|
1334 | `data12` int(10) unsigned NOT NULL default '0', |
---|
1335 | `data13` int(10) unsigned NOT NULL default '0', |
---|
1336 | `data14` int(10) unsigned NOT NULL default '0', |
---|
1337 | `data15` int(10) unsigned NOT NULL default '0', |
---|
1338 | `data16` int(10) unsigned NOT NULL default '0', |
---|
1339 | `data17` int(10) unsigned NOT NULL default '0', |
---|
1340 | `data18` int(10) unsigned NOT NULL default '0', |
---|
1341 | `data19` int(10) unsigned NOT NULL default '0', |
---|
1342 | `data20` int(10) unsigned NOT NULL default '0', |
---|
1343 | `data21` int(10) unsigned NOT NULL default '0', |
---|
1344 | `data22` int(10) unsigned NOT NULL default '0', |
---|
1345 | `data23` int(10) unsigned NOT NULL default '0', |
---|
1346 | `ScriptName` varchar(64) NOT NULL default '', |
---|
1347 | PRIMARY KEY (`entry`), |
---|
1348 | KEY `idx_name` (`name`) |
---|
1349 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System'; |
---|
1350 | |
---|
1351 | -- |
---|
1352 | -- Dumping data for table `gameobject_template` |
---|
1353 | -- |
---|
1354 | |
---|
1355 | LOCK TABLES `gameobject_template` WRITE; |
---|
1356 | /*!40000 ALTER TABLE `gameobject_template` DISABLE KEYS */; |
---|
1357 | /*!40000 ALTER TABLE `gameobject_template` ENABLE KEYS */; |
---|
1358 | UNLOCK TABLES; |
---|
1359 | |
---|
1360 | -- |
---|
1361 | -- Table structure for table `instance_template` |
---|
1362 | -- |
---|
1363 | |
---|
1364 | DROP TABLE IF EXISTS `instance_template`; |
---|
1365 | CREATE TABLE `instance_template` ( |
---|
1366 | `map` smallint(5) unsigned NOT NULL, |
---|
1367 | `parent` int(10) unsigned NOT NULL, |
---|
1368 | `levelMin` tinyint(3) unsigned NOT NULL default '0', |
---|
1369 | `levelMax` tinyint(3) unsigned NOT NULL default '0', |
---|
1370 | `maxPlayers` tinyint(3) unsigned NOT NULL default '0', |
---|
1371 | `reset_delay` int(10) unsigned NOT NULL default '0', |
---|
1372 | `startLocX` float default NULL, |
---|
1373 | `startLocY` float default NULL, |
---|
1374 | `startLocZ` float default NULL, |
---|
1375 | `startLocO` float default NULL, |
---|
1376 | `script` varchar(128) NOT NULL default '', |
---|
1377 | PRIMARY KEY (`map`) |
---|
1378 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1379 | |
---|
1380 | -- |
---|
1381 | -- Dumping data for table `instance_template` |
---|
1382 | -- |
---|
1383 | |
---|
1384 | LOCK TABLES `instance_template` WRITE; |
---|
1385 | /*!40000 ALTER TABLE `instance_template` DISABLE KEYS */; |
---|
1386 | /*!40000 ALTER TABLE `instance_template` ENABLE KEYS */; |
---|
1387 | UNLOCK TABLES; |
---|
1388 | |
---|
1389 | -- |
---|
1390 | -- Table structure for table `item_enchantment_template` |
---|
1391 | -- |
---|
1392 | |
---|
1393 | DROP TABLE IF EXISTS `item_enchantment_template`; |
---|
1394 | CREATE TABLE `item_enchantment_template` ( |
---|
1395 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1396 | `ench` mediumint(8) unsigned NOT NULL default '0', |
---|
1397 | `chance` float unsigned NOT NULL default '0', |
---|
1398 | PRIMARY KEY (`entry`,`ench`) |
---|
1399 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item Random Enchantment System'; |
---|
1400 | |
---|
1401 | -- |
---|
1402 | -- Dumping data for table `item_enchantment_template` |
---|
1403 | -- |
---|
1404 | |
---|
1405 | LOCK TABLES `item_enchantment_template` WRITE; |
---|
1406 | /*!40000 ALTER TABLE `item_enchantment_template` DISABLE KEYS */; |
---|
1407 | /*!40000 ALTER TABLE `item_enchantment_template` ENABLE KEYS */; |
---|
1408 | UNLOCK TABLES; |
---|
1409 | |
---|
1410 | -- |
---|
1411 | -- Table structure for table `item_loot_template` |
---|
1412 | -- |
---|
1413 | |
---|
1414 | DROP TABLE IF EXISTS `item_loot_template`; |
---|
1415 | CREATE TABLE `item_loot_template` ( |
---|
1416 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1417 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
1418 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
1419 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
1420 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
1421 | `maxcount` smallint(5) unsigned NOT NULL default '1', |
---|
1422 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
1423 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
1424 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
1425 | PRIMARY KEY (`entry`,`item`) |
---|
1426 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; |
---|
1427 | |
---|
1428 | -- |
---|
1429 | -- Dumping data for table `item_loot_template` |
---|
1430 | -- |
---|
1431 | |
---|
1432 | LOCK TABLES `item_loot_template` WRITE; |
---|
1433 | /*!40000 ALTER TABLE `item_loot_template` DISABLE KEYS */; |
---|
1434 | /*!40000 ALTER TABLE `item_loot_template` ENABLE KEYS */; |
---|
1435 | UNLOCK TABLES; |
---|
1436 | |
---|
1437 | -- |
---|
1438 | -- Table structure for table `item_template` |
---|
1439 | -- |
---|
1440 | |
---|
1441 | DROP TABLE IF EXISTS `item_template`; |
---|
1442 | CREATE TABLE `item_template` ( |
---|
1443 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1444 | `class` tinyint(3) unsigned NOT NULL default '0', |
---|
1445 | `subclass` tinyint(3) unsigned NOT NULL default '0', |
---|
1446 | `unk0` int(11) NOT NULL default '-1', |
---|
1447 | `name` varchar(255) NOT NULL default '', |
---|
1448 | `displayid` mediumint(8) unsigned NOT NULL default '0', |
---|
1449 | `Quality` tinyint(3) unsigned NOT NULL default '0', |
---|
1450 | `Flags` int(10) unsigned NOT NULL default '0', |
---|
1451 | `BuyCount` tinyint(3) unsigned NOT NULL default '1', |
---|
1452 | `BuyPrice` int(10) unsigned NOT NULL default '0', |
---|
1453 | `SellPrice` int(10) unsigned NOT NULL default '0', |
---|
1454 | `InventoryType` tinyint(3) unsigned NOT NULL default '0', |
---|
1455 | `AllowableClass` mediumint(9) NOT NULL default '-1', |
---|
1456 | `AllowableRace` mediumint(9) NOT NULL default '-1', |
---|
1457 | `ItemLevel` tinyint(3) unsigned NOT NULL default '0', |
---|
1458 | `RequiredLevel` tinyint(3) unsigned NOT NULL default '0', |
---|
1459 | `RequiredSkill` smallint(5) unsigned NOT NULL default '0', |
---|
1460 | `RequiredSkillRank` smallint(5) unsigned NOT NULL default '0', |
---|
1461 | `requiredspell` mediumint(8) unsigned NOT NULL default '0', |
---|
1462 | `requiredhonorrank` mediumint(8) unsigned NOT NULL default '0', |
---|
1463 | `RequiredCityRank` mediumint(8) unsigned NOT NULL default '0', |
---|
1464 | `RequiredReputationFaction` smallint(5) unsigned NOT NULL default '0', |
---|
1465 | `RequiredReputationRank` smallint(5) unsigned NOT NULL default '0', |
---|
1466 | `maxcount` smallint(5) unsigned NOT NULL default '0', |
---|
1467 | `stackable` smallint(5) unsigned NOT NULL default '1', |
---|
1468 | `ContainerSlots` tinyint(3) unsigned NOT NULL default '0', |
---|
1469 | `stat_type1` tinyint(3) unsigned NOT NULL default '0', |
---|
1470 | `stat_value1` smallint(6) NOT NULL default '0', |
---|
1471 | `stat_type2` tinyint(3) unsigned NOT NULL default '0', |
---|
1472 | `stat_value2` smallint(6) NOT NULL default '0', |
---|
1473 | `stat_type3` tinyint(3) unsigned NOT NULL default '0', |
---|
1474 | `stat_value3` smallint(6) NOT NULL default '0', |
---|
1475 | `stat_type4` tinyint(3) unsigned NOT NULL default '0', |
---|
1476 | `stat_value4` smallint(6) NOT NULL default '0', |
---|
1477 | `stat_type5` tinyint(3) unsigned NOT NULL default '0', |
---|
1478 | `stat_value5` smallint(6) NOT NULL default '0', |
---|
1479 | `stat_type6` tinyint(3) unsigned NOT NULL default '0', |
---|
1480 | `stat_value6` smallint(6) NOT NULL default '0', |
---|
1481 | `stat_type7` tinyint(3) unsigned NOT NULL default '0', |
---|
1482 | `stat_value7` smallint(6) NOT NULL default '0', |
---|
1483 | `stat_type8` tinyint(3) unsigned NOT NULL default '0', |
---|
1484 | `stat_value8` smallint(6) NOT NULL default '0', |
---|
1485 | `stat_type9` tinyint(3) unsigned NOT NULL default '0', |
---|
1486 | `stat_value9` smallint(6) NOT NULL default '0', |
---|
1487 | `stat_type10` tinyint(3) unsigned NOT NULL default '0', |
---|
1488 | `stat_value10` smallint(6) NOT NULL default '0', |
---|
1489 | `dmg_min1` float NOT NULL default '0', |
---|
1490 | `dmg_max1` float NOT NULL default '0', |
---|
1491 | `dmg_type1` tinyint(3) unsigned NOT NULL default '0', |
---|
1492 | `dmg_min2` float NOT NULL default '0', |
---|
1493 | `dmg_max2` float NOT NULL default '0', |
---|
1494 | `dmg_type2` tinyint(3) unsigned NOT NULL default '0', |
---|
1495 | `dmg_min3` float NOT NULL default '0', |
---|
1496 | `dmg_max3` float NOT NULL default '0', |
---|
1497 | `dmg_type3` tinyint(3) unsigned NOT NULL default '0', |
---|
1498 | `dmg_min4` float NOT NULL default '0', |
---|
1499 | `dmg_max4` float NOT NULL default '0', |
---|
1500 | `dmg_type4` tinyint(3) unsigned NOT NULL default '0', |
---|
1501 | `dmg_min5` float NOT NULL default '0', |
---|
1502 | `dmg_max5` float NOT NULL default '0', |
---|
1503 | `dmg_type5` tinyint(3) unsigned NOT NULL default '0', |
---|
1504 | `armor` smallint(5) unsigned NOT NULL default '0', |
---|
1505 | `holy_res` tinyint(3) unsigned NOT NULL default '0', |
---|
1506 | `fire_res` tinyint(3) unsigned NOT NULL default '0', |
---|
1507 | `nature_res` tinyint(3) unsigned NOT NULL default '0', |
---|
1508 | `frost_res` tinyint(3) unsigned NOT NULL default '0', |
---|
1509 | `shadow_res` tinyint(3) unsigned NOT NULL default '0', |
---|
1510 | `arcane_res` tinyint(3) unsigned NOT NULL default '0', |
---|
1511 | `delay` smallint(5) unsigned NOT NULL default '1000', |
---|
1512 | `ammo_type` tinyint(3) unsigned NOT NULL default '0', |
---|
1513 | `RangedModRange` float NOT NULL default '0', |
---|
1514 | `spellid_1` mediumint(8) unsigned NOT NULL default '0', |
---|
1515 | `spelltrigger_1` tinyint(3) unsigned NOT NULL default '0', |
---|
1516 | `spellcharges_1` tinyint(4) NOT NULL default '0', |
---|
1517 | `spellppmRate_1` float NOT NULL default '0', |
---|
1518 | `spellcooldown_1` int(11) NOT NULL default '-1', |
---|
1519 | `spellcategory_1` smallint(5) unsigned NOT NULL default '0', |
---|
1520 | `spellcategorycooldown_1` int(11) NOT NULL default '-1', |
---|
1521 | `spellid_2` mediumint(8) unsigned NOT NULL default '0', |
---|
1522 | `spelltrigger_2` tinyint(3) unsigned NOT NULL default '0', |
---|
1523 | `spellcharges_2` tinyint(4) NOT NULL default '0', |
---|
1524 | `spellppmRate_2` float NOT NULL default '0', |
---|
1525 | `spellcooldown_2` int(11) NOT NULL default '-1', |
---|
1526 | `spellcategory_2` smallint(5) unsigned NOT NULL default '0', |
---|
1527 | `spellcategorycooldown_2` int(11) NOT NULL default '-1', |
---|
1528 | `spellid_3` mediumint(8) unsigned NOT NULL default '0', |
---|
1529 | `spelltrigger_3` tinyint(3) unsigned NOT NULL default '0', |
---|
1530 | `spellcharges_3` tinyint(4) NOT NULL default '0', |
---|
1531 | `spellppmRate_3` float NOT NULL default '0', |
---|
1532 | `spellcooldown_3` int(11) NOT NULL default '-1', |
---|
1533 | `spellcategory_3` smallint(5) unsigned NOT NULL default '0', |
---|
1534 | `spellcategorycooldown_3` int(11) NOT NULL default '-1', |
---|
1535 | `spellid_4` mediumint(8) unsigned NOT NULL default '0', |
---|
1536 | `spelltrigger_4` tinyint(3) unsigned NOT NULL default '0', |
---|
1537 | `spellcharges_4` tinyint(4) NOT NULL default '0', |
---|
1538 | `spellppmRate_4` float NOT NULL default '0', |
---|
1539 | `spellcooldown_4` int(11) NOT NULL default '-1', |
---|
1540 | `spellcategory_4` smallint(5) unsigned NOT NULL default '0', |
---|
1541 | `spellcategorycooldown_4` int(11) NOT NULL default '-1', |
---|
1542 | `spellid_5` mediumint(8) unsigned NOT NULL default '0', |
---|
1543 | `spelltrigger_5` tinyint(3) unsigned NOT NULL default '0', |
---|
1544 | `spellcharges_5` tinyint(4) NOT NULL default '0', |
---|
1545 | `spellppmRate_5` float NOT NULL default '0', |
---|
1546 | `spellcooldown_5` int(11) NOT NULL default '-1', |
---|
1547 | `spellcategory_5` smallint(5) unsigned NOT NULL default '0', |
---|
1548 | `spellcategorycooldown_5` int(11) NOT NULL default '-1', |
---|
1549 | `bonding` tinyint(3) unsigned NOT NULL default '0', |
---|
1550 | `description` varchar(255) NOT NULL default '', |
---|
1551 | `PageText` mediumint(8) unsigned NOT NULL default '0', |
---|
1552 | `LanguageID` tinyint(3) unsigned NOT NULL default '0', |
---|
1553 | `PageMaterial` tinyint(3) unsigned NOT NULL default '0', |
---|
1554 | `startquest` mediumint(8) unsigned NOT NULL default '0', |
---|
1555 | `lockid` mediumint(8) unsigned NOT NULL default '0', |
---|
1556 | `Material` tinyint(4) NOT NULL default '0', |
---|
1557 | `sheath` tinyint(3) unsigned NOT NULL default '0', |
---|
1558 | `RandomProperty` mediumint(8) unsigned NOT NULL default '0', |
---|
1559 | `RandomSuffix` mediumint(8) unsigned NOT NULL default '0', |
---|
1560 | `block` mediumint(8) unsigned NOT NULL default '0', |
---|
1561 | `itemset` mediumint(8) unsigned NOT NULL default '0', |
---|
1562 | `MaxDurability` smallint(5) unsigned NOT NULL default '0', |
---|
1563 | `area` mediumint(8) unsigned NOT NULL default '0', |
---|
1564 | `Map` smallint(6) NOT NULL default '0', |
---|
1565 | `BagFamily` mediumint(9) NOT NULL default '0', |
---|
1566 | `TotemCategory` tinyint(4) NOT NULL default '0', |
---|
1567 | `socketColor_1` tinyint(4) NOT NULL default '0', |
---|
1568 | `socketContent_1` mediumint(9) NOT NULL default '0', |
---|
1569 | `socketColor_2` tinyint(4) NOT NULL default '0', |
---|
1570 | `socketContent_2` mediumint(9) NOT NULL default '0', |
---|
1571 | `socketColor_3` tinyint(4) NOT NULL default '0', |
---|
1572 | `socketContent_3` mediumint(9) NOT NULL default '0', |
---|
1573 | `socketBonus` mediumint(9) NOT NULL default '0', |
---|
1574 | `GemProperties` mediumint(9) NOT NULL default '0', |
---|
1575 | `RequiredDisenchantSkill` smallint(6) NOT NULL default '-1', |
---|
1576 | `ArmorDamageModifier` float NOT NULL default '0', |
---|
1577 | `ScriptName` varchar(64) NOT NULL default '', |
---|
1578 | `DisenchantID` mediumint(8) unsigned NOT NULL default '0', |
---|
1579 | `FoodType` tinyint(3) unsigned NOT NULL default '0', |
---|
1580 | `minMoneyLoot` int(10) unsigned NOT NULL default '0', |
---|
1581 | `maxMoneyLoot` int(10) unsigned NOT NULL default '0', |
---|
1582 | `Duration` int(11) NOT NULL default '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time', |
---|
1583 | PRIMARY KEY (`entry`), |
---|
1584 | KEY `idx_name` (`name`), |
---|
1585 | KEY `items_index` (`class`) |
---|
1586 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; |
---|
1587 | |
---|
1588 | -- |
---|
1589 | -- Dumping data for table `item_template` |
---|
1590 | -- |
---|
1591 | |
---|
1592 | LOCK TABLES `item_template` WRITE; |
---|
1593 | /*!40000 ALTER TABLE `item_template` DISABLE KEYS */; |
---|
1594 | /*!40000 ALTER TABLE `item_template` ENABLE KEYS */; |
---|
1595 | UNLOCK TABLES; |
---|
1596 | |
---|
1597 | -- |
---|
1598 | -- Table structure for table `locales_creature` |
---|
1599 | -- |
---|
1600 | |
---|
1601 | DROP TABLE IF EXISTS `locales_creature`; |
---|
1602 | CREATE TABLE `locales_creature` ( |
---|
1603 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1604 | `name_loc1` varchar(100) NOT NULL default '', |
---|
1605 | `name_loc2` varchar(100) NOT NULL default '', |
---|
1606 | `name_loc3` varchar(100) NOT NULL default '', |
---|
1607 | `name_loc4` varchar(100) NOT NULL default '', |
---|
1608 | `name_loc5` varchar(100) NOT NULL default '', |
---|
1609 | `name_loc6` varchar(100) NOT NULL default '', |
---|
1610 | `name_loc7` varchar(100) NOT NULL default '', |
---|
1611 | `name_loc8` varchar(100) NOT NULL default '', |
---|
1612 | `subname_loc1` varchar(100) default NULL, |
---|
1613 | `subname_loc2` varchar(100) default NULL, |
---|
1614 | `subname_loc3` varchar(100) default NULL, |
---|
1615 | `subname_loc4` varchar(100) default NULL, |
---|
1616 | `subname_loc5` varchar(100) default NULL, |
---|
1617 | `subname_loc6` varchar(100) default NULL, |
---|
1618 | `subname_loc7` varchar(100) default NULL, |
---|
1619 | `subname_loc8` varchar(100) default NULL, |
---|
1620 | PRIMARY KEY (`entry`) |
---|
1621 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1622 | |
---|
1623 | -- |
---|
1624 | -- Dumping data for table `locales_creature` |
---|
1625 | -- |
---|
1626 | |
---|
1627 | LOCK TABLES `locales_creature` WRITE; |
---|
1628 | /*!40000 ALTER TABLE `locales_creature` DISABLE KEYS */; |
---|
1629 | /*!40000 ALTER TABLE `locales_creature` ENABLE KEYS */; |
---|
1630 | UNLOCK TABLES; |
---|
1631 | |
---|
1632 | -- |
---|
1633 | -- Table structure for table `locales_gameobject` |
---|
1634 | -- |
---|
1635 | |
---|
1636 | DROP TABLE IF EXISTS `locales_gameobject`; |
---|
1637 | CREATE TABLE `locales_gameobject` ( |
---|
1638 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1639 | `name_loc1` varchar(100) NOT NULL default '', |
---|
1640 | `name_loc2` varchar(100) NOT NULL default '', |
---|
1641 | `name_loc3` varchar(100) NOT NULL default '', |
---|
1642 | `name_loc4` varchar(100) NOT NULL default '', |
---|
1643 | `name_loc5` varchar(100) NOT NULL default '', |
---|
1644 | `name_loc6` varchar(100) NOT NULL default '', |
---|
1645 | `name_loc7` varchar(100) NOT NULL default '', |
---|
1646 | `name_loc8` varchar(100) NOT NULL default '', |
---|
1647 | `castbarcaption_loc1` varchar(100) NOT NULL default '', |
---|
1648 | `castbarcaption_loc2` varchar(100) NOT NULL default '', |
---|
1649 | `castbarcaption_loc3` varchar(100) NOT NULL default '', |
---|
1650 | `castbarcaption_loc4` varchar(100) NOT NULL default '', |
---|
1651 | `castbarcaption_loc5` varchar(100) NOT NULL default '', |
---|
1652 | `castbarcaption_loc6` varchar(100) NOT NULL default '', |
---|
1653 | `castbarcaption_loc7` varchar(100) NOT NULL default '', |
---|
1654 | `castbarcaption_loc8` varchar(100) NOT NULL default '', |
---|
1655 | PRIMARY KEY (`entry`) |
---|
1656 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1657 | |
---|
1658 | -- |
---|
1659 | -- Dumping data for table `locales_gameobject` |
---|
1660 | -- |
---|
1661 | |
---|
1662 | LOCK TABLES `locales_gameobject` WRITE; |
---|
1663 | /*!40000 ALTER TABLE `locales_gameobject` DISABLE KEYS */; |
---|
1664 | /*!40000 ALTER TABLE `locales_gameobject` ENABLE KEYS */; |
---|
1665 | UNLOCK TABLES; |
---|
1666 | |
---|
1667 | -- |
---|
1668 | -- Table structure for table `locales_item` |
---|
1669 | -- |
---|
1670 | |
---|
1671 | DROP TABLE IF EXISTS `locales_item`; |
---|
1672 | CREATE TABLE `locales_item` ( |
---|
1673 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1674 | `name_loc1` varchar(100) NOT NULL default '', |
---|
1675 | `name_loc2` varchar(100) NOT NULL default '', |
---|
1676 | `name_loc3` varchar(100) NOT NULL default '', |
---|
1677 | `name_loc4` varchar(100) NOT NULL default '', |
---|
1678 | `name_loc5` varchar(100) NOT NULL default '', |
---|
1679 | `name_loc6` varchar(100) NOT NULL default '', |
---|
1680 | `name_loc7` varchar(100) NOT NULL default '', |
---|
1681 | `name_loc8` varchar(100) NOT NULL default '', |
---|
1682 | `description_loc1` varchar(255) default NULL, |
---|
1683 | `description_loc2` varchar(255) default NULL, |
---|
1684 | `description_loc3` varchar(255) default NULL, |
---|
1685 | `description_loc4` varchar(255) default NULL, |
---|
1686 | `description_loc5` varchar(255) default NULL, |
---|
1687 | `description_loc6` varchar(255) default NULL, |
---|
1688 | `description_loc7` varchar(255) default NULL, |
---|
1689 | `description_loc8` varchar(255) default NULL, |
---|
1690 | PRIMARY KEY (`entry`) |
---|
1691 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1692 | |
---|
1693 | -- |
---|
1694 | -- Dumping data for table `locales_item` |
---|
1695 | -- |
---|
1696 | |
---|
1697 | LOCK TABLES `locales_item` WRITE; |
---|
1698 | /*!40000 ALTER TABLE `locales_item` DISABLE KEYS */; |
---|
1699 | /*!40000 ALTER TABLE `locales_item` ENABLE KEYS */; |
---|
1700 | UNLOCK TABLES; |
---|
1701 | |
---|
1702 | -- |
---|
1703 | -- Table structure for table `locales_npc_text` |
---|
1704 | -- |
---|
1705 | |
---|
1706 | DROP TABLE IF EXISTS `locales_npc_text`; |
---|
1707 | CREATE TABLE `locales_npc_text` ( |
---|
1708 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1709 | `Text0_0_loc1` longtext, |
---|
1710 | `Text0_0_loc2` longtext, |
---|
1711 | `Text0_0_loc3` longtext, |
---|
1712 | `Text0_0_loc4` longtext, |
---|
1713 | `Text0_0_loc5` longtext, |
---|
1714 | `Text0_0_loc6` longtext, |
---|
1715 | `Text0_0_loc7` longtext, |
---|
1716 | `Text0_0_loc8` longtext, |
---|
1717 | `Text0_1_loc1` longtext, |
---|
1718 | `Text0_1_loc2` longtext, |
---|
1719 | `Text0_1_loc3` longtext, |
---|
1720 | `Text0_1_loc4` longtext, |
---|
1721 | `Text0_1_loc5` longtext, |
---|
1722 | `Text0_1_loc6` longtext, |
---|
1723 | `Text0_1_loc7` longtext, |
---|
1724 | `Text0_1_loc8` longtext, |
---|
1725 | `Text1_0_loc1` longtext, |
---|
1726 | `Text1_0_loc2` longtext, |
---|
1727 | `Text1_0_loc3` longtext, |
---|
1728 | `Text1_0_loc4` longtext, |
---|
1729 | `Text1_0_loc5` longtext, |
---|
1730 | `Text1_0_loc6` longtext, |
---|
1731 | `Text1_0_loc7` longtext, |
---|
1732 | `Text1_0_loc8` longtext, |
---|
1733 | `Text1_1_loc1` longtext, |
---|
1734 | `Text1_1_loc2` longtext, |
---|
1735 | `Text1_1_loc3` longtext, |
---|
1736 | `Text1_1_loc4` longtext, |
---|
1737 | `Text1_1_loc5` longtext, |
---|
1738 | `Text1_1_loc6` longtext, |
---|
1739 | `Text1_1_loc7` longtext, |
---|
1740 | `Text1_1_loc8` longtext, |
---|
1741 | `Text2_0_loc1` longtext, |
---|
1742 | `Text2_0_loc2` longtext, |
---|
1743 | `Text2_0_loc3` longtext, |
---|
1744 | `Text2_0_loc4` longtext, |
---|
1745 | `Text2_0_loc5` longtext, |
---|
1746 | `Text2_0_loc6` longtext, |
---|
1747 | `Text2_0_loc7` longtext, |
---|
1748 | `Text2_0_loc8` longtext, |
---|
1749 | `Text2_1_loc1` longtext, |
---|
1750 | `Text2_1_loc2` longtext, |
---|
1751 | `Text2_1_loc3` longtext, |
---|
1752 | `Text2_1_loc4` longtext, |
---|
1753 | `Text2_1_loc5` longtext, |
---|
1754 | `Text2_1_loc6` longtext, |
---|
1755 | `Text2_1_loc7` longtext, |
---|
1756 | `Text2_1_loc8` longtext, |
---|
1757 | `Text3_0_loc1` longtext, |
---|
1758 | `Text3_0_loc2` longtext, |
---|
1759 | `Text3_0_loc3` longtext, |
---|
1760 | `Text3_0_loc4` longtext, |
---|
1761 | `Text3_0_loc5` longtext, |
---|
1762 | `Text3_0_loc6` longtext, |
---|
1763 | `Text3_0_loc7` longtext, |
---|
1764 | `Text3_0_loc8` longtext, |
---|
1765 | `Text3_1_loc1` longtext, |
---|
1766 | `Text3_1_loc2` longtext, |
---|
1767 | `Text3_1_loc3` longtext, |
---|
1768 | `Text3_1_loc4` longtext, |
---|
1769 | `Text3_1_loc5` longtext, |
---|
1770 | `Text3_1_loc6` longtext, |
---|
1771 | `Text3_1_loc7` longtext, |
---|
1772 | `Text3_1_loc8` longtext, |
---|
1773 | `Text4_0_loc1` longtext, |
---|
1774 | `Text4_0_loc2` longtext, |
---|
1775 | `Text4_0_loc3` longtext, |
---|
1776 | `Text4_0_loc4` longtext, |
---|
1777 | `Text4_0_loc5` longtext, |
---|
1778 | `Text4_0_loc6` longtext, |
---|
1779 | `Text4_0_loc7` longtext, |
---|
1780 | `Text4_0_loc8` longtext, |
---|
1781 | `Text4_1_loc1` longtext, |
---|
1782 | `Text4_1_loc2` longtext, |
---|
1783 | `Text4_1_loc3` longtext, |
---|
1784 | `Text4_1_loc4` longtext, |
---|
1785 | `Text4_1_loc5` longtext, |
---|
1786 | `Text4_1_loc6` longtext, |
---|
1787 | `Text4_1_loc7` longtext, |
---|
1788 | `Text4_1_loc8` longtext, |
---|
1789 | `Text5_0_loc1` longtext, |
---|
1790 | `Text5_0_loc2` longtext, |
---|
1791 | `Text5_0_loc3` longtext, |
---|
1792 | `Text5_0_loc4` longtext, |
---|
1793 | `Text5_0_loc5` longtext, |
---|
1794 | `Text5_0_loc6` longtext, |
---|
1795 | `Text5_0_loc7` longtext, |
---|
1796 | `Text5_0_loc8` longtext, |
---|
1797 | `Text5_1_loc1` longtext, |
---|
1798 | `Text5_1_loc2` longtext, |
---|
1799 | `Text5_1_loc3` longtext, |
---|
1800 | `Text5_1_loc4` longtext, |
---|
1801 | `Text5_1_loc5` longtext, |
---|
1802 | `Text5_1_loc6` longtext, |
---|
1803 | `Text5_1_loc7` longtext, |
---|
1804 | `Text5_1_loc8` longtext, |
---|
1805 | `Text6_0_loc1` longtext, |
---|
1806 | `Text6_0_loc2` longtext, |
---|
1807 | `Text6_0_loc3` longtext, |
---|
1808 | `Text6_0_loc4` longtext, |
---|
1809 | `Text6_0_loc5` longtext, |
---|
1810 | `Text6_0_loc6` longtext, |
---|
1811 | `Text6_0_loc7` longtext, |
---|
1812 | `Text6_0_loc8` longtext, |
---|
1813 | `Text6_1_loc1` longtext, |
---|
1814 | `Text6_1_loc2` longtext, |
---|
1815 | `Text6_1_loc3` longtext, |
---|
1816 | `Text6_1_loc4` longtext, |
---|
1817 | `Text6_1_loc5` longtext, |
---|
1818 | `Text6_1_loc6` longtext, |
---|
1819 | `Text6_1_loc7` longtext, |
---|
1820 | `Text6_1_loc8` longtext, |
---|
1821 | `Text7_0_loc1` longtext, |
---|
1822 | `Text7_0_loc2` longtext, |
---|
1823 | `Text7_0_loc3` longtext, |
---|
1824 | `Text7_0_loc4` longtext, |
---|
1825 | `Text7_0_loc5` longtext, |
---|
1826 | `Text7_0_loc6` longtext, |
---|
1827 | `Text7_0_loc7` longtext, |
---|
1828 | `Text7_0_loc8` longtext, |
---|
1829 | `Text7_1_loc1` longtext, |
---|
1830 | `Text7_1_loc2` longtext, |
---|
1831 | `Text7_1_loc3` longtext, |
---|
1832 | `Text7_1_loc4` longtext, |
---|
1833 | `Text7_1_loc5` longtext, |
---|
1834 | `Text7_1_loc6` longtext, |
---|
1835 | `Text7_1_loc7` longtext, |
---|
1836 | `Text7_1_loc8` longtext, |
---|
1837 | PRIMARY KEY (`entry`) |
---|
1838 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1839 | |
---|
1840 | -- |
---|
1841 | -- Dumping data for table `locales_npc_text` |
---|
1842 | -- |
---|
1843 | |
---|
1844 | LOCK TABLES `locales_npc_text` WRITE; |
---|
1845 | /*!40000 ALTER TABLE `locales_npc_text` DISABLE KEYS */; |
---|
1846 | /*!40000 ALTER TABLE `locales_npc_text` ENABLE KEYS */; |
---|
1847 | UNLOCK TABLES; |
---|
1848 | |
---|
1849 | -- |
---|
1850 | -- Table structure for table `locales_page_text` |
---|
1851 | -- |
---|
1852 | |
---|
1853 | DROP TABLE IF EXISTS `locales_page_text`; |
---|
1854 | CREATE TABLE `locales_page_text` ( |
---|
1855 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1856 | `Text_loc1` longtext, |
---|
1857 | `Text_loc2` longtext, |
---|
1858 | `Text_loc3` longtext, |
---|
1859 | `Text_loc4` longtext, |
---|
1860 | `Text_loc5` longtext, |
---|
1861 | `Text_loc6` longtext, |
---|
1862 | `Text_loc7` longtext, |
---|
1863 | `Text_loc8` longtext, |
---|
1864 | PRIMARY KEY (`entry`) |
---|
1865 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1866 | |
---|
1867 | -- |
---|
1868 | -- Dumping data for table `locales_page_text` |
---|
1869 | -- |
---|
1870 | |
---|
1871 | LOCK TABLES `locales_page_text` WRITE; |
---|
1872 | /*!40000 ALTER TABLE `locales_page_text` DISABLE KEYS */; |
---|
1873 | /*!40000 ALTER TABLE `locales_page_text` ENABLE KEYS */; |
---|
1874 | UNLOCK TABLES; |
---|
1875 | |
---|
1876 | -- |
---|
1877 | -- Table structure for table `locales_quest` |
---|
1878 | -- |
---|
1879 | |
---|
1880 | DROP TABLE IF EXISTS `locales_quest`; |
---|
1881 | CREATE TABLE `locales_quest` ( |
---|
1882 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
1883 | `Title_loc1` text, |
---|
1884 | `Title_loc2` text, |
---|
1885 | `Title_loc3` text, |
---|
1886 | `Title_loc4` text, |
---|
1887 | `Title_loc5` text, |
---|
1888 | `Title_loc6` text, |
---|
1889 | `Title_loc7` text, |
---|
1890 | `Title_loc8` text, |
---|
1891 | `Details_loc1` text, |
---|
1892 | `Details_loc2` text, |
---|
1893 | `Details_loc3` text, |
---|
1894 | `Details_loc4` text, |
---|
1895 | `Details_loc5` text, |
---|
1896 | `Details_loc6` text, |
---|
1897 | `Details_loc7` text, |
---|
1898 | `Details_loc8` text, |
---|
1899 | `Objectives_loc1` text, |
---|
1900 | `Objectives_loc2` text, |
---|
1901 | `Objectives_loc3` text, |
---|
1902 | `Objectives_loc4` text, |
---|
1903 | `Objectives_loc5` text, |
---|
1904 | `Objectives_loc6` text, |
---|
1905 | `Objectives_loc7` text, |
---|
1906 | `Objectives_loc8` text, |
---|
1907 | `OfferRewardText_loc1` text, |
---|
1908 | `OfferRewardText_loc2` text, |
---|
1909 | `OfferRewardText_loc3` text, |
---|
1910 | `OfferRewardText_loc4` text, |
---|
1911 | `OfferRewardText_loc5` text, |
---|
1912 | `OfferRewardText_loc6` text, |
---|
1913 | `OfferRewardText_loc7` text, |
---|
1914 | `OfferRewardText_loc8` text, |
---|
1915 | `RequestItemsText_loc1` text, |
---|
1916 | `RequestItemsText_loc2` text, |
---|
1917 | `RequestItemsText_loc3` text, |
---|
1918 | `RequestItemsText_loc4` text, |
---|
1919 | `RequestItemsText_loc5` text, |
---|
1920 | `RequestItemsText_loc6` text, |
---|
1921 | `RequestItemsText_loc7` text, |
---|
1922 | `RequestItemsText_loc8` text, |
---|
1923 | `EndText_loc1` text, |
---|
1924 | `EndText_loc2` text, |
---|
1925 | `EndText_loc3` text, |
---|
1926 | `EndText_loc4` text, |
---|
1927 | `EndText_loc5` text, |
---|
1928 | `EndText_loc6` text, |
---|
1929 | `EndText_loc7` text, |
---|
1930 | `EndText_loc8` text, |
---|
1931 | `ObjectiveText1_loc1` text, |
---|
1932 | `ObjectiveText1_loc2` text, |
---|
1933 | `ObjectiveText1_loc3` text, |
---|
1934 | `ObjectiveText1_loc4` text, |
---|
1935 | `ObjectiveText1_loc5` text, |
---|
1936 | `ObjectiveText1_loc6` text, |
---|
1937 | `ObjectiveText1_loc7` text, |
---|
1938 | `ObjectiveText1_loc8` text, |
---|
1939 | `ObjectiveText2_loc1` text, |
---|
1940 | `ObjectiveText2_loc2` text, |
---|
1941 | `ObjectiveText2_loc3` text, |
---|
1942 | `ObjectiveText2_loc4` text, |
---|
1943 | `ObjectiveText2_loc5` text, |
---|
1944 | `ObjectiveText2_loc6` text, |
---|
1945 | `ObjectiveText2_loc7` text, |
---|
1946 | `ObjectiveText2_loc8` text, |
---|
1947 | `ObjectiveText3_loc1` text, |
---|
1948 | `ObjectiveText3_loc2` text, |
---|
1949 | `ObjectiveText3_loc3` text, |
---|
1950 | `ObjectiveText3_loc4` text, |
---|
1951 | `ObjectiveText3_loc5` text, |
---|
1952 | `ObjectiveText3_loc6` text, |
---|
1953 | `ObjectiveText3_loc7` text, |
---|
1954 | `ObjectiveText3_loc8` text, |
---|
1955 | `ObjectiveText4_loc1` text, |
---|
1956 | `ObjectiveText4_loc2` text, |
---|
1957 | `ObjectiveText4_loc3` text, |
---|
1958 | `ObjectiveText4_loc4` text, |
---|
1959 | `ObjectiveText4_loc5` text, |
---|
1960 | `ObjectiveText4_loc6` text, |
---|
1961 | `ObjectiveText4_loc7` text, |
---|
1962 | `ObjectiveText4_loc8` text, |
---|
1963 | PRIMARY KEY (`entry`) |
---|
1964 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1965 | |
---|
1966 | -- |
---|
1967 | -- Dumping data for table `locales_quest` |
---|
1968 | -- |
---|
1969 | |
---|
1970 | LOCK TABLES `locales_quest` WRITE; |
---|
1971 | /*!40000 ALTER TABLE `locales_quest` DISABLE KEYS */; |
---|
1972 | /*!40000 ALTER TABLE `locales_quest` ENABLE KEYS */; |
---|
1973 | UNLOCK TABLES; |
---|
1974 | |
---|
1975 | -- |
---|
1976 | -- Table structure for table `npc_gossip` |
---|
1977 | -- |
---|
1978 | |
---|
1979 | DROP TABLE IF EXISTS `npc_gossip`; |
---|
1980 | CREATE TABLE `npc_gossip` ( |
---|
1981 | `npc_guid` int(10) unsigned NOT NULL default '0', |
---|
1982 | `textid` mediumint(8) unsigned NOT NULL default '0', |
---|
1983 | PRIMARY KEY (`npc_guid`) |
---|
1984 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1985 | |
---|
1986 | -- |
---|
1987 | -- Dumping data for table `npc_gossip` |
---|
1988 | -- |
---|
1989 | |
---|
1990 | LOCK TABLES `npc_gossip` WRITE; |
---|
1991 | /*!40000 ALTER TABLE `npc_gossip` DISABLE KEYS */; |
---|
1992 | /*!40000 ALTER TABLE `npc_gossip` ENABLE KEYS */; |
---|
1993 | UNLOCK TABLES; |
---|
1994 | |
---|
1995 | -- |
---|
1996 | -- Table structure for table `npc_gossip_textid` |
---|
1997 | -- |
---|
1998 | |
---|
1999 | DROP TABLE IF EXISTS `npc_gossip_textid`; |
---|
2000 | CREATE TABLE `npc_gossip_textid` ( |
---|
2001 | `zoneid` smallint(5) unsigned NOT NULL default '0', |
---|
2002 | `action` smallint(5) unsigned NOT NULL default '0', |
---|
2003 | `textid` mediumint(8) unsigned NOT NULL default '0', |
---|
2004 | KEY `zoneid` (`zoneid`) |
---|
2005 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2006 | |
---|
2007 | -- |
---|
2008 | -- Dumping data for table `npc_gossip_textid` |
---|
2009 | -- |
---|
2010 | |
---|
2011 | LOCK TABLES `npc_gossip_textid` WRITE; |
---|
2012 | /*!40000 ALTER TABLE `npc_gossip_textid` DISABLE KEYS */; |
---|
2013 | /*!40000 ALTER TABLE `npc_gossip_textid` ENABLE KEYS */; |
---|
2014 | UNLOCK TABLES; |
---|
2015 | |
---|
2016 | -- |
---|
2017 | -- Table structure for table `npc_option` |
---|
2018 | -- |
---|
2019 | |
---|
2020 | DROP TABLE IF EXISTS `npc_option`; |
---|
2021 | CREATE TABLE `npc_option` ( |
---|
2022 | `id` tinyint(3) unsigned NOT NULL default '0', |
---|
2023 | `gossip_id` tinyint(3) unsigned NOT NULL default '0', |
---|
2024 | `npcflag` int(10) unsigned NOT NULL default '0', |
---|
2025 | `icon` tinyint(3) unsigned NOT NULL default '0', |
---|
2026 | `action` tinyint(3) unsigned NOT NULL default '0', |
---|
2027 | `option_text` text, |
---|
2028 | PRIMARY KEY (`id`) |
---|
2029 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2030 | |
---|
2031 | -- |
---|
2032 | -- Dumping data for table `npc_option` |
---|
2033 | -- |
---|
2034 | |
---|
2035 | LOCK TABLES `npc_option` WRITE; |
---|
2036 | /*!40000 ALTER TABLE `npc_option` DISABLE KEYS */; |
---|
2037 | /*!40000 ALTER TABLE `npc_option` ENABLE KEYS */; |
---|
2038 | UNLOCK TABLES; |
---|
2039 | |
---|
2040 | -- |
---|
2041 | -- Table structure for table `npc_text` |
---|
2042 | -- |
---|
2043 | |
---|
2044 | DROP TABLE IF EXISTS `npc_text`; |
---|
2045 | CREATE TABLE `npc_text` ( |
---|
2046 | `ID` mediumint(8) unsigned NOT NULL default '0', |
---|
2047 | `text0_0` longtext, |
---|
2048 | `text0_1` longtext, |
---|
2049 | `lang0` tinyint(3) unsigned NOT NULL default '0', |
---|
2050 | `prob0` float NOT NULL default '0', |
---|
2051 | `em0_0` smallint(5) unsigned NOT NULL default '0', |
---|
2052 | `em0_1` smallint(5) unsigned NOT NULL default '0', |
---|
2053 | `em0_2` smallint(5) unsigned NOT NULL default '0', |
---|
2054 | `em0_3` smallint(5) unsigned NOT NULL default '0', |
---|
2055 | `em0_4` smallint(5) unsigned NOT NULL default '0', |
---|
2056 | `em0_5` smallint(5) unsigned NOT NULL default '0', |
---|
2057 | `text1_0` longtext, |
---|
2058 | `text1_1` longtext, |
---|
2059 | `lang1` tinyint(3) unsigned NOT NULL default '0', |
---|
2060 | `prob1` float NOT NULL default '0', |
---|
2061 | `em1_0` smallint(5) unsigned NOT NULL default '0', |
---|
2062 | `em1_1` smallint(5) unsigned NOT NULL default '0', |
---|
2063 | `em1_2` smallint(5) unsigned NOT NULL default '0', |
---|
2064 | `em1_3` smallint(5) unsigned NOT NULL default '0', |
---|
2065 | `em1_4` smallint(5) unsigned NOT NULL default '0', |
---|
2066 | `em1_5` smallint(5) unsigned NOT NULL default '0', |
---|
2067 | `text2_0` longtext, |
---|
2068 | `text2_1` longtext, |
---|
2069 | `lang2` tinyint(3) unsigned NOT NULL default '0', |
---|
2070 | `prob2` float NOT NULL default '0', |
---|
2071 | `em2_0` smallint(5) unsigned NOT NULL default '0', |
---|
2072 | `em2_1` smallint(5) unsigned NOT NULL default '0', |
---|
2073 | `em2_2` smallint(5) unsigned NOT NULL default '0', |
---|
2074 | `em2_3` smallint(5) unsigned NOT NULL default '0', |
---|
2075 | `em2_4` smallint(5) unsigned NOT NULL default '0', |
---|
2076 | `em2_5` smallint(5) unsigned NOT NULL default '0', |
---|
2077 | `text3_0` longtext, |
---|
2078 | `text3_1` longtext, |
---|
2079 | `lang3` tinyint(3) unsigned NOT NULL default '0', |
---|
2080 | `prob3` float NOT NULL default '0', |
---|
2081 | `em3_0` smallint(5) unsigned NOT NULL default '0', |
---|
2082 | `em3_1` smallint(5) unsigned NOT NULL default '0', |
---|
2083 | `em3_2` smallint(5) unsigned NOT NULL default '0', |
---|
2084 | `em3_3` smallint(5) unsigned NOT NULL default '0', |
---|
2085 | `em3_4` smallint(5) unsigned NOT NULL default '0', |
---|
2086 | `em3_5` smallint(5) unsigned NOT NULL default '0', |
---|
2087 | `text4_0` longtext, |
---|
2088 | `text4_1` longtext, |
---|
2089 | `lang4` tinyint(3) unsigned NOT NULL default '0', |
---|
2090 | `prob4` float NOT NULL default '0', |
---|
2091 | `em4_0` smallint(5) unsigned NOT NULL default '0', |
---|
2092 | `em4_1` smallint(5) unsigned NOT NULL default '0', |
---|
2093 | `em4_2` smallint(5) unsigned NOT NULL default '0', |
---|
2094 | `em4_3` smallint(5) unsigned NOT NULL default '0', |
---|
2095 | `em4_4` smallint(5) unsigned NOT NULL default '0', |
---|
2096 | `em4_5` smallint(5) unsigned NOT NULL default '0', |
---|
2097 | `text5_0` longtext, |
---|
2098 | `text5_1` longtext, |
---|
2099 | `lang5` tinyint(3) unsigned NOT NULL default '0', |
---|
2100 | `prob5` float NOT NULL default '0', |
---|
2101 | `em5_0` smallint(5) unsigned NOT NULL default '0', |
---|
2102 | `em5_1` smallint(5) unsigned NOT NULL default '0', |
---|
2103 | `em5_2` smallint(5) unsigned NOT NULL default '0', |
---|
2104 | `em5_3` smallint(5) unsigned NOT NULL default '0', |
---|
2105 | `em5_4` smallint(5) unsigned NOT NULL default '0', |
---|
2106 | `em5_5` smallint(5) unsigned NOT NULL default '0', |
---|
2107 | `text6_0` longtext, |
---|
2108 | `text6_1` longtext, |
---|
2109 | `lang6` tinyint(3) unsigned NOT NULL default '0', |
---|
2110 | `prob6` float NOT NULL default '0', |
---|
2111 | `em6_0` smallint(5) unsigned NOT NULL default '0', |
---|
2112 | `em6_1` smallint(5) unsigned NOT NULL default '0', |
---|
2113 | `em6_2` smallint(5) unsigned NOT NULL default '0', |
---|
2114 | `em6_3` smallint(5) unsigned NOT NULL default '0', |
---|
2115 | `em6_4` smallint(5) unsigned NOT NULL default '0', |
---|
2116 | `em6_5` smallint(5) unsigned NOT NULL default '0', |
---|
2117 | `text7_0` longtext, |
---|
2118 | `text7_1` longtext, |
---|
2119 | `lang7` tinyint(3) unsigned NOT NULL default '0', |
---|
2120 | `prob7` float NOT NULL default '0', |
---|
2121 | `em7_0` smallint(5) unsigned NOT NULL default '0', |
---|
2122 | `em7_1` smallint(5) unsigned NOT NULL default '0', |
---|
2123 | `em7_2` smallint(5) unsigned NOT NULL default '0', |
---|
2124 | `em7_3` smallint(5) unsigned NOT NULL default '0', |
---|
2125 | `em7_4` smallint(5) unsigned NOT NULL default '0', |
---|
2126 | `em7_5` smallint(5) unsigned NOT NULL default '0', |
---|
2127 | PRIMARY KEY (`ID`) |
---|
2128 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2129 | |
---|
2130 | -- |
---|
2131 | -- Dumping data for table `npc_text` |
---|
2132 | -- |
---|
2133 | |
---|
2134 | LOCK TABLES `npc_text` WRITE; |
---|
2135 | /*!40000 ALTER TABLE `npc_text` DISABLE KEYS */; |
---|
2136 | /*!40000 ALTER TABLE `npc_text` ENABLE KEYS */; |
---|
2137 | UNLOCK TABLES; |
---|
2138 | |
---|
2139 | -- |
---|
2140 | -- Table structure for table `npc_trainer` |
---|
2141 | -- |
---|
2142 | |
---|
2143 | DROP TABLE IF EXISTS `npc_trainer`; |
---|
2144 | CREATE TABLE `npc_trainer` ( |
---|
2145 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2146 | `spell` mediumint(8) unsigned NOT NULL default '0', |
---|
2147 | `spellcost` int(10) unsigned NOT NULL default '0', |
---|
2148 | `reqskill` smallint(5) unsigned NOT NULL default '0', |
---|
2149 | `reqskillvalue` smallint(5) unsigned NOT NULL default '0', |
---|
2150 | `reqlevel` tinyint(3) unsigned NOT NULL default '0', |
---|
2151 | PRIMARY KEY (`entry`,`spell`) |
---|
2152 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2153 | |
---|
2154 | -- |
---|
2155 | -- Dumping data for table `npc_trainer` |
---|
2156 | -- |
---|
2157 | |
---|
2158 | LOCK TABLES `npc_trainer` WRITE; |
---|
2159 | /*!40000 ALTER TABLE `npc_trainer` DISABLE KEYS */; |
---|
2160 | /*!40000 ALTER TABLE `npc_trainer` ENABLE KEYS */; |
---|
2161 | UNLOCK TABLES; |
---|
2162 | |
---|
2163 | -- |
---|
2164 | -- Table structure for table `npc_vendor` |
---|
2165 | -- |
---|
2166 | |
---|
2167 | DROP TABLE IF EXISTS `npc_vendor`; |
---|
2168 | CREATE TABLE `npc_vendor` ( |
---|
2169 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2170 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
2171 | `maxcount` tinyint(3) unsigned NOT NULL default '0', |
---|
2172 | `incrtime` int(10) unsigned NOT NULL default '0', |
---|
2173 | `ExtendedCost` mediumint(8) unsigned NOT NULL default '0', |
---|
2174 | PRIMARY KEY (`entry`,`item`) |
---|
2175 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System'; |
---|
2176 | |
---|
2177 | -- |
---|
2178 | -- Dumping data for table `npc_vendor` |
---|
2179 | -- |
---|
2180 | |
---|
2181 | LOCK TABLES `npc_vendor` WRITE; |
---|
2182 | /*!40000 ALTER TABLE `npc_vendor` DISABLE KEYS */; |
---|
2183 | /*!40000 ALTER TABLE `npc_vendor` ENABLE KEYS */; |
---|
2184 | UNLOCK TABLES; |
---|
2185 | |
---|
2186 | -- |
---|
2187 | -- Table structure for table `page_text` |
---|
2188 | -- |
---|
2189 | |
---|
2190 | DROP TABLE IF EXISTS `page_text`; |
---|
2191 | CREATE TABLE `page_text` ( |
---|
2192 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2193 | `text` longtext NOT NULL, |
---|
2194 | `next_page` mediumint(8) unsigned NOT NULL default '0', |
---|
2195 | PRIMARY KEY (`entry`) |
---|
2196 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System'; |
---|
2197 | |
---|
2198 | -- |
---|
2199 | -- Dumping data for table `page_text` |
---|
2200 | -- |
---|
2201 | |
---|
2202 | LOCK TABLES `page_text` WRITE; |
---|
2203 | /*!40000 ALTER TABLE `page_text` DISABLE KEYS */; |
---|
2204 | /*!40000 ALTER TABLE `page_text` ENABLE KEYS */; |
---|
2205 | UNLOCK TABLES; |
---|
2206 | |
---|
2207 | -- |
---|
2208 | -- Table structure for table `pet_levelstats` |
---|
2209 | -- |
---|
2210 | |
---|
2211 | DROP TABLE IF EXISTS `pet_levelstats`; |
---|
2212 | CREATE TABLE `pet_levelstats` ( |
---|
2213 | `creature_entry` mediumint(8) unsigned NOT NULL, |
---|
2214 | `level` tinyint(3) unsigned NOT NULL, |
---|
2215 | `hp` smallint(5) unsigned NOT NULL, |
---|
2216 | `mana` smallint(5) unsigned NOT NULL, |
---|
2217 | `armor` int(10) unsigned NOT NULL default '0', |
---|
2218 | `str` smallint(5) unsigned NOT NULL, |
---|
2219 | `agi` smallint(5) unsigned NOT NULL, |
---|
2220 | `sta` smallint(5) unsigned NOT NULL, |
---|
2221 | `inte` smallint(5) unsigned NOT NULL, |
---|
2222 | `spi` smallint(5) unsigned NOT NULL, |
---|
2223 | PRIMARY KEY (`creature_entry`,`level`) |
---|
2224 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.'; |
---|
2225 | |
---|
2226 | -- |
---|
2227 | -- Dumping data for table `pet_levelstats` |
---|
2228 | -- |
---|
2229 | |
---|
2230 | LOCK TABLES `pet_levelstats` WRITE; |
---|
2231 | /*!40000 ALTER TABLE `pet_levelstats` DISABLE KEYS */; |
---|
2232 | /*!40000 ALTER TABLE `pet_levelstats` ENABLE KEYS */; |
---|
2233 | UNLOCK TABLES; |
---|
2234 | |
---|
2235 | -- |
---|
2236 | -- Table structure for table `pet_name_generation` |
---|
2237 | -- |
---|
2238 | |
---|
2239 | DROP TABLE IF EXISTS `pet_name_generation`; |
---|
2240 | CREATE TABLE `pet_name_generation` ( |
---|
2241 | `id` mediumint(8) unsigned NOT NULL auto_increment, |
---|
2242 | `word` tinytext NOT NULL, |
---|
2243 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2244 | `half` tinyint(4) NOT NULL default '0', |
---|
2245 | PRIMARY KEY (`id`) |
---|
2246 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2247 | |
---|
2248 | -- |
---|
2249 | -- Dumping data for table `pet_name_generation` |
---|
2250 | -- |
---|
2251 | |
---|
2252 | LOCK TABLES `pet_name_generation` WRITE; |
---|
2253 | /*!40000 ALTER TABLE `pet_name_generation` DISABLE KEYS */; |
---|
2254 | /*!40000 ALTER TABLE `pet_name_generation` ENABLE KEYS */; |
---|
2255 | UNLOCK TABLES; |
---|
2256 | |
---|
2257 | -- |
---|
2258 | -- Table structure for table `petcreateinfo_spell` |
---|
2259 | -- |
---|
2260 | |
---|
2261 | DROP TABLE IF EXISTS `petcreateinfo_spell`; |
---|
2262 | CREATE TABLE `petcreateinfo_spell` ( |
---|
2263 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2264 | `Spell1` mediumint(8) unsigned NOT NULL default '0', |
---|
2265 | `Spell2` mediumint(8) unsigned NOT NULL default '0', |
---|
2266 | `Spell3` mediumint(8) unsigned NOT NULL default '0', |
---|
2267 | `Spell4` mediumint(8) unsigned NOT NULL default '0', |
---|
2268 | PRIMARY KEY (`entry`) |
---|
2269 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet Create Spells'; |
---|
2270 | |
---|
2271 | -- |
---|
2272 | -- Dumping data for table `petcreateinfo_spell` |
---|
2273 | -- |
---|
2274 | |
---|
2275 | LOCK TABLES `petcreateinfo_spell` WRITE; |
---|
2276 | /*!40000 ALTER TABLE `petcreateinfo_spell` DISABLE KEYS */; |
---|
2277 | /*!40000 ALTER TABLE `petcreateinfo_spell` ENABLE KEYS */; |
---|
2278 | UNLOCK TABLES; |
---|
2279 | |
---|
2280 | -- |
---|
2281 | -- Table structure for table `pickpocketing_loot_template` |
---|
2282 | -- |
---|
2283 | |
---|
2284 | DROP TABLE IF EXISTS `pickpocketing_loot_template`; |
---|
2285 | CREATE TABLE `pickpocketing_loot_template` ( |
---|
2286 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2287 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
2288 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
2289 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
2290 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
2291 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
2292 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
2293 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
2294 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
2295 | PRIMARY KEY (`entry`,`item`) |
---|
2296 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; |
---|
2297 | |
---|
2298 | -- |
---|
2299 | -- Dumping data for table `pickpocketing_loot_template` |
---|
2300 | -- |
---|
2301 | |
---|
2302 | LOCK TABLES `pickpocketing_loot_template` WRITE; |
---|
2303 | /*!40000 ALTER TABLE `pickpocketing_loot_template` DISABLE KEYS */; |
---|
2304 | /*!40000 ALTER TABLE `pickpocketing_loot_template` ENABLE KEYS */; |
---|
2305 | UNLOCK TABLES; |
---|
2306 | |
---|
2307 | -- |
---|
2308 | -- Table structure for table `player_classlevelstats` |
---|
2309 | -- |
---|
2310 | |
---|
2311 | DROP TABLE IF EXISTS `player_classlevelstats`; |
---|
2312 | CREATE TABLE `player_classlevelstats` ( |
---|
2313 | `class` tinyint(3) unsigned NOT NULL, |
---|
2314 | `level` tinyint(3) unsigned NOT NULL, |
---|
2315 | `basehp` smallint(5) unsigned NOT NULL, |
---|
2316 | `basemana` smallint(5) unsigned NOT NULL, |
---|
2317 | PRIMARY KEY (`class`,`level`) |
---|
2318 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'; |
---|
2319 | |
---|
2320 | -- |
---|
2321 | -- Dumping data for table `player_classlevelstats` |
---|
2322 | -- |
---|
2323 | |
---|
2324 | LOCK TABLES `player_classlevelstats` WRITE; |
---|
2325 | /*!40000 ALTER TABLE `player_classlevelstats` DISABLE KEYS */; |
---|
2326 | /*!40000 ALTER TABLE `player_classlevelstats` ENABLE KEYS */; |
---|
2327 | UNLOCK TABLES; |
---|
2328 | |
---|
2329 | -- |
---|
2330 | -- Table structure for table `player_levelstats` |
---|
2331 | -- |
---|
2332 | |
---|
2333 | DROP TABLE IF EXISTS `player_levelstats`; |
---|
2334 | CREATE TABLE `player_levelstats` ( |
---|
2335 | `race` tinyint(3) unsigned NOT NULL, |
---|
2336 | `class` tinyint(3) unsigned NOT NULL, |
---|
2337 | `level` tinyint(3) unsigned NOT NULL, |
---|
2338 | `str` tinyint(3) unsigned NOT NULL, |
---|
2339 | `agi` tinyint(3) unsigned NOT NULL, |
---|
2340 | `sta` tinyint(3) unsigned NOT NULL, |
---|
2341 | `inte` tinyint(3) unsigned NOT NULL, |
---|
2342 | `spi` tinyint(3) unsigned NOT NULL, |
---|
2343 | PRIMARY KEY (`race`,`class`,`level`) |
---|
2344 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'; |
---|
2345 | |
---|
2346 | -- |
---|
2347 | -- Dumping data for table `player_levelstats` |
---|
2348 | -- |
---|
2349 | |
---|
2350 | LOCK TABLES `player_levelstats` WRITE; |
---|
2351 | /*!40000 ALTER TABLE `player_levelstats` DISABLE KEYS */; |
---|
2352 | /*!40000 ALTER TABLE `player_levelstats` ENABLE KEYS */; |
---|
2353 | UNLOCK TABLES; |
---|
2354 | |
---|
2355 | -- |
---|
2356 | -- Table structure for table `playercreateinfo` |
---|
2357 | -- |
---|
2358 | |
---|
2359 | DROP TABLE IF EXISTS `playercreateinfo`; |
---|
2360 | CREATE TABLE `playercreateinfo` ( |
---|
2361 | `race` tinyint(3) unsigned NOT NULL default '0', |
---|
2362 | `class` tinyint(3) unsigned NOT NULL default '0', |
---|
2363 | `map` smallint(5) unsigned NOT NULL default '0', |
---|
2364 | `zone` mediumint(8) unsigned NOT NULL default '0', |
---|
2365 | `position_x` float NOT NULL default '0', |
---|
2366 | `position_y` float NOT NULL default '0', |
---|
2367 | `position_z` float NOT NULL default '0', |
---|
2368 | PRIMARY KEY (`race`,`class`) |
---|
2369 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2370 | |
---|
2371 | -- |
---|
2372 | -- Dumping data for table `playercreateinfo` |
---|
2373 | -- |
---|
2374 | |
---|
2375 | LOCK TABLES `playercreateinfo` WRITE; |
---|
2376 | /*!40000 ALTER TABLE `playercreateinfo` DISABLE KEYS */; |
---|
2377 | /*!40000 ALTER TABLE `playercreateinfo` ENABLE KEYS */; |
---|
2378 | UNLOCK TABLES; |
---|
2379 | |
---|
2380 | -- |
---|
2381 | -- Table structure for table `playercreateinfo_action` |
---|
2382 | -- |
---|
2383 | |
---|
2384 | DROP TABLE IF EXISTS `playercreateinfo_action`; |
---|
2385 | CREATE TABLE `playercreateinfo_action` ( |
---|
2386 | `race` tinyint(3) unsigned NOT NULL default '0', |
---|
2387 | `class` tinyint(3) unsigned NOT NULL default '0', |
---|
2388 | `button` smallint(5) unsigned NOT NULL default '0', |
---|
2389 | `action` smallint(5) unsigned NOT NULL default '0', |
---|
2390 | `type` smallint(5) unsigned NOT NULL default '0', |
---|
2391 | `misc` smallint(5) unsigned NOT NULL default '0', |
---|
2392 | KEY `playercreateinfo_race_class_index` (`race`,`class`) |
---|
2393 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2394 | |
---|
2395 | -- |
---|
2396 | -- Dumping data for table `playercreateinfo_action` |
---|
2397 | -- |
---|
2398 | |
---|
2399 | LOCK TABLES `playercreateinfo_action` WRITE; |
---|
2400 | /*!40000 ALTER TABLE `playercreateinfo_action` DISABLE KEYS */; |
---|
2401 | /*!40000 ALTER TABLE `playercreateinfo_action` ENABLE KEYS */; |
---|
2402 | UNLOCK TABLES; |
---|
2403 | |
---|
2404 | -- |
---|
2405 | -- Table structure for table `playercreateinfo_item` |
---|
2406 | -- |
---|
2407 | |
---|
2408 | DROP TABLE IF EXISTS `playercreateinfo_item`; |
---|
2409 | CREATE TABLE `playercreateinfo_item` ( |
---|
2410 | `race` tinyint(3) unsigned NOT NULL default '0', |
---|
2411 | `class` tinyint(3) unsigned NOT NULL default '0', |
---|
2412 | `itemid` mediumint(8) unsigned NOT NULL default '0', |
---|
2413 | `amount` tinyint(3) unsigned NOT NULL default '1', |
---|
2414 | KEY `playercreateinfo_race_class_index` (`race`,`class`) |
---|
2415 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2416 | |
---|
2417 | -- |
---|
2418 | -- Dumping data for table `playercreateinfo_item` |
---|
2419 | -- |
---|
2420 | |
---|
2421 | LOCK TABLES `playercreateinfo_item` WRITE; |
---|
2422 | /*!40000 ALTER TABLE `playercreateinfo_item` DISABLE KEYS */; |
---|
2423 | /*!40000 ALTER TABLE `playercreateinfo_item` ENABLE KEYS */; |
---|
2424 | UNLOCK TABLES; |
---|
2425 | |
---|
2426 | -- |
---|
2427 | -- Table structure for table `playercreateinfo_spell` |
---|
2428 | -- |
---|
2429 | |
---|
2430 | DROP TABLE IF EXISTS `playercreateinfo_spell`; |
---|
2431 | CREATE TABLE `playercreateinfo_spell` ( |
---|
2432 | `race` tinyint(3) unsigned NOT NULL default '0', |
---|
2433 | `class` tinyint(3) unsigned NOT NULL default '0', |
---|
2434 | `Spell` mediumint(8) unsigned NOT NULL default '0', |
---|
2435 | `Note` varchar(255) default NULL, |
---|
2436 | `Active` tinyint(3) unsigned NOT NULL default '1', |
---|
2437 | PRIMARY KEY (`race`,`class`,`Spell`) |
---|
2438 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2439 | |
---|
2440 | -- |
---|
2441 | -- Dumping data for table `playercreateinfo_spell` |
---|
2442 | -- |
---|
2443 | |
---|
2444 | LOCK TABLES `playercreateinfo_spell` WRITE; |
---|
2445 | /*!40000 ALTER TABLE `playercreateinfo_spell` DISABLE KEYS */; |
---|
2446 | /*!40000 ALTER TABLE `playercreateinfo_spell` ENABLE KEYS */; |
---|
2447 | UNLOCK TABLES; |
---|
2448 | |
---|
2449 | -- |
---|
2450 | -- Table structure for table `playercreateinfo_spell_custom` |
---|
2451 | -- |
---|
2452 | |
---|
2453 | DROP TABLE IF EXISTS `playercreateinfo_spell_custom`; |
---|
2454 | CREATE TABLE `playercreateinfo_spell_custom` ( |
---|
2455 | `race` tinyint(3) unsigned NOT NULL default '0', |
---|
2456 | `class` tinyint(3) unsigned NOT NULL default '0', |
---|
2457 | `Spell` mediumint(8) unsigned NOT NULL default '0', |
---|
2458 | `Note` varchar(255) default NULL, |
---|
2459 | `Active` tinyint(3) unsigned NOT NULL default '1', |
---|
2460 | PRIMARY KEY (`race`,`class`,`Spell`) |
---|
2461 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2462 | |
---|
2463 | -- |
---|
2464 | -- Dumping data for table `playercreateinfo_spell_custom` |
---|
2465 | -- |
---|
2466 | |
---|
2467 | LOCK TABLES `playercreateinfo_spell_custom` WRITE; |
---|
2468 | /*!40000 ALTER TABLE `playercreateinfo_spell_custom` DISABLE KEYS */; |
---|
2469 | /*!40000 ALTER TABLE `playercreateinfo_spell_custom` ENABLE KEYS */; |
---|
2470 | UNLOCK TABLES; |
---|
2471 | |
---|
2472 | -- |
---|
2473 | -- Table structure for table `prospecting_loot_template` |
---|
2474 | -- |
---|
2475 | |
---|
2476 | DROP TABLE IF EXISTS `prospecting_loot_template`; |
---|
2477 | CREATE TABLE `prospecting_loot_template` ( |
---|
2478 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2479 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
2480 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
2481 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
2482 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
2483 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
2484 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
2485 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
2486 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
2487 | PRIMARY KEY (`entry`,`item`) |
---|
2488 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; |
---|
2489 | |
---|
2490 | -- |
---|
2491 | -- Dumping data for table `prospecting_loot_template` |
---|
2492 | -- |
---|
2493 | |
---|
2494 | LOCK TABLES `prospecting_loot_template` WRITE; |
---|
2495 | /*!40000 ALTER TABLE `prospecting_loot_template` DISABLE KEYS */; |
---|
2496 | /*!40000 ALTER TABLE `prospecting_loot_template` ENABLE KEYS */; |
---|
2497 | UNLOCK TABLES; |
---|
2498 | |
---|
2499 | -- |
---|
2500 | -- Table structure for table `quest_end_scripts` |
---|
2501 | -- |
---|
2502 | |
---|
2503 | DROP TABLE IF EXISTS `quest_end_scripts`; |
---|
2504 | CREATE TABLE `quest_end_scripts` ( |
---|
2505 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
2506 | `delay` int(10) unsigned NOT NULL default '0', |
---|
2507 | `command` mediumint(8) unsigned NOT NULL default '0', |
---|
2508 | `datalong` mediumint(8) unsigned NOT NULL default '0', |
---|
2509 | `datalong2` int(10) unsigned NOT NULL default '0', |
---|
2510 | `datatext` text NOT NULL, |
---|
2511 | `x` float NOT NULL default '0', |
---|
2512 | `y` float NOT NULL default '0', |
---|
2513 | `z` float NOT NULL default '0', |
---|
2514 | `o` float NOT NULL default '0' |
---|
2515 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2516 | |
---|
2517 | -- |
---|
2518 | -- Dumping data for table `quest_end_scripts` |
---|
2519 | -- |
---|
2520 | |
---|
2521 | LOCK TABLES `quest_end_scripts` WRITE; |
---|
2522 | /*!40000 ALTER TABLE `quest_end_scripts` DISABLE KEYS */; |
---|
2523 | /*!40000 ALTER TABLE `quest_end_scripts` ENABLE KEYS */; |
---|
2524 | UNLOCK TABLES; |
---|
2525 | |
---|
2526 | -- |
---|
2527 | -- Table structure for table `quest_mail_loot_template` |
---|
2528 | -- |
---|
2529 | |
---|
2530 | DROP TABLE IF EXISTS `quest_mail_loot_template`; |
---|
2531 | CREATE TABLE `quest_mail_loot_template` ( |
---|
2532 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2533 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
2534 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
2535 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
2536 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
2537 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
2538 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
2539 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
2540 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
2541 | PRIMARY KEY (`entry`,`item`) |
---|
2542 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; |
---|
2543 | |
---|
2544 | -- |
---|
2545 | -- Dumping data for table `quest_mail_loot_template` |
---|
2546 | -- |
---|
2547 | |
---|
2548 | LOCK TABLES `quest_mail_loot_template` WRITE; |
---|
2549 | /*!40000 ALTER TABLE `quest_mail_loot_template` DISABLE KEYS */; |
---|
2550 | /*!40000 ALTER TABLE `quest_mail_loot_template` ENABLE KEYS */; |
---|
2551 | UNLOCK TABLES; |
---|
2552 | |
---|
2553 | -- |
---|
2554 | -- Table structure for table `quest_start_scripts` |
---|
2555 | -- |
---|
2556 | |
---|
2557 | DROP TABLE IF EXISTS `quest_start_scripts`; |
---|
2558 | CREATE TABLE `quest_start_scripts` ( |
---|
2559 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
2560 | `delay` int(10) unsigned NOT NULL default '0', |
---|
2561 | `command` mediumint(8) unsigned NOT NULL default '0', |
---|
2562 | `datalong` mediumint(8) unsigned NOT NULL default '0', |
---|
2563 | `datalong2` int(10) unsigned NOT NULL default '0', |
---|
2564 | `datatext` text NOT NULL, |
---|
2565 | `x` float NOT NULL default '0', |
---|
2566 | `y` float NOT NULL default '0', |
---|
2567 | `z` float NOT NULL default '0', |
---|
2568 | `o` float NOT NULL default '0' |
---|
2569 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2570 | |
---|
2571 | -- |
---|
2572 | -- Dumping data for table `quest_start_scripts` |
---|
2573 | -- |
---|
2574 | |
---|
2575 | LOCK TABLES `quest_start_scripts` WRITE; |
---|
2576 | /*!40000 ALTER TABLE `quest_start_scripts` DISABLE KEYS */; |
---|
2577 | /*!40000 ALTER TABLE `quest_start_scripts` ENABLE KEYS */; |
---|
2578 | UNLOCK TABLES; |
---|
2579 | |
---|
2580 | -- |
---|
2581 | -- Table structure for table `quest_template` |
---|
2582 | -- |
---|
2583 | |
---|
2584 | DROP TABLE IF EXISTS `quest_template`; |
---|
2585 | CREATE TABLE `quest_template` ( |
---|
2586 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2587 | `Method` tinyint(3) unsigned NOT NULL default '2', |
---|
2588 | `ZoneOrSort` smallint(6) NOT NULL default '0', |
---|
2589 | `SkillOrClass` smallint(6) NOT NULL default '0', |
---|
2590 | `MinLevel` tinyint(3) unsigned NOT NULL default '0', |
---|
2591 | `QuestLevel` tinyint(3) unsigned NOT NULL default '0', |
---|
2592 | `Type` smallint(5) unsigned NOT NULL default '0', |
---|
2593 | `RequiredRaces` smallint(5) unsigned NOT NULL default '0', |
---|
2594 | `RequiredSkillValue` smallint(5) unsigned NOT NULL default '0', |
---|
2595 | `RepObjectiveFaction` smallint(5) unsigned NOT NULL default '0', |
---|
2596 | `RepObjectiveValue` mediumint(9) NOT NULL default '0', |
---|
2597 | `RequiredMinRepFaction` smallint(5) unsigned NOT NULL default '0', |
---|
2598 | `RequiredMinRepValue` mediumint(9) NOT NULL default '0', |
---|
2599 | `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL default '0', |
---|
2600 | `RequiredMaxRepValue` mediumint(9) NOT NULL default '0', |
---|
2601 | `SuggestedPlayers` tinyint(3) unsigned NOT NULL default '0', |
---|
2602 | `LimitTime` int(10) unsigned NOT NULL default '0', |
---|
2603 | `QuestFlags` smallint(5) unsigned NOT NULL default '0', |
---|
2604 | `SpecialFlags` tinyint(3) unsigned NOT NULL default '0', |
---|
2605 | `CharTitleId` tinyint(3) unsigned NOT NULL default '0', |
---|
2606 | `PrevQuestId` mediumint(9) NOT NULL default '0', |
---|
2607 | `NextQuestId` mediumint(9) NOT NULL default '0', |
---|
2608 | `ExclusiveGroup` mediumint(9) NOT NULL default '0', |
---|
2609 | `NextQuestInChain` mediumint(8) unsigned NOT NULL default '0', |
---|
2610 | `SrcItemId` mediumint(8) unsigned NOT NULL default '0', |
---|
2611 | `SrcItemCount` tinyint(3) unsigned NOT NULL default '0', |
---|
2612 | `SrcSpell` mediumint(8) unsigned NOT NULL default '0', |
---|
2613 | `Title` text, |
---|
2614 | `Details` text, |
---|
2615 | `Objectives` text, |
---|
2616 | `OfferRewardText` text, |
---|
2617 | `RequestItemsText` text, |
---|
2618 | `EndText` text, |
---|
2619 | `ObjectiveText1` text, |
---|
2620 | `ObjectiveText2` text, |
---|
2621 | `ObjectiveText3` text, |
---|
2622 | `ObjectiveText4` text, |
---|
2623 | `ReqItemId1` mediumint(8) unsigned NOT NULL default '0', |
---|
2624 | `ReqItemId2` mediumint(8) unsigned NOT NULL default '0', |
---|
2625 | `ReqItemId3` mediumint(8) unsigned NOT NULL default '0', |
---|
2626 | `ReqItemId4` mediumint(8) unsigned NOT NULL default '0', |
---|
2627 | `ReqItemCount1` smallint(5) unsigned NOT NULL default '0', |
---|
2628 | `ReqItemCount2` smallint(5) unsigned NOT NULL default '0', |
---|
2629 | `ReqItemCount3` smallint(5) unsigned NOT NULL default '0', |
---|
2630 | `ReqItemCount4` smallint(5) unsigned NOT NULL default '0', |
---|
2631 | `ReqSourceId1` mediumint(8) unsigned NOT NULL default '0', |
---|
2632 | `ReqSourceId2` mediumint(8) unsigned NOT NULL default '0', |
---|
2633 | `ReqSourceId3` mediumint(8) unsigned NOT NULL default '0', |
---|
2634 | `ReqSourceId4` mediumint(8) unsigned NOT NULL default '0', |
---|
2635 | `ReqSourceCount1` smallint(5) unsigned NOT NULL default '0', |
---|
2636 | `ReqSourceCount2` smallint(5) unsigned NOT NULL default '0', |
---|
2637 | `ReqSourceCount3` smallint(5) unsigned NOT NULL default '0', |
---|
2638 | `ReqSourceCount4` smallint(5) unsigned NOT NULL default '0', |
---|
2639 | `ReqSourceRef1` tinyint(3) unsigned NOT NULL default '0', |
---|
2640 | `ReqSourceRef2` tinyint(3) unsigned NOT NULL default '0', |
---|
2641 | `ReqSourceRef3` tinyint(3) unsigned NOT NULL default '0', |
---|
2642 | `ReqSourceRef4` tinyint(3) unsigned NOT NULL default '0', |
---|
2643 | `ReqCreatureOrGOId1` mediumint(9) NOT NULL default '0', |
---|
2644 | `ReqCreatureOrGOId2` mediumint(9) NOT NULL default '0', |
---|
2645 | `ReqCreatureOrGOId3` mediumint(9) NOT NULL default '0', |
---|
2646 | `ReqCreatureOrGOId4` mediumint(9) NOT NULL default '0', |
---|
2647 | `ReqCreatureOrGOCount1` smallint(5) unsigned NOT NULL default '0', |
---|
2648 | `ReqCreatureOrGOCount2` smallint(5) unsigned NOT NULL default '0', |
---|
2649 | `ReqCreatureOrGOCount3` smallint(5) unsigned NOT NULL default '0', |
---|
2650 | `ReqCreatureOrGOCount4` smallint(5) unsigned NOT NULL default '0', |
---|
2651 | `ReqSpellCast1` mediumint(8) unsigned NOT NULL default '0', |
---|
2652 | `ReqSpellCast2` mediumint(8) unsigned NOT NULL default '0', |
---|
2653 | `ReqSpellCast3` mediumint(8) unsigned NOT NULL default '0', |
---|
2654 | `ReqSpellCast4` mediumint(8) unsigned NOT NULL default '0', |
---|
2655 | `RewChoiceItemId1` mediumint(8) unsigned NOT NULL default '0', |
---|
2656 | `RewChoiceItemId2` mediumint(8) unsigned NOT NULL default '0', |
---|
2657 | `RewChoiceItemId3` mediumint(8) unsigned NOT NULL default '0', |
---|
2658 | `RewChoiceItemId4` mediumint(8) unsigned NOT NULL default '0', |
---|
2659 | `RewChoiceItemId5` mediumint(8) unsigned NOT NULL default '0', |
---|
2660 | `RewChoiceItemId6` mediumint(8) unsigned NOT NULL default '0', |
---|
2661 | `RewChoiceItemCount1` smallint(5) unsigned NOT NULL default '0', |
---|
2662 | `RewChoiceItemCount2` smallint(5) unsigned NOT NULL default '0', |
---|
2663 | `RewChoiceItemCount3` smallint(5) unsigned NOT NULL default '0', |
---|
2664 | `RewChoiceItemCount4` smallint(5) unsigned NOT NULL default '0', |
---|
2665 | `RewChoiceItemCount5` smallint(5) unsigned NOT NULL default '0', |
---|
2666 | `RewChoiceItemCount6` smallint(5) unsigned NOT NULL default '0', |
---|
2667 | `RewItemId1` mediumint(8) unsigned NOT NULL default '0', |
---|
2668 | `RewItemId2` mediumint(8) unsigned NOT NULL default '0', |
---|
2669 | `RewItemId3` mediumint(8) unsigned NOT NULL default '0', |
---|
2670 | `RewItemId4` mediumint(8) unsigned NOT NULL default '0', |
---|
2671 | `RewItemCount1` smallint(5) unsigned NOT NULL default '0', |
---|
2672 | `RewItemCount2` smallint(5) unsigned NOT NULL default '0', |
---|
2673 | `RewItemCount3` smallint(5) unsigned NOT NULL default '0', |
---|
2674 | `RewItemCount4` smallint(5) unsigned NOT NULL default '0', |
---|
2675 | `RewRepFaction1` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case', |
---|
2676 | `RewRepFaction2` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case', |
---|
2677 | `RewRepFaction3` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case', |
---|
2678 | `RewRepFaction4` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case', |
---|
2679 | `RewRepFaction5` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case', |
---|
2680 | `RewRepValue1` mediumint(9) NOT NULL default '0', |
---|
2681 | `RewRepValue2` mediumint(9) NOT NULL default '0', |
---|
2682 | `RewRepValue3` mediumint(9) NOT NULL default '0', |
---|
2683 | `RewRepValue4` mediumint(9) NOT NULL default '0', |
---|
2684 | `RewRepValue5` mediumint(9) NOT NULL default '0', |
---|
2685 | `RewOrReqMoney` int(11) NOT NULL default '0', |
---|
2686 | `RewMoneyMaxLevel` int(10) unsigned NOT NULL default '0', |
---|
2687 | `RewSpell` mediumint(8) unsigned NOT NULL default '0', |
---|
2688 | `RewSpellCast` mediumint(8) unsigned NOT NULL default '0', |
---|
2689 | `RewMailTemplateId` mediumint(8) unsigned NOT NULL default '0', |
---|
2690 | `RewMailDelaySecs` int(11) unsigned NOT NULL default '0', |
---|
2691 | `PointMapId` smallint(5) unsigned NOT NULL default '0', |
---|
2692 | `PointX` float NOT NULL default '0', |
---|
2693 | `PointY` float NOT NULL default '0', |
---|
2694 | `PointOpt` mediumint(8) unsigned NOT NULL default '0', |
---|
2695 | `DetailsEmote1` smallint(5) unsigned NOT NULL default '0', |
---|
2696 | `DetailsEmote2` smallint(5) unsigned NOT NULL default '0', |
---|
2697 | `DetailsEmote3` smallint(5) unsigned NOT NULL default '0', |
---|
2698 | `DetailsEmote4` smallint(5) unsigned NOT NULL default '0', |
---|
2699 | `IncompleteEmote` smallint(5) unsigned NOT NULL default '0', |
---|
2700 | `CompleteEmote` smallint(5) unsigned NOT NULL default '0', |
---|
2701 | `OfferRewardEmote1` smallint(5) unsigned NOT NULL default '0', |
---|
2702 | `OfferRewardEmote2` smallint(5) unsigned NOT NULL default '0', |
---|
2703 | `OfferRewardEmote3` smallint(5) unsigned NOT NULL default '0', |
---|
2704 | `OfferRewardEmote4` smallint(5) unsigned NOT NULL default '0', |
---|
2705 | `StartScript` mediumint(8) unsigned NOT NULL default '0', |
---|
2706 | `CompleteScript` mediumint(8) unsigned NOT NULL default '0', |
---|
2707 | PRIMARY KEY (`entry`) |
---|
2708 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System'; |
---|
2709 | |
---|
2710 | -- |
---|
2711 | -- Dumping data for table `quest_template` |
---|
2712 | -- |
---|
2713 | |
---|
2714 | LOCK TABLES `quest_template` WRITE; |
---|
2715 | /*!40000 ALTER TABLE `quest_template` DISABLE KEYS */; |
---|
2716 | /*!40000 ALTER TABLE `quest_template` ENABLE KEYS */; |
---|
2717 | UNLOCK TABLES; |
---|
2718 | |
---|
2719 | -- |
---|
2720 | -- Table structure for table `reference_loot_template` |
---|
2721 | -- |
---|
2722 | |
---|
2723 | DROP TABLE IF EXISTS `reference_loot_template`; |
---|
2724 | CREATE TABLE `reference_loot_template` ( |
---|
2725 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2726 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
2727 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
2728 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
2729 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
2730 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
2731 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
2732 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
2733 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
2734 | PRIMARY KEY (`entry`,`item`) |
---|
2735 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; |
---|
2736 | |
---|
2737 | -- |
---|
2738 | -- Dumping data for table `reference_loot_template` |
---|
2739 | -- |
---|
2740 | |
---|
2741 | LOCK TABLES `reference_loot_template` WRITE; |
---|
2742 | /*!40000 ALTER TABLE `reference_loot_template` DISABLE KEYS */; |
---|
2743 | /*!40000 ALTER TABLE `reference_loot_template` ENABLE KEYS */; |
---|
2744 | UNLOCK TABLES; |
---|
2745 | |
---|
2746 | -- |
---|
2747 | -- Table structure for table `reserved_name` |
---|
2748 | -- |
---|
2749 | |
---|
2750 | DROP TABLE IF EXISTS `reserved_name`; |
---|
2751 | CREATE TABLE `reserved_name` ( |
---|
2752 | `name` varchar(12) NOT NULL default '', |
---|
2753 | PRIMARY KEY (`name`) |
---|
2754 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player Reserved Names'; |
---|
2755 | |
---|
2756 | -- |
---|
2757 | -- Dumping data for table `reserved_name` |
---|
2758 | -- |
---|
2759 | |
---|
2760 | LOCK TABLES `reserved_name` WRITE; |
---|
2761 | /*!40000 ALTER TABLE `reserved_name` DISABLE KEYS */; |
---|
2762 | /*!40000 ALTER TABLE `reserved_name` ENABLE KEYS */; |
---|
2763 | UNLOCK TABLES; |
---|
2764 | |
---|
2765 | -- |
---|
2766 | -- Table structure for table `script_db_version` |
---|
2767 | -- |
---|
2768 | |
---|
2769 | DROP TABLE IF EXISTS `script_db_version`; |
---|
2770 | CREATE TABLE `script_db_version` ( |
---|
2771 | `version` varchar(255) NOT NULL default '' COMMENT 'Database version string' |
---|
2772 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2773 | |
---|
2774 | -- |
---|
2775 | -- Dumping data for table `script_db_version` |
---|
2776 | -- |
---|
2777 | |
---|
2778 | LOCK TABLES `script_db_version` WRITE; |
---|
2779 | /*!40000 ALTER TABLE `script_db_version` DISABLE KEYS */; |
---|
2780 | /*!40000 ALTER TABLE `script_db_version` ENABLE KEYS */; |
---|
2781 | UNLOCK TABLES; |
---|
2782 | |
---|
2783 | -- |
---|
2784 | -- Table structure for table `script_texts` |
---|
2785 | -- |
---|
2786 | |
---|
2787 | DROP TABLE IF EXISTS `script_texts`; |
---|
2788 | CREATE TABLE `script_texts` ( |
---|
2789 | `entry` mediumint(8) NOT NULL, |
---|
2790 | `content_default` text NOT NULL, |
---|
2791 | `content_loc1` text, |
---|
2792 | `content_loc2` text, |
---|
2793 | `content_loc3` text, |
---|
2794 | `content_loc4` text, |
---|
2795 | `content_loc5` text, |
---|
2796 | `content_loc6` text, |
---|
2797 | `content_loc7` text, |
---|
2798 | `content_loc8` text, |
---|
2799 | `sound` tinyint(3) unsigned NOT NULL default '0', |
---|
2800 | `type` tinyint(3) unsigned NOT NULL default '0', |
---|
2801 | `language` tinyint(3) unsigned NOT NULL default '0', |
---|
2802 | `comment` text, |
---|
2803 | PRIMARY KEY (`entry`) |
---|
2804 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; |
---|
2805 | |
---|
2806 | -- |
---|
2807 | -- Dumping data for table `script_texts` |
---|
2808 | -- |
---|
2809 | |
---|
2810 | LOCK TABLES `script_texts` WRITE; |
---|
2811 | /*!40000 ALTER TABLE `script_texts` DISABLE KEYS */; |
---|
2812 | /*!40000 ALTER TABLE `script_texts` ENABLE KEYS */; |
---|
2813 | UNLOCK TABLES; |
---|
2814 | |
---|
2815 | -- |
---|
2816 | -- Table structure for table `skill_discovery_template` |
---|
2817 | -- |
---|
2818 | |
---|
2819 | DROP TABLE IF EXISTS `skill_discovery_template`; |
---|
2820 | CREATE TABLE `skill_discovery_template` ( |
---|
2821 | `spellId` mediumint(8) unsigned NOT NULL default '0' COMMENT 'SpellId of the discoverable spell', |
---|
2822 | `reqSpell` mediumint(8) unsigned NOT NULL default '0' COMMENT 'spell requirement', |
---|
2823 | `chance` float NOT NULL default '0' COMMENT 'chance to discover', |
---|
2824 | PRIMARY KEY (`spellId`) |
---|
2825 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Discovery System'; |
---|
2826 | |
---|
2827 | -- |
---|
2828 | -- Dumping data for table `skill_discovery_template` |
---|
2829 | -- |
---|
2830 | |
---|
2831 | LOCK TABLES `skill_discovery_template` WRITE; |
---|
2832 | /*!40000 ALTER TABLE `skill_discovery_template` DISABLE KEYS */; |
---|
2833 | /*!40000 ALTER TABLE `skill_discovery_template` ENABLE KEYS */; |
---|
2834 | UNLOCK TABLES; |
---|
2835 | |
---|
2836 | -- |
---|
2837 | -- Table structure for table `skill_extra_item_template` |
---|
2838 | -- |
---|
2839 | |
---|
2840 | DROP TABLE IF EXISTS `skill_extra_item_template`; |
---|
2841 | CREATE TABLE `skill_extra_item_template` ( |
---|
2842 | `spellId` mediumint(8) unsigned NOT NULL default '0' COMMENT 'SpellId of the item creation spell', |
---|
2843 | `requiredSpecialization` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Specialization spell id', |
---|
2844 | `additionalCreateChance` float NOT NULL default '0' COMMENT 'chance to create add', |
---|
2845 | `additionalMaxNum` tinyint(3) unsigned NOT NULL default '0' COMMENT 'max num of adds', |
---|
2846 | PRIMARY KEY (`spellId`) |
---|
2847 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Specialization System'; |
---|
2848 | |
---|
2849 | -- |
---|
2850 | -- Dumping data for table `skill_extra_item_template` |
---|
2851 | -- |
---|
2852 | |
---|
2853 | LOCK TABLES `skill_extra_item_template` WRITE; |
---|
2854 | /*!40000 ALTER TABLE `skill_extra_item_template` DISABLE KEYS */; |
---|
2855 | /*!40000 ALTER TABLE `skill_extra_item_template` ENABLE KEYS */; |
---|
2856 | UNLOCK TABLES; |
---|
2857 | |
---|
2858 | -- |
---|
2859 | -- Table structure for table `skill_fishing_base_level` |
---|
2860 | -- |
---|
2861 | |
---|
2862 | DROP TABLE IF EXISTS `skill_fishing_base_level`; |
---|
2863 | CREATE TABLE `skill_fishing_base_level` ( |
---|
2864 | `entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Area identifier', |
---|
2865 | `skill` smallint(6) NOT NULL default '0' COMMENT 'Base skill level requirement', |
---|
2866 | PRIMARY KEY (`entry`) |
---|
2867 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Fishing system'; |
---|
2868 | |
---|
2869 | -- |
---|
2870 | -- Dumping data for table `skill_fishing_base_level` |
---|
2871 | -- |
---|
2872 | |
---|
2873 | LOCK TABLES `skill_fishing_base_level` WRITE; |
---|
2874 | /*!40000 ALTER TABLE `skill_fishing_base_level` DISABLE KEYS */; |
---|
2875 | /*!40000 ALTER TABLE `skill_fishing_base_level` ENABLE KEYS */; |
---|
2876 | UNLOCK TABLES; |
---|
2877 | |
---|
2878 | -- |
---|
2879 | -- Table structure for table `skinning_loot_template` |
---|
2880 | -- |
---|
2881 | |
---|
2882 | DROP TABLE IF EXISTS `skinning_loot_template`; |
---|
2883 | CREATE TABLE `skinning_loot_template` ( |
---|
2884 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
2885 | `item` mediumint(8) unsigned NOT NULL default '0', |
---|
2886 | `ChanceOrQuestChance` float NOT NULL default '100', |
---|
2887 | `groupid` tinyint(3) unsigned NOT NULL default '0', |
---|
2888 | `mincountOrRef` mediumint(9) NOT NULL default '1', |
---|
2889 | `maxcount` tinyint(3) unsigned NOT NULL default '1', |
---|
2890 | `lootcondition` tinyint(3) unsigned NOT NULL default '0', |
---|
2891 | `condition_value1` mediumint(8) unsigned NOT NULL default '0', |
---|
2892 | `condition_value2` mediumint(8) unsigned NOT NULL default '0', |
---|
2893 | PRIMARY KEY (`entry`,`item`) |
---|
2894 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; |
---|
2895 | |
---|
2896 | -- |
---|
2897 | -- Dumping data for table `skinning_loot_template` |
---|
2898 | -- |
---|
2899 | |
---|
2900 | LOCK TABLES `skinning_loot_template` WRITE; |
---|
2901 | /*!40000 ALTER TABLE `skinning_loot_template` DISABLE KEYS */; |
---|
2902 | /*!40000 ALTER TABLE `skinning_loot_template` ENABLE KEYS */; |
---|
2903 | UNLOCK TABLES; |
---|
2904 | |
---|
2905 | -- |
---|
2906 | -- Table structure for table `spell_affect` |
---|
2907 | -- |
---|
2908 | |
---|
2909 | DROP TABLE IF EXISTS `spell_affect`; |
---|
2910 | CREATE TABLE `spell_affect` ( |
---|
2911 | `entry` smallint(5) unsigned NOT NULL default '0', |
---|
2912 | `effectId` tinyint(3) unsigned NOT NULL default '0', |
---|
2913 | `SpellFamilyMask` bigint(20) unsigned NOT NULL default '0', |
---|
2914 | PRIMARY KEY (`entry`,`effectId`) |
---|
2915 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
2916 | |
---|
2917 | -- |
---|
2918 | -- Dumping data for table `spell_affect` |
---|
2919 | -- |
---|
2920 | |
---|
2921 | LOCK TABLES `spell_affect` WRITE; |
---|
2922 | /*!40000 ALTER TABLE `spell_affect` DISABLE KEYS */; |
---|
2923 | /*!40000 ALTER TABLE `spell_affect` ENABLE KEYS */; |
---|
2924 | UNLOCK TABLES; |
---|
2925 | |
---|
2926 | -- |
---|
2927 | -- Table structure for table `spell_chain` |
---|
2928 | -- |
---|
2929 | |
---|
2930 | DROP TABLE IF EXISTS `spell_chain`; |
---|
2931 | CREATE TABLE `spell_chain` ( |
---|
2932 | `spell_id` mediumint(9) NOT NULL default '0', |
---|
2933 | `prev_spell` mediumint(9) NOT NULL default '0', |
---|
2934 | `first_spell` mediumint(9) NOT NULL default '0', |
---|
2935 | `rank` tinyint(4) NOT NULL default '0', |
---|
2936 | `req_spell` mediumint(9) NOT NULL default '0', |
---|
2937 | PRIMARY KEY (`spell_id`) |
---|
2938 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Additinal Data'; |
---|
2939 | |
---|
2940 | -- |
---|
2941 | -- Dumping data for table `spell_chain` |
---|
2942 | -- |
---|
2943 | |
---|
2944 | LOCK TABLES `spell_chain` WRITE; |
---|
2945 | /*!40000 ALTER TABLE `spell_chain` DISABLE KEYS */; |
---|
2946 | /*!40000 ALTER TABLE `spell_chain` ENABLE KEYS */; |
---|
2947 | UNLOCK TABLES; |
---|
2948 | |
---|
2949 | -- |
---|
2950 | -- Table structure for table `spell_disabled` |
---|
2951 | -- |
---|
2952 | |
---|
2953 | DROP TABLE IF EXISTS `spell_disabled`; |
---|
2954 | CREATE TABLE `spell_disabled` ( |
---|
2955 | `entry` int(11) unsigned NOT NULL default '0' COMMENT 'Spell entry', |
---|
2956 | `disable_mask` int(8) unsigned NOT NULL default '0', |
---|
2957 | `comment` varchar(64) NOT NULL default '', |
---|
2958 | PRIMARY KEY (`entry`) |
---|
2959 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Disabled Spell System'; |
---|
2960 | |
---|
2961 | -- |
---|
2962 | -- Dumping data for table `spell_disabled` |
---|
2963 | -- |
---|
2964 | |
---|
2965 | LOCK TABLES `spell_disabled` WRITE; |
---|
2966 | /*!40000 ALTER TABLE `spell_disabled` DISABLE KEYS */; |
---|
2967 | /*!40000 ALTER TABLE `spell_disabled` ENABLE KEYS */; |
---|
2968 | UNLOCK TABLES; |
---|
2969 | |
---|
2970 | -- |
---|
2971 | -- Table structure for table `spell_elixir` |
---|
2972 | -- |
---|
2973 | |
---|
2974 | DROP TABLE IF EXISTS `spell_elixir`; |
---|
2975 | CREATE TABLE `spell_elixir` ( |
---|
2976 | `entry` int(11) unsigned NOT NULL default '0' COMMENT 'SpellId of potion', |
---|
2977 | `mask` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Mask 0x1 battle 0x2 guardian 0x3 flask 0x7 unstable flasks 0xB shattrath flasks', |
---|
2978 | PRIMARY KEY (`entry`) |
---|
2979 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System'; |
---|
2980 | |
---|
2981 | -- |
---|
2982 | -- Dumping data for table `spell_elixir` |
---|
2983 | -- |
---|
2984 | |
---|
2985 | LOCK TABLES `spell_elixir` WRITE; |
---|
2986 | /*!40000 ALTER TABLE `spell_elixir` DISABLE KEYS */; |
---|
2987 | /*!40000 ALTER TABLE `spell_elixir` ENABLE KEYS */; |
---|
2988 | UNLOCK TABLES; |
---|
2989 | |
---|
2990 | -- |
---|
2991 | -- Table structure for table `spell_learn_spell` |
---|
2992 | -- |
---|
2993 | |
---|
2994 | DROP TABLE IF EXISTS `spell_learn_spell`; |
---|
2995 | CREATE TABLE `spell_learn_spell` ( |
---|
2996 | `entry` smallint(5) unsigned NOT NULL default '0', |
---|
2997 | `SpellID` smallint(5) unsigned NOT NULL default '0', |
---|
2998 | PRIMARY KEY (`entry`,`SpellID`) |
---|
2999 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; |
---|
3000 | |
---|
3001 | -- |
---|
3002 | -- Dumping data for table `spell_learn_spell` |
---|
3003 | -- |
---|
3004 | |
---|
3005 | LOCK TABLES `spell_learn_spell` WRITE; |
---|
3006 | /*!40000 ALTER TABLE `spell_learn_spell` DISABLE KEYS */; |
---|
3007 | /*!40000 ALTER TABLE `spell_learn_spell` ENABLE KEYS */; |
---|
3008 | UNLOCK TABLES; |
---|
3009 | |
---|
3010 | -- |
---|
3011 | -- Table structure for table `spell_pet_auras` |
---|
3012 | -- |
---|
3013 | |
---|
3014 | DROP TABLE IF EXISTS `spell_pet_auras`; |
---|
3015 | CREATE TABLE `spell_pet_auras` ( |
---|
3016 | `spell` mediumint(8) unsigned NOT NULL COMMENT 'dummy spell id', |
---|
3017 | `pet` mediumint(8) unsigned NOT NULL default '0' COMMENT 'pet id; 0 = all', |
---|
3018 | `aura` mediumint(8) unsigned NOT NULL COMMENT 'pet aura id', |
---|
3019 | PRIMARY KEY (`spell`,`pet`) |
---|
3020 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
---|
3021 | |
---|
3022 | -- |
---|
3023 | -- Dumping data for table `spell_pet_auras` |
---|
3024 | -- |
---|
3025 | |
---|
3026 | LOCK TABLES `spell_pet_auras` WRITE; |
---|
3027 | /*!40000 ALTER TABLE `spell_pet_auras` DISABLE KEYS */; |
---|
3028 | /*!40000 ALTER TABLE `spell_pet_auras` ENABLE KEYS */; |
---|
3029 | UNLOCK TABLES; |
---|
3030 | |
---|
3031 | -- |
---|
3032 | -- Table structure for table `spell_proc_event` |
---|
3033 | -- |
---|
3034 | |
---|
3035 | DROP TABLE IF EXISTS `spell_proc_event`; |
---|
3036 | CREATE TABLE `spell_proc_event` ( |
---|
3037 | `entry` smallint(5) unsigned NOT NULL default '0', |
---|
3038 | `SchoolMask` tinyint(4) NOT NULL default '0', |
---|
3039 | `Category` smallint(6) NOT NULL default '0', |
---|
3040 | `SkillID` smallint(6) NOT NULL default '0', |
---|
3041 | `SpellFamilyName` smallint(5) unsigned NOT NULL default '0', |
---|
3042 | `SpellFamilyMask` bigint(20) unsigned NOT NULL default '0', |
---|
3043 | `procFlags` int(10) unsigned NOT NULL default '0', |
---|
3044 | `ppmRate` float NOT NULL default '0', |
---|
3045 | `cooldown` int(10) unsigned NOT NULL default '0', |
---|
3046 | PRIMARY KEY (`entry`) |
---|
3047 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
3048 | |
---|
3049 | -- |
---|
3050 | -- Dumping data for table `spell_proc_event` |
---|
3051 | -- |
---|
3052 | |
---|
3053 | LOCK TABLES `spell_proc_event` WRITE; |
---|
3054 | /*!40000 ALTER TABLE `spell_proc_event` DISABLE KEYS */; |
---|
3055 | /*!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS */; |
---|
3056 | UNLOCK TABLES; |
---|
3057 | |
---|
3058 | -- |
---|
3059 | -- Table structure for table `spell_script_target` |
---|
3060 | -- |
---|
3061 | |
---|
3062 | DROP TABLE IF EXISTS `spell_script_target`; |
---|
3063 | CREATE TABLE `spell_script_target` ( |
---|
3064 | `entry` mediumint(8) unsigned NOT NULL, |
---|
3065 | `type` tinyint(3) unsigned NOT NULL default '0', |
---|
3066 | `targetEntry` mediumint(8) unsigned NOT NULL default '0', |
---|
3067 | UNIQUE KEY `entry_type_target` (`entry`,`type`,`targetEntry`) |
---|
3068 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Spell System'; |
---|
3069 | |
---|
3070 | -- |
---|
3071 | -- Dumping data for table `spell_script_target` |
---|
3072 | -- |
---|
3073 | |
---|
3074 | LOCK TABLES `spell_script_target` WRITE; |
---|
3075 | /*!40000 ALTER TABLE `spell_script_target` DISABLE KEYS */; |
---|
3076 | /*!40000 ALTER TABLE `spell_script_target` ENABLE KEYS */; |
---|
3077 | UNLOCK TABLES; |
---|
3078 | |
---|
3079 | -- |
---|
3080 | -- Table structure for table `spell_scripts` |
---|
3081 | -- |
---|
3082 | |
---|
3083 | DROP TABLE IF EXISTS `spell_scripts`; |
---|
3084 | CREATE TABLE `spell_scripts` ( |
---|
3085 | `id` mediumint(8) unsigned NOT NULL default '0', |
---|
3086 | `delay` int(10) unsigned NOT NULL default '0', |
---|
3087 | `command` mediumint(8) unsigned NOT NULL default '0', |
---|
3088 | `datalong` mediumint(8) unsigned NOT NULL default '0', |
---|
3089 | `datalong2` int(10) unsigned NOT NULL default '0', |
---|
3090 | `datatext` text character set latin1 NOT NULL, |
---|
3091 | `x` float NOT NULL default '0', |
---|
3092 | `y` float NOT NULL default '0', |
---|
3093 | `z` float NOT NULL default '0', |
---|
3094 | `o` float NOT NULL default '0' |
---|
3095 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
3096 | |
---|
3097 | -- |
---|
3098 | -- Dumping data for table `spell_scripts` |
---|
3099 | -- |
---|
3100 | |
---|
3101 | LOCK TABLES `spell_scripts` WRITE; |
---|
3102 | /*!40000 ALTER TABLE `spell_scripts` DISABLE KEYS */; |
---|
3103 | /*!40000 ALTER TABLE `spell_scripts` ENABLE KEYS */; |
---|
3104 | UNLOCK TABLES; |
---|
3105 | |
---|
3106 | -- |
---|
3107 | -- Table structure for table `spell_target_position` |
---|
3108 | -- |
---|
3109 | |
---|
3110 | DROP TABLE IF EXISTS `spell_target_position`; |
---|
3111 | CREATE TABLE `spell_target_position` ( |
---|
3112 | `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier', |
---|
3113 | `target_map` smallint(5) unsigned NOT NULL default '0', |
---|
3114 | `target_position_x` float NOT NULL default '0', |
---|
3115 | `target_position_y` float NOT NULL default '0', |
---|
3116 | `target_position_z` float NOT NULL default '0', |
---|
3117 | `target_orientation` float NOT NULL default '0', |
---|
3118 | PRIMARY KEY (`id`) |
---|
3119 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System'; |
---|
3120 | |
---|
3121 | -- |
---|
3122 | -- Dumping data for table `spell_target_position` |
---|
3123 | -- |
---|
3124 | |
---|
3125 | LOCK TABLES `spell_target_position` WRITE; |
---|
3126 | /*!40000 ALTER TABLE `spell_target_position` DISABLE KEYS */; |
---|
3127 | /*!40000 ALTER TABLE `spell_target_position` ENABLE KEYS */; |
---|
3128 | UNLOCK TABLES; |
---|
3129 | |
---|
3130 | -- |
---|
3131 | -- Table structure for table `spell_threat` |
---|
3132 | -- |
---|
3133 | |
---|
3134 | DROP TABLE IF EXISTS `spell_threat`; |
---|
3135 | CREATE TABLE `spell_threat` ( |
---|
3136 | `entry` mediumint(8) unsigned NOT NULL, |
---|
3137 | `Threat` smallint(6) NOT NULL, |
---|
3138 | PRIMARY KEY (`entry`) |
---|
3139 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; |
---|
3140 | |
---|
3141 | -- |
---|
3142 | -- Dumping data for table `spell_threat` |
---|
3143 | -- |
---|
3144 | |
---|
3145 | LOCK TABLES `spell_threat` WRITE; |
---|
3146 | /*!40000 ALTER TABLE `spell_threat` DISABLE KEYS */; |
---|
3147 | /*!40000 ALTER TABLE `spell_threat` ENABLE KEYS */; |
---|
3148 | UNLOCK TABLES; |
---|
3149 | |
---|
3150 | -- |
---|
3151 | -- Table structure for table `transports` |
---|
3152 | -- |
---|
3153 | |
---|
3154 | DROP TABLE IF EXISTS `transports`; |
---|
3155 | CREATE TABLE `transports` ( |
---|
3156 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
3157 | `name` text, |
---|
3158 | `period` mediumint(8) unsigned NOT NULL default '0', |
---|
3159 | PRIMARY KEY (`entry`) |
---|
3160 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports'; |
---|
3161 | |
---|
3162 | -- |
---|
3163 | -- Dumping data for table `transports` |
---|
3164 | -- |
---|
3165 | |
---|
3166 | LOCK TABLES `transports` WRITE; |
---|
3167 | /*!40000 ALTER TABLE `transports` DISABLE KEYS */; |
---|
3168 | /*!40000 ALTER TABLE `transports` ENABLE KEYS */; |
---|
3169 | UNLOCK TABLES; |
---|
3170 | |
---|
3171 | -- |
---|
3172 | -- Table structure for table `trinity_string` |
---|
3173 | -- |
---|
3174 | |
---|
3175 | DROP TABLE IF EXISTS `trinity_string`; |
---|
3176 | CREATE TABLE `trinity_string` ( |
---|
3177 | `entry` mediumint(8) unsigned NOT NULL default '0', |
---|
3178 | `content_default` text NOT NULL, |
---|
3179 | `content_loc1` text, |
---|
3180 | `content_loc2` text, |
---|
3181 | `content_loc3` text, |
---|
3182 | `content_loc4` text, |
---|
3183 | `content_loc5` text, |
---|
3184 | `content_loc6` text, |
---|
3185 | `content_loc7` text, |
---|
3186 | `content_loc8` text, |
---|
3187 | PRIMARY KEY (`entry`) |
---|
3188 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
3189 | |
---|
3190 | -- |
---|
3191 | -- Dumping data for table `trinity_string` |
---|
3192 | -- |
---|
3193 | |
---|
3194 | LOCK TABLES `trinity_string` WRITE; |
---|
3195 | /*!40000 ALTER TABLE `trinity_string` DISABLE KEYS */; |
---|
3196 | /*!40000 ALTER TABLE `trinity_string` ENABLE KEYS */; |
---|
3197 | UNLOCK TABLES; |
---|
3198 | |
---|
3199 | -- |
---|
3200 | -- Table structure for table `uptime` |
---|
3201 | -- |
---|
3202 | |
---|
3203 | DROP TABLE IF EXISTS `uptime`; |
---|
3204 | CREATE TABLE `uptime` ( |
---|
3205 | `starttime` bigint(20) unsigned NOT NULL default '0', |
---|
3206 | `startstring` varchar(64) NOT NULL default '', |
---|
3207 | `uptime` bigint(20) unsigned NOT NULL default '0', |
---|
3208 | `maxplayers` smallint(5) unsigned NOT NULL default '0', |
---|
3209 | PRIMARY KEY (`starttime`) |
---|
3210 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system'; |
---|
3211 | |
---|
3212 | -- |
---|
3213 | -- Dumping data for table `uptime` |
---|
3214 | -- |
---|
3215 | |
---|
3216 | LOCK TABLES `uptime` WRITE; |
---|
3217 | /*!40000 ALTER TABLE `uptime` DISABLE KEYS */; |
---|
3218 | /*!40000 ALTER TABLE `uptime` ENABLE KEYS */; |
---|
3219 | UNLOCK TABLES; |
---|
3220 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
---|
3221 | |
---|
3222 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
---|
3223 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
---|
3224 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
---|
3225 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
---|
3226 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
---|
3227 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
---|
3228 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
---|
3229 | |
---|
3230 | -- Dump completed on 2008-10-14 13:23:35 |
---|