CjKUyiYp

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : OnlineServer
5Source Server Version : 50641
6Source Host           : XXXXXX
7Source Database       : player
8
9Target Server Type    : MYSQL
10Target Server Version : 50641
11File Encoding         : 65001
12
13Date: 2019-10-05 23:22:15
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `item`
20-- ----------------------------
21DROP TABLE IF EXISTS `item`;
22CREATE TABLE `item` (
23  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
24  `owner_id` int(11) unsigned NOT NULL DEFAULT '0',
25  `window` enum('INVENTORY','EQUIPMENT','SAFEBOX','MALL') NOT NULL DEFAULT 'INVENTORY',
26  `pos` smallint(5) unsigned NOT NULL DEFAULT '0',
27  `count` int(3) unsigned NOT NULL DEFAULT '0',
28  `vnum` int(11) unsigned NOT NULL DEFAULT '0',
29  `socket0` int(10) unsigned NOT NULL DEFAULT '0',
30  `socket1` int(10) unsigned NOT NULL DEFAULT '0',
31  `socket2` int(10) unsigned NOT NULL DEFAULT '0',
32  `socket3` int(10) unsigned NOT NULL DEFAULT '0',
33  `socket4` int(10) unsigned NOT NULL DEFAULT '0',
34  `socket5` int(10) unsigned NOT NULL DEFAULT '0',
35  `attrtype0` tinyint(4) NOT NULL DEFAULT '0',
36  `attrvalue0` smallint(6) NOT NULL DEFAULT '0',
37  `attrtype1` tinyint(4) NOT NULL DEFAULT '0',
38  `attrvalue1` smallint(6) NOT NULL DEFAULT '0',
39  `attrtype2` tinyint(4) NOT NULL DEFAULT '0',
40  `attrvalue2` smallint(6) NOT NULL DEFAULT '0',
41  `attrtype3` tinyint(4) NOT NULL DEFAULT '0',
42  `attrvalue3` smallint(6) NOT NULL DEFAULT '0',
43  `attrtype4` tinyint(4) NOT NULL DEFAULT '0',
44  `attrvalue4` smallint(6) NOT NULL DEFAULT '0',
45  `attrtype5` tinyint(4) NOT NULL DEFAULT '0',
46  `attrvalue5` smallint(6) NOT NULL DEFAULT '0',
47  `attrtype6` tinyint(4) NOT NULL DEFAULT '0',
48  `attrvalue6` smallint(6) 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=90182812 DEFAULT CHARSET=latin1;