· 6 years ago · Nov 12, 2019, 09:32 PM
1
2DROP TABLE IF EXISTS `player_shop`;
3CREATE TABLE `player_shop` (
4 `id` int(255) NOT NULL AUTO_INCREMENT,
5 `player_id` int(255) NOT NULL,
6 `shop_vid` int(255) NOT NULL DEFAULT '0',
7 `item_count` int(3) NOT NULL DEFAULT '0',
8 `name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
9 `status` enum('OK','CLOSED') COLLATE utf8_polish_ci NOT NULL DEFAULT 'OK',
10 `map_index` int(20) NOT NULL DEFAULT '0',
11 `x` int(30) NOT NULL DEFAULT '0',
12 `y` int(30) NOT NULL DEFAULT '0',
13 `z` int(30) NOT NULL,
14 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
15 `date_close` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
16 `ip` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0.0.0.0',
17 `gold` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
18 `cash` int(255) NOT NULL DEFAULT '0',
19 `channel` int(1) NOT NULL DEFAULT '1',
20 PRIMARY KEY (`id`,`shop_vid`)
21) ENGINE=MyISAM;
22
23DROP TABLE IF EXISTS `shop_cost`;
24CREATE TABLE `shop_cost` (
25 `id` int(255) NOT NULL AUTO_INCREMENT,
26 `time` int(255) NOT NULL DEFAULT '0',
27 `time_type` enum('day','hour','normal_shop') NOT NULL DEFAULT 'day',
28 `cost` int(255) NOT NULL DEFAULT '0',
29 PRIMARY KEY (`id`)
30) ENGINE=MyISAM AUTO_INCREMENT=12;
31
32-- ----------------------------
33-- Records of shop_cost
34-- ----------------------------
35INSERT INTO `shop_cost` VALUES ('5', '0', 'normal_shop', '5000000');
36INSERT INTO `shop_cost` VALUES ('6', '1', 'hour', '100000');
37INSERT INTO `shop_cost` VALUES ('7', '2', 'hour', '500000');
38INSERT INTO `shop_cost` VALUES ('8', '3', 'hour', '1000000');
39INSERT INTO `shop_cost` VALUES ('9', '1', 'day', '1500000');
40INSERT INTO `shop_cost` VALUES ('10', '2', 'day', '2000000');
41INSERT INTO `shop_cost` VALUES ('11', '3', 'day', '2500000');
42
43
44DROP TABLE IF EXISTS `shop_limit`;
45CREATE TABLE `shop_limit` (
46 `channel` int(2) DEFAULT NULL,
47 `map_index` int(11) DEFAULT NULL,
48 `shop_limit` varchar(255) DEFAULT NULL
49) ENGINE=MyISAM;
50
51DROP TABLE IF EXISTS `player_gift`;
52CREATE TABLE `player_gift` (
53 `id` int(255) NOT NULL AUTO_INCREMENT,
54 `owner_id` int(255) NOT NULL,
55 `date_add` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
56 `date_get` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
57 `status` enum('WAIT','OK') COLLATE utf8_polish_ci NOT NULL DEFAULT 'WAIT',
58 `from` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
59 `reason` text COLLATE utf8_polish_ci NOT NULL,
60 `vnum` int(255) NOT NULL DEFAULT '0',
61 `count` bigint(255) NOT NULL DEFAULT '1',
62 `socket0` int(10) unsigned NOT NULL DEFAULT '0',
63 `socket1` int(10) unsigned NOT NULL DEFAULT '0',
64 `socket2` int(10) unsigned NOT NULL DEFAULT '0',
65 `socket3` int(10) unsigned NOT NULL DEFAULT '0',
66 `socket4` int(10) unsigned NOT NULL DEFAULT '0',
67 `socket5` int(10) unsigned NOT NULL DEFAULT '0',
68 `attrtype0` tinyint(4) NOT NULL DEFAULT '0',
69 `attrvalue0` smallint(6) NOT NULL DEFAULT '0',
70 `attrtype1` tinyint(4) NOT NULL DEFAULT '0',
71 `attrvalue1` smallint(6) NOT NULL DEFAULT '0',
72 `attrtype2` tinyint(4) NOT NULL DEFAULT '0',
73 `attrvalue2` smallint(6) NOT NULL DEFAULT '0',
74 `attrtype3` tinyint(4) NOT NULL DEFAULT '0',
75 `attrvalue3` smallint(6) NOT NULL DEFAULT '0',
76 `attrtype4` tinyint(4) NOT NULL DEFAULT '0',
77 `attrvalue4` smallint(6) NOT NULL DEFAULT '0',
78 `attrtype5` tinyint(4) NOT NULL DEFAULT '0',
79 `attrvalue5` smallint(6) NOT NULL DEFAULT '0',
80 `attrtype6` tinyint(4) NOT NULL DEFAULT '0',
81 `attrvalue6` smallint(6) NOT NULL DEFAULT '0',
82 `applytype0` tinyint(4) NOT NULL DEFAULT '0',
83 `applyvalue0` smallint(6) NOT NULL DEFAULT '0',
84 `applytype1` tinyint(4) NOT NULL DEFAULT '0',
85 `applyvalue1` smallint(6) NOT NULL DEFAULT '0',
86 `applytype2` tinyint(4) NOT NULL DEFAULT '0',
87 `applyvalue2` smallint(6) NOT NULL DEFAULT '0',
88 `applytype3` int(11) NOT NULL DEFAULT '0',
89 `applyvalue3` int(11) NOT NULL DEFAULT '0',
90 `applytype4` int(11) NOT NULL DEFAULT '0',
91 `applyvalue4` int(11) NOT NULL DEFAULT '0',
92 `applytype5` int(11) NOT NULL DEFAULT '0',
93 `applyvalue5` int(11) NOT NULL DEFAULT '0',
94 `applytype6` int(11) NOT NULL DEFAULT '0',
95 `applyvalue6` int(11) NOT NULL DEFAULT '0',
96 `applytype7` int(11) NOT NULL DEFAULT '0',
97 `applyvalue7` int(11) NOT NULL DEFAULT '0',
98 PRIMARY KEY (`id`)
99) ENGINE=MyISAM;
100ALTER TABLE `player_gift` ADD UNIQUE `id` (`id`);
101
102-- ----------------------------
103-- Table structure for player_shop_items
104-- ----------------------------
105DROP TABLE IF EXISTS `player_shop_items`;
106CREATE TABLE `player_shop_items` (
107 `id` int(255) NOT NULL AUTO_INCREMENT,
108 `shop_id` int(255) NOT NULL,
109 `player_id` int(255) NOT NULL DEFAULT '0',
110 `vnum` int(255) NOT NULL DEFAULT '0',
111 `count` int(20) NOT NULL DEFAULT '1',
112 `pos` int(20) NOT NULL DEFAULT '0',
113 `display_pos` int(20) NOT NULL DEFAULT '0',
114 `price` bigint(255) NOT NULL DEFAULT '0',
115 `socket0` int(10) unsigned NOT NULL DEFAULT '0',
116 `socket1` int(10) unsigned NOT NULL DEFAULT '0',
117 `socket2` int(10) unsigned NOT NULL DEFAULT '0',
118 `socket3` int(10) unsigned NOT NULL DEFAULT '0',
119 `socket4` int(10) unsigned NOT NULL DEFAULT '0',
120 `socket5` int(10) unsigned NOT NULL DEFAULT '0',
121 `attrtype0` tinyint(4) NOT NULL DEFAULT '0',
122 `attrvalue0` smallint(6) NOT NULL DEFAULT '0',
123 `attrtype1` tinyint(4) NOT NULL DEFAULT '0',
124 `attrvalue1` smallint(6) NOT NULL DEFAULT '0',
125 `attrtype2` tinyint(4) NOT NULL DEFAULT '0',
126 `attrvalue2` smallint(6) NOT NULL DEFAULT '0',
127 `attrtype3` tinyint(4) NOT NULL DEFAULT '0',
128 `attrvalue3` smallint(6) NOT NULL DEFAULT '0',
129 `attrtype4` tinyint(4) NOT NULL DEFAULT '0',
130 `attrvalue4` smallint(6) NOT NULL DEFAULT '0',
131 `attrtype5` tinyint(4) NOT NULL DEFAULT '0',
132 `attrvalue5` smallint(6) NOT NULL DEFAULT '0',
133 `attrtype6` tinyint(4) NOT NULL DEFAULT '0',
134 `attrvalue6` smallint(6) NOT NULL DEFAULT '0',
135 `applytype0` tinyint(4) NOT NULL DEFAULT '0',
136 `applyvalue0` smallint(6) NOT NULL DEFAULT '0',
137 `applytype1` tinyint(4) NOT NULL DEFAULT '0',
138 `applyvalue1` smallint(6) NOT NULL DEFAULT '0',
139 `applytype2` tinyint(4) NOT NULL DEFAULT '0',
140 `applyvalue2` smallint(6) NOT NULL DEFAULT '0',
141 `applytype3` int(11) NOT NULL DEFAULT '0',
142 `applyvalue3` int(11) NOT NULL DEFAULT '0',
143 `applytype4` int(11) NOT NULL DEFAULT '0',
144 `applyvalue4` int(11) NOT NULL DEFAULT '0',
145 `applytype5` int(11) NOT NULL DEFAULT '0',
146 `applyvalue5` int(11) NOT NULL DEFAULT '0',
147 `applytype6` int(11) NOT NULL DEFAULT '0',
148 `applyvalue6` int(11) NOT NULL DEFAULT '0',
149 `applytype7` int(11) NOT NULL DEFAULT '0',
150 `applyvalue7` int(11) NOT NULL DEFAULT '0',
151 PRIMARY KEY (`id`)
152) ENGINE=MyISAM;