xgpfLnpV

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