pf10GNP9

1DROP TABLE IF EXISTS `raid_instance_tiles`;
2CREATE TABLE IF NOT EXISTS `raid_instance_tiles` (
3  `instance_id` int(255) NOT NULL,
4  `x` int(4) NOT NULL,
5  `y` int(4) NOT NULL,
6  `z` int(4) NOT NULL,
7  `hidden` int(2) NOT NULL DEFAULT '0',
8  `wall` int(2) NOT NULL DEFAULT '0',
9  `objective_id` int(255) NOT NULL DEFAULT '0',
10  `objective_hp` int(6) NOT NULL DEFAULT '0',
11  `objective_max_hp` int(6) NOT NULL DEFAULT '100',
12  `movable` int(1) NOT NULL DEFAULT '0',
13  `search_items` text NOT NULL,
14  `teleports` int(1) NOT NULL DEFAULT '0',
15  `teleport_x` int(4) NOT NULL,
16  `teleport_y` int(4) NOT NULL,
17  `teleport_z` int(4) NOT NULL,
18  `interact` varchar(40) NOT NULL,
19  `on_interact` text NOT NULL,
20  `on_tile_enter` text NOT NULL,
21  `on_move` text NOT NULL
22  PRIMARY KEY (`instance_id`,`x`,`y`,`z`)
23) ENGINE=MyISAM DEFAULT CHARSET=latin1;
24
25DROP TABLE IF EXISTS `raid_maps`;
26CREATE TABLE IF NOT EXISTS `raid_maps` (
27  `raid_id` int(255) NOT NULL,
28  `z` int(3) NOT NULL DEFAULT '0'
29  `map_image` varchar(200) NOT NULL,
30  `columns` int(4) NOT NULL DEFAULT '15',
31  `rows` int(4) NOT NULL DEFAULT '15',
32  `static_walls` text NOT NULL,
33  `static_floors` text NOT NULL
34  PRIMARY KEY (`raid_id`,`z`)
35) ENGINE=MyISAM DEFAULT CHARSET=latin1;
36
37INSERT INTO `raid_maps` (`raid_id`, `z`, `map_image`, `columns`, `rows`, `static_walls`, `static_floors`) VALUES
38(1, 0, 'map-alt.png', 15, 15, '', '0,9#1,9#2,9#3,9#4,9#5,9#6,9#7,9#8,9#9,9#10,9#11,9#7,7#8,7#7,8#8,8#7,9#8,9#7,10#8,10#7,11#8,11#11,8#11,7#11,6#11,5#11,4#11,3#11,2#10,4#10,3#10,2#12,4#12,3#12,2'),
39(3, 0, 'trials/big_map.png', 25, 25, '21,11#22,11#21,12#22,10#20,13#21,13#20,14#20,15#19,16#22,9#13,12#14,12#13,13#14,13#14,14#12,12#15,13#13,14#15,12#10,1#10,2#10,3#14,1#14,2#14,3#11,5#13,5#9,0#15,0#9,4#15,4#10,5#14,5#7,15#7,16#7,17#7,18#7,19#7,20#7,21#7,22#7,23#7,24#0,14#1,15#2,16#0,17#1,17#5,15#6,14#4,16#5,17#6,17#3,18#3,20#3,22#4,23#5,24#2,23#1,24#0,23#6,23#2,17#4,17', ''),
40(4, 0, 'christmas/winter_is_coming.png', 15, 15, '0,0#2,3#2,4#3,4#2,5#3,5#9,14#10,14#11,13#11,14#12,12#12,13#12,14#13,11#13,12#13,13#13,14#14,12#14,13#14,14#4,11#4,12#4,13#5,10#6,11#6,12#6,13#5,13#12,11#11,12#9,6#8,7#8,8#10,7#10,8#8,9#10,9#12,8#12,9#10,3#10,4#12,3#12,4#11,5', '');
41
42DROP TABLE IF EXISTS `raid_maps_ai_data`;
43CREATE TABLE IF NOT EXISTS `raid_maps_ai_data` (
44  `id` int(255) NOT NULL AUTO_INCREMENT,
45  `entity_id` varchar(30) NOT NULL
46  `raid_id` int(255) NOT NULL,
47  `state` int(3) NOT NULL DEFAULT '0',
48  `x` int(3) NOT NULL,
49  `y` int(3) NOT NULL,
50  `z` int(3) NOT NULL DEFAULT '0',
51  `hidden` int(2) NOT NULL DEFAULT '0',
52  `dest_x` int(3) NOT NULL DEFAULT '0',
53  `dest_y` int(3) NOT NULL DEFAULT '0',
54  `dest_z` int(3) NOT NULL DEFAULT '0',
55  `ai_id` int(255) NOT NULL,
56  `ai_count` int(3) NOT NULL DEFAULT '0',
57  `hostile` int(1) NOT NULL DEFAULT '1',
58  `player_cannot_move` int(11) NOT NULL DEFAULT '0'
59  `interact` varchar(40) NOT NULL DEFAULT '',
60  `patrol_route` varchar(300) NOT NULL,
61  `on_interact` text NOT NULL,
62  `on_defeat` text NOT NULL,
63  PRIMARY KEY (`id`),
64  KEY `map_id` (`raid_id`),
65  KEY `y` (`y`,`z`,`x`),
66  KEY `map_id_2` (`raid_id`),
67  KEY `entity_id` (`entity_id`,`raid_id`)
68) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
69
70INSERT INTO `raid_maps_ai_data` (`id`, `entity_id`, `raid_id`, `state`, `x`, `y`, `z`, `hidden`, `dest_x`, `dest_y`, `dest_z`, `ai_id`, `ai_count`, `hostile`, `player_cannot_move`, `interact`, `patrol_route`, `on_interact`, `on_defeat`) VALUES
71(1, '', 1, 0, 7, 7, 0, 0, 0, 0, 0, 3, 2, 1, 0, '', '', '', ''),
72(2, '', 1, 0, 8, 11, 0, 0, 0, 0, 0, 4, 2, 1, 0, '', '', '', ''),
73(3, '', 1, 0, 11, 3, 0, 0, 0, 0, 0, 5, 1, 0, 0, 'Observe', '', 'endRaidSuccess', ''),
74(4, '', 2, 0, 0, 2, 2, 0, 0, 0, 0, 2, 1, 1, 0, '', '', '', ''),
75(5, '', 3, 0, 21, 3, 0, 0, 0, 0, 0, 8, 1, 1, 0, 'Talk', '', 'checkFlag:npc2##flag:npc3##endCondition', ''),
76(6, '', 3, 0, 23, 3, 0, 0, 0, 0, 0, 10, 1, 1, 0, 'Talk', '', 'checkFlag:npc4##flag:npc5##endCondition', ''),
77(7, '', 3, 0, 23, 5, 0, 0, 0, 0, 0, 2, 1, 1, 0, '', '', '', ''),
78(8, '', 3, 0, 21, 5, 0, 0, 0, 0, 0, 7, 1, 1, 0, 'Talk', '', 'checkFlag:npc1##flag:npc2##endCondition', ''),
79(9, '', 3, 0, 23, 7, 0, 0, 0, 0, 0, 12, 1, 1, 0, 'Talk', '', 'checkFlag:npc5##flag:npc6##flag:task1Completed##sendClientMsg:Correct##endCondition', ''),
80(10, '', 3, 0, 21, 7, 0, 0, 0, 0, 0, 1, 1, 1, 0, 'Talk', '', '', ''),
81(11, '', 3, 0, 19, 3, 0, 0, 0, 0, 0, 6, 1, 1, 0, 'Talk', '', 'flag:npc1', ''),
82(12, '', 3, 0, 19, 5, 0, 0, 0, 0, 0, 11, 1, 1, 0, '', '', '', ''),
83(13, '', 3, 0, 19, 7, 0, 0, 0, 0, 0, 9, 1, 1, 0, 'Talk', '', 'checkFlag:npc3##flag:npc4##endCondition', ''),
84(14, '', 3, 1, 17, 17, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 's,s,s,s,s,s,e,e,e,e,e,e,n,n,n,n,n,n,w,w,w,w,w,w', '', ''),
85(15, '', 3, 1, 17, 20, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 's,s,s,e,e,e,e,e,e,n,n,n,n,n,n,w,w,w,w,w,w,s,s,s', '', ''),
86(16, '', 3, 1, 17, 23, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'e,e,e,e,e,e,n,n,n,n,n,n,w,w,w,w,w,w,s,s,s,s,s,s', '', ''),
87(17, '', 3, 1, 23, 17, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'w,w,w,w,w,w,s,s,s,s,s,s,e,e,e,e,e,e,n,n,n,n,n,n', '', ''),
88(18, '', 3, 1, 23, 20, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'n,n,n,w,w,w,w,w,w,s,s,s,s,s,s,e,e,e,e,e,e,n,n,n', '', ''),
89(19, '', 3, 1, 23, 23, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'n,n,n,n,n,n,w,w,w,w,w,w,s,s,s,s,s,s,e,e,e,e,e,e', '', ''),
90(20, '', 3, 1, 20, 19, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'e,s,s,w,w,n,n,e', '', ''),
91(21, '', 3, 1, 20, 21, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'w,n,n,e,e,s,s,w', '', ''),
92(22, '', 4, 0, 9, 8, 0, 0, 0, 0, 0, 14, 1, 1, 0, '', '', '', 'endRaidSuccess##showTile:9,,7##teachRecipe:Homemade Pie##sendClientMsg:<font class=warOther>You defeat what many thought was Santa Claus but was in fact a weird creature whose true form revealed itself as his body disappears.</font>'),
93(23, '', 4, 0, 11, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
94(24, '', 4, 0, 9, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:The.. key.. lies.. in.. his.. reci..', ''),
95(25, '', 4, 0, 4, 4, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
96(26, '', 4, 0, 1, 4, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
97(27, '', 4, 0, 1, 6, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
98(28, '', 4, 0, 3, 3, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
99(29, '', 4, 0, 3, 6, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
100(31, '', 4, 0, 0, 7, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled3'),
101(32, '', 4, 0, 7, 14, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled2'),
102(33, '', 4, 0, 14, 7, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled1'),
103(34, '', 4, 0, 13, 7, 0, 0, 0, 0, 0, 17, 1, 1, 0, 'Talk', '', 'sendClientMsg:This thing scares me.. and so does he. Our powers are not enough. But I fear he is a harbinger for something ..else.', 'flag:elfKilled1'),
104(35, '', 4, 0, 7, 13, 0, 0, 0, 0, 0, 17, 1, 1, 0, 'Talk', '', 'sendClientMsg:We were brought here from a different world to help with his facade.. he is an imposter.', 'flag:elfKilled2'),
105(36, '', 4, 0, 0, 8, 0, 0, 0, 0, 0, 17, 1, 1, 0, 'Talk', '', 'sendClientMsg:This land is wicked and true evil roams it. We are too powerless. Please help us.', 'flag:elfKilled3'),
106(37, '', 4, 0, 7, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
107(38, '', 4, 0, 8, 11, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:I.. am.. not.. in.. control.', ''),
108(39, '', 4, 0, 10, 11, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
109(40, '', 4, 0, 9, 12, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:I.. am.. drifting.', ''),
110(41, 'granny', 4, 0, 5, 11, 0, 1, 0, 0, 0, 20, 1, 1, 0, '', '', '', 'removeBuff:holidaySpirit##endRaidSuccess');
111
112DROP TABLE IF EXISTS `raid_maps_tiles_data`;
113CREATE TABLE IF NOT EXISTS `raid_maps_tiles_data` (
114  `raid_id` int(255) NOT NULL,
115  `x` int(4) NOT NULL,
116  `y` int(4) NOT NULL,
117  `z` int(4) NOT NULL DEFAULT '0',
118  `hidden` int(2) NOT NULL DEFAULT '0',
119  `wall` int(2) NOT NULL DEFAULT '0',
120  `objective_id` int(255) NOT NULL DEFAULT '0',
121  `objective_max_hp` int(6) NOT NULL DEFAULT '100',
122  `movable` int(1) NOT NULL DEFAULT '0',
123  `search_items` text NOT NULL,
124  `teleports` int(1) NOT NULL DEFAULT '0',
125  `teleport_x` int(4) NOT NULL,
126  `teleport_y` int(4) NOT NULL,
127  `teleport_z` int(4) NOT NULL,
128  `interact` varchar(40) NOT NULL,
129  `on_interact` text NOT NULL,
130  `on_tile_enter` text NOT NULL,
131  `on_move` text NOT NULL
132  PRIMARY KEY (`raid_id`,`x`,`y`,`z`)
133) ENGINE=MyISAM DEFAULT CHARSET=latin1;
134
135INSERT INTO `raid_maps_tiles_data` (`raid_id`, `x`, `y`, `z`, `hidden`, `wall`, `objective_id`, `objective_max_hp`, `movable`, `search_items`, `teleports`, `teleport_x`, `teleport_y`, `teleport_z`, `interact`, `on_interact`, `on_tile_enter`, `on_move`) VALUES
136(1, 1, 9, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is your future.##flag:done', ''),
137(1, 3, 9, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is also your past.', ''),
138(1, 7, 7, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Those who are left alive.. will no longer be alive.', ''),
139(1, 8, 11, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is what you will become.\r\n', ''),
140(1, 11, 8, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:We do not interfere.', ''),
141(1, 11, 7, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:We only observe.', ''),
142(1, 11, 6, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:But now you have observed.', ''),
143(1, 11, 5, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Will you interfere?', ''),
144(1, 11, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Tell me...', ''),
145(1, 11, 3, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:..<font class=itemPhantom><b>Observer</b></font>.', ''),
146(3, 10, 0, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:2', ''),
147(3, 10, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:3', ''),
148(3, 14, 0, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:5', ''),
149(3, 14, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:4', ''),
150(3, 18, 19, 0, 0, 0, 6, 100, 1, '', 0, 0, 0, 0, '', '', '', ''),
151(3, 1, 18, 0, 0, 0, 7, 100, 0, '', 1, 5, 21, 0, '', '', '', ''),
152(3, 1, 20, 0, 0, 0, 7, 100, 0, '', 1, 1, 19, 0, '', '', '', ''),
153(3, 0, 19, 0, 0, 0, 7, 100, 0, '', 1, 1, 23, 0, '', '', '', ''),
154(3, 2, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
155(3, 0, 21, 0, 0, 0, 7, 100, 0, '', 1, 1, 19, 0, '', '', '', ''),
156(3, 2, 21, 0, 0, 0, 7, 100, 0, '', 1, 3, 19, 0, '', '', '', ''),
157(3, 1, 22, 0, 0, 0, 7, 100, 0, '', 1, 2, 18, 0, '', '', '', ''),
158(3, 4, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 24, 0, '', '', '', ''),
159(3, 6, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
160(3, 4, 21, 0, 0, 0, 7, 100, 0, '', 1, 5, 23, 0, '', '', '', ''),
161(3, 6, 21, 0, 0, 0, 7, 100, 0, '', 1, 2, 22, 0, '', '', '', ''),
162(3, 5, 22, 0, 0, 0, 7, 100, 0, '', 1, 5, 19, 0, '', '', '', ''),
163(3, 5, 18, 0, 0, 0, 7, 100, 0, '', 1, 4, 20, 0, '', '', '', ''),
164(3, 5, 20, 0, 0, 0, 7, 100, 0, '', 1, 3, 21, 0, '', '', '', ''),
165(3, 3, 17, 0, 0, 0, 7, 100, 0, '', 1, 0, 22, 0, '', '', '', ''),
166(3, 4, 24, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
167(3, 2, 24, 0, 0, 0, 0, 100, 0, '', 1, 5, 16, 0, '', '', '', ''),
168(3, 6, 16, 0, 0, 0, 0, 100, 0, '', 1, 1, 16, 0, '', '', '', ''),
169(3, 0, 15, 0, 0, 0, 0, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
170(3, 0, 16, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'flag:task3Secret\r\n', ''),
171(4, 5, 11, 0, 0, 0, 8, 100, 0, '', 0, 0, 0, 0, 'Desecrate', 'despawnObjective##showAI:granny', '', ''),
172(4, 14, 11, 0, 0, 0, 10, 100, 0, '', 0, 0, 0, 0, 'Eat (+60HP)', 'checkFlag:elfKilled1##sendClientMsg:You eat the cane but you feel nothing from it.. almost as if the source of its magic is gone.##elseCondition##checkFlag:mimicKilled1##sendClientMsg:The disappearance of a nearby mimic strengthens the effect of this candy cane.##heal:100##elseCondition##heal:60##endCondition##endCondition##despawnObjective', '', ''),
173(4, 9, 11, 0, 0, 0, 10, 100, 0, '', 0, 0, 0, 0, 'Eat (+60HP)', 'checkFlag:elfKilled2##sendClientMsg:You eat the cane but you feel nothing from it.. almost as if the source of its magic is gone.##elseCondition##checkFlag:mimicKilled2##sendClientMsg:The disappearance of a nearby mimic strengthens the effect of this candy cane.##heal:100##elseCondition##heal:60##endCondition##endCondition##despawnObjective', '', ''),
174(4, 2, 10, 0, 0, 0, 10, 100, 0, '', 0, 0, 0, 0, 'Eat (+60HP)', 'checkFlag:elfKilled3##sendClientMsg:You eat the cane but you feel nothing from it.. almost as if the source of its magic is gone.##elseCondition##checkFlag:mimicKilled3##sendClientMsg:The disappearance of a nearby mimic strengthens the effect of this candy cane.##heal:100##elseCondition##heal:60##endCondition##endCondition##despawnObjective', '', ''),
175(4, 4, 0, 0, 0, 0, 9, 100, 0, '', 0, 0, 0, 0, 'Open', 'sendClientMsg: You find a note that says "We have left some canes that should replenish your health, should you need it!" - The Elves.##despawnObjective', '', ''),
176(4, 9, 7, 0, 1, 0, 11, 100, 0, '', 0, 0, 0, 0, '', '', 'checkBuff:holidaySpirit##despawnObjective:11,,2##spawnAI:19,,11,,2##showTile:5,,12##spawnObjective:16##sendClientMsg:Somewhere in the distance you hear the sound of ice cracking.##elseCondition##sendClientMsg:Nothing happens as you step on the strange platform.##endCondition', ''),
177(4, 5, 12, 0, 1, 0, 12, 100, 0, '', 1, 11, 2, 0, '', '', '', ''),
178(4, 11, 3, 0, 0, 0, 14, 100, 0, '', 0, 0, 0, 0, '', '', '', ''),
179(4, 11, 4, 0, 0, 0, 15, 100, 0, '', 1, 5, 11, 0, '', '', '', ''),
180(4, 11, 2, 0, 0, 1, 13, 100, 0, '', 0, 0, 0, 0, '', '', '', '');
181
182DROP TABLE IF EXISTS `raid_objectives`;
183CREATE TABLE IF NOT EXISTS `raid_objectives` (
184  `id` int(255) NOT NULL AUTO_INCREMENT,
185  `name` varchar(40) NOT NULL,
186  `image` varchar(200) NOT NULL,
187  PRIMARY KEY (`id`)
188) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
189
190INSERT INTO `raid_objectives` (`id`, `name`, `image`) VALUES
191(1, 'Strange Hive', 'warfare/strangehive.gif'),
192(2, 'Platform', 'raids/objectives/trials/knowledge.png'),
193(3, 'Platform', 'raids/objectives/trials/strength.png'),
194(4, 'Platform', 'raids/objectives/trials/history.png'),
195(5, 'Platform', 'raids/objectives/trials/courage.png'),
196(6, 'Strange Platform', 'raids/objectives/trials/sequence_platform4.png'),
197(7, 'Teleporter', 'raids/objectives/trials/teleporter.png'),
198(8, 'Strange Grave', 'raids/objectives/christmas/grave.png'),
199(9, 'Gift', 'raids/objectives/christmas/gift.png'),
200(10, 'Candy Cane', 'raids/objectives/christmas/candy_cane.png'),
201(11, 'Platform', 'raids/objectives/christmas/nose_meh.png'),
202(12, 'Portal', 'raids/objectives/christmas/portal.png'),
203(13, 'Ice Block', 'raids/objectives/christmas/frozen.png'),
204(14, 'Snow Trail', 'raids/objectives/christmas/snow_trail.png'),
205(15, 'Crashed Sleigh', 'raids/objectives/christmas/crashed_sleigh.png'),
206(16, 'Activated Platform', 'raids/objectives/christmas/nose_activated.png');
207
208DROP TABLE IF EXISTS `raid_players`;
209CREATE TABLE IF NOT EXISTS `raid_players` (
210  `id` bigint(20) NOT NULL AUTO_INCREMENT,
211  `account` varchar(10) DEFAULT NULL,
212  `instance_id` bigint(20) NOT NULL,
213  `team` int(4) NOT NULL DEFAULT '1',
214  `x` int(3) NOT NULL DEFAULT '0',
215  `y` int(3) NOT NULL DEFAULT '0',
216  `z` int(3) NOT NULL DEFAULT '0',
217  `last_active` datetime NOT NULL,
218  `rewards` text NOT NULL,
219  PRIMARY KEY (`id`),
220  UNIQUE KEY `UNIQUE` (`account`),
221  KEY `INDEX` (`instance_id`)
222) ENGINE=InnoDB AUTO_INCREMENT=384 DEFAULT CHARSET=latin1;
223
224DROP TABLE IF EXISTS `raid_player_rewards`;
225CREATE TABLE IF NOT EXISTS `raid_player_rewards` (
226  `account_id` bigint(20) NOT NULL,
227  `raid_id` int(255) NOT NULL,
228  `time_taken_secs` int(40) NOT NULL DEFAULT '0',
229  `rewards_to_claim` text NOT NULL,
230  `hourly_cooldown` int(1) NOT NULL DEFAULT '0',
231  `daily_cooldown` int(1) NOT NULL DEFAULT '0',
232  `weekly_cooldown` int(1) NOT NULL DEFAULT '0',
233  `claimed` int(1) NOT NULL DEFAULT '0',
234  `raid_completed` int(1) NOT NULL DEFAULT '0',
235  PRIMARY KEY (`account_id`,`raid_id`)
236) ENGINE=MyISAM DEFAULT CHARSET=latin1;
237COMMIT;