· 9 years ago · Jan 02, 2017, 09:34 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.7.16-0ubuntu0.16.04.1 - (Ubuntu)
4-- Server OS: Linux
5-- HeidiSQL Version: 9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for streetwarsrp
14CREATE DATABASE IF NOT EXISTS `streetwarsrp` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci */;
15USE `streetwarsrp`;
16
17
18-- Dumping structure for table streetwarsrp.actions
19CREATE TABLE IF NOT EXISTS `actions` (
20 `id` int(11) NOT NULL AUTO_INCREMENT,
21 `transaction` int(11) NOT NULL,
22 `uid` bigint(20) DEFAULT NULL,
23 `buyer_name` varchar(50) DEFAULT NULL,
24 `actions` text,
25 `forum_claimed` int(11) DEFAULT '0',
26 `package` int(11) DEFAULT NULL,
27 `server` text,
28 `runonce` int(11) NOT NULL DEFAULT '1',
29 `updateable` int(11) NOT NULL DEFAULT '0',
30 `delivered` int(11) DEFAULT '0',
31 `active` int(11) DEFAULT '1',
32 `expiretime` date DEFAULT '0000-00-00',
33 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37-- Data exporting was unselected.
38
39
40-- Dumping structure for table streetwarsrp.advent_calendar
41CREATE TABLE IF NOT EXISTS `advent_calendar` (
42 `day` int(11) NOT NULL,
43 `img` text,
44 `package` text,
45 PRIMARY KEY (`day`)
46) ENGINE=InnoDB DEFAULT CHARSET=utf8;
47
48-- Data exporting was unselected.
49
50
51-- Dumping structure for table streetwarsrp.advent_claims
52CREATE TABLE IF NOT EXISTS `advent_claims` (
53 `id` int(11) NOT NULL AUTO_INCREMENT,
54 `adv_id` int(11) DEFAULT NULL,
55 `uid` bigint(20) DEFAULT NULL,
56 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
57 PRIMARY KEY (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59
60-- Data exporting was unselected.
61
62
63-- Dumping structure for table streetwarsrp.blacklist
64CREATE TABLE IF NOT EXISTS `blacklist` (
65 `id` int(11) NOT NULL AUTO_INCREMENT,
66 `name` text NOT NULL,
67 `steam64` bigint(20) NOT NULL,
68 `steamid` varchar(64) NOT NULL,
69 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
70 PRIMARY KEY (`id`)
71) ENGINE=InnoDB DEFAULT CHARSET=utf8;
72
73-- Data exporting was unselected.
74
75
76-- Dumping structure for table streetwarsrp.categories
77CREATE TABLE IF NOT EXISTS `categories` (
78 `id` int(11) NOT NULL AUTO_INCREMENT,
79 `order_id` int(11) DEFAULT NULL,
80 `name` varchar(50) DEFAULT NULL,
81 PRIMARY KEY (`id`)
82) ENGINE=InnoDB DEFAULT CHARSET=utf8;
83
84-- Data exporting was unselected.
85
86
87-- Dumping structure for table streetwarsrp.credit_packages
88CREATE TABLE IF NOT EXISTS `credit_packages` (
89 `id` int(11) NOT NULL AUTO_INCREMENT,
90 `title` varchar(50) NOT NULL,
91 `descr` text NOT NULL,
92 `amount` int(11) NOT NULL,
93 `price` double NOT NULL,
94 `currency` int(11) DEFAULT NULL,
95 PRIMARY KEY (`id`)
96) ENGINE=InnoDB DEFAULT CHARSET=utf8;
97
98-- Data exporting was unselected.
99
100
101-- Dumping structure for table streetwarsrp.currencies
102CREATE TABLE IF NOT EXISTS `currencies` (
103 `id` int(11) NOT NULL AUTO_INCREMENT,
104 `cc` varchar(3) NOT NULL,
105 PRIMARY KEY (`id`)
106) ENGINE=InnoDB DEFAULT CHARSET=utf8;
107
108-- Data exporting was unselected.
109
110
111-- Dumping structure for table streetwarsrp.logs
112CREATE TABLE IF NOT EXISTS `logs` (
113 `id` int(11) NOT NULL AUTO_INCREMENT,
114 `uid` bigint(20) NOT NULL DEFAULT '0',
115 `action` text NOT NULL,
116 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
117 PRIMARY KEY (`id`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8;
119
120-- Data exporting was unselected.
121
122
123-- Dumping structure for table streetwarsrp.news
124CREATE TABLE IF NOT EXISTS `news` (
125 `id` int(11) NOT NULL AUTO_INCREMENT,
126 `content` text NOT NULL,
127 `date` varchar(50) NOT NULL,
128 `uid` bigint(20) DEFAULT NULL,
129 PRIMARY KEY (`id`)
130) ENGINE=InnoDB DEFAULT CHARSET=utf8;
131
132-- Data exporting was unselected.
133
134
135-- Dumping structure for table streetwarsrp.packages
136CREATE TABLE IF NOT EXISTS `packages` (
137 `id` int(11) NOT NULL AUTO_INCREMENT,
138 `order_id` int(11) DEFAULT NULL,
139 `title` varchar(50) DEFAULT NULL,
140 `servers` text,
141 `labels` text,
142 `lower_text` text,
143 `actions` text,
144 `currency` int(11) DEFAULT '1',
145 `price` double DEFAULT '0',
146 `credits` double DEFAULT '0',
147 `img` varchar(1024) DEFAULT NULL,
148 `permanent` int(11) DEFAULT NULL,
149 `rebuyable` int(11) DEFAULT '0',
150 `days` int(11) DEFAULT '0',
151 `custom_price` double DEFAULT '0',
152 `custom_price_min` double DEFAULT NULL,
153 `non_compatible` varchar(1024) DEFAULT '[]',
154 `upgradeable` varchar(1024) DEFAULT '[]',
155 `hide` varchar(1024) DEFAULT '[]',
156 `no_owned` int(11) DEFAULT '0',
157 `bought_disable` varchar(1024) DEFAULT '[]',
158 `subscription` int(11) NOT NULL DEFAULT '0',
159 `once` int(11) NOT NULL DEFAULT '0',
160 `category` int(11) NOT NULL DEFAULT '1',
161 `alternative_paypal` varchar(50) DEFAULT NULL,
162 `enabled` int(11) DEFAULT '1',
163 PRIMARY KEY (`id`)
164) ENGINE=InnoDB DEFAULT CHARSET=utf8;
165
166-- Data exporting was unselected.
167
168
169-- Dumping structure for table streetwarsrp.pages
170CREATE TABLE IF NOT EXISTS `pages` (
171 `page` varchar(50) DEFAULT NULL,
172 `content` text
173) ENGINE=InnoDB DEFAULT CHARSET=utf8;
174
175-- Data exporting was unselected.
176
177
178-- Dumping structure for table streetwarsrp.permission_groups
179CREATE TABLE IF NOT EXISTS `permission_groups` (
180 `id` int(11) NOT NULL AUTO_INCREMENT,
181 `title` varchar(128) NOT NULL,
182 `json` text NOT NULL,
183 PRIMARY KEY (`id`)
184) ENGINE=InnoDB DEFAULT CHARSET=utf8;
185
186-- Data exporting was unselected.
187
188
189-- Dumping structure for table streetwarsrp.players
190CREATE TABLE IF NOT EXISTS `players` (
191 `id` int(11) NOT NULL AUTO_INCREMENT,
192 `uid` bigint(20) DEFAULT NULL,
193 `name` varchar(50) DEFAULT NULL,
194 `credits` double NOT NULL DEFAULT '0',
195 `admin` int(11) NOT NULL DEFAULT '0',
196 `perm_group` int(11) DEFAULT '0',
197 `session_token` varchar(128) DEFAULT NULL,
198 `tos_lastread` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
199 `ip` varchar(45) DEFAULT NULL,
200 PRIMARY KEY (`id`)
201) ENGINE=InnoDB DEFAULT CHARSET=utf8;
202
203-- Data exporting was unselected.
204
205
206-- Dumping structure for table streetwarsrp.postlogs
207CREATE TABLE IF NOT EXISTS `postlogs` (
208 `log` text,
209 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP
210) ENGINE=InnoDB DEFAULT CHARSET=utf8;
211
212-- Data exporting was unselected.
213
214
215-- Dumping structure for table streetwarsrp.prepurchase
216CREATE TABLE IF NOT EXISTS `prepurchase` (
217 `id` int(11) NOT NULL AUTO_INCREMENT,
218 `type` varchar(50) NOT NULL,
219 `uid` bigint(20) NOT NULL,
220 `json` text NOT NULL,
221 `delivered` tinyint(4) NOT NULL DEFAULT '0',
222 `extra` text,
223 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
224 PRIMARY KEY (`id`)
225) ENGINE=InnoDB DEFAULT CHARSET=utf8;
226
227-- Data exporting was unselected.
228
229
230-- Dumping structure for table streetwarsrp.raffles
231CREATE TABLE IF NOT EXISTS `raffles` (
232 `id` int(11) NOT NULL AUTO_INCREMENT,
233 `title` varchar(50) NOT NULL,
234 `descr` text NOT NULL,
235 `price` double NOT NULL,
236 `credits` int(11) NOT NULL,
237 `currency` int(11) NOT NULL DEFAULT '1',
238 `package` int(11) NOT NULL,
239 `img` text NOT NULL,
240 `max_per_person` int(11) NOT NULL DEFAULT '1',
241 `end_amount` int(11) NOT NULL DEFAULT '10',
242 `ended` int(11) NOT NULL DEFAULT '0',
243 `winner` bigint(20) DEFAULT NULL,
244 `enabled` int(11) NOT NULL DEFAULT '1',
245 PRIMARY KEY (`id`)
246) ENGINE=InnoDB DEFAULT CHARSET=utf8;
247
248-- Data exporting was unselected.
249
250
251-- Dumping structure for table streetwarsrp.raffle_tickets
252CREATE TABLE IF NOT EXISTS `raffle_tickets` (
253 `id` int(11) NOT NULL AUTO_INCREMENT,
254 `raffle_id` int(11) DEFAULT NULL,
255 `uid` bigint(20) DEFAULT NULL,
256 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
257 PRIMARY KEY (`id`)
258) ENGINE=InnoDB DEFAULT CHARSET=utf8;
259
260-- Data exporting was unselected.
261
262
263-- Dumping structure for table streetwarsrp.requests
264CREATE TABLE IF NOT EXISTS `requests` (
265 `id` int(11) NOT NULL AUTO_INCREMENT,
266 `error` int(11) NOT NULL,
267 `msg` text,
268 `debug` text,
269 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
270 PRIMARY KEY (`id`)
271) ENGINE=InnoDB DEFAULT CHARSET=utf8;
272
273-- Data exporting was unselected.
274
275
276-- Dumping structure for table streetwarsrp.servers
277CREATE TABLE IF NOT EXISTS `servers` (
278 `id` int(11) NOT NULL AUTO_INCREMENT,
279 `order_id` int(11) DEFAULT NULL,
280 `game` varchar(50) DEFAULT NULL,
281 `ip` varchar(50) DEFAULT NULL,
282 `port` varchar(50) DEFAULT NULL,
283 `rcon` text,
284 `name` varchar(128) NOT NULL,
285 `featured_package` int(11) NOT NULL DEFAULT '0',
286 `image_link` text,
287 PRIMARY KEY (`id`)
288) ENGINE=InnoDB DEFAULT CHARSET=utf8;
289
290-- Data exporting was unselected.
291
292
293-- Dumping structure for table streetwarsrp.settings
294CREATE TABLE IF NOT EXISTS `settings` (
295 `name` varchar(50) NOT NULL,
296 `value` text,
297 `value2` int(11) NOT NULL DEFAULT '0',
298 `value3` timestamp NULL DEFAULT NULL,
299 PRIMARY KEY (`name`)
300) ENGINE=InnoDB DEFAULT CHARSET=utf8;
301
302-- Data exporting was unselected.
303
304
305-- Dumping structure for table streetwarsrp.tickets
306CREATE TABLE IF NOT EXISTS `tickets` (
307 `id` int(11) NOT NULL AUTO_INCREMENT,
308 `uid` varchar(50) NOT NULL,
309 `descr` text NOT NULL,
310 `text` text NOT NULL,
311 `active` int(11) NOT NULL DEFAULT '1',
312 `seen` int(11) NOT NULL DEFAULT '0',
313 `client_seen` int(11) NOT NULL DEFAULT '1',
314 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
315 PRIMARY KEY (`id`)
316) ENGINE=InnoDB DEFAULT CHARSET=utf8;
317
318-- Data exporting was unselected.
319
320
321-- Dumping structure for table streetwarsrp.ticket_replies
322CREATE TABLE IF NOT EXISTS `ticket_replies` (
323 `id` int(11) NOT NULL AUTO_INCREMENT,
324 `ticket_id` int(11) DEFAULT NULL,
325 `uid` bigint(20) DEFAULT NULL,
326 `text` text,
327 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
328 PRIMARY KEY (`id`)
329) ENGINE=InnoDB DEFAULT CHARSET=utf8;
330
331-- Data exporting was unselected.
332
333
334-- Dumping structure for table streetwarsrp.transactions
335CREATE TABLE IF NOT EXISTS `transactions` (
336 `id` int(11) NOT NULL AUTO_INCREMENT,
337 `name` varchar(50) DEFAULT NULL,
338 `buyer` varchar(50) DEFAULT NULL,
339 `email` varchar(50) DEFAULT NULL,
340 `uid` bigint(20) DEFAULT NULL,
341 `buyer_uid` bigint(20) DEFAULT NULL,
342 `package` int(11) DEFAULT NULL,
343 `credit_package` int(11) DEFAULT NULL,
344 `raffle_package` int(11) DEFAULT NULL,
345 `currency` varchar(50) DEFAULT NULL,
346 `price` double DEFAULT NULL,
347 `credits` double DEFAULT '0',
348 `txn_id` varchar(50) DEFAULT NULL,
349 `gateway` varchar(50) DEFAULT NULL,
350 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
351 PRIMARY KEY (`id`)
352) ENGINE=InnoDB DEFAULT CHARSET=utf8;
353
354-- Data exporting was unselected.
355/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
356/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
357/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;