v7RJeuJ7

1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for offline_shop_item
5-- ----------------------------
6DROP TABLE IF EXISTS `offline_shop_item`;
7CREATE TABLE `offline_shop_item` (
8  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
9  `owner_id` int(11) unsigned NOT NULL DEFAULT '0',
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  `price` int(11) NOT NULL DEFAULT '0',
50  `status` smallint(1) NOT NULL DEFAULT '0',
51  PRIMARY KEY (`id`),
52  KEY `owner_id_idx` (`owner_id`),
53  KEY `item_vnum_index` (`vnum`)
54) ENGINE=MyISAM AUTO_INCREMENT=2430000326 DEFAULT CHARSET=latin1;
55
56-- ----------------------------
57-- Table structure for offline_shop_npc
58-- ----------------------------
59DROP TABLE IF EXISTS `offline_shop_npc`;
60CREATE TABLE `offline_shop_npc` (
61  `owner_id` int(11) NOT NULL DEFAULT '0',
62  `sign` varchar(32) DEFAULT NULL,
63  `name` varchar(32) DEFAULT NULL,
64  `time` int(11) DEFAULT NULL,
65  `x` int(11) DEFAULT NULL,
66  `y` int(11) DEFAULT NULL,
67  `z` int(11) DEFAULT NULL,
68  `mapIndex` int(11) DEFAULT NULL,
69  `channel` int(2) DEFAULT NULL,
70  PRIMARY KEY (`owner_id`)
71) ENGINE=InnoDB DEFAULT CHARSET=latin1;