rfuwGRaX

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