hawtcsVL

1-- ----------------------------
2-- Table structure for `fake_pcs`
3-- ----------------------------
4DROP TABLE IF EXISTS `fake_pcs`;
5CREATE TABLE `fake_pcs` (
6  `npc_id` int(11) NOT NULL,
7  `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
8  `sex` tinyint(3) unsigned NOT NULL DEFAULT '0',
9  `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
10  `title` varchar(16) NOT NULL DEFAULT '',
11  `title_color` char(6) NOT NULL DEFAULT 'FFFFFF',
12  `name` varchar(35) NOT NULL,
13  `name_color` char(6) NOT NULL DEFAULT 'FFFFFF',
14  `hair_style` tinyint(3) unsigned NOT NULL DEFAULT '0',
15  `hair_color` tinyint(3) unsigned NOT NULL DEFAULT '0',
16  `face` tinyint(3) unsigned NOT NULL DEFAULT '0',
17  `mount` tinyint(3) unsigned NOT NULL DEFAULT '0',
18  `team` tinyint(3) unsigned NOT NULL DEFAULT '0',
19  `hero` tinyint(3) unsigned NOT NULL DEFAULT '0',
20  `pd_under` int(11) NOT NULL DEFAULT '0',
21  `pd_under_aug` int(11) NOT NULL DEFAULT '0',
22  `pd_head` int(11) NOT NULL DEFAULT '0',
23  `pd_head_aug` int(11) NOT NULL DEFAULT '0',
24  `pd_rhand` int(11) NOT NULL DEFAULT '0',
25  `pd_rhand_aug` int(11) NOT NULL DEFAULT '0',
26  `pd_lhand` int(11) NOT NULL DEFAULT '0',
27  `pd_lhand_aug` int(11) NOT NULL DEFAULT '0',
28  `pd_lrhand` int(11) NOT NULL DEFAULT '0',
29  `pd_lrhand_aug` int(11) NOT NULL DEFAULT '0',
30  `pd_gloves` int(11) NOT NULL DEFAULT '0',
31  `pd_gloves_aug` int(11) NOT NULL DEFAULT '0',
32  `pd_chest` int(11) NOT NULL DEFAULT '0',
33  `pd_chest_aug` int(11) NOT NULL DEFAULT '0',
34  `pd_legs` int(11) NOT NULL DEFAULT '0',
35  `pd_legs_aug` int(11) NOT NULL DEFAULT '0',
36  `pd_feet` int(11) NOT NULL DEFAULT '0',
37  `pd_feet_aug` int(11) NOT NULL DEFAULT '0',
38  `pd_back` int(11) NOT NULL DEFAULT '0',
39  `pd_back_aug` int(11) NOT NULL DEFAULT '0',
40  `pd_hair` int(11) NOT NULL DEFAULT '0',
41  `pd_hair_aug` int(11) NOT NULL DEFAULT '0',
42  `pd_hair2` int(11) NOT NULL DEFAULT '0',
43  `pd_hair2_aug` int(11) NOT NULL DEFAULT '0',
44  `pd_rbracelet` int(11) NOT NULL DEFAULT '0',
45  `pd_rbracelet_aug` int(11) NOT NULL DEFAULT '0',
46  `pd_lbracelet` int(11) NOT NULL DEFAULT '0',
47  `pd_lbracelet_aug` int(11) NOT NULL DEFAULT '0',
48  `pd_deco1` int(11) NOT NULL DEFAULT '0',
49  `pd_deco1_aug` int(11) NOT NULL DEFAULT '0',
50  `pd_deco2` int(11) NOT NULL DEFAULT '0',
51  `pd_deco2_aug` int(11) NOT NULL DEFAULT '0',
52  `pd_deco3` int(11) NOT NULL DEFAULT '0',
53  `pd_deco3_aug` int(11) NOT NULL DEFAULT '0',
54  `pd_deco4` int(11) NOT NULL DEFAULT '0',
55  `pd_deco4_aug` int(11) NOT NULL DEFAULT '0',
56  `pd_deco5` int(11) NOT NULL DEFAULT '0',
57  `pd_deco5_aug` int(11) NOT NULL DEFAULT '0',
58  `pd_deco6` int(11) NOT NULL DEFAULT '0',
59  `pd_deco6_aug` int(11) NOT NULL DEFAULT '0',
60  `enchant_effect` int(11) NOT NULL DEFAULT '0',
61  `pvp_flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
62  `karma` int(10) unsigned NOT NULL DEFAULT '0',
63  `fishing` tinyint(3) unsigned NOT NULL DEFAULT '0',
64  `fishing_x` mediumint(9) NOT NULL DEFAULT '0',
65  `fishing_y` mediumint(9) NOT NULL DEFAULT '0',
66  `fishing_z` mediumint(9) NOT NULL DEFAULT '0',
67  `invisible` tinyint(3) unsigned NOT NULL DEFAULT '0',
68  PRIMARY KEY (`npc_id`)
69) ENGINE=MyISAM DEFAULT CHARSET=utf8;