· 8 years ago · Dec 10, 2017, 03:40 PM
1
2-- ----------------------------
3-- Table structure for item
4-- ----------------------------
5DROP TABLE IF EXISTS `item`;
6CREATE TABLE `item` (
7 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
8 `owner_id` bigint(20) unsigned NOT NULL DEFAULT '0',
9 `window` enum('INVENTORY','EQUIPMENT','SAFEBOX','MALL') NOT NULL DEFAULT 'INVENTORY',
10 `pos` smallint(5) unsigned NOT NULL DEFAULT '0',
11 `count` tinyint(3) unsigned NOT NULL DEFAULT '0',
12 `vnum` int(11) unsigned NOT NULL DEFAULT '0',
13 `socket0` int(10) unsigned NOT NULL DEFAULT '0',
14 `socket1` int(10) unsigned NOT NULL DEFAULT '0',
15 `socket2` int(10) unsigned NOT NULL DEFAULT '0',
16 `socket3` int(10) unsigned NOT NULL DEFAULT '0',
17 `socket4` int(10) unsigned NOT NULL DEFAULT '0',
18 `socket5` int(10) unsigned NOT NULL DEFAULT '0',
19 `attrtype0` tinyint(4) NOT NULL DEFAULT '0',
20 `attrvalue0` smallint(6) NOT NULL DEFAULT '0',
21 `attrtype1` tinyint(4) NOT NULL DEFAULT '0',
22 `attrvalue1` smallint(6) NOT NULL DEFAULT '0',
23 `attrtype2` tinyint(4) NOT NULL DEFAULT '0',
24 `attrvalue2` smallint(6) NOT NULL DEFAULT '0',
25 `attrtype3` tinyint(4) NOT NULL DEFAULT '0',
26 `attrvalue3` smallint(6) NOT NULL DEFAULT '0',
27 `attrtype4` tinyint(4) NOT NULL DEFAULT '0',
28 `attrvalue4` smallint(6) NOT NULL DEFAULT '0',
29 `attrtype5` tinyint(4) NOT NULL DEFAULT '0',
30 `attrvalue5` smallint(6) NOT NULL DEFAULT '0',
31 `attrtype6` tinyint(4) NOT NULL DEFAULT '0',
32 `attrvalue6` smallint(6) NOT NULL DEFAULT '0',
33 `applytype0` tinyint(4) NOT NULL DEFAULT '0',
34 `applyvalue0` smallint(6) NOT NULL DEFAULT '0',
35 `applytype1` tinyint(4) NOT NULL DEFAULT '0',
36 `applyvalue1` smallint(6) NOT NULL DEFAULT '0',
37 `applytype2` tinyint(4) NOT NULL DEFAULT '0',
38 `applyvalue2` smallint(6) NOT NULL DEFAULT '0',
39 `applytype3` int(11) NOT NULL DEFAULT '0',
40 `applyvalue3` int(11) NOT NULL DEFAULT '0',
41 `applytype4` int(11) NOT NULL DEFAULT '0',
42 `applyvalue4` int(11) NOT NULL DEFAULT '0',
43 `applytype5` int(11) NOT NULL DEFAULT '0',
44 `applyvalue5` int(11) NOT NULL DEFAULT '0',
45 `applytype6` int(11) NOT NULL DEFAULT '0',
46 `applyvalue6` int(11) NOT NULL DEFAULT '0',
47 `applytype7` int(11) NOT NULL DEFAULT '0',
48 `applyvalue7` int(11) NOT NULL DEFAULT '0',
49 PRIMARY KEY (`id`),
50 KEY `owner_id_idx` (`owner_id`),
51 KEY `item_vnum_index` (`vnum`)
52) ENGINE=MyISAM AUTO_INCREMENT=2000048549 DEFAULT CHARSET=latin1;
53
54-- ----------------------------
55-- Records of item
56-- ----------------------------
57INSERT INTO `item` VALUES ('19869345', '137787', 'INVENTORY', '19', '1', '779', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');