Ngm42PXM

1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for `item`
5-- ----------------------------
6DROP TABLE IF EXISTS `item`;
7CREATE TABLE `item` (
8  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
9  `owner_id` int(11) unsigned NOT NULL DEFAULT '0',
10  `window` enum('INVENTORY','EQUIPMENT','SAFEBOX','MALL') NOT NULL DEFAULT 'INVENTORY',
11  `pos` int(11) unsigned NOT NULL DEFAULT '0',
12  `count` int(11) unsigned NOT NULL DEFAULT '0',
13  `vnum` int(11) unsigned NOT NULL DEFAULT '0',
14  `socket0` int(11) unsigned NOT NULL DEFAULT '0',
15  `socket1` int(11) unsigned NOT NULL DEFAULT '0',
16  `socket2` int(11) unsigned NOT NULL DEFAULT '0',
17  `socket3` int(11) unsigned NOT NULL DEFAULT '0',
18  `socket4` int(11) unsigned NOT NULL DEFAULT '0',
19  `socket5` int(11) unsigned NOT NULL DEFAULT '0',
20  `attrtype0` int(11) NOT NULL DEFAULT '0',
21  `attrvalue0` int(11) NOT NULL DEFAULT '0',
22  `attrtype1` int(11) NOT NULL DEFAULT '0',
23  `attrvalue1` int(11) NOT NULL DEFAULT '0',
24  `attrtype2` int(11) NOT NULL DEFAULT '0',
25  `attrvalue2` int(11) NOT NULL DEFAULT '0',
26  `attrtype3` int(11) NOT NULL DEFAULT '0',
27  `attrvalue3` int(11) NOT NULL DEFAULT '0',
28  `attrtype4` int(11) NOT NULL DEFAULT '0',
29  `attrvalue4` int(11) NOT NULL DEFAULT '0',
30  `attrtype5` int(11) NOT NULL DEFAULT '0',
31  `attrvalue5` int(11) NOT NULL DEFAULT '0',
32  `attrtype6` int(11) NOT NULL DEFAULT '0',
33  `attrvalue6` int(11) NOT NULL DEFAULT '0',
34  `dwVnum` int(11) NOT NULL,
35  PRIMARY KEY (`id`),
36  KEY `owner_id_idx` (`owner_id`),
37  KEY `item_vnum_index` (`vnum`)
38) ENGINE=MyISAM AUTO_INCREMENT=2500000414 DEFAULT CHARSET=latin1;
39
40-- ----------------------------
41-- Records of item
42-- ----------------------------