pJbHJabt

1-- ----------------------------
2-- Table structure for `player_shop`
3-- ----------------------------
4DROP TABLE IF EXISTS `player_shop`;
5CREATE TABLE `player_shop` (
6  `id` int(255) NOT NULL AUTO_INCREMENT,
7  `player_id` int(255) NOT NULL,
8  `shop_vid` int(255) NOT NULL,
9  `item_count` int(3) NOT NULL DEFAULT '0',
10  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
11  `status` enum('OK','CLOSED') CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL DEFAULT 'OK',
12  `map_index` int(20) NOT NULL DEFAULT '0',
13  `x` int(30) NOT NULL DEFAULT '0',
14  `y` int(30) NOT NULL DEFAULT '0',
15  `z` int(30) NOT NULL,
16  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
17  `date_close` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
18  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL DEFAULT '0.0.0.0',
19  `gold` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
20  `cash` int(255) NOT NULL DEFAULT '0',
21  `channel` int(1) NOT NULL DEFAULT '1',
22  PRIMARY KEY (`id`,`shop_vid`)
23) ENGINE=MyISAM DEFAULT CHARSET=utf8;
24
25-- ----------------------------
26-- Records of player_shop
27-- ----------------------------
28
29-- ----------------------------
30-- Table structure for `player_shop_items`
31-- ----------------------------
32DROP TABLE IF EXISTS `player_shop_items`;
33CREATE TABLE `player_shop_items` (
34  `id` int(255) NOT NULL AUTO_INCREMENT,
35  `shop_id` int(255) NOT NULL,
36  `player_id` int(255) NOT NULL DEFAULT '0',
37  `vnum` int(255) NOT NULL DEFAULT '0',
38  `count` int(20) NOT NULL DEFAULT '1',
39  `pos` int(20) NOT NULL DEFAULT '0',
40  `display_pos` int(20) NOT NULL DEFAULT '0',
41  `price` bigint(255) NOT NULL DEFAULT '0',
42  `socket0` int(10) unsigned NOT NULL DEFAULT '0',
43  `socket1` int(10) unsigned NOT NULL DEFAULT '0',
44  `socket2` int(10) unsigned NOT NULL DEFAULT '0',
45  `socket3` int(10) unsigned NOT NULL DEFAULT '0',
46  `socket4` int(10) unsigned NOT NULL DEFAULT '0',
47  `socket5` int(10) unsigned NOT NULL DEFAULT '0',
48  `attrtype0` tinyint(4) NOT NULL DEFAULT '0',
49  `attrvalue0` smallint(6) NOT NULL DEFAULT '0',
50  `attrtype1` tinyint(4) NOT NULL DEFAULT '0',
51  `attrvalue1` smallint(6) NOT NULL DEFAULT '0',
52  `attrtype2` tinyint(4) NOT NULL DEFAULT '0',
53  `attrvalue2` smallint(6) NOT NULL DEFAULT '0',
54  `attrtype3` tinyint(4) NOT NULL DEFAULT '0',
55  `attrvalue3` smallint(6) NOT NULL DEFAULT '0',
56  `attrtype4` tinyint(4) NOT NULL DEFAULT '0',
57  `attrvalue4` smallint(6) NOT NULL DEFAULT '0',
58  `attrtype5` tinyint(4) NOT NULL DEFAULT '0',
59  `attrvalue5` smallint(6) NOT NULL DEFAULT '0',
60  `attrtype6` tinyint(4) NOT NULL DEFAULT '0',
61  `attrvalue6` smallint(6) NOT NULL DEFAULT '0',
62  `applytype0` tinyint(4) NOT NULL DEFAULT '0',
63  `applyvalue0` smallint(6) NOT NULL DEFAULT '0',
64  `applytype1` tinyint(4) NOT NULL DEFAULT '0',
65  `applyvalue1` smallint(6) NOT NULL DEFAULT '0',
66  `applytype2` tinyint(4) NOT NULL DEFAULT '0',
67  `applyvalue2` smallint(6) NOT NULL DEFAULT '0',
68  `applytype3` int(11) NOT NULL DEFAULT '0',
69  `applyvalue3` int(11) NOT NULL DEFAULT '0',
70  `applytype4` int(11) NOT NULL DEFAULT '0',
71  `applyvalue4` int(11) NOT NULL DEFAULT '0',
72  `applytype5` int(11) NOT NULL DEFAULT '0',
73  `applyvalue5` int(11) NOT NULL DEFAULT '0',
74  `applytype6` int(11) NOT NULL DEFAULT '0',
75  `applyvalue6` int(11) NOT NULL DEFAULT '0',
76  `applytype7` int(11) NOT NULL DEFAULT '0',
77  `applyvalue7` int(11) NOT NULL DEFAULT '0',
78  PRIMARY KEY (`id`)
79) ENGINE=MyISAM DEFAULT CHARSET=utf8;
80
81-- ----------------------------
82-- Records of player_shop_items
83-- ----------------------------