VH9zEASu

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