· 6 years ago · Oct 24, 2019, 06:46 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : Divi Gaming
5Source Server Version : 50505
6Source Host : 92.222.67.204:3306
7Source Database : Divi
8
9Target Server Type : MYSQL
10Target Server Version : 50505
11File Encoding : 65001
12
13Date: 2019-10-24 20:41:38
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for Achievement
20-- ----------------------------
21DROP TABLE IF EXISTS `Achievement`;
22CREATE TABLE `Achievement` (
23 `Area` varchar(255) NOT NULL,
24 `Title` varchar(255) NOT NULL,
25 `Content` varchar(255) NOT NULL,
26 `Points` varchar(255) NOT NULL,
27 `X` varchar(255) NOT NULL,
28 `Y` varchar(255) NOT NULL,
29 `Z` varchar(255) NOT NULL
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31
32-- ----------------------------
33-- Records of Achievement
34-- ----------------------------
35INSERT INTO `Achievement` VALUES ('FirstText', 'OMG!', 'Dein erster Text', '25', '-1968.71155', '119.39053', '27.68750');
36INSERT INTO `Achievement` VALUES ('Strider', 'Snake', '', '25', '-1974.142578125', '119.39053', '27.68750');
37INSERT INTO `Achievement` VALUES ('', 'Dean', '', '15', '-1974.142578125', '138.35937', '27.68750');
38
39-- ----------------------------
40-- Table structure for Ban
41-- ----------------------------
42DROP TABLE IF EXISTS `Ban`;
43CREATE TABLE `Ban` (
44 `ID` int(11) NOT NULL AUTO_INCREMENT,
45 `Name` varchar(255) DEFAULT NULL,
46 `Grund` varchar(255) DEFAULT NULL,
47 PRIMARY KEY (`ID`)
48) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
49
50-- ----------------------------
51-- Records of Ban
52-- ----------------------------
53
54-- ----------------------------
55-- Table structure for Changelog
56-- ----------------------------
57DROP TABLE IF EXISTS `Changelog`;
58CREATE TABLE `Changelog` (
59 `ID` int(11) NOT NULL AUTO_INCREMENT,
60 `Type` varchar(255) NOT NULL,
61 `Title` varchar(255) NOT NULL,
62 `Content` varchar(255) NOT NULL,
63 `Creator` varchar(255) NOT NULL,
64 `Date` date NOT NULL,
65 `Version` varchar(255) NOT NULL,
66 PRIMARY KEY (`ID`)
67) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
68
69-- ----------------------------
70-- Records of Changelog
71-- ----------------------------
72INSERT INTO `Changelog` VALUES ('1', 'Application', 'ABC', '123', 'Chem', '2018-10-27', '1.0');
73INSERT INTO `Changelog` VALUES ('2', 'Server', 'DEF', '456', 'iLimix', '2018-10-27', '1.1');
74INSERT INTO `Changelog` VALUES ('3', 'Homepage', 'GHI', '789', 'iLimix', '2018-10-27', '0.5');
75INSERT INTO `Changelog` VALUES ('4', 'Application', 'Divi Launcher: Release', 'Freudig können wir bekannt geben das der\r\nDivi Launcher nun Heruntergeladen werden kann.\r\nViel Spaß beim Benutzen!\r\n', 'Chem', '2018-10-28', 'Release');
76INSERT INTO `Changelog` VALUES ('6', 'Application', 'Update Feed Update!', 'Nun wird auch im update Feed der\r\nText korrekt angezeigt, die höhe\r\nDürfte nun optimal eingestellt sein\r\n', '', '2018-10-28', '1.0.1');
77INSERT INTO `Changelog` VALUES ('7', 'Application', 'Test', 'Lorem ipsum dolor sit amet, consetetur sadipscing \r\nelitr,sed diam nonumy eirmod tempor invidunt \r\nut labore et dolore magna aliquyam erat, sed \r\ndiam voluptua. At vero eos et accusam et justo \r\nduo dolores et ea rebum. Stet clita kasd gubergren', 'Chem', '2018-10-28', '1.0.1.1');
78INSERT INTO `Changelog` VALUES ('10', 'Application', 'Test', 'Lorem ipsum dolor sit amet, consetetur sadipscing \r\nelitr,sed diam nonumy eirmod tempor invidunt \r\nut labore et dolore magna aliquyam erat, sed \r\ndiam voluptua. At vero eos et accusam et justo \r\nduo dolores et ea rebum. Stet clita kasd gubergren', 'Chem', '2018-10-28', '1.0.1.1');
79INSERT INTO `Changelog` VALUES ('11', 'Application', 'Test', 'Lorem ipsum dolor sit amet, consetetur sadipscing \r\nelitr,sed diam nonumy eirmod tempor invidunt \r\nut labore et dolore magna aliquyam erat, sed \r\ndiam voluptua. At vero eos et accusam et justo \r\nduo dolores et ea rebum. Stet clita kasd gubergren', 'Chem', '2018-10-28', '1.0.1.1');
80
81-- ----------------------------
82-- Table structure for clothes
83-- ----------------------------
84DROP TABLE IF EXISTS `clothes`;
85CREATE TABLE `clothes` (
86 `ID` int(11) NOT NULL AUTO_INCREMENT,
87 `Type` int(11) NOT NULL,
88 `ObjectID` int(11) NOT NULL,
89 `Name` varchar(255) NOT NULL,
90 `Owner` int(11) NOT NULL,
91 PRIMARY KEY (`ID`)
92) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;
93
94-- ----------------------------
95-- Records of clothes
96-- ----------------------------
97INSERT INTO `clothes` VALUES ('70', '1', '7448', 'Schwarzer Hut', '57');
98INSERT INTO `clothes` VALUES ('102', '1', '7438', 'Kappe #1', '57');
99INSERT INTO `clothes` VALUES ('103', '1', '7439', 'Kappe #2', '57');
100INSERT INTO `clothes` VALUES ('104', '1', '7440', 'Kappe #3', '57');
101INSERT INTO `clothes` VALUES ('105', '1', '7441', 'Kappe #4', '57');
102INSERT INTO `clothes` VALUES ('106', '1', '7448', 'Schwarzer Hut', '57');
103INSERT INTO `clothes` VALUES ('107', '1', '7449', 'Blauer Hut', '57');
104INSERT INTO `clothes` VALUES ('108', '1', '7450', 'Grüner Hut', '57');
105INSERT INTO `clothes` VALUES ('109', '1', '7451', 'Roter Hut', '57');
106INSERT INTO `clothes` VALUES ('110', '2', '7422', 'Brille #6', '57');
107INSERT INTO `clothes` VALUES ('111', '2', '7423', 'Brille #7', '57');
108INSERT INTO `clothes` VALUES ('112', '2', '7424', 'Brille #8', '57');
109INSERT INTO `clothes` VALUES ('113', '2', '7425', 'Brille #9', '57');
110INSERT INTO `clothes` VALUES ('114', '2', '7426', 'Brille #10', '57');
111INSERT INTO `clothes` VALUES ('115', '3', '7460', 'Armbanduhr #5', '57');
112INSERT INTO `clothes` VALUES ('116', '3', '7462', 'Armbanduhr #7', '57');
113INSERT INTO `clothes` VALUES ('117', '3', '7463', 'Armbanduhr #8', '57');
114INSERT INTO `clothes` VALUES ('118', '3', '7464', 'Armbanduhr #9', '57');
115INSERT INTO `clothes` VALUES ('119', '3', '7465', 'Armbanduhr #10', '57');
116INSERT INTO `clothes` VALUES ('120', '4', '8378', 'Tasche #4', '57');
117INSERT INTO `clothes` VALUES ('121', '4', '8380', 'Tasche #5', '57');
118INSERT INTO `clothes` VALUES ('122', '4', '8382', 'Tasche #6', '57');
119INSERT INTO `clothes` VALUES ('123', '5', '7471', 'Maske #1', '57');
120INSERT INTO `clothes` VALUES ('124', '5', '7472', 'Maske #2', '57');
121INSERT INTO `clothes` VALUES ('125', '5', '7473', 'Maske #3', '57');
122INSERT INTO `clothes` VALUES ('126', '5', '7474', 'Maske #4', '57');
123INSERT INTO `clothes` VALUES ('127', '5', '7476', 'Maske #6', '57');
124INSERT INTO `clothes` VALUES ('128', '5', '7477', 'Maske #7', '57');
125INSERT INTO `clothes` VALUES ('129', '5', '7478', 'Maske #8', '57');
126INSERT INTO `clothes` VALUES ('130', '7', '7521', 'Nike Bauchtasche', '57');
127INSERT INTO `clothes` VALUES ('131', '1', '7440', 'Kappe #3', '60');
128
129-- ----------------------------
130-- Table structure for coins
131-- ----------------------------
132DROP TABLE IF EXISTS `coins`;
133CREATE TABLE `coins` (
134 `Name` varchar(255) NOT NULL,
135 `Coins` int(15) NOT NULL,
136 `txn` text NOT NULL,
137 `psc` text NOT NULL,
138 PRIMARY KEY (`Name`)
139) ENGINE=InnoDB DEFAULT CHARSET=utf8;
140
141-- ----------------------------
142-- Records of coins
143-- ----------------------------
144
145-- ----------------------------
146-- Table structure for Faction_buycar
147-- ----------------------------
148DROP TABLE IF EXISTS `Faction_buycar`;
149CREATE TABLE `Faction_buycar` (
150 `ID` int(11) NOT NULL AUTO_INCREMENT,
151 `Faction` int(11) NOT NULL,
152 `VehID` int(11) NOT NULL,
153 `Preis` int(11) NOT NULL,
154 `Color` text NOT NULL,
155 `Color2` text NOT NULL,
156 `INFO` varchar(255) NOT NULL,
157 PRIMARY KEY (`ID`)
158) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
159
160-- ----------------------------
161-- Records of Faction_buycar
162-- ----------------------------
163INSERT INTO `Faction_buycar` VALUES ('1', '1', '487', '400000', '#000000', '#FFFF', 'PD Maverick');
164INSERT INTO `Faction_buycar` VALUES ('2', '1', '427', '4000', '#000000', '#FFFF', 'Enforcer');
165INSERT INTO `Faction_buycar` VALUES ('3', '1', '532', '4000', '#000000', '#FFFF', 'HPV1000');
166INSERT INTO `Faction_buycar` VALUES ('4', '1', '596', '8000', '#000000', '#FFFF', 'Police LS');
167INSERT INTO `Faction_buycar` VALUES ('5', '1', '599', '8000', '#000000', '#FFFF', 'Police Ranger');
168INSERT INTO `Faction_buycar` VALUES ('6', '1', '411', '10000', '#000000', '#FFFF', 'Infernus');
169
170-- ----------------------------
171-- Table structure for Faction_Car
172-- ----------------------------
173DROP TABLE IF EXISTS `Faction_Car`;
174CREATE TABLE `Faction_Car` (
175 `ID` int(11) NOT NULL AUTO_INCREMENT,
176 `VehID` int(11) NOT NULL,
177 `Faction` int(11) NOT NULL,
178 `OwnerSlot` smallint(255) NOT NULL,
179 `X` double(255,0) NOT NULL,
180 `Y` double(255,0) NOT NULL,
181 `Z` double(255,0) NOT NULL,
182 `RX` double(255,0) NOT NULL,
183 `RY` double(255,0) NOT NULL,
184 `RZ` double(255,0) NOT NULL,
185 `CarRang` smallint(255) NOT NULL COMMENT '0',
186 `Panzerung` int(255) NOT NULL,
187 `Tank` int(255) NOT NULL DEFAULT '100' COMMENT '100',
188 PRIMARY KEY (`ID`)
189) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
190
191-- ----------------------------
192-- Records of Faction_Car
193-- ----------------------------
194INSERT INTO `Faction_Car` VALUES ('29', '411', '1', '0', '1529', '-1688', '6', '0', '0', '270', '0', '0', '100');
195INSERT INTO `Faction_Car` VALUES ('30', '411', '1', '0', '1529', '-1684', '6', '0', '0', '270', '0', '0', '100');
196INSERT INTO `Faction_Car` VALUES ('33', '427', '1', '0', '1531', '-1646', '6', '0', '0', '180', '0', '0', '100');
197INSERT INTO `Faction_Car` VALUES ('34', '427', '1', '0', '1526', '-1646', '6', '0', '0', '180', '0', '0', '100');
198INSERT INTO `Faction_Car` VALUES ('35', '427', '1', '0', '1539', '-1646', '6', '0', '0', '180', '0', '0', '100');
199INSERT INTO `Faction_Car` VALUES ('36', '427', '1', '0', '1535', '-1646', '6', '0', '0', '180', '0', '0', '100');
200INSERT INTO `Faction_Car` VALUES ('37', '599', '1', '0', '1602', '-1684', '6', '0', '0', '90', '0', '0', '100');
201INSERT INTO `Faction_Car` VALUES ('38', '599', '1', '0', '1602', '-1688', '6', '0', '0', '90', '0', '0', '100');
202INSERT INTO `Faction_Car` VALUES ('39', '599', '1', '0', '1602', '-1692', '6', '0', '0', '90', '0', '0', '100');
203INSERT INTO `Faction_Car` VALUES ('40', '599', '1', '0', '1602', '-1696', '6', '0', '0', '90', '0', '0', '100');
204INSERT INTO `Faction_Car` VALUES ('41', '599', '1', '0', '1602', '-1700', '6', '0', '0', '90', '0', '0', '100');
205INSERT INTO `Faction_Car` VALUES ('42', '599', '1', '0', '1602', '-1704', '6', '0', '0', '90', '0', '0', '100');
206INSERT INTO `Faction_Car` VALUES ('43', '596', '1', '0', '1594', '-1711', '6', '0', '0', '359', '0', '0', '100');
207INSERT INTO `Faction_Car` VALUES ('44', '596', '1', '0', '1592', '-1711', '6', '0', '0', '359', '0', '0', '100');
208INSERT INTO `Faction_Car` VALUES ('45', '596', '1', '0', '1587', '-1711', '6', '0', '0', '359', '0', '0', '100');
209INSERT INTO `Faction_Car` VALUES ('46', '596', '1', '0', '1570', '-1712', '6', '0', '0', '173', '0', '0', '100');
210INSERT INTO `Faction_Car` VALUES ('47', '596', '1', '0', '1579', '-1711', '6', '0', '0', '359', '0', '0', '100');
211INSERT INTO `Faction_Car` VALUES ('48', '532', '1', '0', '1577', '-1623', '13', '0', '0', '274', '0', '0', '100');
212INSERT INTO `Faction_Car` VALUES ('49', '411', '1', '0', '1545', '-1659', '6', '0', '0', '269', '0', '0', '100');
213INSERT INTO `Faction_Car` VALUES ('50', '532', '1', '0', '1576', '-1703', '6', '0', '0', '96', '0', '0', '100');
214
215-- ----------------------------
216-- Table structure for Fraktion
217-- ----------------------------
218DROP TABLE IF EXISTS `Fraktion`;
219CREATE TABLE `Fraktion` (
220 `ID` int(11) NOT NULL AUTO_INCREMENT,
221 `Owner` text NOT NULL,
222 `Geld` bigint(20) NOT NULL DEFAULT '0',
223 `Materials` bigint(20) NOT NULL DEFAULT '0',
224 `Drogen` bigint(20) NOT NULL DEFAULT '0',
225 `Fahrzeuggeld` bigint(20) NOT NULL DEFAULT '0',
226 `MaxVehicles` int(11) NOT NULL DEFAULT '0',
227 `MaxPlayers` int(11) NOT NULL DEFAULT '0',
228 `DepotEquip` int(11) NOT NULL,
229 PRIMARY KEY (`ID`)
230) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
231
232-- ----------------------------
233-- Records of Fraktion
234-- ----------------------------
235INSERT INTO `Fraktion` VALUES ('1', 'LSPD', '0', '0', '0', '0', '20', '0', '9967');
236INSERT INTO `Fraktion` VALUES ('2', 'FBI', '0', '0', '0', '0', '20', '0', '0');
237INSERT INTO `Fraktion` VALUES ('3', 'Army', '0', '0', '0', '0', '20', '0', '0');
238INSERT INTO `Fraktion` VALUES ('4', 'Regierung', '0', '0', '0', '2000000000', '40', '0', '0');
239
240-- ----------------------------
241-- Table structure for Gang
242-- ----------------------------
243DROP TABLE IF EXISTS `Gang`;
244CREATE TABLE `Gang` (
245 `ID` int(11) NOT NULL AUTO_INCREMENT,
246 `Gangname` varchar(255) NOT NULL,
247 `OwnerUID` varchar(255) NOT NULL,
248 `Cash` bigint(20) NOT NULL,
249 `CashMax` bigint(255) NOT NULL DEFAULT '10000',
250 `Member` int(11) NOT NULL,
251 `MemberMax` int(255) NOT NULL DEFAULT '4',
252 `Cars` int(11) NOT NULL,
253 `CarsMax` int(11) NOT NULL DEFAULT '3',
254 PRIMARY KEY (`ID`)
255) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
256
257-- ----------------------------
258-- Records of Gang
259-- ----------------------------
260INSERT INTO `Gang` VALUES ('10', 'Hallo', '60', '310', '10000', '4', '4', '0', '35');
261INSERT INTO `Gang` VALUES ('11', 'Black', '61', '310', '10000', '4', '4', '0', '35');
262INSERT INTO `Gang` VALUES ('12', 'BBC', '63', '310', '10000', '4', '4', '0', '35');
263
264-- ----------------------------
265-- Table structure for Gang_Member
266-- ----------------------------
267DROP TABLE IF EXISTS `Gang_Member`;
268CREATE TABLE `Gang_Member` (
269 `ID` int(11) NOT NULL,
270 `GangID` int(11) NOT NULL,
271 `Member` varchar(255) NOT NULL,
272 `Rank` varchar(255) NOT NULL,
273 PRIMARY KEY (`GangID`,`ID`)
274) ENGINE=InnoDB DEFAULT CHARSET=utf8;
275
276-- ----------------------------
277-- Records of Gang_Member
278-- ----------------------------
279INSERT INTO `Gang_Member` VALUES ('0', '10', '60', '6');
280INSERT INTO `Gang_Member` VALUES ('0', '11', '61', '6');
281INSERT INTO `Gang_Member` VALUES ('0', '12', '63', '6');
282
283-- ----------------------------
284-- Table structure for Homepage_Slider
285-- ----------------------------
286DROP TABLE IF EXISTS `Homepage_Slider`;
287CREATE TABLE `Homepage_Slider` (
288 `ID` int(11) NOT NULL AUTO_INCREMENT,
289 `Title` varchar(255) NOT NULL,
290 `Content` varchar(255) NOT NULL,
291 `Image` varchar(255) NOT NULL,
292 `ImageThumb` varchar(255) NOT NULL,
293 PRIMARY KEY (`ID`)
294) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
295
296-- ----------------------------
297-- Records of Homepage_Slider
298-- ----------------------------
299INSERT INTO `Homepage_Slider` VALUES ('1', 'dsaasd', 'asddsa', 'adsdsa', 'dsadsa');
300
301-- ----------------------------
302-- Table structure for Houses
303-- ----------------------------
304DROP TABLE IF EXISTS `Houses`;
305CREATE TABLE `Houses` (
306 `ID` int(6) NOT NULL AUTO_INCREMENT,
307 `X` float DEFAULT NULL,
308 `Y` float DEFAULT NULL,
309 `Z` float DEFAULT NULL,
310 `INTERIOR` int(10) DEFAULT NULL,
311 `INTX` float DEFAULT NULL,
312 `INTY` float DEFAULT NULL,
313 `INTZ` float DEFAULT NULL,
314 `MONEY` int(20) DEFAULT '0',
315 `WEAP1` varchar(45) DEFAULT '0',
316 `WEAP2` varchar(45) DEFAULT '0',
317 `WEAP3` varchar(45) DEFAULT '0',
318 `LOCKED` int(2) DEFAULT '0',
319 `PRICE` int(10) DEFAULT '0',
320 `OWNER` varchar(32) DEFAULT 'no-one',
321 `RENTABLE` int(2) DEFAULT '0',
322 `RENTALPRICE` int(10) DEFAULT '0',
323 `RENT1` varchar(32) DEFAULT 'no-one',
324 `RENT2` varchar(32) DEFAULT 'no-one',
325 `RENT3` varchar(32) DEFAULT 'no-one',
326 `RENT4` varchar(32) DEFAULT 'no-one',
327 `RENT5` varchar(32) DEFAULT 'no-one',
328 PRIMARY KEY (`ID`)
329) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=latin1;
330
331-- ----------------------------
332-- Records of Houses
333-- ----------------------------
334INSERT INTO `Houses` VALUES ('115', '1567.52', '-1884.55', '13.5576', '10', '2270.08', '-1210.49', '1047.56', '0', '0', '0', '0', '0', '23323', 'Funachra', '0', '0', 'no-one', 'no-one', 'no-one', 'no-one', 'no-one');
335INSERT INTO `Houses` VALUES ('116', '1258.71', '-785.462', '92.0302', '5', '1261.12', '-785.38', '1091.91', '0', '0', '0', '0', '0', '999999', 'no-one', '0', '0', 'no-one', 'no-one', 'no-one', 'no-one', 'no-one');
336
337-- ----------------------------
338-- Table structure for Inventory
339-- ----------------------------
340DROP TABLE IF EXISTS `Inventory`;
341CREATE TABLE `Inventory` (
342 `UID` int(11) NOT NULL,
343 PRIMARY KEY (`UID`)
344) ENGINE=InnoDB DEFAULT CHARSET=utf8;
345
346-- ----------------------------
347-- Records of Inventory
348-- ----------------------------
349
350-- ----------------------------
351-- Table structure for itemlist
352-- ----------------------------
353DROP TABLE IF EXISTS `itemlist`;
354CREATE TABLE `itemlist` (
355 `id` int(11) NOT NULL AUTO_INCREMENT,
356 `item_owner` int(11) NOT NULL,
357 `item_type` varchar(30) NOT NULL,
358 `item_id` int(11) NOT NULL,
359 `item_slot` int(11) NOT NULL,
360 `item_value` int(11) NOT NULL,
361 `item_count` int(11) NOT NULL,
362 `item_duty` int(11) NOT NULL,
363 `item_health` int(11) NOT NULL,
364 PRIMARY KEY (`id`),
365 KEY `id` (`id`)
366) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=latin1;
367
368-- ----------------------------
369-- Records of itemlist
370-- ----------------------------
371INSERT INTO `itemlist` VALUES ('120', '69', 'player', '1', '1', '187', '1', '0', '100');
372INSERT INTO `itemlist` VALUES ('121', '60', 'player', '1', '1', '188', '1', '0', '100');
373INSERT INTO `itemlist` VALUES ('122', '60', 'player', '1', '2', '189', '1', '0', '100');
374INSERT INTO `itemlist` VALUES ('123', '61', 'player', '1', '1', '190', '1', '0', '100');
375INSERT INTO `itemlist` VALUES ('124', '69', 'player', '1', '2', '191', '1', '0', '100');
376INSERT INTO `itemlist` VALUES ('125', '69', 'player', '1', '3', '192', '1', '0', '100');
377INSERT INTO `itemlist` VALUES ('126', '69', 'player', '1', '4', '193', '1', '0', '100');
378INSERT INTO `itemlist` VALUES ('127', '60', 'player', '1', '3', '194', '1', '0', '100');
379INSERT INTO `itemlist` VALUES ('128', '60', 'player', '1', '4', '195', '1', '0', '100');
380INSERT INTO `itemlist` VALUES ('129', '60', 'player', '1', '5', '196', '1', '0', '100');
381INSERT INTO `itemlist` VALUES ('130', '60', 'player', '1', '6', '197', '1', '0', '100');
382INSERT INTO `itemlist` VALUES ('131', '60', 'player', '1', '7', '198', '1', '0', '100');
383INSERT INTO `itemlist` VALUES ('132', '60', 'player', '1', '8', '199', '1', '0', '100');
384INSERT INTO `itemlist` VALUES ('133', '60', 'player', '1', '9', '200', '1', '0', '100');
385
386-- ----------------------------
387-- Table structure for marktplatz
388-- ----------------------------
389DROP TABLE IF EXISTS `marktplatz`;
390CREATE TABLE `marktplatz` (
391 `ID` int(10) NOT NULL AUTO_INCREMENT,
392 `seller` varchar(50) NOT NULL,
393 `title` varchar(255) NOT NULL,
394 `description` text NOT NULL,
395 `price` int(15) NOT NULL,
396 `buyer` varchar(50) NOT NULL,
397 `starttime` datetime NOT NULL,
398 `endtime` datetime NOT NULL,
399 `objecttyp` varchar(25) NOT NULL,
400 `objectID` int(8) NOT NULL,
401 PRIMARY KEY (`ID`)
402) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
403
404-- ----------------------------
405-- Records of marktplatz
406-- ----------------------------
407
408-- ----------------------------
409-- Table structure for Neuigkeiten
410-- ----------------------------
411DROP TABLE IF EXISTS `Neuigkeiten`;
412CREATE TABLE `Neuigkeiten` (
413 `ID` int(11) NOT NULL,
414 `Title` text NOT NULL,
415 `Neuigkeiten` longtext NOT NULL,
416 `Datum` varchar(255) NOT NULL,
417 PRIMARY KEY (`ID`) USING BTREE
418) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
419
420-- ----------------------------
421-- Records of Neuigkeiten
422-- ----------------------------
423INSERT INTO `Neuigkeiten` VALUES ('1', '[Update] Login v30000000', 'Update v.0.0.1\r\n - Login\r\n - Register', '27.03.2018');
424INSERT INTO `Neuigkeiten` VALUES ('2', '[NEWS] Server Comeback', '', '27.03.2018');
425INSERT INTO `Neuigkeiten` VALUES ('3', '[NEWS] Server Comeback', '', '27.03.2018');
426INSERT INTO `Neuigkeiten` VALUES ('4', '[NEWS] Server Comeback', '', '27.03.2018');
427INSERT INTO `Neuigkeiten` VALUES ('5', '[NEWS] Server Comeback', '', '27.03.2018');
428INSERT INTO `Neuigkeiten` VALUES ('6', '[NEWS] Server Comeback', '', '27.03.2018');
429INSERT INTO `Neuigkeiten` VALUES ('7', '[NEWS] Server Comeback', '', '27.03.2018');
430INSERT INTO `Neuigkeiten` VALUES ('8', '[NEWS] Server Comeback', '', '27.03.2018');
431INSERT INTO `Neuigkeiten` VALUES ('9', '[NEWS] Server Comeback', '', '27.03.2018');
432
433-- ----------------------------
434-- Table structure for Partei
435-- ----------------------------
436DROP TABLE IF EXISTS `Partei`;
437CREATE TABLE `Partei` (
438 `ID` int(11) NOT NULL,
439 `Partei` varchar(255) NOT NULL,
440 `Vote` int(255) NOT NULL,
441 PRIMARY KEY (`ID`)
442) ENGINE=InnoDB DEFAULT CHARSET=latin1;
443
444-- ----------------------------
445-- Records of Partei
446-- ----------------------------
447INSERT INTO `Partei` VALUES ('1', 'SPD', '0');
448INSERT INTO `Partei` VALUES ('2', 'AfD', '0');
449INSERT INTO `Partei` VALUES ('3', 'CDU', '0');
450
451-- ----------------------------
452-- Table structure for Players
453-- ----------------------------
454DROP TABLE IF EXISTS `Players`;
455CREATE TABLE `Players` (
456 `UID` int(11) NOT NULL AUTO_INCREMENT,
457 `Name` varchar(255) NOT NULL,
458 `Password` varchar(255) NOT NULL,
459 `Salt` varchar(255) NOT NULL,
460 `Email` varchar(255) NOT NULL,
461 `Serial` varchar(255) NOT NULL,
462 `RegisterDate` varchar(255) NOT NULL,
463 `Birthday` varchar(255) NOT NULL,
464 `Language` varchar(255) NOT NULL,
465 `TSUID` varchar(255) NOT NULL,
466 `Premiumpunkte` bigint(20) NOT NULL,
467 `Gender` varchar(255) NOT NULL,
468 `Securetoken` varchar(255) NOT NULL,
469 `Autologin` tinyint(4) NOT NULL,
470 `MacAdress` varchar(255) NOT NULL,
471 PRIMARY KEY (`UID`) USING BTREE
472) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
473
474-- ----------------------------
475-- Records of Players
476-- ----------------------------
477INSERT INTO `Players` VALUES ('59', 'Chem', '42df06dad5ce91ba3cc42447ed3c213a95ba79cc50d856e474f51bed0ec9466149bf246e9329d106bd95f9fdec6268f161db9e4c8dde98d288a5b61fa0cdd471', 'QS9~W', '', '953856F292EDE59F5E7ED1F9F8080291', '10.8.2019, 13:5', '09.08.2000', '1', '', '99999', 'Männlich', '', '1', '');
478INSERT INTO `Players` VALUES ('60', 'iLimix', '39ae846f22e66ddc5d78f4e4d178b2c8ff43d81dd36c091deb873290804f3d4ac12b97ac638edfec257e7b0ab3b5536ac2e9f3a2f0c229fcbb3ba9de632c93e7', 'nmM[L', 'duran.kazim@outlook.de', '555DACE1F16D427A338DF8A52B56BEE3', '11.8.2019, 21:41', '14.04.1997', '1', '', '0', 'Weiblich', '', '1', '9C-5C-8E-C0-7C-D6');
479INSERT INTO `Players` VALUES ('61', 'Karma', '1e22a431665709665312e2b9e0a1ca3b5e35df9e7c316a7d4fc03e65e2f3ea79b2317fe7eec79578a6c798197feb741da4bbd1f6c889b883e77f08437a80ee89', 'doN=t', 'retrowolke@web.de', 'D92857D1BC744F49BF863157C791FB94', '11.8.2019, 21:44', '28.10.1994', '1', '', '99999', 'Männlich', '', '1', '');
480INSERT INTO `Players` VALUES ('62', 'Strider', 'ee1ab68433f4a1f9d51f3c81134cdfca2b16c490a6a5d888863e728edc40eac6a47cf530ee6b94c2229a6b77c3a85ed3166ec5086775c3360b6ebd2c1cc13f0f', '1ttOq', 'Strider@Hotmail.com', 'BB9E8DFE35CDD23DB2C448881111F6A2', '13.9.2019, 18:23', '22.5.1870', '1', '', '0', 'Männlich', '', '1', '');
481INSERT INTO `Players` VALUES ('63', 'Se7enDeagle', '1c7693b92d5680d3029a226f6c014d7a59d7afc231d1f8728ff74d24439b2f5914036c992cb8c290832ea49816be7ee542726bc2996d0ae4042d2707dee70b2f', ']<7Z', 'bart.ba@web.de', 'D6EFC1DAB254262284648E3F1F4EDC12', '14.9.2019, 21:7', '16.7.2001', '1', '', '0', 'Männlich', '', '1', '');
482INSERT INTO `Players` VALUES ('64', 'Bad_Karma', '8ae61f605b28b82307934e50088e98011f9cc751f53c3a92ae383f075c78ebe6196697d7746d3c38438ae776eb25fb2dadf21a7fef49059faf953795706dbc37', 'ZhsRC', 'dean.94@gmx.at', '181762C6136ED3B0336AFEB7C19C6802', '18.9.2019, 10:9', '28.10.1994', '1', '', '0', 'Männlich', '', '1', '');
483INSERT INTO `Players` VALUES ('65', 'Shanks', 'c00e5fa121c71c6c78eb137c0db7b47547ceabf9ea7efe5fb71ee6a42136d9a2ac8a73f35d51b912a0ca1b438b89bb3966143f6ca76ad9e47be9d3632dd5a336', 'HOW0+', 'Mehmet@hotmail.com', '9FAFA014160F62FB6DB77D078CE069A4', '20.9.2019, 23:47', '13.09.1995', '1', '', '999999999', 'Männlich', '', '1', '');
484INSERT INTO `Players` VALUES ('66', 'Good_Karma', 'd9771198b721320e71d97f472425b904e203f68678f19830f6beb84e6472036916d196dc4bc07ae1cbd13bf74388f32a5f5a18c000ac1c3714a0501930c34104', '[M.11', 'penis@gmx.at', '68FCCE3FA1C58151B740A2EC6C3BA2E3', '23.9.2019, 20:40', '28.10.1994', '1', '', '0', 'Männlich', '', '0', '');
485INSERT INTO `Players` VALUES ('67', 'BadKarma', '252eb82a6be0086c05ae9e9d12483993582768016e22cb458c795fd5c88ccf369949dad6df8cd443964eafcc2ace0d20964d42bea743f8e2ee15845a19477706', ':4O2h', 'Workflow99@gmx.de', 'D6C8E690F4FF289BCBD03014C2CD80E2', '30.9.2019, 22:35', '08.01.1999', '2', '', '0', 'Männlich', '', '1', '');
486INSERT INTO `Players` VALUES ('68', 'n0pe', 'fe5fc40a046df1ba1b4b7108aad1275726ae07d57ac9dcb961db133012e0fe8c56fc4f7a5e6bfed0a7e31c01306e64b01f90841213e59dad96848877d3734f15', 'ZBW@;', 'pipimann@test.de', '0B7828CB6EB7DD0DE1CD99BD0C62A3B2', '6.10.2019, 19:43', '20.10.1997', '1', '', '0', 'Männlich', '', '0', '');
487INSERT INTO `Players` VALUES ('69', 'Funachra', '718671fa143467757613d36ee3f59ac613b324c0d19d329462287769907273877deaee00e4d7f2df15d518e061a397c6bb7f3e3e27e62f282f8b7dbbc2d6300b', 'xp8Cf', 'Funachra@gmail.com', 'CF36E7C28A2E7B7D4B82011A19B19B93', '11.10.2019, 21:27', '15.12.1987', '1', '', '0', 'Männlich', '', '1', '');
488
489-- ----------------------------
490-- Table structure for Players_Achievement
491-- ----------------------------
492DROP TABLE IF EXISTS `Players_Achievement`;
493CREATE TABLE `Players_Achievement` (
494 `UID` int(11) NOT NULL AUTO_INCREMENT,
495 `FirstText` tinyint(4) NOT NULL DEFAULT '0',
496 PRIMARY KEY (`UID`),
497 CONSTRAINT `Players_Achievement_ibfk_1` FOREIGN KEY (`UID`) REFERENCES `Players` (`UID`) ON DELETE CASCADE ON UPDATE CASCADE
498) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
499
500-- ----------------------------
501-- Records of Players_Achievement
502-- ----------------------------
503INSERT INTO `Players_Achievement` VALUES ('59', '0');
504INSERT INTO `Players_Achievement` VALUES ('60', '0');
505INSERT INTO `Players_Achievement` VALUES ('61', '0');
506INSERT INTO `Players_Achievement` VALUES ('62', '0');
507INSERT INTO `Players_Achievement` VALUES ('63', '0');
508INSERT INTO `Players_Achievement` VALUES ('64', '0');
509INSERT INTO `Players_Achievement` VALUES ('65', '0');
510INSERT INTO `Players_Achievement` VALUES ('66', '0');
511INSERT INTO `Players_Achievement` VALUES ('67', '0');
512INSERT INTO `Players_Achievement` VALUES ('68', '0');
513INSERT INTO `Players_Achievement` VALUES ('69', '0');
514
515-- ----------------------------
516-- Table structure for Players_Job
517-- ----------------------------
518DROP TABLE IF EXISTS `Players_Job`;
519CREATE TABLE `Players_Job` (
520 `UID` int(11) NOT NULL,
521 `Job` int(255) NOT NULL,
522 `Bus` bigint(20) NOT NULL,
523 `Mull` bigint(20) NOT NULL,
524 PRIMARY KEY (`UID`),
525 CONSTRAINT `Players_Job_ibfk_1` FOREIGN KEY (`UID`) REFERENCES `Players` (`UID`) ON DELETE CASCADE ON UPDATE CASCADE
526) ENGINE=InnoDB DEFAULT CHARSET=latin1;
527
528-- ----------------------------
529-- Records of Players_Job
530-- ----------------------------
531INSERT INTO `Players_Job` VALUES ('59', '1', '1', '0');
532INSERT INTO `Players_Job` VALUES ('60', '1', '251', '0');
533INSERT INTO `Players_Job` VALUES ('61', '1', '45', '0');
534INSERT INTO `Players_Job` VALUES ('62', '1', '1', '0');
535INSERT INTO `Players_Job` VALUES ('63', '1', '1', '0');
536INSERT INTO `Players_Job` VALUES ('64', '1', '1', '0');
537INSERT INTO `Players_Job` VALUES ('65', '1', '1', '0');
538INSERT INTO `Players_Job` VALUES ('66', '1', '1', '0');
539INSERT INTO `Players_Job` VALUES ('67', '1', '22', '0');
540INSERT INTO `Players_Job` VALUES ('68', '1', '0', '0');
541INSERT INTO `Players_Job` VALUES ('69', '1', '196', '0');
542
543-- ----------------------------
544-- Table structure for shops
545-- ----------------------------
546DROP TABLE IF EXISTS `shops`;
547CREATE TABLE `shops` (
548 `x` varchar(255) NOT NULL,
549 `y` varchar(255) NOT NULL,
550 `z` varchar(255) NOT NULL,
551 `rot` varchar(255) NOT NULL,
552 `skin` varchar(255) NOT NULL,
553 `type` varchar(255) NOT NULL,
554 `interior` varchar(255) NOT NULL,
555 `dimension` varchar(255) NOT NULL
556) ENGINE=InnoDB DEFAULT CHARSET=utf8;
557
558-- ----------------------------
559-- Records of shops
560-- ----------------------------
561INSERT INTO `shops` VALUES ('1564.207031', '-1833.958008', '13.546875', '302.927887', '1', '1', '0', '0');
562INSERT INTO `shops` VALUES ('1565.030273', '-1833.879883', '13.382812', '273.407196', '1', '3', '0', '0');
563INSERT INTO `shops` VALUES ('1066.690430', '-1756.021484', '13.421490', '39.230042', '0', '3', '0', '0');
564
565-- ----------------------------
566-- Table structure for Smartphone
567-- ----------------------------
568DROP TABLE IF EXISTS `Smartphone`;
569CREATE TABLE `Smartphone` (
570 `UID` int(11) NOT NULL AUTO_INCREMENT,
571 `Smartphone` smallint(6) NOT NULL COMMENT '0',
572 `Background` smallint(6) NOT NULL COMMENT '0',
573 PRIMARY KEY (`UID`),
574 KEY `UID` (`UID`),
575 CONSTRAINT `Smartphone_ibfk_1` FOREIGN KEY (`UID`) REFERENCES `Players` (`UID`) ON DELETE CASCADE ON UPDATE CASCADE
576) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
577
578-- ----------------------------
579-- Records of Smartphone
580-- ----------------------------
581INSERT INTO `Smartphone` VALUES ('59', '0', '0');
582INSERT INTO `Smartphone` VALUES ('60', '0', '0');
583INSERT INTO `Smartphone` VALUES ('61', '0', '0');
584INSERT INTO `Smartphone` VALUES ('62', '0', '0');
585INSERT INTO `Smartphone` VALUES ('63', '0', '0');
586INSERT INTO `Smartphone` VALUES ('64', '0', '0');
587INSERT INTO `Smartphone` VALUES ('65', '0', '0');
588INSERT INTO `Smartphone` VALUES ('66', '0', '0');
589INSERT INTO `Smartphone` VALUES ('67', '0', '0');
590INSERT INTO `Smartphone` VALUES ('68', '0', '0');
591INSERT INTO `Smartphone` VALUES ('69', '0', '0');
592
593-- ----------------------------
594-- Table structure for support
595-- ----------------------------
596DROP TABLE IF EXISTS `support`;
597CREATE TABLE `support` (
598 `ID` int(11) NOT NULL AUTO_INCREMENT,
599 `player` text NOT NULL,
600 `subject` text NOT NULL,
601 `message` text NOT NULL,
602 `state` text NOT NULL,
603 PRIMARY KEY (`ID`)
604) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
605
606-- ----------------------------
607-- Records of support
608-- ----------------------------
609INSERT INTO `support` VALUES ('1', 'iLimix', 'sadadssad', 'Admin iLimix [1568454366]:\nawdawddawadw\n\n\n-----------------\n\nAdmin iLimix [1568454329]:\nHow cna i Help u\n\n\n-----------------\n\nAdmin iLimix [1568454328]:\nHow cna i Help u\n\n\n-----------------\n\nAdmin iLimix [1568454291]:\nHallo\n\n\n-----------------\n\nsdadsadasads\n', 'open');
610INSERT INTO `support` VALUES ('2', 'iLimix', 'dsaadsasd', 'Admin iLimix [14.9.2019, 10:53]:\nadwwaewdaadwawd\n\n\n-----------------\n\ndasdasadss\n', 'open');
611
612-- ----------------------------
613-- Table structure for Todolist
614-- ----------------------------
615DROP TABLE IF EXISTS `Todolist`;
616CREATE TABLE `Todolist` (
617 `ID` int(11) NOT NULL AUTO_INCREMENT,
618 `Thema` varchar(50) NOT NULL,
619 `AufgabenBereich` varchar(50) NOT NULL,
620 `Status` varchar(50) NOT NULL,
621 `Datum` text NOT NULL,
622 `Beschreibung` longtext NOT NULL,
623 `Version` text NOT NULL,
624 PRIMARY KEY (`ID`)
625) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
626
627-- ----------------------------
628-- Records of Todolist
629-- ----------------------------
630INSERT INTO `Todolist` VALUES ('5', 'Test', 'Teamspeak', 'Erledigt', '27.03.2018', 'Dies war nur ein Test', '0.0.1');
631INSERT INTO `Todolist` VALUES ('6', 'Arsch', 'Ingame', 'In Bearbeitung', '27.03.2018', '<p>Weil ich so geil bin<br></p>', '0-0-2');
632INSERT INTO `Todolist` VALUES ('7', 'Tachodesign', 'Grafikdesign', 'In Bearbeitung', '01.04.2018', '<p>Designen eines Tachos</p>', '1.0');
633
634-- ----------------------------
635-- Table structure for Unternehmen
636-- ----------------------------
637DROP TABLE IF EXISTS `Unternehmen`;
638CREATE TABLE `Unternehmen` (
639 `ID` int(11) NOT NULL AUTO_INCREMENT,
640 `Name` varchar(255) NOT NULL,
641 `Firmenart` varchar(255) NOT NULL,
642 `Besitzer` varchar(255) NOT NULL,
643 `Kontostand` bigint(255) NOT NULL,
644 `Upgrade` smallint(255) NOT NULL,
645 `Farhzeuge` int(255) NOT NULL,
646 `Auftrag` int(255) NOT NULL,
647 PRIMARY KEY (`ID`) USING BTREE
648) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
649
650-- ----------------------------
651-- Records of Unternehmen
652-- ----------------------------
653INSERT INTO `Unternehmen` VALUES ('1', 'dsadsadas', 'GmbH', 'Lorenzo', '0', '0', '0', '0');
654INSERT INTO `Unternehmen` VALUES ('2', 'dsadsadas', 'GmbH', 'Lorenzo', '0', '0', '0', '0');
655INSERT INTO `Unternehmen` VALUES ('3', 'dsadsadas', 'GmbH', 'Lorenzo', '0', '0', '0', '0');
656INSERT INTO `Unternehmen` VALUES ('4', 'dsadsadas', 'GmbH', 'Lorenzo', '0', '0', '0', '0');
657INSERT INTO `Unternehmen` VALUES ('5', 'dsadsadas', 'GmbH', 'Lorenzo', '0', '0', '0', '0');
658INSERT INTO `Unternehmen` VALUES ('6', 'dsadsadas', 'GmbH', 'Lorenzo', '0', '0', '0', '0');
659
660-- ----------------------------
661-- Table structure for Userdata
662-- ----------------------------
663DROP TABLE IF EXISTS `Userdata`;
664CREATE TABLE `Userdata` (
665 `UID` int(11) NOT NULL AUTO_INCREMENT,
666 `Name` varchar(255) NOT NULL,
667 `Money` bigint(255) NOT NULL DEFAULT '350',
668 `Bankmoney` bigint(255) NOT NULL DEFAULT '500',
669 `Spawn_X` varchar(255) NOT NULL DEFAULT '1567.8955078125',
670 `Spawn_Y` varchar(255) NOT NULL DEFAULT '-1890.69921875',
671 `Spawn_Z` varchar(255) NOT NULL DEFAULT '13.559101104736',
672 `Spawn_Rot` varchar(255) NOT NULL DEFAULT '0',
673 `Spawn_Dim` varchar(255) NOT NULL DEFAULT '0',
674 `Spawn_Int` varchar(255) NOT NULL DEFAULT '0',
675 `Skin` smallint(6) NOT NULL DEFAULT '1',
676 `Adminlevel` int(255) NOT NULL DEFAULT '0',
677 `Playingtime` double(11,0) NOT NULL DEFAULT '0',
678 `LastLogin` longtext NOT NULL,
679 `Identitycard` smallint(6) NOT NULL DEFAULT '0',
680 `Faction` int(11) NOT NULL DEFAULT '0',
681 `Factionrang` int(11) NOT NULL DEFAULT '0',
682 `Companies` varchar(255) NOT NULL,
683 `Gang` varchar(255) NOT NULL DEFAULT '0',
684 `Hunger` int(11) NOT NULL DEFAULT '100',
685 `Number` int(11) NOT NULL,
686 `SocialState` varchar(255) NOT NULL,
687 `Wanteds` smallint(6) NOT NULL DEFAULT '0',
688 `Stvo` smallint(6) NOT NULL DEFAULT '0',
689 `Experience` bigint(20) NOT NULL DEFAULT '0',
690 `Level` bigint(20) NOT NULL DEFAULT '1',
691 `currentVehicle` int(11) NOT NULL DEFAULT '0',
692 `maxVehicle` int(11) NOT NULL DEFAULT '10',
693 `customSlot` tinyint(255) NOT NULL,
694 `blueprints` varchar(256) NOT NULL DEFAULT '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]',
695 `LoggedIn` smallint(255) NOT NULL,
696 `car_license` smallint(6) NOT NULL DEFAULT '0',
697 PRIMARY KEY (`UID`),
698 KEY `UID` (`UID`),
699 KEY `UID_2` (`UID`),
700 CONSTRAINT `Userdata_ibfk_1` FOREIGN KEY (`UID`) REFERENCES `Players` (`UID`) ON DELETE CASCADE ON UPDATE CASCADE
701) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
702
703-- ----------------------------
704-- Records of Userdata
705-- ----------------------------
706INSERT INTO `Userdata` VALUES ('59', 'Chem', '999999999', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '7', '0', '13.08.2019 um 21:08 Uhr', '0', '0', '0', '0', '0', '100', '881794', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '0', '0');
707INSERT INTO `Userdata` VALUES ('60', 'iLimix', '999999934', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '7', '0', '24.010.2019 um 17:34 Uhr', '0', '1', '5', '0', '10', '100', '65336', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '1');
708INSERT INTO `Userdata` VALUES ('61', 'Karma', '999769759', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '7', '0', '24.010.2019 um 00:23 Uhr', '0', '0', '5', '0', '11', '100', '652730', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '3');
709INSERT INTO `Userdata` VALUES ('62', 'Strider', '999999999', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '7', '0', '13.09.2019 um 18:28 Uhr', '0', '0', '0', '0', '0', '100', '74098', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '0');
710INSERT INTO `Userdata` VALUES ('63', 'Se7enDeagle', '999999999', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '7', '0', '12.010.2019 um 20:14 Uhr', '0', '0', '0', '0', '12', '100', '344432', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '0');
711INSERT INTO `Userdata` VALUES ('64', 'Bad_Karma', '999999999', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '7', '0', '23.09.2019 um 21:27 Uhr', '0', '0', '0', '0', '0', '100', '191230', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '0');
712INSERT INTO `Userdata` VALUES ('65', 'Shanks', '999999999', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '7', '0', '16.010.2019 um 18:06 Uhr', '0', '0', '5', '0', '0', '100', '341139', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '0');
713INSERT INTO `Userdata` VALUES ('66', 'Good_Karma', '999999999', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '0', '0', '14.010.2019 um 10:51 Uhr', '0', '0', '0', '0', '0', '100', '985329', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '0');
714INSERT INTO `Userdata` VALUES ('67', 'BadKarma', '999999999', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '0', '0', '30.09.2019 um 23:11 Uhr', '0', '0', '0', '0', '0', '100', '787737', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '0');
715INSERT INTO `Userdata` VALUES ('68', 'n0pe', '999999999', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '0', '0', '06.010.2019 um 19:43 Uhr', '0', '0', '0', '0', '0', '100', '708755', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '0', '0');
716INSERT INTO `Userdata` VALUES ('69', 'Funachra', '0', '500', '1567.895508', '-1890.699219', '13.559101', '0', '0', '0', '1', '0', '0', '23.010.2019 um 22:34 Uhr', '0', '1', '5', '0', '0', '100', '957951', '', '0', '0', '0', '1', '0', '10', '0', '[ [ false,false,false,false,false,false,false,false,false,false,false,false,false,false,false ] ]', '1', '0');
717
718-- ----------------------------
719-- Table structure for Vehicles
720-- ----------------------------
721DROP TABLE IF EXISTS `Vehicles`;
722CREATE TABLE `Vehicles` (
723 `id` int(11) NOT NULL AUTO_INCREMENT,
724 `model` int(10) NOT NULL,
725 `x` float NOT NULL,
726 `y` float NOT NULL,
727 `z` float NOT NULL,
728 `rotx` float NOT NULL,
729 `roty` float NOT NULL,
730 `rotz` float NOT NULL,
731 `color1` tinyint(4) NOT NULL DEFAULT '0',
732 `color2` tinyint(4) NOT NULL DEFAULT '0',
733 `faction` int(11) NOT NULL DEFAULT '0',
734 `owner` int(11) NOT NULL DEFAULT '0',
735 `plate` varchar(25) NOT NULL,
736 `locked` tinyint(4) NOT NULL DEFAULT '0',
737 `interior` int(11) NOT NULL DEFAULT '0',
738 `currinterior` int(11) NOT NULL DEFAULT '0',
739 `dimension` int(11) NOT NULL DEFAULT '0',
740 `currdimension` int(11) NOT NULL DEFAULT '0',
741 `tintedwindows` tinyint(4) NOT NULL DEFAULT '0',
742 `fuel` int(11) NOT NULL DEFAULT '100',
743 `panelStates` varchar(35) NOT NULL DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]',
744 `engine` tinyint(4) NOT NULL DEFAULT '0',
745 `wheelStates` varchar(35) NOT NULL DEFAULT '[ [ 0, 0, 0, 0 ] ]',
746 `lights` tinyint(4) NOT NULL DEFAULT '0',
747 `hp` float NOT NULL DEFAULT '300',
748 `doorStates` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0, 0, 0, 0 ] ]',
749 `sirens` tinyint(4) NOT NULL DEFAULT '1',
750 `handbrake` tinyint(4) NOT NULL DEFAULT '0',
751 `Impounded` tinyint(4) NOT NULL DEFAULT '0',
752 `job` int(11) NOT NULL DEFAULT '0',
753 `paintjob` int(11) NOT NULL DEFAULT '4',
754 `upgrades` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]',
755 `rent` tinyint(1) NOT NULL DEFAULT '0',
756 `rentcost` int(11) NOT NULL DEFAULT '0',
757 `lred` int(11) NOT NULL DEFAULT '255',
758 `lgreen` int(11) NOT NULL DEFAULT '255',
759 `lblue` int(11) NOT NULL DEFAULT '255',
760 `opticalTunings` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]',
761 `performanceTuning` varchar(255) NOT NULL DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]',
762 `sticker` int(11) NOT NULL DEFAULT '0',
763 `var` int(11) NOT NULL DEFAULT '5',
764 `LSDDoor` varchar(255) NOT NULL DEFAULT 'false',
765 `seeGO` int(11) NOT NULL DEFAULT '0',
766 `trafiRadar` varchar(255) NOT NULL DEFAULT 'false',
767 `airRide` varchar(255) NOT NULL DEFAULT 'false',
768 `wheelFront` int(11) NOT NULL DEFAULT '0',
769 `wheelRear` int(11) NOT NULL DEFAULT '0',
770 `driveType` varchar(255) NOT NULL DEFAULT '',
771 `neonTuning` varchar(255) NOT NULL DEFAULT 'false',
772 `headlight` varchar(255) NOT NULL DEFAULT '[ [ 255, 255, 255 ] ]',
773 `r` int(255) NOT NULL DEFAULT '0',
774 `g` int(255) NOT NULL DEFAULT '0',
775 `b` int(255) NOT NULL DEFAULT '0',
776 `r1` int(11) NOT NULL DEFAULT '0',
777 `g1` int(11) NOT NULL DEFAULT '0',
778 `b1` int(11) NOT NULL DEFAULT '0',
779 `r2` int(11) NOT NULL DEFAULT '0',
780 `g2` int(11) NOT NULL DEFAULT '0',
781 `b2` int(11) NOT NULL DEFAULT '0',
782 `r3` int(11) NOT NULL DEFAULT '0',
783 `g3` int(11) NOT NULL DEFAULT '0',
784 `b3` int(11) NOT NULL DEFAULT '0',
785 `offroadAbility` int(10) NOT NULL DEFAULT '0',
786 `slot` int(11) NOT NULL,
787 PRIMARY KEY (`id`,`slot`)
788) ENGINE=MyISAM AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
789
790-- ----------------------------
791-- Records of Vehicles
792-- ----------------------------
793INSERT INTO `Vehicles` VALUES ('187', '451', '1595.17', '-1877.56', '13.5391', '0', '0', '0', '0', '0', '0', '69', 'DDR-259', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 1087, 0, 0, 1078, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '6', 'true', '1', 'true', 'true', '8', '8', '', 'pink', '[ [ 11, 13, 158 ] ]', '27', '34', '198', '86', '232', '30', '0', '0', '0', '0', '0', '0', '1', '0');
794INSERT INTO `Vehicles` VALUES ('188', '451', '1567.9', '-1890.7', '13.5591', '0', '0', '0', '0', '0', '0', '60', 'XJN-268', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
795INSERT INTO `Vehicles` VALUES ('189', '451', '1568.96', '-1847.83', '13.0451', '359.335', '359.973', '0.373535', '0', '0', '0', '60', 'WLV-266', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 4, 4, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'red', '[ [ 48, 85, 211 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
796INSERT INTO `Vehicles` VALUES ('190', '559', '2219.5', '1386.1', '11', '0', '0', '0', '0', '0', '0', '61', 'MI-KARMA', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 1050, 1071, 0, 0, 0, 0, 0, 1087, 0, 0, 1080, 1066, 1173, 1161, 0 ] ]', '[ [ 5, 5, 5, 5, 5, 5, 5, 0, 5 ] ]', '0', '255', 'true', '1', 'false', 'true', '8', '8', 'rwd', 'green', '[ [ 7, 13, 96 ] ]', '42', '42', '42', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
797INSERT INTO `Vehicles` VALUES ('191', '493', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '69', 'MUO-432', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
798INSERT INTO `Vehicles` VALUES ('192', '473', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '69', 'PWO-882', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
799INSERT INTO `Vehicles` VALUES ('193', '454', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '69', 'USJ-147', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
800INSERT INTO `Vehicles` VALUES ('194', '452', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '60', 'DMA-597', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
801INSERT INTO `Vehicles` VALUES ('195', '473', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '60', 'VBO-142', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
802INSERT INTO `Vehicles` VALUES ('196', '484', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '60', 'YWK-812', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
803INSERT INTO `Vehicles` VALUES ('197', '473', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '60', 'YBM-998', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
804INSERT INTO `Vehicles` VALUES ('198', '473', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '60', 'GKH-893', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
805INSERT INTO `Vehicles` VALUES ('199', '484', '890', '-2033.6', '0', '0', '0', '0', '0', '0', '0', '60', 'SXJ-736', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
806INSERT INTO `Vehicles` VALUES ('200', '493', '911.99', '-1980.69', '1.00902', '0', '0', '0', '0', '0', '0', '60', 'XIT-164', '0', '0', '0', '0', '0', '0', '100', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '[ [ 0, 0, 0, 0 ] ]', '0', '300', '[ [ 0, 0, 0, 0, 0, 0 ] ]', '1', '0', '0', '0', '4', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '0', '0', '255', '255', '255', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0 ]]', '0', '5', 'false', '0', 'false', 'false', '0', '0', '', 'false', '[ [ 255, 255, 255 ] ]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
807
808-- ----------------------------
809-- Table structure for Vipcodes
810-- ----------------------------
811DROP TABLE IF EXISTS `Vipcodes`;
812CREATE TABLE `Vipcodes` (
813 `Vipcode` text NOT NULL,
814 `Dauer` int(11) NOT NULL
815) ENGINE=InnoDB DEFAULT CHARSET=utf8;
816
817-- ----------------------------
818-- Records of Vipcodes
819-- ----------------------------
820INSERT INTO `Vipcodes` VALUES ('162A6F250B', '366');
821INSERT INTO `Vipcodes` VALUES ('ED332B66D6', '366');
822INSERT INTO `Vipcodes` VALUES ('5103D092A4', '20');
823
824-- ----------------------------
825-- Table structure for VipPlayers
826-- ----------------------------
827DROP TABLE IF EXISTS `VipPlayers`;
828CREATE TABLE `VipPlayers` (
829 `Spielername` varchar(50) NOT NULL,
830 `Guthaben` int(11) NOT NULL,
831 `VipAblaufdatum` int(13) NOT NULL
832) ENGINE=InnoDB DEFAULT CHARSET=utf8;
833
834-- ----------------------------
835-- Records of VipPlayers
836-- ----------------------------
837INSERT INTO `VipPlayers` VALUES ('iLimix', '0', '1586377687');