· 8 years ago · May 16, 2018, 06:54 PM
1# --------------------------------------------------------
2# Host: 127.0.0.1
3# Server version: 5.5.9
4# Server OS: Win64
5# HeidiSQL version: 6.0.0.3603
6# Date/time: 2011-06-24 10:59:06
7# --------------------------------------------------------
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14# Dumping structure for table [chaos]_char.account_data
15DROP TABLE IF EXISTS `account_data`;
16CREATE TABLE IF NOT EXISTS `account_data` (
17 `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
18 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
19 `time` int(10) unsigned NOT NULL DEFAULT '0',
20 `data` blob NOT NULL,
21 PRIMARY KEY (`accountId`,`type`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8;
23
24# Dumping data for table [chaos]_char.account_data: ~0 rows (approximately)
25DELETE FROM `account_data`;
26/*!40000 ALTER TABLE `account_data` DISABLE KEYS */;
27/*!40000 ALTER TABLE `account_data` ENABLE KEYS */;
28
29
30# Dumping structure for table [chaos]_char.account_instance_times
31DROP TABLE IF EXISTS `account_instance_times`;
32CREATE TABLE IF NOT EXISTS `account_instance_times` (
33 `accountId` int(10) unsigned NOT NULL,
34 `instanceId` int(10) unsigned NOT NULL DEFAULT '0',
35 `releaseTime` bigint(20) unsigned NOT NULL DEFAULT '0',
36 PRIMARY KEY (`accountId`,`instanceId`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38
39# Dumping data for table [chaos]_char.account_instance_times: ~0 rows (approximately)
40DELETE FROM `account_instance_times`;
41/*!40000 ALTER TABLE `account_instance_times` DISABLE KEYS */;
42/*!40000 ALTER TABLE `account_instance_times` ENABLE KEYS */;
43
44
45# Dumping structure for table [chaos]_char.account_tutorial
46DROP TABLE IF EXISTS `account_tutorial`;
47CREATE TABLE IF NOT EXISTS `account_tutorial` (
48 `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
49 `tut0` int(10) unsigned NOT NULL DEFAULT '0',
50 `tut1` int(10) unsigned NOT NULL DEFAULT '0',
51 `tut2` int(10) unsigned NOT NULL DEFAULT '0',
52 `tut3` int(10) unsigned NOT NULL DEFAULT '0',
53 `tut4` int(10) unsigned NOT NULL DEFAULT '0',
54 `tut5` int(10) unsigned NOT NULL DEFAULT '0',
55 `tut6` int(10) unsigned NOT NULL DEFAULT '0',
56 `tut7` int(10) unsigned NOT NULL DEFAULT '0',
57 PRIMARY KEY (`accountId`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59
60# Dumping data for table [chaos]_char.account_tutorial: ~0 rows (approximately)
61DELETE FROM `account_tutorial`;
62/*!40000 ALTER TABLE `account_tutorial` DISABLE KEYS */;
63/*!40000 ALTER TABLE `account_tutorial` ENABLE KEYS */;
64
65
66# Dumping structure for table [chaos]_char.addons
67DROP TABLE IF EXISTS `addons`;
68CREATE TABLE IF NOT EXISTS `addons` (
69 `name` varchar(120) NOT NULL DEFAULT '',
70 `crc` int(10) unsigned NOT NULL DEFAULT '0',
71 PRIMARY KEY (`name`)
72) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Addons';
73
74# Dumping data for table [chaos]_char.addons: ~0 rows (approximately)
75DELETE FROM `addons`;
76/*!40000 ALTER TABLE `addons` DISABLE KEYS */;
77/*!40000 ALTER TABLE `addons` ENABLE KEYS */;
78
79
80# Dumping structure for table [chaos]_char.arena_team
81DROP TABLE IF EXISTS `arena_team`;
82CREATE TABLE IF NOT EXISTS `arena_team` (
83 `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0',
84 `name` varchar(24) NOT NULL,
85 `captainGuid` int(10) unsigned NOT NULL DEFAULT '0',
86 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
87 `rating` smallint(5) unsigned NOT NULL DEFAULT '0',
88 `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0',
89 `seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0',
90 `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0',
91 `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0',
92 `rank` int(10) unsigned NOT NULL DEFAULT '0',
93 `backgroundColor` int(10) unsigned NOT NULL DEFAULT '0',
94 `emblemStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
95 `emblemColor` int(10) unsigned NOT NULL DEFAULT '0',
96 `borderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
97 `borderColor` int(10) unsigned NOT NULL DEFAULT '0',
98 PRIMARY KEY (`arenaTeamId`)
99) ENGINE=InnoDB DEFAULT CHARSET=utf8;
100
101# Dumping data for table [chaos]_char.arena_team: ~0 rows (approximately)
102DELETE FROM `arena_team`;
103/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
104/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
105
106
107# Dumping structure for table [chaos]_char.arena_team_member
108DROP TABLE IF EXISTS `arena_team_member`;
109CREATE TABLE IF NOT EXISTS `arena_team_member` (
110 `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0',
111 `guid` int(10) unsigned NOT NULL DEFAULT '0',
112 `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0',
113 `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0',
114 `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0',
115 `seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0',
116 `personalRating` smallint(5) unsigned NOT NULL DEFAULT '0',
117 PRIMARY KEY (`arenaTeamId`,`guid`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8;
119
120# Dumping data for table [chaos]_char.arena_team_member: ~0 rows (approximately)
121DELETE FROM `arena_team_member`;
122/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
123/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
124
125
126# Dumping structure for table [chaos]_char.arena_team_stats
127DROP TABLE IF EXISTS `arena_team_stats`;
128CREATE TABLE IF NOT EXISTS `arena_team_stats` (
129 `arenateamid` int(10) unsigned NOT NULL DEFAULT '0',
130 `rating` int(10) unsigned NOT NULL DEFAULT '0',
131 `games` int(10) unsigned NOT NULL DEFAULT '0',
132 `wins` int(10) unsigned NOT NULL DEFAULT '0',
133 `played` int(10) unsigned NOT NULL DEFAULT '0',
134 `wins2` int(10) unsigned NOT NULL DEFAULT '0',
135 `rank` int(10) unsigned NOT NULL DEFAULT '0',
136 PRIMARY KEY (`arenateamid`)
137) ENGINE=InnoDB DEFAULT CHARSET=utf8;
138
139# Dumping data for table [chaos]_char.arena_team_stats: ~0 rows (approximately)
140DELETE FROM `arena_team_stats`;
141/*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
142/*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
143
144
145# Dumping structure for table [chaos]_char.auctionhouse
146DROP TABLE IF EXISTS `auctionhouse`;
147CREATE TABLE IF NOT EXISTS `auctionhouse` (
148 `id` int(10) unsigned NOT NULL DEFAULT '0',
149 `auctioneerguid` int(10) unsigned NOT NULL DEFAULT '0',
150 `itemguid` int(10) unsigned NOT NULL DEFAULT '0',
151 `itemowner` int(10) unsigned NOT NULL DEFAULT '0',
152 `buyoutprice` int(10) unsigned NOT NULL DEFAULT '0',
153 `time` int(10) unsigned NOT NULL DEFAULT '0',
154 `buyguid` int(10) unsigned NOT NULL DEFAULT '0',
155 `lastbid` int(10) unsigned NOT NULL DEFAULT '0',
156 `startbid` int(10) unsigned NOT NULL DEFAULT '0',
157 `deposit` int(10) unsigned NOT NULL DEFAULT '0',
158 PRIMARY KEY (`id`),
159 UNIQUE KEY `item_guid` (`itemguid`)
160) ENGINE=InnoDB DEFAULT CHARSET=utf8;
161
162# Dumping data for table [chaos]_char.auctionhouse: ~0 rows (approximately)
163DELETE FROM `auctionhouse`;
164/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
165/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
166
167
168# Dumping structure for table [chaos]_char.auctionhousebot
169DROP TABLE IF EXISTS `auctionhousebot`;
170CREATE TABLE IF NOT EXISTS `auctionhousebot` (
171 `auctionhouse` int(11) NOT NULL DEFAULT '0' COMMENT 'mapID of the auctionhouse.',
172 `name` char(25) DEFAULT NULL COMMENT 'Text name of the auctionhouse.',
173 `minitems` int(11) DEFAULT '0' COMMENT 'This is the minimum number of items you want to keep in the auction house. a 0 here will make it the same as the maximum.',
174 `maxitems` int(11) DEFAULT '0' COMMENT 'This is the number of items you want to keep in the auction house.',
175 `percentgreytradegoods` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items',
176 `percentwhitetradegoods` int(11) DEFAULT '27' COMMENT 'Sets the percentage of the White Trade Goods auction items',
177 `percentgreentradegoods` int(11) DEFAULT '12' COMMENT 'Sets the percentage of the Green Trade Goods auction items',
178 `percentbluetradegoods` int(11) DEFAULT '10' COMMENT 'Sets the percentage of the Blue Trade Goods auction items',
179 `percentpurpletradegoods` int(11) DEFAULT '1' COMMENT 'Sets the percentage of the Purple Trade Goods auction items',
180 `percentorangetradegoods` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the Orange Trade Goods auction items',
181 `percentyellowtradegoods` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the Yellow Trade Goods auction items',
182 `percentgreyitems` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the non trade Grey auction items',
183 `percentwhiteitems` int(11) DEFAULT '10' COMMENT 'Sets the percentage of the non trade White auction items',
184 `percentgreenitems` int(11) DEFAULT '30' COMMENT 'Sets the percentage of the non trade Green auction items',
185 `percentblueitems` int(11) DEFAULT '8' COMMENT 'Sets the percentage of the non trade Blue auction items',
186 `percentpurpleitems` int(11) DEFAULT '2' COMMENT 'Sets the percentage of the non trade Purple auction items',
187 `percentorangeitems` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the non trade Orange auction items',
188 `percentyellowitems` int(11) DEFAULT '0' COMMENT 'Sets the percentage of the non trade Yellow auction items',
189 `minpricegrey` int(11) DEFAULT '100' COMMENT 'Minimum price of Grey items (percentage).',
190 `maxpricegrey` int(11) DEFAULT '150' COMMENT 'Maximum price of Grey items (percentage).',
191 `minpricewhite` int(11) DEFAULT '150' COMMENT 'Minimum price of White items (percentage).',
192 `maxpricewhite` int(11) DEFAULT '250' COMMENT 'Maximum price of White items (percentage).',
193 `minpricegreen` int(11) DEFAULT '800' COMMENT 'Minimum price of Green items (percentage).',
194 `maxpricegreen` int(11) DEFAULT '1400' COMMENT 'Maximum price of Green items (percentage).',
195 `minpriceblue` int(11) DEFAULT '1250' COMMENT 'Minimum price of Blue items (percentage).',
196 `maxpriceblue` int(11) DEFAULT '1750' COMMENT 'Maximum price of Blue items (percentage).',
197 `minpricepurple` int(11) DEFAULT '2250' COMMENT 'Minimum price of Purple items (percentage).',
198 `maxpricepurple` int(11) DEFAULT '4550' COMMENT 'Maximum price of Purple items (percentage).',
199 `minpriceorange` int(11) DEFAULT '3250' COMMENT 'Minimum price of Orange items (percentage).',
200 `maxpriceorange` int(11) DEFAULT '5550' COMMENT 'Maximum price of Orange items (percentage).',
201 `minpriceyellow` int(11) DEFAULT '5250' COMMENT 'Minimum price of Yellow items (percentage).',
202 `maxpriceyellow` int(11) DEFAULT '6550' COMMENT 'Maximum price of Yellow items (percentage).',
203 `minbidpricegrey` int(11) DEFAULT '70' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 70',
204 `maxbidpricegrey` int(11) DEFAULT '100' COMMENT 'Starting bid price of Grey items as a percentage of the randomly chosen buyout price. Default: 100',
205 `minbidpricewhite` int(11) DEFAULT '70' COMMENT 'Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 70',
206 `maxbidpricewhite` int(11) DEFAULT '100' COMMENT 'Starting bid price of White items as a percentage of the randomly chosen buyout price. Default: 100',
207 `minbidpricegreen` int(11) DEFAULT '80' COMMENT 'Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 80',
208 `maxbidpricegreen` int(11) DEFAULT '100' COMMENT 'Starting bid price of Green items as a percentage of the randomly chosen buyout price. Default: 100',
209 `minbidpriceblue` int(11) DEFAULT '75' COMMENT 'Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 75',
210 `maxbidpriceblue` int(11) DEFAULT '100' COMMENT 'Starting bid price of Blue items as a percentage of the randomly chosen buyout price. Default: 100',
211 `minbidpricepurple` int(11) DEFAULT '80' COMMENT 'Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 80',
212 `maxbidpricepurple` int(11) DEFAULT '100' COMMENT 'Starting bid price of Purple items as a percentage of the randomly chosen buyout price. Default: 100',
213 `minbidpriceorange` int(11) DEFAULT '80' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 80',
214 `maxbidpriceorange` int(11) DEFAULT '100' COMMENT 'Starting bid price of Orange items as a percentage of the randomly chosen buyout price. Default: 100',
215 `minbidpriceyellow` int(11) DEFAULT '80' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 80',
216 `maxbidpriceyellow` int(11) DEFAULT '100' COMMENT 'Starting bid price of Yellow items as a percentage of the randomly chosen buyout price. Default: 100',
217 `maxstackgrey` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
218 `maxstackwhite` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
219 `maxstackgreen` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
220 `maxstackblue` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
221 `maxstackpurple` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
222 `maxstackorange` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
223 `maxstackyellow` int(11) DEFAULT '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
224 `buyerpricegrey` int(11) DEFAULT '1' COMMENT 'Multiplier to vendorprice when buying grey items from auctionhouse',
225 `buyerpricewhite` int(11) DEFAULT '3' COMMENT 'Multiplier to vendorprice when buying white items from auctionhouse',
226 `buyerpricegreen` int(11) DEFAULT '5' COMMENT 'Multiplier to vendorprice when buying green items from auctionhouse',
227 `buyerpriceblue` int(11) DEFAULT '12' COMMENT 'Multiplier to vendorprice when buying blue items from auctionhouse',
228 `buyerpricepurple` int(11) DEFAULT '15' COMMENT 'Multiplier to vendorprice when buying purple items from auctionhouse',
229 `buyerpriceorange` int(11) DEFAULT '20' COMMENT 'Multiplier to vendorprice when buying orange items from auctionhouse',
230 `buyerpriceyellow` int(11) DEFAULT '22' COMMENT 'Multiplier to vendorprice when buying yellow items from auctionhouse',
231 `buyerbiddinginterval` int(11) DEFAULT '1' COMMENT 'Interval how frequently AHB bids on each AH. Time in minutes',
232 `buyerbidsperinterval` int(11) DEFAULT '1' COMMENT 'number of bids to put in per bidding interval',
233 PRIMARY KEY (`auctionhouse`)
234) ENGINE=InnoDB DEFAULT CHARSET=latin1;
235
236# Dumping data for table [chaos]_char.auctionhousebot: ~3 rows (approximately)
237DELETE FROM `auctionhousebot`;
238/*!40000 ALTER TABLE `auctionhousebot` DISABLE KEYS */;
239INSERT INTO `auctionhousebot` (`auctionhouse`, `name`, `minitems`, `maxitems`, `percentgreytradegoods`, `percentwhitetradegoods`, `percentgreentradegoods`, `percentbluetradegoods`, `percentpurpletradegoods`, `percentorangetradegoods`, `percentyellowtradegoods`, `percentgreyitems`, `percentwhiteitems`, `percentgreenitems`, `percentblueitems`, `percentpurpleitems`, `percentorangeitems`, `percentyellowitems`, `minpricegrey`, `maxpricegrey`, `minpricewhite`, `maxpricewhite`, `minpricegreen`, `maxpricegreen`, `minpriceblue`, `maxpriceblue`, `minpricepurple`, `maxpricepurple`, `minpriceorange`, `maxpriceorange`, `minpriceyellow`, `maxpriceyellow`, `minbidpricegrey`, `maxbidpricegrey`, `minbidpricewhite`, `maxbidpricewhite`, `minbidpricegreen`, `maxbidpricegreen`, `minbidpriceblue`, `maxbidpriceblue`, `minbidpricepurple`, `maxbidpricepurple`, `minbidpriceorange`, `maxbidpriceorange`, `minbidpriceyellow`, `maxbidpriceyellow`, `maxstackgrey`, `maxstackwhite`, `maxstackgreen`, `maxstackblue`, `maxstackpurple`, `maxstackorange`, `maxstackyellow`, `buyerpricegrey`, `buyerpricewhite`, `buyerpricegreen`, `buyerpriceblue`, `buyerpricepurple`, `buyerpriceorange`, `buyerpriceyellow`, `buyerbiddinginterval`, `buyerbidsperinterval`) VALUES
240 (2, 'Alliance', 250, 250, 0, 27, 12, 10, 1, 0, 0, 0, 10, 30, 8, 2, 0, 0, 100, 150, 150, 250, 800, 1400, 1250, 1750, 2250, 4550, 3250, 5550, 5250, 6550, 70, 100, 70, 100, 80, 100, 75, 100, 80, 100, 80, 100, 80, 100, 0, 0, 3, 2, 1, 1, 1, 1, 3, 5, 12, 15, 20, 22, 1, 1),
241 (6, 'Horde', 250, 250, 0, 27, 12, 10, 1, 0, 0, 0, 10, 30, 8, 2, 0, 0, 100, 150, 150, 250, 800, 1400, 1250, 1750, 2250, 4550, 3250, 5550, 5250, 6550, 70, 100, 70, 100, 80, 100, 75, 100, 80, 100, 80, 100, 80, 100, 0, 0, 3, 2, 1, 1, 1, 1, 3, 5, 12, 15, 20, 22, 1, 1),
242 (7, 'Neutral', 250, 250, 0, 27, 12, 10, 1, 0, 0, 0, 10, 30, 8, 2, 0, 0, 100, 150, 150, 250, 800, 1400, 1250, 1750, 2250, 4550, 3250, 5550, 5250, 6550, 70, 100, 70, 100, 80, 100, 75, 100, 80, 100, 80, 100, 80, 100, 0, 0, 3, 2, 1, 1, 1, 1, 3, 5, 12, 15, 20, 22, 1, 1);
243/*!40000 ALTER TABLE `auctionhousebot` ENABLE KEYS */;
244
245
246# Dumping structure for table [chaos]_char.bugreport
247DROP TABLE IF EXISTS `bugreport`;
248CREATE TABLE IF NOT EXISTS `bugreport` (
249 `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
250 `type` longtext NOT NULL,
251 `content` longtext NOT NULL,
252 PRIMARY KEY (`id`)
253) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Debug System';
254
255# Dumping data for table [chaos]_char.bugreport: ~0 rows (approximately)
256DELETE FROM `bugreport`;
257/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
258/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
259
260
261# Dumping structure for table [chaos]_char.channels
262DROP TABLE IF EXISTS `channels`;
263CREATE TABLE IF NOT EXISTS `channels` (
264 `name` varchar(128) NOT NULL,
265 `team` int(10) unsigned NOT NULL,
266 `announce` tinyint(3) unsigned NOT NULL DEFAULT '1',
267 `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
268 `password` varchar(32) DEFAULT NULL,
269 `bannedList` text,
270 `lastUsed` int(10) unsigned NOT NULL,
271 PRIMARY KEY (`name`,`team`)
272) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System';
273
274# Dumping data for table [chaos]_char.channels: ~0 rows (approximately)
275DELETE FROM `channels`;
276/*!40000 ALTER TABLE `channels` DISABLE KEYS */;
277/*!40000 ALTER TABLE `channels` ENABLE KEYS */;
278
279
280# Dumping structure for table [chaos]_char.characters
281DROP TABLE IF EXISTS `characters`;
282CREATE TABLE IF NOT EXISTS `characters` (
283 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
284 `account` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
285 `name` varchar(12) NOT NULL DEFAULT '',
286 `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
287 `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
288 `gender` tinyint(3) unsigned NOT NULL DEFAULT '0',
289 `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
290 `xp` int(10) unsigned NOT NULL DEFAULT '0',
291 `money` int(10) unsigned NOT NULL DEFAULT '0',
292 `playerBytes` int(10) unsigned NOT NULL DEFAULT '0',
293 `playerBytes2` int(10) unsigned NOT NULL DEFAULT '0',
294 `playerFlags` int(10) unsigned NOT NULL DEFAULT '0',
295 `position_x` float NOT NULL DEFAULT '0',
296 `position_y` float NOT NULL DEFAULT '0',
297 `position_z` float NOT NULL DEFAULT '0',
298 `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
299 `instance_id` int(10) unsigned NOT NULL DEFAULT '0',
300 `instance_mode_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
301 `orientation` float NOT NULL DEFAULT '0',
302 `taximask` text NOT NULL,
303 `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
304 `cinematic` tinyint(3) unsigned NOT NULL DEFAULT '0',
305 `totaltime` int(10) unsigned NOT NULL DEFAULT '0',
306 `leveltime` int(10) unsigned NOT NULL DEFAULT '0',
307 `logout_time` int(10) unsigned NOT NULL DEFAULT '0',
308 `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT '0',
309 `rest_bonus` float NOT NULL DEFAULT '0',
310 `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0',
311 `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0',
312 `trans_x` float NOT NULL DEFAULT '0',
313 `trans_y` float NOT NULL DEFAULT '0',
314 `trans_z` float NOT NULL DEFAULT '0',
315 `trans_o` float NOT NULL DEFAULT '0',
316 `transguid` mediumint(8) unsigned NOT NULL DEFAULT '0',
317 `extra_flags` smallint(5) unsigned NOT NULL DEFAULT '0',
318 `stable_slots` tinyint(3) unsigned NOT NULL DEFAULT '0',
319 `at_login` smallint(5) unsigned NOT NULL DEFAULT '0',
320 `zone` smallint(5) unsigned NOT NULL DEFAULT '0',
321 `death_expire_time` int(10) unsigned NOT NULL DEFAULT '0',
322 `taxi_path` text,
323 `arenaPoints` int(10) unsigned NOT NULL DEFAULT '0',
324 `totalHonorPoints` int(10) unsigned NOT NULL DEFAULT '0',
325 `todayHonorPoints` int(10) unsigned NOT NULL DEFAULT '0',
326 `yesterdayHonorPoints` int(10) unsigned NOT NULL DEFAULT '0',
327 `totalKills` int(10) unsigned NOT NULL DEFAULT '0',
328 `todayKills` smallint(5) unsigned NOT NULL DEFAULT '0',
329 `yesterdayKills` smallint(5) unsigned NOT NULL DEFAULT '0',
330 `chosenTitle` int(10) unsigned NOT NULL DEFAULT '0',
331 `knownCurrencies` bigint(20) unsigned NOT NULL DEFAULT '0',
332 `watchedFaction` int(10) unsigned NOT NULL DEFAULT '0',
333 `drunk` smallint(5) unsigned NOT NULL DEFAULT '0',
334 `health` int(10) unsigned NOT NULL DEFAULT '0',
335 `power1` int(10) unsigned NOT NULL DEFAULT '0',
336 `power2` int(10) unsigned NOT NULL DEFAULT '0',
337 `power3` int(10) unsigned NOT NULL DEFAULT '0',
338 `power4` int(10) unsigned NOT NULL DEFAULT '0',
339 `power5` int(10) unsigned NOT NULL DEFAULT '0',
340 `power6` int(10) unsigned NOT NULL DEFAULT '0',
341 `power7` int(10) unsigned NOT NULL DEFAULT '0',
342 `latency` mediumint(8) unsigned NOT NULL DEFAULT '0',
343 `speccount` tinyint(3) unsigned NOT NULL DEFAULT '1',
344 `activespec` tinyint(3) unsigned NOT NULL DEFAULT '0',
345 `exploredZones` longtext,
346 `equipmentCache` longtext,
347 `ammoId` int(10) unsigned NOT NULL DEFAULT '0',
348 `knownTitles` longtext,
349 `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0',
350 `deleteInfos_Account` int(10) unsigned DEFAULT NULL,
351 `deleteInfos_Name` varchar(12) DEFAULT NULL,
352 `deleteDate` int(10) unsigned DEFAULT NULL,
353 PRIMARY KEY (`guid`),
354 KEY `idx_account` (`account`),
355 KEY `idx_online` (`online`),
356 KEY `idx_name` (`name`)
357) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
358
359# Dumping data for table [chaos]_char.characters: ~0 rows (approximately)
360DELETE FROM `characters`;
361/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
362/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
363
364
365# Dumping structure for table [chaos]_char.character_account_data
366DROP TABLE IF EXISTS `character_account_data`;
367CREATE TABLE IF NOT EXISTS `character_account_data` (
368 `guid` int(10) unsigned NOT NULL DEFAULT '0',
369 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
370 `time` int(10) unsigned NOT NULL DEFAULT '0',
371 `data` blob NOT NULL,
372 PRIMARY KEY (`guid`,`type`)
373) ENGINE=InnoDB DEFAULT CHARSET=utf8;
374
375# Dumping data for table [chaos]_char.character_account_data: ~0 rows (approximately)
376DELETE FROM `character_account_data`;
377/*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */;
378/*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */;
379
380
381# Dumping structure for table [chaos]_char.character_achievement
382DROP TABLE IF EXISTS `character_achievement`;
383CREATE TABLE IF NOT EXISTS `character_achievement` (
384 `guid` int(10) unsigned NOT NULL,
385 `achievement` smallint(5) unsigned NOT NULL,
386 `date` int(10) unsigned NOT NULL DEFAULT '0',
387 PRIMARY KEY (`guid`,`achievement`)
388) ENGINE=InnoDB DEFAULT CHARSET=utf8;
389
390# Dumping data for table [chaos]_char.character_achievement: ~0 rows (approximately)
391DELETE FROM `character_achievement`;
392/*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
393/*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
394
395
396# Dumping structure for table [chaos]_char.character_achievement_progress
397DROP TABLE IF EXISTS `character_achievement_progress`;
398CREATE TABLE IF NOT EXISTS `character_achievement_progress` (
399 `guid` int(10) unsigned NOT NULL,
400 `criteria` smallint(5) unsigned NOT NULL,
401 `counter` int(10) unsigned NOT NULL,
402 `date` int(10) unsigned NOT NULL DEFAULT '0',
403 PRIMARY KEY (`guid`,`criteria`)
404) ENGINE=InnoDB DEFAULT CHARSET=utf8;
405
406# Dumping data for table [chaos]_char.character_achievement_progress: ~0 rows (approximately)
407DELETE FROM `character_achievement_progress`;
408/*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
409/*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
410
411
412# Dumping structure for table [chaos]_char.character_action
413DROP TABLE IF EXISTS `character_action`;
414CREATE TABLE IF NOT EXISTS `character_action` (
415 `guid` int(10) unsigned NOT NULL DEFAULT '0',
416 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
417 `button` tinyint(3) unsigned NOT NULL DEFAULT '0',
418 `action` int(10) unsigned NOT NULL DEFAULT '0',
419 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
420 PRIMARY KEY (`guid`,`spec`,`button`)
421) ENGINE=InnoDB DEFAULT CHARSET=utf8;
422
423# Dumping data for table [chaos]_char.character_action: ~0 rows (approximately)
424DELETE FROM `character_action`;
425/*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
426/*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
427
428
429# Dumping structure for table [chaos]_char.character_arena_stats
430DROP TABLE IF EXISTS `character_arena_stats`;
431CREATE TABLE IF NOT EXISTS `character_arena_stats` (
432 `guid` int(10) NOT NULL,
433 `slot` tinyint(3) NOT NULL,
434 `matchMakerRating` smallint(5) NOT NULL,
435 PRIMARY KEY (`guid`,`slot`)
436) ENGINE=InnoDB DEFAULT CHARSET=utf8;
437
438# Dumping data for table [chaos]_char.character_arena_stats: ~0 rows (approximately)
439DELETE FROM `character_arena_stats`;
440/*!40000 ALTER TABLE `character_arena_stats` DISABLE KEYS */;
441/*!40000 ALTER TABLE `character_arena_stats` ENABLE KEYS */;
442
443
444# Dumping structure for table [chaos]_char.character_aura
445DROP TABLE IF EXISTS `character_aura`;
446CREATE TABLE IF NOT EXISTS `character_aura` (
447 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
448 `caster_guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
449 `item_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
450 `spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
451 `effect_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
452 `recalculate_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
453 `stackcount` tinyint(3) unsigned NOT NULL DEFAULT '1',
454 `amount0` int(11) NOT NULL DEFAULT '0',
455 `amount1` int(11) NOT NULL DEFAULT '0',
456 `amount2` int(11) NOT NULL DEFAULT '0',
457 `base_amount0` int(11) NOT NULL DEFAULT '0',
458 `base_amount1` int(11) NOT NULL DEFAULT '0',
459 `base_amount2` int(11) NOT NULL DEFAULT '0',
460 `maxduration` int(11) NOT NULL DEFAULT '0',
461 `remaintime` int(11) NOT NULL DEFAULT '0',
462 `remaincharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
463 PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`,`effect_mask`)
464) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
465
466# Dumping data for table [chaos]_char.character_aura: ~0 rows (approximately)
467DELETE FROM `character_aura`;
468/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
469/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
470
471
472# Dumping structure for table [chaos]_char.character_banned
473DROP TABLE IF EXISTS `character_banned`;
474CREATE TABLE IF NOT EXISTS `character_banned` (
475 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
476 `bandate` int(10) unsigned NOT NULL DEFAULT '0',
477 `unbandate` int(10) unsigned NOT NULL DEFAULT '0',
478 `bannedby` varchar(50) NOT NULL,
479 `banreason` varchar(255) NOT NULL,
480 `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
481 PRIMARY KEY (`guid`,`bandate`)
482) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List';
483
484# Dumping data for table [chaos]_char.character_banned: ~0 rows (approximately)
485DELETE FROM `character_banned`;
486/*!40000 ALTER TABLE `character_banned` DISABLE KEYS */;
487/*!40000 ALTER TABLE `character_banned` ENABLE KEYS */;
488
489
490# Dumping structure for table [chaos]_char.character_battleground_data
491DROP TABLE IF EXISTS `character_battleground_data`;
492CREATE TABLE IF NOT EXISTS `character_battleground_data` (
493 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
494 `instanceId` int(10) unsigned NOT NULL COMMENT 'Instance Identifier',
495 `team` smallint(5) unsigned NOT NULL,
496 `joinX` float NOT NULL DEFAULT '0',
497 `joinY` float NOT NULL DEFAULT '0',
498 `joinZ` float NOT NULL DEFAULT '0',
499 `joinO` float NOT NULL DEFAULT '0',
500 `joinMapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
501 `taxiStart` int(10) unsigned NOT NULL DEFAULT '0',
502 `taxiEnd` int(10) unsigned NOT NULL DEFAULT '0',
503 `mountSpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
504 PRIMARY KEY (`guid`)
505) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
506
507# Dumping data for table [chaos]_char.character_battleground_data: ~0 rows (approximately)
508DELETE FROM `character_battleground_data`;
509/*!40000 ALTER TABLE `character_battleground_data` DISABLE KEYS */;
510/*!40000 ALTER TABLE `character_battleground_data` ENABLE KEYS */;
511
512
513# Dumping structure for table [chaos]_char.character_battleground_random
514DROP TABLE IF EXISTS `character_battleground_random`;
515CREATE TABLE IF NOT EXISTS `character_battleground_random` (
516 `guid` int(10) unsigned NOT NULL DEFAULT '0',
517 PRIMARY KEY (`guid`)
518) ENGINE=InnoDB DEFAULT CHARSET=utf8;
519
520# Dumping data for table [chaos]_char.character_battleground_random: ~0 rows (approximately)
521DELETE FROM `character_battleground_random`;
522/*!40000 ALTER TABLE `character_battleground_random` DISABLE KEYS */;
523/*!40000 ALTER TABLE `character_battleground_random` ENABLE KEYS */;
524
525
526# Dumping structure for table [chaos]_char.character_declinedname
527DROP TABLE IF EXISTS `character_declinedname`;
528CREATE TABLE IF NOT EXISTS `character_declinedname` (
529 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
530 `genitive` varchar(15) NOT NULL DEFAULT '',
531 `dative` varchar(15) NOT NULL DEFAULT '',
532 `accusative` varchar(15) NOT NULL DEFAULT '',
533 `instrumental` varchar(15) NOT NULL DEFAULT '',
534 `prepositional` varchar(15) NOT NULL DEFAULT '',
535 PRIMARY KEY (`guid`)
536) ENGINE=InnoDB DEFAULT CHARSET=utf8;
537
538# Dumping data for table [chaos]_char.character_declinedname: ~0 rows (approximately)
539DELETE FROM `character_declinedname`;
540/*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
541/*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
542
543
544# Dumping structure for table [chaos]_char.character_equipmentsets
545DROP TABLE IF EXISTS `character_equipmentsets`;
546CREATE TABLE IF NOT EXISTS `character_equipmentsets` (
547 `guid` int(10) NOT NULL DEFAULT '0',
548 `setguid` bigint(20) NOT NULL AUTO_INCREMENT,
549 `setindex` tinyint(3) unsigned NOT NULL DEFAULT '0',
550 `name` varchar(31) NOT NULL,
551 `iconname` varchar(100) NOT NULL,
552 `item0` int(10) unsigned NOT NULL DEFAULT '0',
553 `item1` int(10) unsigned NOT NULL DEFAULT '0',
554 `item2` int(10) unsigned NOT NULL DEFAULT '0',
555 `item3` int(10) unsigned NOT NULL DEFAULT '0',
556 `item4` int(10) unsigned NOT NULL DEFAULT '0',
557 `item5` int(10) unsigned NOT NULL DEFAULT '0',
558 `item6` int(10) unsigned NOT NULL DEFAULT '0',
559 `item7` int(10) unsigned NOT NULL DEFAULT '0',
560 `item8` int(10) unsigned NOT NULL DEFAULT '0',
561 `item9` int(10) unsigned NOT NULL DEFAULT '0',
562 `item10` int(10) unsigned NOT NULL DEFAULT '0',
563 `item11` int(10) unsigned NOT NULL DEFAULT '0',
564 `item12` int(10) unsigned NOT NULL DEFAULT '0',
565 `item13` int(10) unsigned NOT NULL DEFAULT '0',
566 `item14` int(10) unsigned NOT NULL DEFAULT '0',
567 `item15` int(10) unsigned NOT NULL DEFAULT '0',
568 `item16` int(10) unsigned NOT NULL DEFAULT '0',
569 `item17` int(10) unsigned NOT NULL DEFAULT '0',
570 `item18` int(10) unsigned NOT NULL DEFAULT '0',
571 PRIMARY KEY (`setguid`),
572 UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`),
573 KEY `Idx_setindex` (`setindex`)
574) ENGINE=InnoDB DEFAULT CHARSET=utf8;
575
576# Dumping data for table [chaos]_char.character_equipmentsets: ~0 rows (approximately)
577DELETE FROM `character_equipmentsets`;
578/*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */;
579/*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */;
580
581
582# Dumping structure for table [chaos]_char.character_gifts
583DROP TABLE IF EXISTS `character_gifts`;
584CREATE TABLE IF NOT EXISTS `character_gifts` (
585 `guid` int(10) unsigned NOT NULL DEFAULT '0',
586 `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
587 `entry` int(10) unsigned NOT NULL DEFAULT '0',
588 `flags` int(10) unsigned NOT NULL DEFAULT '0',
589 PRIMARY KEY (`item_guid`),
590 KEY `idx_guid` (`guid`)
591) ENGINE=InnoDB DEFAULT CHARSET=utf8;
592
593# Dumping data for table [chaos]_char.character_gifts: ~0 rows (approximately)
594DELETE FROM `character_gifts`;
595/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
596/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
597
598
599# Dumping structure for table [chaos]_char.character_glyphs
600DROP TABLE IF EXISTS `character_glyphs`;
601CREATE TABLE IF NOT EXISTS `character_glyphs` (
602 `guid` int(10) unsigned NOT NULL,
603 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
604 `glyph1` smallint(5) unsigned NOT NULL DEFAULT '0',
605 `glyph2` smallint(5) unsigned DEFAULT '0',
606 `glyph3` smallint(5) unsigned DEFAULT '0',
607 `glyph4` smallint(5) unsigned DEFAULT '0',
608 `glyph5` smallint(5) unsigned DEFAULT '0',
609 `glyph6` smallint(5) unsigned DEFAULT '0',
610 PRIMARY KEY (`guid`,`spec`)
611) ENGINE=InnoDB DEFAULT CHARSET=utf8;
612
613# Dumping data for table [chaos]_char.character_glyphs: ~0 rows (approximately)
614DELETE FROM `character_glyphs`;
615/*!40000 ALTER TABLE `character_glyphs` DISABLE KEYS */;
616/*!40000 ALTER TABLE `character_glyphs` ENABLE KEYS */;
617
618
619# Dumping structure for table [chaos]_char.character_homebind
620DROP TABLE IF EXISTS `character_homebind`;
621CREATE TABLE IF NOT EXISTS `character_homebind` (
622 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
623 `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
624 `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
625 `posX` float NOT NULL DEFAULT '0',
626 `posY` float NOT NULL DEFAULT '0',
627 `posZ` float NOT NULL DEFAULT '0',
628 PRIMARY KEY (`guid`)
629) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
630
631# Dumping data for table [chaos]_char.character_homebind: ~0 rows (approximately)
632DELETE FROM `character_homebind`;
633/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
634/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
635
636
637# Dumping structure for table [chaos]_char.character_instance
638DROP TABLE IF EXISTS `character_instance`;
639CREATE TABLE IF NOT EXISTS `character_instance` (
640 `guid` int(10) unsigned NOT NULL DEFAULT '0',
641 `instance` int(10) unsigned NOT NULL DEFAULT '0',
642 `permanent` tinyint(3) unsigned NOT NULL DEFAULT '0',
643 PRIMARY KEY (`guid`,`instance`),
644 KEY `instance` (`instance`)
645) ENGINE=InnoDB DEFAULT CHARSET=utf8;
646
647# Dumping data for table [chaos]_char.character_instance: ~0 rows (approximately)
648DELETE FROM `character_instance`;
649/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
650/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
651
652
653# Dumping structure for table [chaos]_char.character_inventory
654DROP TABLE IF EXISTS `character_inventory`;
655CREATE TABLE IF NOT EXISTS `character_inventory` (
656 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
657 `bag` int(10) unsigned NOT NULL DEFAULT '0',
658 `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
659 `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier',
660 PRIMARY KEY (`item`),
661 UNIQUE KEY `guid` (`guid`,`bag`,`slot`),
662 KEY `idx_guid` (`guid`)
663) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
664
665# Dumping data for table [chaos]_char.character_inventory: ~0 rows (approximately)
666DELETE FROM `character_inventory`;
667/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
668/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
669
670
671# Dumping structure for table [chaos]_char.character_pet
672DROP TABLE IF EXISTS `character_pet`;
673CREATE TABLE IF NOT EXISTS `character_pet` (
674 `id` int(10) unsigned NOT NULL DEFAULT '0',
675 `entry` int(10) unsigned NOT NULL DEFAULT '0',
676 `owner` int(10) unsigned NOT NULL DEFAULT '0',
677 `modelid` int(10) unsigned DEFAULT '0',
678 `CreatedBySpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
679 `PetType` tinyint(3) unsigned NOT NULL DEFAULT '0',
680 `level` smallint(5) unsigned NOT NULL DEFAULT '1',
681 `exp` int(10) unsigned NOT NULL DEFAULT '0',
682 `Reactstate` tinyint(3) unsigned NOT NULL DEFAULT '0',
683 `name` varchar(21) NOT NULL DEFAULT 'Pet',
684 `renamed` tinyint(3) unsigned NOT NULL DEFAULT '0',
685 `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
686 `curhealth` int(10) unsigned NOT NULL DEFAULT '1',
687 `curmana` int(10) unsigned NOT NULL DEFAULT '0',
688 `curhappiness` int(10) unsigned NOT NULL DEFAULT '0',
689 `savetime` int(10) unsigned NOT NULL DEFAULT '0',
690 `abdata` text,
691 PRIMARY KEY (`id`),
692 KEY `owner` (`owner`),
693 KEY `idx_slot` (`slot`)
694) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
695
696# Dumping data for table [chaos]_char.character_pet: ~0 rows (approximately)
697DELETE FROM `character_pet`;
698/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
699/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
700
701
702# Dumping structure for table [chaos]_char.character_pet_declinedname
703DROP TABLE IF EXISTS `character_pet_declinedname`;
704CREATE TABLE IF NOT EXISTS `character_pet_declinedname` (
705 `id` int(10) unsigned NOT NULL DEFAULT '0',
706 `owner` int(10) unsigned NOT NULL DEFAULT '0',
707 `genitive` varchar(12) NOT NULL DEFAULT '',
708 `dative` varchar(12) NOT NULL DEFAULT '',
709 `accusative` varchar(12) NOT NULL DEFAULT '',
710 `instrumental` varchar(12) NOT NULL DEFAULT '',
711 `prepositional` varchar(12) NOT NULL DEFAULT '',
712 PRIMARY KEY (`id`),
713 KEY `owner_key` (`owner`)
714) ENGINE=InnoDB DEFAULT CHARSET=utf8;
715
716# Dumping data for table [chaos]_char.character_pet_declinedname: ~0 rows (approximately)
717DELETE FROM `character_pet_declinedname`;
718/*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
719/*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
720
721
722# Dumping structure for table [chaos]_char.character_queststatus
723DROP TABLE IF EXISTS `character_queststatus`;
724CREATE TABLE IF NOT EXISTS `character_queststatus` (
725 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
726 `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
727 `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
728 `explored` tinyint(3) unsigned NOT NULL DEFAULT '0',
729 `timer` int(10) unsigned NOT NULL DEFAULT '0',
730 `mobcount1` smallint(5) unsigned NOT NULL DEFAULT '0',
731 `mobcount2` smallint(5) unsigned NOT NULL DEFAULT '0',
732 `mobcount3` smallint(5) unsigned NOT NULL DEFAULT '0',
733 `mobcount4` smallint(5) unsigned NOT NULL DEFAULT '0',
734 `itemcount1` smallint(5) unsigned NOT NULL DEFAULT '0',
735 `itemcount2` smallint(5) unsigned NOT NULL DEFAULT '0',
736 `itemcount3` smallint(5) unsigned NOT NULL DEFAULT '0',
737 `itemcount4` smallint(5) unsigned NOT NULL DEFAULT '0',
738 PRIMARY KEY (`guid`,`quest`)
739) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
740
741# Dumping data for table [chaos]_char.character_queststatus: ~0 rows (approximately)
742DELETE FROM `character_queststatus`;
743/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
744/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
745
746
747# Dumping structure for table [chaos]_char.character_queststatus_daily
748DROP TABLE IF EXISTS `character_queststatus_daily`;
749CREATE TABLE IF NOT EXISTS `character_queststatus_daily` (
750 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
751 `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
752 `time` int(10) unsigned NOT NULL DEFAULT '0',
753 PRIMARY KEY (`guid`,`quest`),
754 KEY `idx_guid` (`guid`)
755) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
756
757# Dumping data for table [chaos]_char.character_queststatus_daily: ~0 rows (approximately)
758DELETE FROM `character_queststatus_daily`;
759/*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
760/*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
761
762
763# Dumping structure for table [chaos]_char.character_queststatus_rewarded
764DROP TABLE IF EXISTS `character_queststatus_rewarded`;
765CREATE TABLE IF NOT EXISTS `character_queststatus_rewarded` (
766 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
767 `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
768 PRIMARY KEY (`guid`,`quest`)
769) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
770
771# Dumping data for table [chaos]_char.character_queststatus_rewarded: ~0 rows (approximately)
772DELETE FROM `character_queststatus_rewarded`;
773/*!40000 ALTER TABLE `character_queststatus_rewarded` DISABLE KEYS */;
774/*!40000 ALTER TABLE `character_queststatus_rewarded` ENABLE KEYS */;
775
776
777# Dumping structure for table [chaos]_char.character_queststatus_weekly
778DROP TABLE IF EXISTS `character_queststatus_weekly`;
779CREATE TABLE IF NOT EXISTS `character_queststatus_weekly` (
780 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
781 `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
782 PRIMARY KEY (`guid`,`quest`),
783 KEY `idx_guid` (`guid`)
784) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
785
786# Dumping data for table [chaos]_char.character_queststatus_weekly: ~0 rows (approximately)
787DELETE FROM `character_queststatus_weekly`;
788/*!40000 ALTER TABLE `character_queststatus_weekly` DISABLE KEYS */;
789/*!40000 ALTER TABLE `character_queststatus_weekly` ENABLE KEYS */;
790
791
792# Dumping structure for table [chaos]_char.character_reputation
793DROP TABLE IF EXISTS `character_reputation`;
794CREATE TABLE IF NOT EXISTS `character_reputation` (
795 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
796 `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
797 `standing` int(11) NOT NULL DEFAULT '0',
798 `flags` smallint(5) unsigned NOT NULL DEFAULT '0',
799 PRIMARY KEY (`guid`,`faction`)
800) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
801
802# Dumping data for table [chaos]_char.character_reputation: ~0 rows (approximately)
803DELETE FROM `character_reputation`;
804/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
805/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
806
807
808# Dumping structure for table [chaos]_char.character_skills
809DROP TABLE IF EXISTS `character_skills`;
810CREATE TABLE IF NOT EXISTS `character_skills` (
811 `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier',
812 `skill` smallint(5) unsigned NOT NULL,
813 `value` smallint(5) unsigned NOT NULL,
814 `max` smallint(5) unsigned NOT NULL,
815 PRIMARY KEY (`guid`,`skill`)
816) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
817
818# Dumping data for table [chaos]_char.character_skills: ~0 rows (approximately)
819DELETE FROM `character_skills`;
820/*!40000 ALTER TABLE `character_skills` DISABLE KEYS */;
821/*!40000 ALTER TABLE `character_skills` ENABLE KEYS */;
822
823
824# Dumping structure for table [chaos]_char.character_social
825DROP TABLE IF EXISTS `character_social`;
826CREATE TABLE IF NOT EXISTS `character_social` (
827 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
828 `friend` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier',
829 `flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags',
830 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
831 PRIMARY KEY (`guid`,`friend`,`flags`),
832 KEY `friend` (`friend`)
833) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
834
835# Dumping data for table [chaos]_char.character_social: ~0 rows (approximately)
836DELETE FROM `character_social`;
837/*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
838/*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
839
840
841# Dumping structure for table [chaos]_char.character_spell
842DROP TABLE IF EXISTS `character_spell`;
843CREATE TABLE IF NOT EXISTS `character_spell` (
844 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
845 `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
846 `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
847 `disabled` tinyint(3) unsigned NOT NULL DEFAULT '0',
848 PRIMARY KEY (`guid`,`spell`)
849) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
850
851# Dumping data for table [chaos]_char.character_spell: ~0 rows (approximately)
852DELETE FROM `character_spell`;
853/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
854/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
855
856
857# Dumping structure for table [chaos]_char.character_spell_cooldown
858DROP TABLE IF EXISTS `character_spell_cooldown`;
859CREATE TABLE IF NOT EXISTS `character_spell_cooldown` (
860 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
861 `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
862 `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
863 `time` int(10) unsigned NOT NULL DEFAULT '0',
864 PRIMARY KEY (`guid`,`spell`)
865) ENGINE=InnoDB DEFAULT CHARSET=utf8;
866
867# Dumping data for table [chaos]_char.character_spell_cooldown: ~0 rows (approximately)
868DELETE FROM `character_spell_cooldown`;
869/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
870/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
871
872
873# Dumping structure for table [chaos]_char.character_stats
874DROP TABLE IF EXISTS `character_stats`;
875CREATE TABLE IF NOT EXISTS `character_stats` (
876 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
877 `maxhealth` int(10) unsigned NOT NULL DEFAULT '0',
878 `maxpower1` int(10) unsigned NOT NULL DEFAULT '0',
879 `maxpower2` int(10) unsigned NOT NULL DEFAULT '0',
880 `maxpower3` int(10) unsigned NOT NULL DEFAULT '0',
881 `maxpower4` int(10) unsigned NOT NULL DEFAULT '0',
882 `maxpower5` int(10) unsigned NOT NULL DEFAULT '0',
883 `maxpower6` int(10) unsigned NOT NULL DEFAULT '0',
884 `maxpower7` int(10) unsigned NOT NULL DEFAULT '0',
885 `strength` int(10) unsigned NOT NULL DEFAULT '0',
886 `agility` int(10) unsigned NOT NULL DEFAULT '0',
887 `stamina` int(10) unsigned NOT NULL DEFAULT '0',
888 `intellect` int(10) unsigned NOT NULL DEFAULT '0',
889 `spirit` int(10) unsigned NOT NULL DEFAULT '0',
890 `armor` int(10) unsigned NOT NULL DEFAULT '0',
891 `resHoly` int(10) unsigned NOT NULL DEFAULT '0',
892 `resFire` int(10) unsigned NOT NULL DEFAULT '0',
893 `resNature` int(10) unsigned NOT NULL DEFAULT '0',
894 `resFrost` int(10) unsigned NOT NULL DEFAULT '0',
895 `resShadow` int(10) unsigned NOT NULL DEFAULT '0',
896 `resArcane` int(10) unsigned NOT NULL DEFAULT '0',
897 `blockPct` float unsigned NOT NULL DEFAULT '0',
898 `dodgePct` float unsigned NOT NULL DEFAULT '0',
899 `parryPct` float unsigned NOT NULL DEFAULT '0',
900 `critPct` float unsigned NOT NULL DEFAULT '0',
901 `rangedCritPct` float unsigned NOT NULL DEFAULT '0',
902 `spellCritPct` float unsigned NOT NULL DEFAULT '0',
903 `attackPower` int(10) unsigned NOT NULL DEFAULT '0',
904 `rangedAttackPower` int(10) unsigned NOT NULL DEFAULT '0',
905 `spellPower` int(10) unsigned NOT NULL DEFAULT '0',
906 `resilience` int(10) unsigned NOT NULL DEFAULT '0',
907 PRIMARY KEY (`guid`)
908) ENGINE=InnoDB DEFAULT CHARSET=utf8;
909
910# Dumping data for table [chaos]_char.character_stats: ~0 rows (approximately)
911DELETE FROM `character_stats`;
912/*!40000 ALTER TABLE `character_stats` DISABLE KEYS */;
913/*!40000 ALTER TABLE `character_stats` ENABLE KEYS */;
914
915
916# Dumping structure for table [chaos]_char.character_talent
917DROP TABLE IF EXISTS `character_talent`;
918CREATE TABLE IF NOT EXISTS `character_talent` (
919 `guid` int(10) unsigned NOT NULL,
920 `spell` mediumint(8) unsigned NOT NULL,
921 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
922 PRIMARY KEY (`guid`,`spell`,`spec`)
923) ENGINE=InnoDB DEFAULT CHARSET=utf8;
924
925# Dumping data for table [chaos]_char.character_talent: ~0 rows (approximately)
926DELETE FROM `character_talent`;
927/*!40000 ALTER TABLE `character_talent` DISABLE KEYS */;
928/*!40000 ALTER TABLE `character_talent` ENABLE KEYS */;
929
930
931# Dumping structure for table [chaos]_char.corpse
932DROP TABLE IF EXISTS `corpse`;
933CREATE TABLE IF NOT EXISTS `corpse` (
934 `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
935 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
936 `posX` float NOT NULL DEFAULT '0',
937 `posY` float NOT NULL DEFAULT '0',
938 `posZ` float NOT NULL DEFAULT '0',
939 `orientation` float NOT NULL DEFAULT '0',
940 `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
941 `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',
942 `displayId` int(10) unsigned NOT NULL DEFAULT '0',
943 `itemCache` text NOT NULL,
944 `bytes1` int(10) unsigned NOT NULL DEFAULT '0',
945 `bytes2` int(10) unsigned NOT NULL DEFAULT '0',
946 `guildId` int(10) unsigned NOT NULL DEFAULT '0',
947 `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
948 `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
949 `time` int(10) unsigned NOT NULL DEFAULT '0',
950 `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
951 `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
952 PRIMARY KEY (`corpseGuid`),
953 KEY `idx_type` (`corpseType`),
954 KEY `idx_instance` (`instanceId`),
955 KEY `idx_player` (`guid`),
956 KEY `idx_time` (`time`)
957) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System';
958
959# Dumping data for table [chaos]_char.corpse: ~0 rows (approximately)
960DELETE FROM `corpse`;
961/*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
962/*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
963
964
965# Dumping structure for table [chaos]_char.creature_respawn
966DROP TABLE IF EXISTS `creature_respawn`;
967CREATE TABLE IF NOT EXISTS `creature_respawn` (
968 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
969 `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
970 `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
971 PRIMARY KEY (`guid`,`instanceId`),
972 KEY `idx_instance` (`instanceId`)
973) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
974
975# Dumping data for table [chaos]_char.creature_respawn: ~0 rows (approximately)
976DELETE FROM `creature_respawn`;
977/*!40000 ALTER TABLE `creature_respawn` DISABLE KEYS */;
978/*!40000 ALTER TABLE `creature_respawn` ENABLE KEYS */;
979
980
981# Dumping structure for table [chaos]_char.daily_players_reports
982DROP TABLE IF EXISTS `daily_players_reports`;
983CREATE TABLE IF NOT EXISTS `daily_players_reports` (
984 `guid` int(10) unsigned NOT NULL DEFAULT '0',
985 `creation_time` int(10) unsigned NOT NULL DEFAULT '0',
986 `average` float NOT NULL DEFAULT '0',
987 `total_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
988 `speed_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
989 `fly_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
990 `jump_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
991 `waterwalk_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
992 `teleportplane_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
993 `climb_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
994 PRIMARY KEY (`guid`)
995) ENGINE=InnoDB DEFAULT CHARSET=utf8;
996
997# Dumping data for table [chaos]_char.daily_players_reports: ~0 rows (approximately)
998DELETE FROM `daily_players_reports`;
999/*!40000 ALTER TABLE `daily_players_reports` DISABLE KEYS */;
1000/*!40000 ALTER TABLE `daily_players_reports` ENABLE KEYS */;
1001
1002
1003# Dumping structure for table [chaos]_char.gameobject_respawn
1004DROP TABLE IF EXISTS `gameobject_respawn`;
1005CREATE TABLE IF NOT EXISTS `gameobject_respawn` (
1006 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1007 `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
1008 `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
1009 PRIMARY KEY (`guid`,`instanceId`),
1010 KEY `idx_instance` (`instanceId`)
1011) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
1012
1013# Dumping data for table [chaos]_char.gameobject_respawn: ~0 rows (approximately)
1014DELETE FROM `gameobject_respawn`;
1015/*!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS */;
1016/*!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS */;
1017
1018
1019# Dumping structure for table [chaos]_char.game_event_condition_save
1020DROP TABLE IF EXISTS `game_event_condition_save`;
1021CREATE TABLE IF NOT EXISTS `game_event_condition_save` (
1022 `eventEntry` tinyint(3) unsigned NOT NULL,
1023 `condition_id` int(10) unsigned NOT NULL DEFAULT '0',
1024 `done` float DEFAULT '0',
1025 PRIMARY KEY (`eventEntry`,`condition_id`)
1026) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1027
1028# Dumping data for table [chaos]_char.game_event_condition_save: ~0 rows (approximately)
1029DELETE FROM `game_event_condition_save`;
1030/*!40000 ALTER TABLE `game_event_condition_save` DISABLE KEYS */;
1031/*!40000 ALTER TABLE `game_event_condition_save` ENABLE KEYS */;
1032
1033
1034# Dumping structure for table [chaos]_char.game_event_save
1035DROP TABLE IF EXISTS `game_event_save`;
1036CREATE TABLE IF NOT EXISTS `game_event_save` (
1037 `eventEntry` tinyint(3) unsigned NOT NULL,
1038 `state` tinyint(3) unsigned NOT NULL DEFAULT '1',
1039 `next_start` int(10) unsigned NOT NULL DEFAULT '0',
1040 PRIMARY KEY (`eventEntry`)
1041) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1042
1043# Dumping data for table [chaos]_char.game_event_save: ~0 rows (approximately)
1044DELETE FROM `game_event_save`;
1045/*!40000 ALTER TABLE `game_event_save` DISABLE KEYS */;
1046/*!40000 ALTER TABLE `game_event_save` ENABLE KEYS */;
1047
1048
1049# Dumping structure for table [chaos]_char.gmisland_teleport
1050DROP TABLE IF EXISTS `gmisland_teleport`;
1051CREATE TABLE IF NOT EXISTS `gmisland_teleport` (
1052 `map` smallint(5) unsigned NOT NULL DEFAULT '0',
1053 `x` double NOT NULL DEFAULT '0',
1054 `y` double NOT NULL DEFAULT '0',
1055 `z` double NOT NULL DEFAULT '0',
1056 `orientation` double NOT NULL DEFAULT '0',
1057 `comment` varchar(255) DEFAULT NULL,
1058 PRIMARY KEY (`map`)
1059) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1060
1061# Dumping data for table [chaos]_char.gmisland_teleport: 1 rows
1062DELETE FROM `gmisland_teleport`;
1063/*!40000 ALTER TABLE `gmisland_teleport` DISABLE KEYS */;
1064INSERT INTO `gmisland_teleport` (`map`, `x`, `y`, `z`, `orientation`, `comment`) VALUES
1065 (13, 1.118799, 0.477914, -144.70865, 3.133046, 'Jail Box');
1066/*!40000 ALTER TABLE `gmisland_teleport` ENABLE KEYS */;
1067
1068
1069# Dumping structure for table [chaos]_char.gm_subsurveys
1070DROP TABLE IF EXISTS `gm_subsurveys`;
1071CREATE TABLE IF NOT EXISTS `gm_subsurveys` (
1072 `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT,
1073 `subsurveyId` int(10) unsigned NOT NULL DEFAULT '0',
1074 `rank` int(10) unsigned NOT NULL DEFAULT '0',
1075 `comment` text NOT NULL,
1076 PRIMARY KEY (`surveyId`,`subsurveyId`)
1077) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1078
1079# Dumping data for table [chaos]_char.gm_subsurveys: ~0 rows (approximately)
1080DELETE FROM `gm_subsurveys`;
1081/*!40000 ALTER TABLE `gm_subsurveys` DISABLE KEYS */;
1082/*!40000 ALTER TABLE `gm_subsurveys` ENABLE KEYS */;
1083
1084
1085# Dumping structure for table [chaos]_char.gm_surveys
1086DROP TABLE IF EXISTS `gm_surveys`;
1087CREATE TABLE IF NOT EXISTS `gm_surveys` (
1088 `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT,
1089 `guid` int(10) unsigned NOT NULL DEFAULT '0',
1090 `mainSurvey` int(10) unsigned NOT NULL DEFAULT '0',
1091 `overallComment` longtext NOT NULL,
1092 `createTime` int(10) unsigned NOT NULL DEFAULT '0',
1093 PRIMARY KEY (`surveyId`)
1094) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1095
1096# Dumping data for table [chaos]_char.gm_surveys: ~0 rows (approximately)
1097DELETE FROM `gm_surveys`;
1098/*!40000 ALTER TABLE `gm_surveys` DISABLE KEYS */;
1099/*!40000 ALTER TABLE `gm_surveys` ENABLE KEYS */;
1100
1101
1102# Dumping structure for table [chaos]_char.gm_tickets
1103DROP TABLE IF EXISTS `gm_tickets`;
1104CREATE TABLE IF NOT EXISTS `gm_tickets` (
1105 `ticketId` int(10) unsigned NOT NULL AUTO_INCREMENT,
1106 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier of ticket creator',
1107 `name` varchar(12) NOT NULL COMMENT 'Name of ticket creator',
1108 `message` text NOT NULL,
1109 `createTime` int(10) unsigned NOT NULL DEFAULT '0',
1110 `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
1111 `posX` float NOT NULL DEFAULT '0',
1112 `posY` float NOT NULL DEFAULT '0',
1113 `posZ` float NOT NULL DEFAULT '0',
1114 `lastModifiedTime` int(10) unsigned NOT NULL DEFAULT '0',
1115 `closedBy` int(10) NOT NULL DEFAULT '0',
1116 `assignedTo` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned',
1117 `comment` text NOT NULL,
1118 `completed` tinyint(3) unsigned NOT NULL DEFAULT '0',
1119 `escalated` tinyint(3) unsigned NOT NULL DEFAULT '0',
1120 `viewed` tinyint(3) unsigned NOT NULL DEFAULT '0',
1121 PRIMARY KEY (`ticketId`)
1122) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1123
1124# Dumping data for table [chaos]_char.gm_tickets: ~0 rows (approximately)
1125DELETE FROM `gm_tickets`;
1126/*!40000 ALTER TABLE `gm_tickets` DISABLE KEYS */;
1127/*!40000 ALTER TABLE `gm_tickets` ENABLE KEYS */;
1128
1129
1130# Dumping structure for table [chaos]_char.groups
1131DROP TABLE IF EXISTS `groups`;
1132CREATE TABLE IF NOT EXISTS `groups` (
1133 `guid` int(10) unsigned NOT NULL,
1134 `leaderGuid` int(10) unsigned NOT NULL,
1135 `lootMethod` tinyint(3) unsigned NOT NULL,
1136 `looterGuid` int(10) unsigned NOT NULL,
1137 `lootThreshold` tinyint(3) unsigned NOT NULL,
1138 `icon1` int(10) unsigned NOT NULL,
1139 `icon2` int(10) unsigned NOT NULL,
1140 `icon3` int(10) unsigned NOT NULL,
1141 `icon4` int(10) unsigned NOT NULL,
1142 `icon5` int(10) unsigned NOT NULL,
1143 `icon6` int(10) unsigned NOT NULL,
1144 `icon7` int(10) unsigned NOT NULL,
1145 `icon8` int(10) unsigned NOT NULL,
1146 `groupType` tinyint(3) unsigned NOT NULL,
1147 `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
1148 `raiddifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
1149 PRIMARY KEY (`guid`),
1150 KEY `leaderGuid` (`leaderGuid`)
1151) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups';
1152
1153# Dumping data for table [chaos]_char.groups: ~0 rows (approximately)
1154DELETE FROM `groups`;
1155/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
1156/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
1157
1158
1159# Dumping structure for table [chaos]_char.group_instance
1160DROP TABLE IF EXISTS `group_instance`;
1161CREATE TABLE IF NOT EXISTS `group_instance` (
1162 `guid` int(10) unsigned NOT NULL DEFAULT '0',
1163 `instance` int(10) unsigned NOT NULL DEFAULT '0',
1164 `permanent` tinyint(3) unsigned NOT NULL DEFAULT '0',
1165 PRIMARY KEY (`guid`,`instance`),
1166 KEY `instance` (`instance`)
1167) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1168
1169# Dumping data for table [chaos]_char.group_instance: ~0 rows (approximately)
1170DELETE FROM `group_instance`;
1171/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
1172/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
1173
1174
1175# Dumping structure for table [chaos]_char.group_member
1176DROP TABLE IF EXISTS `group_member`;
1177CREATE TABLE IF NOT EXISTS `group_member` (
1178 `guid` int(10) unsigned NOT NULL,
1179 `memberGuid` int(10) unsigned NOT NULL,
1180 `memberFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
1181 `subgroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
1182 `roles` tinyint(3) unsigned NOT NULL DEFAULT '0',
1183 PRIMARY KEY (`memberGuid`)
1184) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups';
1185
1186# Dumping data for table [chaos]_char.group_member: ~0 rows (approximately)
1187DELETE FROM `group_member`;
1188/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
1189/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
1190
1191
1192# Dumping structure for table [chaos]_char.guild
1193DROP TABLE IF EXISTS `guild`;
1194CREATE TABLE IF NOT EXISTS `guild` (
1195 `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1196 `name` varchar(24) NOT NULL DEFAULT '',
1197 `leaderguid` int(10) unsigned NOT NULL DEFAULT '0',
1198 `EmblemStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
1199 `EmblemColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
1200 `BorderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
1201 `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
1202 `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
1203 `info` text NOT NULL,
1204 `motd` varchar(128) NOT NULL DEFAULT '',
1205 `createdate` int(10) unsigned NOT NULL DEFAULT '0',
1206 `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0',
1207 PRIMARY KEY (`guildid`)
1208) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
1209
1210# Dumping data for table [chaos]_char.guild: ~0 rows (approximately)
1211DELETE FROM `guild`;
1212/*!40000 ALTER TABLE `guild` DISABLE KEYS */;
1213/*!40000 ALTER TABLE `guild` ENABLE KEYS */;
1214
1215
1216# Dumping structure for table [chaos]_char.guild_bank_eventlog
1217DROP TABLE IF EXISTS `guild_bank_eventlog`;
1218CREATE TABLE IF NOT EXISTS `guild_bank_eventlog` (
1219 `guildid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator',
1220 `LogGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column',
1221 `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild bank TabId',
1222 `EventType` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Event type',
1223 `PlayerGuid` int(10) unsigned NOT NULL DEFAULT '0',
1224 `ItemOrMoney` int(10) unsigned NOT NULL DEFAULT '0',
1225 `ItemStackCount` smallint(5) unsigned NOT NULL DEFAULT '0',
1226 `DestTabId` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id',
1227 `TimeStamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time',
1228 PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
1229 KEY `guildid_key` (`guildid`),
1230 KEY `Idx_PlayerGuid` (`PlayerGuid`),
1231 KEY `Idx_LogGuid` (`LogGuid`)
1232) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1233
1234# Dumping data for table [chaos]_char.guild_bank_eventlog: ~0 rows (approximately)
1235DELETE FROM `guild_bank_eventlog`;
1236/*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
1237/*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
1238
1239
1240# Dumping structure for table [chaos]_char.guild_bank_item
1241DROP TABLE IF EXISTS `guild_bank_item`;
1242CREATE TABLE IF NOT EXISTS `guild_bank_item` (
1243 `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1244 `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1245 `SlotId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1246 `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
1247 PRIMARY KEY (`guildid`,`TabId`,`SlotId`),
1248 KEY `guildid_key` (`guildid`),
1249 KEY `Idx_item_guid` (`item_guid`)
1250) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1251
1252# Dumping data for table [chaos]_char.guild_bank_item: ~0 rows (approximately)
1253DELETE FROM `guild_bank_item`;
1254/*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
1255/*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
1256
1257
1258# Dumping structure for table [chaos]_char.guild_bank_right
1259DROP TABLE IF EXISTS `guild_bank_right`;
1260CREATE TABLE IF NOT EXISTS `guild_bank_right` (
1261 `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1262 `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1263 `rid` tinyint(3) unsigned NOT NULL DEFAULT '0',
1264 `gbright` tinyint(3) unsigned NOT NULL DEFAULT '0',
1265 `SlotPerDay` int(10) unsigned NOT NULL DEFAULT '0',
1266 PRIMARY KEY (`guildid`,`TabId`,`rid`),
1267 KEY `guildid_key` (`guildid`)
1268) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1269
1270# Dumping data for table [chaos]_char.guild_bank_right: ~0 rows (approximately)
1271DELETE FROM `guild_bank_right`;
1272/*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
1273/*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
1274
1275
1276# Dumping structure for table [chaos]_char.guild_bank_tab
1277DROP TABLE IF EXISTS `guild_bank_tab`;
1278CREATE TABLE IF NOT EXISTS `guild_bank_tab` (
1279 `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1280 `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1281 `TabName` varchar(16) NOT NULL DEFAULT '',
1282 `TabIcon` varchar(100) NOT NULL DEFAULT '',
1283 `TabText` varchar(500) DEFAULT NULL,
1284 PRIMARY KEY (`guildid`,`TabId`),
1285 KEY `guildid_key` (`guildid`)
1286) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1287
1288# Dumping data for table [chaos]_char.guild_bank_tab: ~0 rows (approximately)
1289DELETE FROM `guild_bank_tab`;
1290/*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
1291/*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
1292
1293
1294# Dumping structure for table [chaos]_char.guild_eventlog
1295DROP TABLE IF EXISTS `guild_eventlog`;
1296CREATE TABLE IF NOT EXISTS `guild_eventlog` (
1297 `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator',
1298 `LogGuid` int(10) unsigned NOT NULL COMMENT 'Log record identificator - auxiliary column',
1299 `EventType` tinyint(3) unsigned NOT NULL COMMENT 'Event type',
1300 `PlayerGuid1` int(10) unsigned NOT NULL COMMENT 'Player 1',
1301 `PlayerGuid2` int(10) unsigned NOT NULL COMMENT 'Player 2',
1302 `NewRank` tinyint(3) unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)',
1303 `TimeStamp` int(10) unsigned NOT NULL COMMENT 'Event UNIX time',
1304 PRIMARY KEY (`guildid`,`LogGuid`),
1305 KEY `Idx_PlayerGuid1` (`PlayerGuid1`),
1306 KEY `Idx_PlayerGuid2` (`PlayerGuid2`),
1307 KEY `Idx_LogGuid` (`LogGuid`)
1308) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Eventlog';
1309
1310# Dumping data for table [chaos]_char.guild_eventlog: ~0 rows (approximately)
1311DELETE FROM `guild_eventlog`;
1312/*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
1313/*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
1314
1315
1316# Dumping structure for table [chaos]_char.guild_member
1317DROP TABLE IF EXISTS `guild_member`;
1318CREATE TABLE IF NOT EXISTS `guild_member` (
1319 `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator',
1320 `guid` int(10) unsigned NOT NULL,
1321 `rank` tinyint(3) unsigned NOT NULL,
1322 `pnote` varchar(31) NOT NULL DEFAULT '',
1323 `offnote` varchar(31) NOT NULL DEFAULT '',
1324 `BankResetTimeMoney` int(10) unsigned NOT NULL DEFAULT '0',
1325 `BankRemMoney` int(10) unsigned NOT NULL DEFAULT '0',
1326 `BankResetTimeTab0` int(10) unsigned NOT NULL DEFAULT '0',
1327 `BankRemSlotsTab0` int(10) unsigned NOT NULL DEFAULT '0',
1328 `BankResetTimeTab1` int(10) unsigned NOT NULL DEFAULT '0',
1329 `BankRemSlotsTab1` int(10) unsigned NOT NULL DEFAULT '0',
1330 `BankResetTimeTab2` int(10) unsigned NOT NULL DEFAULT '0',
1331 `BankRemSlotsTab2` int(10) unsigned NOT NULL DEFAULT '0',
1332 `BankResetTimeTab3` int(10) unsigned NOT NULL DEFAULT '0',
1333 `BankRemSlotsTab3` int(10) unsigned NOT NULL DEFAULT '0',
1334 `BankResetTimeTab4` int(10) unsigned NOT NULL DEFAULT '0',
1335 `BankRemSlotsTab4` int(10) unsigned NOT NULL DEFAULT '0',
1336 `BankResetTimeTab5` int(10) unsigned NOT NULL DEFAULT '0',
1337 `BankRemSlotsTab5` int(10) unsigned NOT NULL DEFAULT '0',
1338 UNIQUE KEY `guid_key` (`guid`),
1339 KEY `guildid_key` (`guildid`),
1340 KEY `guildid_rank_key` (`guildid`,`rank`)
1341) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
1342
1343# Dumping data for table [chaos]_char.guild_member: ~0 rows (approximately)
1344DELETE FROM `guild_member`;
1345/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1346/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1347
1348
1349# Dumping structure for table [chaos]_char.guild_rank
1350DROP TABLE IF EXISTS `guild_rank`;
1351CREATE TABLE IF NOT EXISTS `guild_rank` (
1352 `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1353 `rid` tinyint(3) unsigned NOT NULL,
1354 `rname` varchar(20) NOT NULL DEFAULT '',
1355 `rights` mediumint(8) unsigned NOT NULL DEFAULT '0',
1356 `BankMoneyPerDay` int(10) unsigned NOT NULL DEFAULT '0',
1357 PRIMARY KEY (`guildid`,`rid`),
1358 KEY `Idx_rid` (`rid`)
1359) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
1360
1361# Dumping data for table [chaos]_char.guild_rank: ~0 rows (approximately)
1362DELETE FROM `guild_rank`;
1363/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1364/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1365
1366
1367# Dumping structure for table [chaos]_char.instance
1368DROP TABLE IF EXISTS `instance`;
1369CREATE TABLE IF NOT EXISTS `instance` (
1370 `id` int(10) unsigned NOT NULL DEFAULT '0',
1371 `map` smallint(5) unsigned NOT NULL DEFAULT '0',
1372 `resettime` int(10) unsigned NOT NULL DEFAULT '0',
1373 `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
1374 `completedEncounters` int(10) unsigned NOT NULL DEFAULT '0',
1375 `data` tinytext NOT NULL,
1376 PRIMARY KEY (`id`),
1377 KEY `map` (`map`),
1378 KEY `resettime` (`resettime`),
1379 KEY `difficulty` (`difficulty`)
1380) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1381
1382# Dumping data for table [chaos]_char.instance: ~0 rows (approximately)
1383DELETE FROM `instance`;
1384/*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1385/*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1386
1387
1388# Dumping structure for table [chaos]_char.instance_reset
1389DROP TABLE IF EXISTS `instance_reset`;
1390CREATE TABLE IF NOT EXISTS `instance_reset` (
1391 `mapid` smallint(5) unsigned NOT NULL DEFAULT '0',
1392 `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
1393 `resettime` int(10) unsigned NOT NULL DEFAULT '0',
1394 PRIMARY KEY (`mapid`,`difficulty`),
1395 KEY `difficulty` (`difficulty`)
1396) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1397
1398# Dumping data for table [chaos]_char.instance_reset: ~0 rows (approximately)
1399DELETE FROM `instance_reset`;
1400/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1401/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1402
1403
1404# Dumping structure for table [chaos]_char.item_instance
1405DROP TABLE IF EXISTS `item_instance`;
1406CREATE TABLE IF NOT EXISTS `item_instance` (
1407 `guid` int(10) unsigned NOT NULL DEFAULT '0',
1408 `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0',
1409 `owner_guid` int(10) unsigned NOT NULL DEFAULT '0',
1410 `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0',
1411 `giftCreatorGuid` int(10) unsigned NOT NULL DEFAULT '0',
1412 `count` int(10) unsigned NOT NULL DEFAULT '1',
1413 `duration` int(10) NOT NULL DEFAULT '0',
1414 `charges` tinytext,
1415 `flags` mediumint(8) unsigned NOT NULL DEFAULT '0',
1416 `enchantments` text NOT NULL,
1417 `randomPropertyId` smallint(5) NOT NULL DEFAULT '0',
1418 `durability` smallint(5) unsigned NOT NULL DEFAULT '0',
1419 `playedTime` int(10) unsigned NOT NULL DEFAULT '0',
1420 `text` text,
1421 PRIMARY KEY (`guid`),
1422 KEY `idx_owner_guid` (`owner_guid`)
1423) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item System';
1424
1425# Dumping data for table [chaos]_char.item_instance: ~0 rows (approximately)
1426DELETE FROM `item_instance`;
1427/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1428/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1429
1430
1431# Dumping structure for table [chaos]_char.item_refund_instance
1432DROP TABLE IF EXISTS `item_refund_instance`;
1433CREATE TABLE IF NOT EXISTS `item_refund_instance` (
1434 `item_guid` int(10) unsigned NOT NULL COMMENT 'Item GUID',
1435 `player_guid` int(10) unsigned NOT NULL COMMENT 'Player GUID',
1436 `paidMoney` int(10) unsigned NOT NULL DEFAULT '0',
1437 `paidExtendedCost` smallint(5) unsigned NOT NULL DEFAULT '0',
1438 PRIMARY KEY (`item_guid`,`player_guid`)
1439) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System';
1440
1441# Dumping data for table [chaos]_char.item_refund_instance: ~0 rows (approximately)
1442DELETE FROM `item_refund_instance`;
1443/*!40000 ALTER TABLE `item_refund_instance` DISABLE KEYS */;
1444/*!40000 ALTER TABLE `item_refund_instance` ENABLE KEYS */;
1445
1446
1447# Dumping structure for table [chaos]_char.item_soulbound_trade_data
1448DROP TABLE IF EXISTS `item_soulbound_trade_data`;
1449CREATE TABLE IF NOT EXISTS `item_soulbound_trade_data` (
1450 `itemGuid` int(10) unsigned NOT NULL COMMENT 'Item GUID',
1451 `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade',
1452 PRIMARY KEY (`itemGuid`)
1453) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System';
1454
1455# Dumping data for table [chaos]_char.item_soulbound_trade_data: ~0 rows (approximately)
1456DELETE FROM `item_soulbound_trade_data`;
1457/*!40000 ALTER TABLE `item_soulbound_trade_data` DISABLE KEYS */;
1458/*!40000 ALTER TABLE `item_soulbound_trade_data` ENABLE KEYS */;
1459
1460
1461# Dumping structure for table [chaos]_char.jail
1462DROP TABLE IF EXISTS `jail`;
1463CREATE TABLE IF NOT EXISTS `jail` (
1464 `guid` int(11) unsigned NOT NULL COMMENT 'GUID of the jail brother',
1465 `char` varchar(13) NOT NULL COMMENT 'Jailed charname',
1466 `release` int(11) unsigned NOT NULL COMMENT 'Release time for the char',
1467 `amnestietime` int(11) NOT NULL,
1468 `reason` varchar(255) NOT NULL COMMENT 'Reason for the jail',
1469 `times` int(11) unsigned NOT NULL COMMENT 'How many times this char already was jailed',
1470 `gmacc` int(11) unsigned NOT NULL COMMENT 'Used GM acc to jail this char',
1471 `gmchar` varchar(13) NOT NULL COMMENT 'Used GM char to jail this char',
1472 `lasttime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last time jailed',
1473 `duration` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Duration of the jail',
1474 PRIMARY KEY (`guid`)
1475) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Jail table for Trinitycore by WarHead Edited by SPGM';
1476
1477# Dumping data for table [chaos]_char.jail: 0 rows
1478DELETE FROM `jail`;
1479/*!40000 ALTER TABLE `jail` DISABLE KEYS */;
1480/*!40000 ALTER TABLE `jail` ENABLE KEYS */;
1481
1482
1483# Dumping structure for table [chaos]_char.jail_conf
1484DROP TABLE IF EXISTS `jail_conf`;
1485CREATE TABLE IF NOT EXISTS `jail_conf` (
1486 `id` int(11) NOT NULL AUTO_INCREMENT,
1487 `obt` varchar(50) DEFAULT NULL,
1488 `jail_conf` int(11) DEFAULT NULL,
1489 `jail_tele` float DEFAULT NULL,
1490 `help_ger` varchar(255) CHARACTER SET latin1 DEFAULT '',
1491 `help_enq` varchar(255) DEFAULT '',
1492 PRIMARY KEY (`id`)
1493) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
1494
1495# Dumping data for table [chaos]_char.jail_conf: 17 rows
1496DELETE FROM `jail_conf`;
1497/*!40000 ALTER TABLE `jail_conf` DISABLE KEYS */;
1498INSERT INTO `jail_conf` (`id`, `obt`, `jail_conf`, `jail_tele`, `help_ger`, `help_enq`) VALUES
1499 (1, 'm_jailconf_max_jails', 3, NULL, 'Hier legst ihre fest nach wie fielen Jails der Char gelöscht werden \r\nStandart = 3\r\n ', 'How many time the characters can be Jailed before being deleted\r\nDefault = 3'),
1500 (2, 'm_jailconf_max_duration', 672, NULL, 'Hier legst ihre fest wie hoch der maximale Jail Time in Stunden \r\nStandart = 672\r\n', 'Here put how high the maximum Jail Time in hours\r\nDefault = 672'),
1501 (3, 'm_jailconf_min_reason', 25, NULL, 'Hier legst ihre die minimalen Zeichen fest die als Grund angeben müsst \r\nStandart = 25\r\n\r\n', 'Here list how many characters are needed as the minimum reason\r\nDefault = 25'),
1502 (4, 'm_jailconf_warn_player', 1, NULL, 'Hier legst ihre fest wann der Char gewarnt wirt bevor er gelöscht wird \r\nStandart = 1\r\n', 'How many time to warn the player before jailing them\r\nDefault = 1'),
1503 (5, 'm_jailconf_amnestie', 180, NULL, '', 'This is how many in days when the Jail is status is set to 0\r\nStandard = 180 days (approximately Ë year)\r\n 0 days (off)'),
1504 (6, 'm_jailconf_ally_x', NULL, 31.7282, 'Teleport Alliance X Achse \r\nStandart = 31,7282\r\n', 'Teleport Alliance X Axis \r\nStandart = 31,7282\r\n'),
1505 (7, 'm_jailconf_ally_y', NULL, 135.794, 'Teleport Alliance Y Achse \r\nStandart = 135,794\r\n', 'Teleport Alliance Y Axis \r\nStandart = 135,794\r\n'),
1506 (8, 'm_jailconf_ally_z', NULL, -40.0508, 'Teleport Alliance Z Achse \r\nStandart = -40,0508', 'Teleport Alliance Z Axis \r\nStandart = -40,0508'),
1507 (9, 'm_jailconf_ally_o', NULL, 4.73516, 'Teleport Alliance blickrichtung\r\nStandart = 4,73516', 'Teleport Alliance Orientation\r\nStandart = 4,73516'),
1508 (10, 'm_jailconf_ally_m', 35, NULL, 'Teleport Alliance Mape\r\nStandart = 35', 'Teleport Alliance Map\r\nStandart = 35'),
1509 (11, 'm_jailconf_horde_x', NULL, 2179.85, 'Teleport Horde X Achse \r\nStandart = \r\n', 'Teleport Horde X Axis \r\nStandart = \r\n'),
1510 (12, 'm_jailconf_horde_y', NULL, -4763.96, 'Teleport Horde Y Achse \r\nStandart = -4763,96', 'Teleport Horde Y Axis \r\nStandart = -4763,96'),
1511 (13, 'm_jailconf_horde_z', NULL, 54.911, 'Teleport Horde Z Achse \r\nStandart = 54,911', 'Teleport Horde Z Axis \r\nStandart = 54,911'),
1512 (14, 'm_jailconf_horde_o', NULL, 4.44216, 'Teleport Horde blickrichtung\r\nStandart = 4,44216', 'Teleport Horde Orientation\r\nStandart = 4,44216'),
1513 (15, 'm_jailconf_horde_m', 1, NULL, 'Teleport Horde Mape\r\nStandart = 1', 'eleport Horde Map\r\nStandart = 1'),
1514 (16, 'm_jailconf_ban', 0, NULL, 'Nach wie vielen Jail soll der Account Gebant werden\r\nStandart = 0 (aus)\r\n', 'After how many jails the account will be Banned\r\nDefault = 0 (off)'),
1515 (17, 'm_jailconf_radius', 10, NULL, 'Legt den Bewegung Radius in Metern waren des Jails fest\r\nStandart = 10\r\n', 'Sets the range of motion in meters of the jail\r\nDefault = 10');
1516/*!40000 ALTER TABLE `jail_conf` ENABLE KEYS */;
1517
1518
1519# Dumping structure for table [chaos]_char.lag_reports
1520DROP TABLE IF EXISTS `lag_reports`;
1521CREATE TABLE IF NOT EXISTS `lag_reports` (
1522 `reportId` int(10) unsigned NOT NULL AUTO_INCREMENT,
1523 `guid` int(10) unsigned NOT NULL DEFAULT '0',
1524 `lagType` tinyint(3) unsigned NOT NULL DEFAULT '0',
1525 `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
1526 `posX` float NOT NULL DEFAULT '0',
1527 `posY` float NOT NULL DEFAULT '0',
1528 `posZ` float NOT NULL DEFAULT '0',
1529 PRIMARY KEY (`reportId`)
1530) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1531
1532# Dumping data for table [chaos]_char.lag_reports: ~0 rows (approximately)
1533DELETE FROM `lag_reports`;
1534/*!40000 ALTER TABLE `lag_reports` DISABLE KEYS */;
1535/*!40000 ALTER TABLE `lag_reports` ENABLE KEYS */;
1536
1537
1538# Dumping structure for table [chaos]_char.mail
1539DROP TABLE IF EXISTS `mail`;
1540CREATE TABLE IF NOT EXISTS `mail` (
1541 `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
1542 `messageType` tinyint(3) unsigned NOT NULL DEFAULT '0',
1543 `stationery` tinyint(3) NOT NULL DEFAULT '41',
1544 `mailTemplateId` smallint(5) unsigned NOT NULL DEFAULT '0',
1545 `sender` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1546 `receiver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1547 `subject` longtext,
1548 `body` longtext,
1549 `has_items` tinyint(3) unsigned NOT NULL DEFAULT '0',
1550 `expire_time` int(10) unsigned NOT NULL DEFAULT '0',
1551 `deliver_time` int(10) unsigned NOT NULL DEFAULT '0',
1552 `money` int(10) unsigned NOT NULL DEFAULT '0',
1553 `cod` int(10) unsigned NOT NULL DEFAULT '0',
1554 `checked` tinyint(3) unsigned NOT NULL DEFAULT '0',
1555 PRIMARY KEY (`id`),
1556 KEY `idx_receiver` (`receiver`)
1557) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Mail System';
1558
1559# Dumping data for table [chaos]_char.mail: ~0 rows (approximately)
1560DELETE FROM `mail`;
1561/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1562/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1563
1564
1565# Dumping structure for table [chaos]_char.mail_external
1566DROP TABLE IF EXISTS `mail_external`;
1567CREATE TABLE IF NOT EXISTS `mail_external` (
1568 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1569 `receiver` int(10) unsigned NOT NULL,
1570 `subject` varchar(200) DEFAULT 'Support Message',
1571 `message` varchar(200) DEFAULT '',
1572 `money` int(10) unsigned NOT NULL DEFAULT '0',
1573 `item` int(10) unsigned NOT NULL DEFAULT '0',
1574 `item_count` int(10) unsigned NOT NULL DEFAULT '0',
1575 PRIMARY KEY (`id`)
1576) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1577
1578# Dumping data for table [chaos]_char.mail_external: 0 rows
1579DELETE FROM `mail_external`;
1580/*!40000 ALTER TABLE `mail_external` DISABLE KEYS */;
1581/*!40000 ALTER TABLE `mail_external` ENABLE KEYS */;
1582
1583
1584# Dumping structure for table [chaos]_char.mail_items
1585DROP TABLE IF EXISTS `mail_items`;
1586CREATE TABLE IF NOT EXISTS `mail_items` (
1587 `mail_id` int(10) unsigned NOT NULL DEFAULT '0',
1588 `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
1589 `receiver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1590 PRIMARY KEY (`item_guid`),
1591 KEY `idx_receiver` (`receiver`),
1592 KEY `idx_mail_id` (`mail_id`)
1593) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1594
1595# Dumping data for table [chaos]_char.mail_items: ~0 rows (approximately)
1596DELETE FROM `mail_items`;
1597/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1598/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1599
1600
1601# Dumping structure for table [chaos]_char.petition
1602DROP TABLE IF EXISTS `petition`;
1603CREATE TABLE IF NOT EXISTS `petition` (
1604 `ownerguid` int(10) unsigned NOT NULL,
1605 `petitionguid` int(10) unsigned DEFAULT '0',
1606 `name` varchar(24) NOT NULL,
1607 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
1608 PRIMARY KEY (`ownerguid`,`type`),
1609 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1610) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
1611
1612# Dumping data for table [chaos]_char.petition: ~0 rows (approximately)
1613DELETE FROM `petition`;
1614/*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1615/*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1616
1617
1618# Dumping structure for table [chaos]_char.petition_sign
1619DROP TABLE IF EXISTS `petition_sign`;
1620CREATE TABLE IF NOT EXISTS `petition_sign` (
1621 `ownerguid` int(10) unsigned NOT NULL,
1622 `petitionguid` int(10) unsigned NOT NULL DEFAULT '0',
1623 `playerguid` int(10) unsigned NOT NULL DEFAULT '0',
1624 `player_account` int(10) unsigned NOT NULL DEFAULT '0',
1625 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
1626 PRIMARY KEY (`petitionguid`,`playerguid`),
1627 KEY `Idx_playerguid` (`playerguid`),
1628 KEY `Idx_ownerguid` (`ownerguid`)
1629) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
1630
1631# Dumping data for table [chaos]_char.petition_sign: ~0 rows (approximately)
1632DELETE FROM `petition_sign`;
1633/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1634/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1635
1636
1637# Dumping structure for table [chaos]_char.pet_aura
1638DROP TABLE IF EXISTS `pet_aura`;
1639CREATE TABLE IF NOT EXISTS `pet_aura` (
1640 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1641 `caster_guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
1642 `spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
1643 `effect_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
1644 `recalculate_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
1645 `stackcount` tinyint(3) unsigned NOT NULL DEFAULT '1',
1646 `amount0` mediumint(8) NOT NULL,
1647 `amount1` mediumint(8) NOT NULL,
1648 `amount2` mediumint(8) NOT NULL,
1649 `base_amount0` mediumint(8) NOT NULL,
1650 `base_amount1` mediumint(8) NOT NULL,
1651 `base_amount2` mediumint(8) NOT NULL,
1652 `maxduration` int(11) NOT NULL DEFAULT '0',
1653 `remaintime` int(11) NOT NULL DEFAULT '0',
1654 `remaincharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
1655 PRIMARY KEY (`guid`,`spell`,`effect_mask`)
1656) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
1657
1658# Dumping data for table [chaos]_char.pet_aura: ~0 rows (approximately)
1659DELETE FROM `pet_aura`;
1660/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1661/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1662
1663
1664# Dumping structure for table [chaos]_char.pet_spell
1665DROP TABLE IF EXISTS `pet_spell`;
1666CREATE TABLE IF NOT EXISTS `pet_spell` (
1667 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1668 `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
1669 `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
1670 PRIMARY KEY (`guid`,`spell`)
1671) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
1672
1673# Dumping data for table [chaos]_char.pet_spell: ~0 rows (approximately)
1674DELETE FROM `pet_spell`;
1675/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1676/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1677
1678
1679# Dumping structure for table [chaos]_char.pet_spell_cooldown
1680DROP TABLE IF EXISTS `pet_spell_cooldown`;
1681CREATE TABLE IF NOT EXISTS `pet_spell_cooldown` (
1682 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
1683 `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
1684 `time` int(10) unsigned NOT NULL DEFAULT '0',
1685 PRIMARY KEY (`guid`,`spell`)
1686) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1687
1688# Dumping data for table [chaos]_char.pet_spell_cooldown: ~0 rows (approximately)
1689DELETE FROM `pet_spell_cooldown`;
1690/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1691/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1692
1693
1694# Dumping structure for table [chaos]_char.players_reports_status
1695DROP TABLE IF EXISTS `players_reports_status`;
1696CREATE TABLE IF NOT EXISTS `players_reports_status` (
1697 `guid` int(10) unsigned NOT NULL DEFAULT '0',
1698 `creation_time` int(10) unsigned NOT NULL DEFAULT '0',
1699 `average` float NOT NULL DEFAULT '0',
1700 `total_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
1701 `speed_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
1702 `fly_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
1703 `jump_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
1704 `waterwalk_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
1705 `teleportplane_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
1706 `climb_reports` bigint(20) unsigned NOT NULL DEFAULT '0',
1707 PRIMARY KEY (`guid`)
1708) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1709
1710# Dumping data for table [chaos]_char.players_reports_status: ~0 rows (approximately)
1711DELETE FROM `players_reports_status`;
1712/*!40000 ALTER TABLE `players_reports_status` DISABLE KEYS */;
1713/*!40000 ALTER TABLE `players_reports_status` ENABLE KEYS */;
1714
1715
1716# Dumping structure for table [chaos]_char.pool_quest_save
1717DROP TABLE IF EXISTS `pool_quest_save`;
1718CREATE TABLE IF NOT EXISTS `pool_quest_save` (
1719 `pool_id` int(10) unsigned NOT NULL DEFAULT '0',
1720 `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
1721 PRIMARY KEY (`pool_id`,`quest_id`)
1722) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1723
1724# Dumping data for table [chaos]_char.pool_quest_save: ~0 rows (approximately)
1725DELETE FROM `pool_quest_save`;
1726/*!40000 ALTER TABLE `pool_quest_save` DISABLE KEYS */;
1727/*!40000 ALTER TABLE `pool_quest_save` ENABLE KEYS */;
1728
1729
1730# Dumping structure for table [chaos]_char.reserved_name
1731DROP TABLE IF EXISTS `reserved_name`;
1732CREATE TABLE IF NOT EXISTS `reserved_name` (
1733 `name` varchar(12) NOT NULL DEFAULT '',
1734 PRIMARY KEY (`name`)
1735) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names';
1736
1737# Dumping data for table [chaos]_char.reserved_name: ~0 rows (approximately)
1738DELETE FROM `reserved_name`;
1739/*!40000 ALTER TABLE `reserved_name` DISABLE KEYS */;
1740/*!40000 ALTER TABLE `reserved_name` ENABLE KEYS */;
1741
1742
1743# Dumping structure for table [chaos]_char.worldstates
1744DROP TABLE IF EXISTS `worldstates`;
1745CREATE TABLE IF NOT EXISTS `worldstates` (
1746 `entry` int(10) unsigned NOT NULL DEFAULT '0',
1747 `value` int(10) unsigned NOT NULL DEFAULT '0',
1748 `comment` tinytext,
1749 PRIMARY KEY (`entry`)
1750) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variable Saves';
1751
1752# Dumping data for table [chaos]_char.worldstates: ~4 rows (approximately)
1753DELETE FROM `worldstates`;
1754/*!40000 ALTER TABLE `worldstates` DISABLE KEYS */;
1755INSERT INTO `worldstates` (`entry`, `value`, `comment`) VALUES
1756 (20001, 0, 'NextArenaPointDistributionTime'),
1757 (20002, 0, 'NextWeeklyQuestResetTime'),
1758 (20003, 0, 'NextBGRandomDailyResetTime'),
1759 (20004, 0, 'cleaning_flags');
1760/*!40000 ALTER TABLE `worldstates` ENABLE KEYS */;
1761/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1762/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1763/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;