4UqiKk5P

1-- ----------------------------
2-- Table structure for `item_proto`
3-- ----------------------------
4DROP TABLE IF EXISTS `item_proto`;
5CREATE TABLE `item_proto` (
6  `vnum` int(11) unsigned NOT NULL DEFAULT '0',
7  `name` varbinary(24) NOT NULL DEFAULT 'Noname',
8  `locale_name` varbinary(24) NOT NULL DEFAULT 'Noname',
9  `type` tinyint(2) NOT NULL DEFAULT '0',
10  `subtype` tinyint(2) NOT NULL DEFAULT '0',
11  `weight` tinyint(3) DEFAULT '0',
12  `size` tinyint(3) DEFAULT '0',
13  `antiflag` int(11) DEFAULT '0',
14  `flag` int(11) DEFAULT '0',
15  `wearflag` int(11) DEFAULT '0',
16  `immuneflag` set('PARA','CURSE','STUN','SLEEP','SLOW','POISON','TERROR') NOT NULL DEFAULT '',
17  `gold` int(11) DEFAULT '0',
18  `shop_buy_price` int(10) unsigned NOT NULL DEFAULT '0',
19  `refined_vnum` int(10) unsigned NOT NULL DEFAULT '0',
20  `refine_set` smallint(11) unsigned NOT NULL DEFAULT '0',
21  `refine_set2` smallint(5) unsigned NOT NULL DEFAULT '0',
22  `magic_pct` tinyint(4) NOT NULL DEFAULT '0',
23  `limittype0` tinyint(4) DEFAULT '0',
24  `limitvalue0` int(11) DEFAULT '0',
25  `limittype1` tinyint(4) DEFAULT '0',
26  `limitvalue1` int(11) DEFAULT '0',
27  `applytype0` tinyint(4) DEFAULT '0',
28  `applyvalue0` int(11) DEFAULT '0',
29  `applytype1` tinyint(4) DEFAULT '0',
30  `applyvalue1` int(11) DEFAULT '0',
31  `applytype2` tinyint(4) DEFAULT '0',
32  `applyvalue2` int(11) DEFAULT '0',
33  `value0` int(11) DEFAULT '0',
34  `value1` int(11) DEFAULT '0',
35  `value2` int(11) DEFAULT '0',
36  `value3` int(11) DEFAULT '0',
37  `value4` int(11) DEFAULT '0',
38  `value5` int(11) DEFAULT '0',
39  `socket0` tinyint(4) DEFAULT '-1',
40  `socket1` tinyint(4) DEFAULT '-1',
41  `socket2` tinyint(4) DEFAULT '-1',
42  `socket3` tinyint(4) DEFAULT '-1',
43  `socket4` tinyint(4) DEFAULT '-1',
44  `socket5` tinyint(4) DEFAULT '-1',
45  `specular` tinyint(4) NOT NULL DEFAULT '0',
46  `socket_pct` tinyint(4) NOT NULL DEFAULT '0',
47  `addon_type` smallint(6) NOT NULL DEFAULT '0',
48  `vnum_range` tinyint(4) NOT NULL DEFAULT '0',
49  PRIMARY KEY (`vnum`)
50) ENGINE=MyISAM DEFAULT CHARSET=latin1;