SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `item`
-- ----------------------------
DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) unsigned NOT NULL DEFAULT '0',
  `window` enum('INVENTORY','EQUIPMENT','SAFEBOX','MALL') NOT NULL DEFAULT 'INVENTORY',
  `pos` int(11) unsigned NOT NULL DEFAULT '0',
  `count` int(11) unsigned NOT NULL DEFAULT '0',
  `vnum` int(11) unsigned NOT NULL DEFAULT '0',
  `socket0` int(11) unsigned NOT NULL DEFAULT '0',
  `socket1` int(11) unsigned NOT NULL DEFAULT '0',
  `socket2` int(11) unsigned NOT NULL DEFAULT '0',
  `socket3` int(11) unsigned NOT NULL DEFAULT '0',
  `socket4` int(11) unsigned NOT NULL DEFAULT '0',
  `socket5` int(11) unsigned NOT NULL DEFAULT '0',
  `attrtype0` int(11) NOT NULL DEFAULT '0',
  `attrvalue0` int(11) NOT NULL DEFAULT '0',
  `attrtype1` int(11) NOT NULL DEFAULT '0',
  `attrvalue1` int(11) NOT NULL DEFAULT '0',
  `attrtype2` int(11) NOT NULL DEFAULT '0',
  `attrvalue2` int(11) NOT NULL DEFAULT '0',
  `attrtype3` int(11) NOT NULL DEFAULT '0',
  `attrvalue3` int(11) NOT NULL DEFAULT '0',
  `attrtype4` int(11) NOT NULL DEFAULT '0',
  `attrvalue4` int(11) NOT NULL DEFAULT '0',
  `attrtype5` int(11) NOT NULL DEFAULT '0',
  `attrvalue5` int(11) NOT NULL DEFAULT '0',
  `attrtype6` int(11) NOT NULL DEFAULT '0',
  `attrvalue6` int(11) NOT NULL DEFAULT '0',
  `dwVnum` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `owner_id_idx` (`owner_id`),
  KEY `item_vnum_index` (`vnum`)
) ENGINE=MyISAM AUTO_INCREMENT=2500000414 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of item
-- ----------------------------