· 6 years ago · Aug 20, 2019, 07:04 PM
1
2SET FOREIGN_KEY_CHECKS=0;
3
4-- ----------------------------
5-- Table structure for offline_shop_item
6-- ----------------------------
7DROP TABLE IF EXISTS `offline_shop_item`;
8CREATE TABLE `offline_shop_item` (
9 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
10 `owner_id` int(11) unsigned NOT NULL DEFAULT '0',
11 `pos` smallint(5) unsigned NOT NULL DEFAULT '0',
12 `count` tinyint(3) unsigned NOT NULL DEFAULT '0',
13 `vnum` int(11) unsigned NOT NULL DEFAULT '0',
14 `socket0` int(10) unsigned NOT NULL DEFAULT '0',
15 `socket1` int(10) unsigned NOT NULL DEFAULT '0',
16 `socket2` int(10) unsigned NOT NULL DEFAULT '0',
17 `socket3` int(10) unsigned NOT NULL DEFAULT '0',
18 `socket4` int(10) unsigned NOT NULL DEFAULT '0',
19 `socket5` int(10) unsigned NOT NULL DEFAULT '0',
20 `attrtype0` tinyint(4) NOT NULL DEFAULT '0',
21 `attrvalue0` smallint(6) NOT NULL DEFAULT '0',
22 `attrtype1` tinyint(4) NOT NULL DEFAULT '0',
23 `attrvalue1` smallint(6) NOT NULL DEFAULT '0',
24 `attrtype2` tinyint(4) NOT NULL DEFAULT '0',
25 `attrvalue2` smallint(6) NOT NULL DEFAULT '0',
26 `attrtype3` tinyint(4) NOT NULL DEFAULT '0',
27 `attrvalue3` smallint(6) NOT NULL DEFAULT '0',
28 `attrtype4` tinyint(4) NOT NULL DEFAULT '0',
29 `attrvalue4` smallint(6) NOT NULL DEFAULT '0',
30 `attrtype5` tinyint(4) NOT NULL DEFAULT '0',
31 `attrvalue5` smallint(6) NOT NULL DEFAULT '0',
32 `attrtype6` tinyint(4) NOT NULL DEFAULT '0',
33 `attrvalue6` smallint(6) NOT NULL DEFAULT '0',
34 `applytype0` tinyint(4) NOT NULL DEFAULT '0',
35 `applyvalue0` smallint(6) NOT NULL DEFAULT '0',
36 `applytype1` tinyint(4) NOT NULL DEFAULT '0',
37 `applyvalue1` smallint(6) NOT NULL DEFAULT '0',
38 `applytype2` tinyint(4) NOT NULL DEFAULT '0',
39 `applyvalue2` smallint(6) NOT NULL DEFAULT '0',
40 `applytype3` int(11) NOT NULL DEFAULT '0',
41 `applyvalue3` int(11) NOT NULL DEFAULT '0',
42 `applytype4` int(11) NOT NULL DEFAULT '0',
43 `applyvalue4` int(11) NOT NULL DEFAULT '0',
44 `applytype5` int(11) NOT NULL DEFAULT '0',
45 `applyvalue5` int(11) NOT NULL DEFAULT '0',
46 `applytype6` int(11) NOT NULL DEFAULT '0',
47 `applyvalue6` int(11) NOT NULL DEFAULT '0',
48 `applytype7` int(11) NOT NULL DEFAULT '0',
49 `applyvalue7` int(11) NOT NULL DEFAULT '0',
50 `price` int(11) NOT NULL DEFAULT '0',
51 `status` smallint(1) NOT NULL DEFAULT '0',
52 PRIMARY KEY (`id`),
53 KEY `owner_id_idx` (`owner_id`),
54 KEY `item_vnum_index` (`vnum`)
55) ENGINE=MyISAM AUTO_INCREMENT=2430000326 DEFAULT CHARSET=latin1;
56
57-- ----------------------------
58-- Records of offline_shop_item
59-- ----------------------------
60
61-- ----------------------------
62-- Table structure for offline_shop_npc
63-- ----------------------------
64DROP TABLE IF EXISTS `offline_shop_npc`;
65CREATE TABLE `offline_shop_npc` (
66 `owner_id` int(11) NOT NULL DEFAULT '0',
67 `sign` varchar(32) DEFAULT NULL,
68 `name` varchar(32) DEFAULT NULL,
69 `time` int(11) DEFAULT NULL,
70 `x` int(11) DEFAULT NULL,
71 `y` int(11) DEFAULT NULL,
72 `z` int(11) DEFAULT NULL,
73 `mapIndex` int(11) DEFAULT NULL,
74 `channel` int(2) DEFAULT NULL,
75 PRIMARY KEY (`owner_id`)
76) ENGINE=InnoDB DEFAULT CHARSET=latin1;
77
78-- ----------------------------
79-- Records of offline_shop_npc
80-- ----------------------------