KLJ3XH5N

1,0000000000000000x\r
2
3\nx1111100000000000000000x\r\nx1111100000000000000000x\r
4
5\nx1111100000000000000000x\r\nx1111100000000000000000x\r
6
7\nx1111100000000000000000x\r\nx1111100000000000000000x\r
8
9\nx1111100000000000000000x\r\nx1111100000000000000000x\r
10
11\nx1111100000000000000000x\r\nx1111100000000000000000x\r
12
13\nx1111100000000000000000x\r\nx1111100000000000000000x\r
14
15\nx1111100000000000000000x\r\nx1111100000000000000000x\r
16
17\n11111100000000000000000x\r\nx1111100000000000000000x\r
18
19\nx1111100000000000000000x\r\nx1111100000000000000000x\r
20
21\nx1111100000000000000000x\r\nx1111100000000000000000x\r
22
23\nx1111100000000000000000x\r\nx1111100000000000000000x\r
24
25\nx1111100000000000000000x\r\nx1111100000000000000000x\r
26
27\nx1111100000000000000000x\r\nx1111100000000000000000x\r
28
29\nx1111100000000000000000x\r\nx1111100000000000000000x\r
30
31\nx1111100000000000000000x\r\nx1111100000000000000000x\r
32
33\nx1111100000000000000000x\r\nx1111100000000000000000x\r
34
35\nxxxxxxxxxxxxxxxxxxxxxxxx', '', '1'),
36('model_y', 0, 3, 0, 2, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxx\r
37
38\nx00000000xx0000000000xx0000x\r\nx00000000xx0000000000xx0000x
39
40\r\n000000000xx0000000000xx0000x\r
41
42\nx00000000xx0000000000xx0000x\r\nx00000000xx0000xx0000xx0000x
43
44\r\nx00000000xx0000xx0000xx0000x\r
45
46\nx00000000xx0000xx0000000000x\r\nx00000000xx0000xx0000000000x
47
48\r\nxxxxx0000xx0000xx0000000000x\r
49
50\nxxxxx0000xx0000xx0000000000x\r\nxxxxx0000xx0000xxxxxxxxxxxxx
51
52\r\nxxxxx0000xx0000xxxxxxxxxxxxx\r
53
54\nx00000000xx0000000000000000x\r\nx00000000xx0000000000000000x
55
56\r\nx00000000xx0000000000000000x\r
57
58\nx00000000xx0000000000000000x\r\nx0000xxxxxxxxxxxxxxxxxx0000x
59
60\r\nx0000xxxxxxxxxxxxxxxxxx0000x\r
61
62\nx00000000000000000000000000x\r\nx00000000000000000000000000x
63
64\r\nx00000000000000000000000000x\r
65
66\nx00000000000000000000000000x\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 
67
68'', '1'),
69('model_oscar', 0, 15, 1, 2, 
70
71'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
72
73x\r
74
75\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
76
77xx\r
78
79\nxxxxxxxxx11111111xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
80
81xx\r
82
83\nxxxxxxxxx11111111xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
84
85xx\r
86
87\nxxxxxxxxx11111111xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
88
89xx\r
90
91\nxxxxxxxxx11111111xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
92
93xx\r
94
95\nxxxxxxxxx11111111xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
96
97xx\r
98
99\nxxxxxxxxx11111111xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
100
101xx\r
102
103\nxxxxxxxxx11111111xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
104
105xx\r
106
107\nxxxxxxxxx11111111xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
108
109xx\r
110
111\nxxxxxxxxxxxx11xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
112
113xx\r
114
115\nx1111111x11111111x00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
116
117xx\r
118
119\nx1111111x11111111x00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
120
121xx\r
122
123\nx1111111x11111111x00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
124
125xx\r
126
127\nx1111111111111111100000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
128
129xx\r
130
131\nx1111111111111111100000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
132
133xx\r
134
135\nx1111111x11111111x00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
136
137xx\r
138
139\nx1111111x11111111x00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
140
141xx\r
142
143\nx1111111x11111111x00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
144
145xx\r
146
147\nxxxxxxxxxxxx11xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
148
149xx\r
150
151\nxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
152
153xx\r
154
155\nxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
156
157xx\r
158
159\nxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
160
161xx\r
162
163\nxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
164
165xx\r
166
167\nxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
168
169xx\r
170
171\nxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
172
173xx\r
174
175\nxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
176
177xx\r
178
179\nxxxxxxxxx00000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
180
181xx\r
182
183\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
184
185xx', '', '1'),
186('model_b2g', 0, 0, 0, 2, 'xxxxxxxxxxxxxx\r\nx00000x000000x\r
187
188\nx000000000000x\r\nx00000x000000x\r\nx00000x000000x\r
189
190\nx00000x000000x\r\nx00000x000000x\r\nxxx0xxx000000x\r
191
192\nx000000000000x\r\nx000000000000x\r\nx000000000000x\r
193
194\nx000000000000x\r\nx000000000000x\r\nx000000000000x\r
195
196\nx000000000000x\r\nx000000000000x\r\nx000000000000x\r
197
198\nx00000xx00000x\r\nxxxxxxxxxxxxxx', '', '1'),
199('model_opening', 0, 23, 2, 2, 'xxxxxxxxxxxxxxxxxxx\r
200
201\nxxxxxxx222222222222\r\nxxxxxxx222222222222\r
202
203\nxxxxxxx222222222222\r\nxxxxxxx222222222222\r
204
205\nxxxxxxx222222222222\r\nxxxxxxx222222222222\r
206
207\nxxxxxxx222222222222\r\nxxxxxxx111111111111\r
208
209\nx222221111111111111\r\nx222221111111111111\r
210
211\nx222221111111111111\r\nx222221111111111111\r
212
213\nx222221111111111111\r\nx222221111111111111\r
214
215\nx222221111111111111\r\nx222221111111111111\r
216
217\nx2222xx111111111111\r\nx2222xx000000000000\r
218
219\nx2222xx000000000000\r\nx2222xx000000000000\r
220
221\nx2222xx000000000000\r\nx2222xx000000000000\r
222
223\n22222xx000000000000\r\nx2222xx000000000000\r
224
225\nxxxxxxxxxxxxxxxxxxx', '', '1');
226
227-- --------------------------------------------------------
228
229--
230-- Estrutura da tabela `room_rights`
231--
232
233CREATE TABLE IF NOT EXISTS `room_rights` (
234  `room_id` int(10) unsigned NOT NULL,
235  `user_id` int(10) unsigned NOT NULL,
236  KEY `room_id` (`room_id`)
237) ENGINE=MyISAM DEFAULT CHARSET=latin1;
238
239-- --------------------------------------------------------
240
241--
242-- Estrutura da tabela `server_settings`
243--
244
245CREATE TABLE IF NOT EXISTS `server_settings` (
246  `motd` text NOT NULL,
247  `timer` int(11) NOT NULL default '15',
248  `pixels` int(11) NOT NULL default '15',
249  `credits` int(11) NOT NULL default '75',
250  `enable_chatlogs` enum('0','1') NOT NULL default '1',
251  `enable_roomlogs` enum('0','1') NOT NULL default '1',
252  `vipclothesforhcusers` enum('1','0') NOT NULL default '1',
253  `MaxRoomsPerUser` int(4) NOT NULL default '50',
254  `enable_externalchatlinks` enum
255
256('disabled','blacklist','whitelist') NOT NULL default 
257
258'disabled',
259  `enable_securesessions` enum('1','0') NOT NULL default '1',
260  `enable_cmdlogs` enum('0','1') NOT NULL default '1',
261  `allow_friendfurnidrops` enum('0','1') NOT NULL default '1'
262) ENGINE=MyISAM DEFAULT CHARSET=latin1;
263
264--
265-- Extraindo dados da tabela `server_settings`
266--
267
268INSERT INTO `server_settings` (`motd`, `timer`, `pixels`, 
269
270`credits`, `enable_chatlogs`, `enable_roomlogs`, 
271
272`vipclothesforhcusers`, `MaxRoomsPerUser`, 
273
274`enable_externalchatlinks`, `enable_securesessions`, 
275
276`enable_cmdlogs`, `allow_friendfurnidrops`) VALUES
277('Olá seja Bem-vindo ao Hotel \\nNós da equipe CSHP Free lhe 
278
279desejamos um bom jogo', 15, 15, 75, '1', '1', '1', 50, 
280
281'disabled', '1', '1', '1');
282
283-- --------------------------------------------------------
284
285--
286-- Estrutura da tabela `server_status`
287--
288
289CREATE TABLE IF NOT EXISTS `server_status` (
290  `status` enum('0','1','2') NOT NULL default '0',
291  `users_online` int(11) NOT NULL default '0',
292  `rooms_loaded` int(11) NOT NULL default '0',
293  `server_ver` text NOT NULL,
294  `stamp` double NOT NULL,
295  `userpeak` int(11) NOT NULL default '0'
296) ENGINE=MyISAM DEFAULT CHARSET=latin1;
297
298--
299-- Extraindo dados da tabela `server_status`
300--
301
302INSERT INTO `server_status` (`status`, `users_online`, 
303
304`rooms_loaded`, `server_ver`, `stamp`, `userpeak`) VALUES
305('1', 0, 0, 'Phoenix v3.7.0 (Build 13740)', 1326994465, 0);
306
307-- --------------------------------------------------------
308
309--
310-- Estrutura da tabela `system_stats`
311--
312
313CREATE TABLE IF NOT EXISTS `system_stats` (
314  `id` int(5) NOT NULL auto_increment,
315  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
316  `users` int(5) NOT NULL default '0',
317  `rooms` int(5) NOT NULL default '0',
318  PRIMARY KEY  (`id`)
319) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
320
321--
322-- Extraindo dados da tabela `system_stats`
323--
324
325INSERT INTO `system_stats` (`id`, `date`, `users`, `rooms`) 
326
327VALUES
328(1, '2011-01-14 22:51:56', 1, 0);
329
330-- --------------------------------------------------------
331
332--
333-- Estrutura da tabela `tele_links`
334--
335
336CREATE TABLE IF NOT EXISTS `tele_links` (
337  `tele_one_id` int(10) unsigned NOT NULL,
338  `tele_two_id` int(10) unsigned NOT NULL,
339  KEY `tele_one_id` (`tele_one_id`)
340) ENGINE=MyISAM DEFAULT CHARSET=latin1;
341
342-- --------------------------------------------------------
343
344--
345-- Estrutura da tabela `texts`
346--
347
348CREATE TABLE IF NOT EXISTS `texts` (
349  `identifier` varchar(50) NOT NULL,
350  `display_text` text NOT NULL,
351  PRIMARY KEY  (`identifier`)
352) ENGINE=InnoDB DEFAULT CHARSET=latin1;
353
354--
355-- Extraindo dados da tabela `texts`
356--
357
358INSERT INTO `texts` (`identifier`, `display_text`) VALUES
359('emu_cleandb', 'Cleaning up database..'),
360('emu_connectdb', 'Connecting to database..'),
361('emu_loadroles', 'Loading Roles..'),
362('emu_loadsettings', 'Loading Settings..'),
363('emu_loadtexts', 'Loading Texts..');
364
365-- --------------------------------------------------------
366
367--
368-- Estrutura da tabela `users`
369--
370
371CREATE TABLE IF NOT EXISTS `users` (
372  `id` int(11) unsigned NOT NULL auto_increment,
373  `username` varchar(50) NOT NULL,
374  `real_name` varchar(100) NOT NULL default '',
375  `password` varchar(50) NOT NULL,
376  `mail` varchar(50) NOT NULL default 'defaultuser@meth0d.org',
377  `auth_ticket` text NOT NULL,
378  `rank` int(11) unsigned NOT NULL default '1',
379  `credits` int(11) NOT NULL default '50000',
380  `vip_points` int(11) NOT NULL default '0',
381  `activity_points` int(11) NOT NULL default '0',
382  `activity_points_lastupdate` double NOT NULL default '0',
383  `look` varchar(255) NOT NULL default 'hr-115-42.hd-190-1.ch-
384
385215-62.lg-285-91.sh-290-62',
386  `gender` enum('M','F') NOT NULL default 'M',
387  `motto` varchar(50) NOT NULL,
388  `account_created` varchar(50) NOT NULL,
389  `last_online` varchar(50) NOT NULL,
390  `online` enum('0','1') NOT NULL default '0',
391  `ip_last` varchar(120) NOT NULL,
392  `ip_reg` varchar(120) NOT NULL,
393  `home_room` int(10) unsigned NOT NULL default '0',
394  `respect` int(11) NOT NULL default '0',
395  `daily_respect_points` int(11) NOT NULL default '3',
396  `daily_pet_respect_points` int(11) NOT NULL default '3',
397  `newbie_status` int(11) NOT NULL default '0',
398  `is_muted` enum('0','1') NOT NULL default '0',
399  `mutant_penalty` enum('0','1','2') NOT NULL default '0',
400  `mutant_penalty_expire` int(11) NOT NULL default '0',
401  `block_newfriends` enum('0','1') NOT NULL default '0',
402  `hide_online` enum('0','1') NOT NULL default '0',
403  `hide_inroom` enum('0','1') NOT NULL default '0',
404  `mail_verified` varchar(6) NOT NULL default '0',
405  `vip` enum('0','1') NOT NULL default '0',
406  `volume` int(3) NOT NULL default '100',
407  PRIMARY KEY  (`id`)
408) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
409
410-- --------------------------------------------------------
411
412--
413-- Estrutura da tabela `user_achievements`
414--
415
416CREATE TABLE IF NOT EXISTS `user_achievements` (
417  `user_id` int(10) unsigned NOT NULL,
418  `achievement_id` int(10) unsigned NOT NULL,
419  `achievement_level` int(11) NOT NULL,
420  KEY `user_id` (`user_id`)
421) ENGINE=MyISAM DEFAULT CHARSET=latin1;
422
423-- --------------------------------------------------------
424
425--
426-- Estrutura da tabela `user_badges`
427--
428
429CREATE TABLE IF NOT EXISTS `user_badges` (
430  `user_id` int(10) unsigned NOT NULL,
431  `badge_id` varchar(100) NOT NULL,
432  `badge_slot` int(11) NOT NULL default '0',
433  KEY `user_id` (`user_id`)
434) ENGINE=MyISAM DEFAULT CHARSET=latin1;
435
436-- --------------------------------------------------------
437
438--
439-- Estrutura da tabela `user_effects`
440--
441
442CREATE TABLE IF NOT EXISTS `user_effects` (
443  `user_id` int(10) unsigned NOT NULL,
444  `effect_id` int(11) NOT NULL default '1',
445  `total_duration` int(11) NOT NULL default '3600',
446  `is_activated` enum('0','1') NOT NULL default '0',
447  `activated_stamp` double NOT NULL default '0',
448  KEY `user_id` (`user_id`)
449) ENGINE=MyISAM DEFAULT CHARSET=latin1;
450
451-- --------------------------------------------------------
452
453--
454-- Estrutura da tabela `user_favorites`
455--
456
457CREATE TABLE IF NOT EXISTS `user_favorites` (
458  `user_id` int(10) unsigned NOT NULL,
459  `room_id` int(10) unsigned NOT NULL,
460  KEY `user_id` (`user_id`)
461) ENGINE=MyISAM DEFAULT CHARSET=latin1;
462
463-- --------------------------------------------------------
464
465--
466-- Estrutura da tabela `user_ignores`
467--
468
469CREATE TABLE IF NOT EXISTS `user_ignores` (
470  `user_id` int(10) unsigned NOT NULL,
471  `ignore_id` int(10) unsigned NOT NULL,
472  KEY `user_id` (`user_id`)
473) ENGINE=MyISAM DEFAULT CHARSET=latin1;
474
475-- --------------------------------------------------------
476
477--
478-- Estrutura da tabela `user_info`
479--
480
481CREATE TABLE IF NOT EXISTS `user_info` (
482  `user_id` int(11) NOT NULL,
483  `bans` int(11) NOT NULL default '0',
484  `cautions` int(11) NOT NULL default '0',
485  `reg_timestamp` double NOT NULL default '0',
486  `login_timestamp` double NOT NULL default '0',
487  `cfhs` int(11) NOT NULL default '0',
488  `cfhs_abusive` int(11) NOT NULL default '0',
489  PRIMARY KEY  (`user_id`)
490) ENGINE=MyISAM DEFAULT CHARSET=latin1;
491
492-- --------------------------------------------------------
493
494--
495-- Estrutura da tabela `user_pets`
496--
497
498CREATE TABLE IF NOT EXISTS `user_pets` (
499  `id` int(10) unsigned NOT NULL auto_increment,
500  `user_id` int(10) unsigned NOT NULL,
501  `room_id` int(10) unsigned NOT NULL,
502  `name` varchar(32) NOT NULL default 'Unnamed',
503  `race` varchar(3) NOT NULL default '000',
504  `color` varchar(6) NOT NULL default 'FFFFFF',
505  `type` int(10) unsigned NOT NULL,
506  `expirience` int(11) NOT NULL,
507  `energy` int(11) NOT NULL,
508  `nutrition` int(11) NOT NULL default '100',
509  `respect` int(11) NOT NULL default '0',
510  `createstamp` double NOT NULL default '0',
511  `x` int(11) NOT NULL default '0',
512  `y` int(11) NOT NULL default '0',
513  `z` double NOT NULL default '0',
514  PRIMARY KEY  (`id`),
515  KEY `user_id` (`user_id`)
516) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
517
518-- --------------------------------------------------------
519
520--
521-- Estrutura da tabela `user_presents`
522--
523
524CREATE TABLE IF NOT EXISTS `user_presents` (
525  `item_id` int(10) unsigned NOT NULL,
526  `base_id` int(10) unsigned NOT NULL,
527  `amount` int(11) NOT NULL,
528  `extra_data` text NOT NULL,
529  KEY `item_id` (`item_id`)
530) ENGINE=MyISAM DEFAULT CHARSET=latin1;
531
532-- --------------------------------------------------------
533
534--
535-- Estrutura da tabela `user_quests`
536--
537
538CREATE TABLE IF NOT EXISTS `user_quests` (
539  `id` int(10) unsigned NOT NULL auto_increment,
540  `user_id` int(10) unsigned NOT NULL,
541  `quest_id` int(10) unsigned NOT NULL,
542  PRIMARY KEY  (`id`)
543) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
544
545-- --------------------------------------------------------
546
547--
548-- Estrutura da tabela `user_roomvisits`
549--
550
551CREATE TABLE IF NOT EXISTS `user_roomvisits` (
552  `user_id` int(10) unsigned NOT NULL,
553  `room_id` int(10) unsigned NOT NULL,
554  `entry_timestamp` double NOT NULL,
555  `exit_timestamp` double NOT NULL,
556  `hour` int(11) NOT NULL,
557  `minute` int(11) NOT NULL,
558  KEY `user_id` (`user_id`)
559) ENGINE=MyISAM DEFAULT CHARSET=latin1;
560
561-- --------------------------------------------------------
562
563--
564-- Estrutura da tabela `user_stats`
565--
566
567CREATE TABLE IF NOT EXISTS `user_stats` (
568  `id` int(7) NOT NULL,
569  `RoomVisits` int(7) NOT NULL default '0',
570  `OnlineTime` int(7) NOT NULL default '0',
571  `Respect` int(6) NOT NULL default '0',
572  `RespectGiven` int(6) NOT NULL default '0',
573  `GiftsGiven` int(6) NOT NULL default '0',
574  `GiftsReceived` int(6) NOT NULL default '0',
575  `DailyRespectPoints` int(1) NOT NULL default '3',
576  `DailyPetRespectPoints` int(1) NOT NULL default '3',
577  `AchievementScore` int(7) NOT NULL default '0',
578  `quest_id` int(10) unsigned NOT NULL default '0',
579  `quest_progress` int(10) NOT NULL default '0',
580  `lev_builder` int(10) NOT NULL default '0',
581  `lev_social` int(10) NOT NULL default '0',
582  `lev_identity` int(10) NOT NULL default '0',
583  `lev_explore` int(10) NOT NULL default '0',
584  PRIMARY KEY  (`id`)
585) ENGINE=MyISAM DEFAULT CHARSET=latin1;
586
587-- --------------------------------------------------------
588
589--
590-- Estrutura da tabela `user_subscriptions`
591--
592
593CREATE TABLE IF NOT EXISTS `user_subscriptions` (
594  `user_id` int(10) unsigned NOT NULL,
595  `subscription_id` varchar(50) NOT NULL,
596  `timestamp_activated` int(11) NOT NULL,
597  `timestamp_expire` int(11) NOT NULL,
598  KEY `user_id` (`user_id`)
599) ENGINE=MyISAM DEFAULT CHARSET=latin1;
600
601-- --------------------------------------------------------
602
603--
604-- Estrutura da tabela `user_tags`
605--
606
607CREATE TABLE IF NOT EXISTS `user_tags` (
608  `id` int(11) NOT NULL auto_increment,
609  `user_id` int(10) unsigned NOT NULL,
610  `tag` varchar(100) NOT NULL,
611  PRIMARY KEY  (`id`),
612  KEY `user_id` (`user_id`)
613) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
614
615-- --------------------------------------------------------
616
617--
618-- Estrutura da tabela `user_wardrobe`
619--
620
621CREATE TABLE IF NOT EXISTS `user_wardrobe` (
622  `user_id` int(10) unsigned NOT NULL,
623  `slot_id` int(10) unsigned NOT NULL,
624  `look` varchar(255) NOT NULL,
625  `gender` enum('F','M') NOT NULL default 'M',
626  KEY `user_id` (`user_id`)
627) ENGINE=MyISAM DEFAULT CHARSET=latin1;
628
629-- --------------------------------------------------------
630
631--
632-- Estrutura da tabela `wired_items`
633--
634
635CREATE TABLE IF NOT EXISTS `wired_items` (
636  `item_id` int(9) NOT NULL,
637  `extra1` text NOT NULL,
638  `extra2` text NOT NULL,
639  `extra3` text NOT NULL,
640  `extra4` text NOT NULL,
641  `extra5` text NOT NULL,
642  PRIMARY KEY  (`item_id`),
643  UNIQUE KEY `item_id` (`item_id`)
644) ENGINE=MyISAM DEFAULT CHARSET=latin1;
645
646-- --------------------------------------------------------
647
648--
649-- Estrutura da tabela `wordfilter`
650--
651
652CREATE TABLE IF NOT EXISTS `wordfilter` (
653  `word` varchar(100) NOT NULL,
654  `replacement` varchar(100) NOT NULL,
655  `strict` enum('1','0') NOT NULL,
656  PRIMARY KEY  (`word`),
657  UNIQUE KEY `word` (`word`)
658) ENGINE=MyISAM DEFAULT CHARSET=latin1;
659
660/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
661/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS 
662
663*/;
664/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;