· 6 years ago · Dec 17, 2019, 11:18 AM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : iveyas2
5 Source Server Type : MySQL
6 Source Server Version : 50726
7 Source Host : 51.75.36.164:3306
8 Source Schema : site
9
10 Target Server Type : MySQL
11 Target Server Version : 50726
12 File Encoding : 65001
13
14 Date: 17/12/2019 12:14:39
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for block_logs
22-- ----------------------------
23DROP TABLE IF EXISTS `block_logs`;
24CREATE TABLE `block_logs` (
25 `user` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `who_baned` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
28 `reason` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
29 `create_date` datetime(0) NULL DEFAULT NULL,
30 `unblock_date` datetime(0) NULL DEFAULT NULL,
31 PRIMARY KEY (`id`) USING BTREE
32) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
33
34-- ----------------------------
35-- Table structure for change_logs
36-- ----------------------------
37DROP TABLE IF EXISTS `change_logs`;
38CREATE TABLE `change_logs` (
39 `id` int(11) NOT NULL AUTO_INCREMENT,
40 `user` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
41 `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_polish_ci NULL DEFAULT NULL,
42 `status` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
43 `date` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
44 `ip` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
45 PRIMARY KEY (`id`) USING BTREE
46) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
47
48-- ----------------------------
49-- Table structure for codes
50-- ----------------------------
51DROP TABLE IF EXISTS `codes`;
52CREATE TABLE `codes` (
53 `id` int(11) NOT NULL AUTO_INCREMENT,
54 `code` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
55 `value` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
56 `count` int(11) NULL DEFAULT NULL,
57 `original_count` int(11) NULL DEFAULT NULL,
58 PRIMARY KEY (`id`) USING BTREE
59) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
60
61-- ----------------------------
62-- Table structure for codes_used
63-- ----------------------------
64DROP TABLE IF EXISTS `codes_used`;
65CREATE TABLE `codes_used` (
66 `id` int(11) NOT NULL AUTO_INCREMENT,
67 `user_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
68 `code` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
69 `date` datetime(0) NULL DEFAULT NULL,
70 PRIMARY KEY (`id`) USING BTREE
71) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
72
73-- ----------------------------
74-- Table structure for events_calendar
75-- ----------------------------
76DROP TABLE IF EXISTS `events_calendar`;
77CREATE TABLE `events_calendar` (
78 `Title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
79 `Date` date NULL DEFAULT NULL,
80 `Link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
81) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
82
83-- ----------------------------
84-- Table structure for news
85-- ----------------------------
86DROP TABLE IF EXISTS `news`;
87CREATE TABLE `news` (
88 `id` int(11) NOT NULL AUTO_INCREMENT,
89 `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
90 `content` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
91 `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
92 `date` bigint(11) NOT NULL,
93 PRIMARY KEY (`id`) USING BTREE
94) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
95
96-- ----------------------------
97-- Table structure for payment_logs
98-- ----------------------------
99DROP TABLE IF EXISTS `payment_logs`;
100CREATE TABLE `payment_logs` (
101 `id` int(11) NOT NULL AUTO_INCREMENT,
102 `user` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
103 `method` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
104 `value` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
105 `cost` decimal(10, 0) NULL DEFAULT NULL,
106 `date` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
107 `ip` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
108 PRIMARY KEY (`id`) USING BTREE
109) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
110
111-- ----------------------------
112-- Table structure for payment_sms
113-- ----------------------------
114DROP TABLE IF EXISTS `payment_sms`;
115CREATE TABLE `payment_sms` (
116 `id` int(11) NOT NULL AUTO_INCREMENT,
117 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
118 `value` int(11) NULL DEFAULT NULL,
119 `cost` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
120 `number` int(11) NULL DEFAULT NULL,
121 `content` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
122 `service_id` int(11) NULL DEFAULT NULL,
123 PRIMARY KEY (`id`) USING BTREE
124) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
125
126-- ----------------------------
127-- Table structure for payment_transfer
128-- ----------------------------
129DROP TABLE IF EXISTS `payment_transfer`;
130CREATE TABLE `payment_transfer` (
131 `id` int(11) NOT NULL AUTO_INCREMENT,
132 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
133 `value` int(11) NULL DEFAULT NULL,
134 `cost` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
135 PRIMARY KEY (`id`) USING BTREE
136) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
137
138-- ----------------------------
139-- Table structure for payment_transfer_epayouts
140-- ----------------------------
141DROP TABLE IF EXISTS `payment_transfer_epayouts`;
142CREATE TABLE `payment_transfer_epayouts` (
143 `id` int(11) NOT NULL AUTO_INCREMENT,
144 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
145 `value` int(11) NULL DEFAULT NULL,
146 `cost` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
147 PRIMARY KEY (`id`) USING BTREE
148) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
149
150-- ----------------------------
151-- Table structure for paypal_logs
152-- ----------------------------
153DROP TABLE IF EXISTS `paypal_logs`;
154CREATE TABLE `paypal_logs` (
155 `id` int(11) NOT NULL AUTO_INCREMENT,
156 `account_id` int(11) NULL DEFAULT NULL,
157 `tx` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
158 `price` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
159 `action` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
160 PRIMARY KEY (`id`) USING BTREE
161) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
162
163-- ----------------------------
164-- Table structure for shop_categories
165-- ----------------------------
166DROP TABLE IF EXISTS `shop_categories`;
167CREATE TABLE `shop_categories` (
168 `id` int(11) NOT NULL AUTO_INCREMENT,
169 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
170 `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
171 PRIMARY KEY (`id`) USING BTREE
172) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
173
174-- ----------------------------
175-- Table structure for shop_items
176-- ----------------------------
177DROP TABLE IF EXISTS `shop_items`;
178CREATE TABLE `shop_items` (
179 `id` int(11) NOT NULL AUTO_INCREMENT,
180 `category_id` int(11) NULL DEFAULT NULL,
181 `vnum` int(11) NULL DEFAULT NULL,
182 `count` int(11) NULL DEFAULT NULL,
183 `socket0` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
184 `socket1` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
185 `socket2` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
186 `cost` decimal(10, 0) NULL DEFAULT NULL,
187 `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
188 `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
189 PRIMARY KEY (`id`) USING BTREE
190) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
191
192-- ----------------------------
193-- Table structure for shop_logs
194-- ----------------------------
195DROP TABLE IF EXISTS `shop_logs`;
196CREATE TABLE `shop_logs` (
197 `id` int(11) NOT NULL AUTO_INCREMENT,
198 `user` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
199 `item` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
200 `cost` decimal(10, 0) NULL DEFAULT NULL,
201 `date` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
202 `ip` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
203 PRIMARY KEY (`id`) USING BTREE
204) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
205
206-- ----------------------------
207-- Table structure for sms_check
208-- ----------------------------
209DROP TABLE IF EXISTS `sms_check`;
210CREATE TABLE `sms_check` (
211 `id` int(11) NOT NULL AUTO_INCREMENT,
212 `code` varchar(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
213 `user_id` int(11) NULL DEFAULT NULL,
214 `number` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
215 `date` int(11) NULL DEFAULT NULL,
216 PRIMARY KEY (`id`) USING BTREE
217) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
218
219-- ----------------------------
220-- Table structure for transfer_check
221-- ----------------------------
222DROP TABLE IF EXISTS `transfer_check`;
223CREATE TABLE `transfer_check` (
224 `id` int(11) NOT NULL AUTO_INCREMENT,
225 `user_id` int(11) NULL DEFAULT NULL,
226 `amount` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
227 `order_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
228 `sign` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
229 `date` datetime(0) NULL DEFAULT NULL,
230 PRIMARY KEY (`id`) USING BTREE
231) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
232
233-- ----------------------------
234-- Table structure for transfer_check_epayouts
235-- ----------------------------
236DROP TABLE IF EXISTS `transfer_check_epayouts`;
237CREATE TABLE `transfer_check_epayouts` (
238 `id` int(11) NOT NULL AUTO_INCREMENT,
239 `user_id` int(11) NULL DEFAULT NULL,
240 `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
241 `order_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
242 `status` int(1) NULL DEFAULT NULL,
243 `calculated_at` datetime(0) NULL DEFAULT NULL,
244 PRIMARY KEY (`id`) USING BTREE
245) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
246
247-- ----------------------------
248-- Table structure for transfer_log
249-- ----------------------------
250DROP TABLE IF EXISTS `transfer_log`;
251CREATE TABLE `transfer_log` (
252 `id` int(11) NOT NULL AUTO_INCREMENT,
253 `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
254 `amount` float(11, 0) NULL DEFAULT NULL,
255 `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
256 `user_id` int(11) NULL DEFAULT NULL,
257 `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
258 `created_at` datetime(0) NULL DEFAULT NULL,
259 PRIMARY KEY (`id`) USING BTREE
260) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
261
262SET FOREIGN_KEY_CHECKS = 1;