· 9 years ago · Nov 02, 2016, 10:30 PM
1CREATE DATABASE IF NOT EXISTS `tanoaframework` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2USE `tanoaframework`;
3
4-- ----------------------------
5-- Table structure for `auctionhouse`
6-- ----------------------------
7DROP TABLE IF EXISTS `auctionhouse`;
8CREATE TABLE `auctionhouse` (
9 `id` int(12) NOT NULL AUTO_INCREMENT,
10 `item` varchar(32) NOT NULL,
11 `verkauferuid` varchar(50) NOT NULL,
12 `verkaufername` varchar(32) NOT NULL,
13 `kauferuid` varchar(50) NOT NULL,
14 `kaufername` varchar(32) NOT NULL,
15 `preis` int(100) NOT NULL,
16 `howlong` int(100) NOT NULL DEFAULT '12',
17 `aktiv` tinyint(1) NOT NULL DEFAULT '1',
18 `status` int(100) NOT NULL DEFAULT '1',
19 `abholbar` tinyint(1) NOT NULL DEFAULT '0',
20 `candelete` tinyint(1) NOT NULL DEFAULT '0',
21 PRIMARY KEY (`id`),
22 KEY `verkauferuid` (`verkauferuid`),
23 KEY `kauferuid` (`kauferuid`)
24) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
25
26-- ----------------------------
27-- Table structure for `banlog`
28-- ----------------------------
29DROP TABLE IF EXISTS `banlog`;
30CREATE TABLE `banlog` (
31 `id` int(12) NOT NULL AUTO_INCREMENT,
32 `playerid` varchar(32) NOT NULL,
33 `datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
34 `bangrund` text NOT NULL,
35 PRIMARY KEY (`id`),
36 KEY `playerid` (`playerid`)
37) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
38
39-- ----------------------------
40-- Table structure for `bugreport`
41-- ----------------------------
42DROP TABLE IF EXISTS `bugreport`;
43CREATE TABLE `bugreport` (
44 `uid` int(12) NOT NULL AUTO_INCREMENT,
45 `name` varchar(32) NOT NULL,
46 `playerid` varchar(50) NOT NULL,
47 `bug` text NOT NULL,
48 `inbearbeitung` varchar(50) NOT NULL DEFAULT 'false',
49 `abgeschlossen` varchar(50) NOT NULL DEFAULT 'false',
50 `belohnung` int(10) unsigned NOT NULL DEFAULT '0',
51 `antwort` varchar(500) NOT NULL,
52 `active` tinyint(1) NOT NULL DEFAULT '1',
53 PRIMARY KEY (`uid`)
54) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
55
56-- ----------------------------
57-- Table structure for `east`
58-- ----------------------------
59DROP TABLE IF EXISTS `east`;
60CREATE TABLE `east` (
61 `uid` int(12) NOT NULL AUTO_INCREMENT,
62 `name` varchar(32) NOT NULL,
63 `playerid` varchar(50) NOT NULL,
64 `cash` int(100) NOT NULL DEFAULT '0',
65 `bank` int(100) NOT NULL DEFAULT '1000000',
66 `licenses` text,
67 `stats` text NOT NULL,
68 `alive` text NOT NULL,
69 `direction` double NOT NULL DEFAULT '0',
70 `position_x` double NOT NULL DEFAULT '0',
71 `position_y` double NOT NULL DEFAULT '0',
72 `position_z` double NOT NULL DEFAULT '0',
73 `time` int(11) NOT NULL DEFAULT '0',
74 `exp` int(100) NOT NULL DEFAULT '0',
75 `talente` text,
76 `talentpunkte` int(100) NOT NULL DEFAULT '0',
77 `erfolge` text,
78 `title` varchar(150) NOT NULL DEFAULT 'Kein Titel',
79 PRIMARY KEY (`uid`),
80 UNIQUE KEY `playerid` (`playerid`),
81 KEY `name` (`name`)
82) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
83
84-- ----------------------------
85-- Table structure for `eastgear`
86-- ----------------------------
87DROP TABLE IF EXISTS `eastgear`;
88CREATE TABLE `eastgear` (
89 `uid` int(12) NOT NULL AUTO_INCREMENT,
90 `name` varchar(32) NOT NULL,
91 `playerid` varchar(50) NOT NULL,
92 `assigned_items` text NOT NULL,
93 `backpack` varchar(64) NOT NULL DEFAULT '""',
94 `backpack_items` text NOT NULL,
95 `backpack_magazines` text NOT NULL,
96 `backpack_weapons` text NOT NULL,
97 `current_weapon` varchar(64) NOT NULL DEFAULT '""',
98 `goggles` varchar(64) NOT NULL DEFAULT '""',
99 `handgun_items` text NOT NULL,
100 `handgun_weapon` varchar(64) NOT NULL DEFAULT '""',
101 `headgear` varchar(64) NOT NULL DEFAULT '""',
102 `binocular` varchar(64) NOT NULL DEFAULT '""',
103 `loaded_magazines` text NOT NULL,
104 `primary_weapon` varchar(64) NOT NULL DEFAULT '""',
105 `primary_weapon_items` text NOT NULL,
106 `secondary_weapon` varchar(64) NOT NULL DEFAULT '""',
107 `secondary_weapon_items` text NOT NULL,
108 `uniform` varchar(64) NOT NULL DEFAULT '""',
109 `uniform_items` text NOT NULL,
110 `uniform_magazines` text NOT NULL,
111 `uniform_weapons` text NOT NULL,
112 `vest` varchar(64) NOT NULL DEFAULT '""',
113 `vest_items` text NOT NULL,
114 `vest_magazines` text NOT NULL,
115 `vest_weapons` text NOT NULL,
116 `zinventar` text NOT NULL,
117 PRIMARY KEY (`uid`),
118 UNIQUE KEY `playerid` (`playerid`),
119 KEY `name` (`name`)
120) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
121
122-- ----------------------------
123-- Table structure for `economy`
124-- ----------------------------
125DROP TABLE IF EXISTS `economy`;
126CREATE TABLE `economy` (
127 `id` int(11) NOT NULL AUTO_INCREMENT,
128 `resource` varchar(50) NOT NULL,
129 `buyprice` int(12) NOT NULL DEFAULT '1',
130 `sellprice` int(12) NOT NULL DEFAULT '1',
131 `varprice` int(12) NOT NULL DEFAULT '1',
132 `maxprice` int(12) NOT NULL DEFAULT '1',
133 `minprice` int(12) NOT NULL DEFAULT '1',
134 `factor` int(12) NOT NULL DEFAULT '1',
135 PRIMARY KEY (`id`,`resource`)
136) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4;
137
138-- ----------------------------
139-- Records of economy
140-- ----------------------------
141INSERT INTO `economy` VALUES ('1', 'mehl', '-1', '2000', '1', '2000', '1250', '6');
142INSERT INTO `economy` VALUES ('2', 'bananen', '-1', '100', '1', '100', '60', '3');
143INSERT INTO `economy` VALUES ('3', 'kokusnusse', '-1', '100', '1', '100', '60', '3');
144INSERT INTO `economy` VALUES ('4', 'alkohol', '-1', '5500', '3', '10000', '5500', '1');
145INSERT INTO `economy` VALUES ('5', 'extasy', '-1', '13500', '3', '13500', '9000', '1');
146INSERT INTO `economy` VALUES ('6', 'zucker', '-1', '800', '1', '2000', '800', '3');
147INSERT INTO `economy` VALUES ('7', 'eisen', '-1', '1350', '1', '2450', '1350', '7');
148INSERT INTO `economy` VALUES ('8', 'bauxit_processed', '-1', '5000', '1', '5000', '3500', '2');
149INSERT INTO `economy` VALUES ('9', 'kohle_processed', '-1', '2682', '1', '3500', '2100', '2');
150INSERT INTO `economy` VALUES ('10', 'kunststoff', '-1', '2100', '1', '2100', '1200', '4');
151INSERT INTO `economy` VALUES ('11', 'stoff', '-1', '1900', '1', '1900', '1100', '4');
152INSERT INTO `economy` VALUES ('12', 'holzbretter', '-1', '1224', '1', '1500', '1000', '4');
153INSERT INTO `economy` VALUES ('13', 'chemischestoffe', '-1', '3241', '1', '3300', '2500', '4');
154INSERT INTO `economy` VALUES ('14', 'schwefelsaure', '-1', '4200', '1', '4200', '3100', '4');
155INSERT INTO `economy` VALUES ('15', 'glas', '-1', '2800', '1', '2800', '2300', '4');
156INSERT INTO `economy` VALUES ('16', 'silikon', '-1', '2250', '1', '2250', '1600', '4');
157INSERT INTO `economy` VALUES ('17', 'gummi', '-1', '2200', '1', '2200', '1100', '4');
158INSERT INTO `economy` VALUES ('18', 'diamanten', '-1', '11976', '1', '13500', '9000', '2');
159INSERT INTO `economy` VALUES ('19', 'schokolade', '-1', '2000', '1', '2000', '800', '3');
160INSERT INTO `economy` VALUES ('20', 'kokusnussbrot', '-1', '2500', '1', '2500', '1500', '3');
161INSERT INTO `economy` VALUES ('21', 'bananenkuchen', '-1', '2500', '1', '2500', '1500', '3');
162INSERT INTO `economy` VALUES ('22', 'froschenkel', '-1', '3500', '1', '3500', '2500', '3');
163INSERT INTO `economy` VALUES ('23', 'lsd', '-1', '8000', '3', '8000', '7000', '1');
164INSERT INTO `economy` VALUES ('24', 'marijuana', '-1', '4500', '3', '4500', '3800', '1');
165INSERT INTO `economy` VALUES ('25', 'kokain', '-1', '9203', '3', '9300', '7200', '1');
166INSERT INTO `economy` VALUES ('26', 'salema_raw', '-1', '166', '1', '450', '150', '5');
167INSERT INTO `economy` VALUES ('27', 'ornate_raw', '-1', '1379', '1', '1500', '750', '5');
168INSERT INTO `economy` VALUES ('28', 'mackerel_raw', '-1', '300', '1', '300', '600', '5');
169INSERT INTO `economy` VALUES ('29', 'tuna_raw', '-1', '750', '1', '250', '750', '5');
170INSERT INTO `economy` VALUES ('30', 'mullet_raw', '-1', '300', '1', '300', '700', '5');
171INSERT INTO `economy` VALUES ('31', 'catshark_raw', '-1', '350', '1', '350', '850', '5');
172INSERT INTO `economy` VALUES ('32', 'turtle_raw', '-1', '11209', '1', '20000', '11000', '5');
173INSERT INTO `economy` VALUES ('33', 'ephedrin', '-1', '3000', '1', '4000', '3000', '6');
174INSERT INTO `economy` VALUES ('34', 'paper', '-1', '6308', '1', '6500', '5000', '4');
175INSERT INTO `economy` VALUES ('35', 'plastikfolie', '-1', '6500', '1', '6500', '5000', '4');
176INSERT INTO `economy` VALUES ('36', 'tintenfisch', '-1', '1250', '1', '1250', '850', '5');
177INSERT INTO `economy` VALUES ('37', 'stahl', '-1', '11512', '1', '14800', '11200', '7');
178INSERT INTO `economy` VALUES ('38', 'titan', '-1', '23500', '1', '23500', '20000', '7');
179INSERT INTO `economy` VALUES ('39', 'aluminium', '-1', '22800', '1', '22800', '19200', '7');
180INSERT INTO `economy` VALUES ('40', 'kerosin', '-1', '19000', '1', '25000', '19000', '4');
181INSERT INTO `economy` VALUES ('41', 'kraftstoff', '-1', '13840', '1', '17500', '13500', '4');
182INSERT INTO `economy` VALUES ('42', 'panzerglas', '-1', '35000', '1', '35000', '28000', '4');
183INSERT INTO `economy` VALUES ('43', 'schwarzpulver', '-1', '23500', '1', '23500', '21000', '4');
184INSERT INTO `economy` VALUES ('44', 'alkohollegal', '-1', '2400', '1', '2400', '1800', '3');
185INSERT INTO `economy` VALUES ('45', 'diamant', '-1', '4418', '1', '4500', '4000', '2');
186INSERT INTO `economy` VALUES ('46', 'diamantenstaub', '-1', '16500', '1', '16500', '10000', '2');
187
188-- ----------------------------
189-- Table structure for `empty`
190-- ----------------------------
191DROP TABLE IF EXISTS `empty`;
192CREATE TABLE `empty` (
193 `uid` int(12) NOT NULL AUTO_INCREMENT,
194 `name` varchar(32) NOT NULL,
195 `playerid` varchar(50) NOT NULL,
196 PRIMARY KEY (`uid`),
197 UNIQUE KEY `playerid` (`playerid`),
198 KEY `name` (`name`)
199) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
200
201-- ----------------------------
202-- Table structure for `empty1`
203-- ----------------------------
204DROP TABLE IF EXISTS `empty1`;
205CREATE TABLE `empty1` (
206 `uid` int(12) NOT NULL AUTO_INCREMENT,
207 `name` varchar(32) NOT NULL,
208 `playerid` varchar(50) NOT NULL,
209 PRIMARY KEY (`uid`),
210 UNIQUE KEY `playerid` (`playerid`),
211 KEY `name` (`name`)
212) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
213
214-- ----------------------------
215-- Table structure for `empty2`
216-- ----------------------------
217DROP TABLE IF EXISTS `empty2`;
218CREATE TABLE `empty2` (
219 `uid` int(12) NOT NULL AUTO_INCREMENT,
220 `name` varchar(32) NOT NULL,
221 `playerid` varchar(50) NOT NULL,
222 PRIMARY KEY (`uid`),
223 UNIQUE KEY `playerid` (`playerid`),
224 KEY `name` (`name`)
225) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
226
227-- ----------------------------
228-- Table structure for `empty3`
229-- ----------------------------
230DROP TABLE IF EXISTS `empty3`;
231CREATE TABLE `empty3` (
232 `uid` int(12) NOT NULL AUTO_INCREMENT,
233 `name` varchar(32) NOT NULL,
234 `playerid` varchar(50) NOT NULL,
235 PRIMARY KEY (`uid`),
236 UNIQUE KEY `playerid` (`playerid`),
237 KEY `name` (`name`)
238) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
239
240-- ----------------------------
241-- Table structure for `empty4`
242-- ----------------------------
243DROP TABLE IF EXISTS `empty4`;
244CREATE TABLE `empty4` (
245 `uid` int(12) NOT NULL AUTO_INCREMENT,
246 `name` varchar(32) NOT NULL,
247 `playerid` varchar(50) NOT NULL,
248 PRIMARY KEY (`uid`),
249 UNIQUE KEY `playerid` (`playerid`),
250 KEY `name` (`name`)
251) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
252
253-- ----------------------------
254-- Table structure for `gangebiet`
255-- ----------------------------
256DROP TABLE IF EXISTS `gangebiet`;
257CREATE TABLE `gangebiet` (
258 `id` int(11) NOT NULL AUTO_INCREMENT,
259 `gang` varchar(32) DEFAULT NULL,
260 `gebiet` varchar(32) DEFAULT NULL,
261 `classname` varchar(32) NOT NULL,
262 `pos` varchar(64) DEFAULT NULL,
263 `aktiv` tinyint(4) DEFAULT '1',
264 PRIMARY KEY (`id`)
265) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
266
267-- ----------------------------
268-- Records of gangebiet
269-- ----------------------------
270INSERT INTO `gangebiet` VALUES ('1', 'Ninjas', 'Händler', 'Flag_Red_F', '[3263.0671,5899.0571,0]', '1');
271INSERT INTO `gangebiet` VALUES ('2', 'RG', 'Stadt', 'Flag_Red_F', '[2678.8081,12313.063,0]', '1');
272INSERT INTO `gangebiet` VALUES ('3', 'Ninjas', 'Händler', 'Flag_Red_F', '[4053.4919,2595.5093,0]', '1');
273INSERT INTO `gangebiet` VALUES ('4', 'RG', 'Stadt', 'Flag_Red_F', '[11649.998,4086.1284,0]', '1');
274INSERT INTO `gangebiet` VALUES ('5', 'RG', 'Stadt', 'Flag_Red_F', '[12154.104,9403.8906,0]', '1');
275
276-- ----------------------------
277-- Table structure for `gangs`
278-- ----------------------------
279DROP TABLE IF EXISTS `gangs`;
280CREATE TABLE `gangs` (
281 `id` int(11) NOT NULL AUTO_INCREMENT,
282 `owner` varchar(32) DEFAULT NULL,
283 `name` varchar(32) DEFAULT NULL,
284 `members` text,
285 `bank` int(100) DEFAULT '0',
286 `punkte` int(100) DEFAULT '0',
287 `vorstellung` varchar(500) DEFAULT NULL,
288 `information` varchar(500) DEFAULT NULL,
289 `flag` varchar(500) NOT NULL DEFAULT 'flag.paa',
290 `exp` int(100) DEFAULT '0',
291 `talentpunkte` int(100) DEFAULT '0',
292 `talente` text,
293 `freundlich` text,
294 `feindlich` text,
295 `rang` text,
296 `active` tinyint(4) DEFAULT '1',
297 PRIMARY KEY (`id`),
298 UNIQUE KEY `name_UNIQUE` (`name`)
299) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
300
301-- ----------------------------
302-- Table structure for `geldwasche`
303-- ----------------------------
304DROP TABLE IF EXISTS `geldwasche`;
305CREATE TABLE `geldwasche` (
306 `id` int(11) NOT NULL AUTO_INCREMENT,
307 `player` text NOT NULL,
308 `value` int(10) unsigned NOT NULL,
309 `remainingtime` int(11) NOT NULL DEFAULT '15',
310 PRIMARY KEY (`id`)
311) ENGINE=MyISAM DEFAULT CHARSET=latin1;
312
313-- ----------------------------
314-- Records of geldwasche
315-- ----------------------------
316
317-- ----------------------------
318-- Table structure for `hauptlog`
319-- ----------------------------
320DROP TABLE IF EXISTS `hauptlog`;
321CREATE TABLE `hauptlog` (
322 `uid` int(12) NOT NULL AUTO_INCREMENT,
323 `playerid` varchar(32) NOT NULL,
324 `playername` varchar(32) NOT NULL,
325 `logname` varchar(500) NOT NULL,
326 `logtext` text NOT NULL,
327 `remainingtime` int(11) NOT NULL DEFAULT '2',
328 `active` tinyint(4) DEFAULT '1',
329 PRIMARY KEY (`uid`),
330 KEY `playerid` (`playerid`)
331) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
332
333-- ----------------------------
334-- Table structure for `houses`
335-- ----------------------------
336DROP TABLE IF EXISTS `houses`;
337CREATE TABLE `houses` (
338 `id` int(11) NOT NULL AUTO_INCREMENT,
339 `pid` varchar(32) NOT NULL,
340 `name` varchar(32) DEFAULT NULL,
341 `schlussel` text,
342 `platz` int(100) DEFAULT '0',
343 `inventory` text,
344 `maxinventory` int(100) DEFAULT '0',
345 `versteck` text,
346 `maxversteck` int(100) DEFAULT '0',
347 `geld` text,
348 `upgrades` text,
349 `pos` varchar(64) DEFAULT NULL,
350 `renttime` int(11) NOT NULL DEFAULT '0',
351 `gekundigt` text,
352 `owned` tinyint(1) DEFAULT '0',
353 PRIMARY KEY (`id`,`pid`)
354) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
355
356-- ----------------------------
357-- Table structure for `independent`
358-- ----------------------------
359DROP TABLE IF EXISTS `independent`;
360CREATE TABLE `independent` (
361 `uid` int(12) NOT NULL AUTO_INCREMENT,
362 `name` varchar(32) NOT NULL,
363 `playerid` varchar(50) NOT NULL,
364 `cash` int(100) NOT NULL DEFAULT '0',
365 `bank` int(100) NOT NULL DEFAULT '120000',
366 `licenses` text,
367 `stats` text NOT NULL,
368 `alive` text NOT NULL,
369 `direction` double NOT NULL DEFAULT '0',
370 `position_x` double NOT NULL DEFAULT '0',
371 `position_y` double NOT NULL DEFAULT '0',
372 `position_z` double NOT NULL DEFAULT '0',
373 `time` int(11) NOT NULL DEFAULT '0',
374 `exp` int(100) NOT NULL DEFAULT '0',
375 `talente` text,
376 `talentpunkte` int(100) NOT NULL DEFAULT '0',
377 `erfolge` text,
378 `title` varchar(150) NOT NULL DEFAULT 'Kein Titel',
379 PRIMARY KEY (`uid`),
380 UNIQUE KEY `playerid` (`playerid`),
381 KEY `name` (`name`)
382) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
383
384-- ----------------------------
385-- Table structure for `independentgear`
386-- ----------------------------
387DROP TABLE IF EXISTS `independentgear`;
388CREATE TABLE `independentgear` (
389 `uid` int(12) NOT NULL AUTO_INCREMENT,
390 `name` varchar(32) NOT NULL,
391 `playerid` varchar(50) NOT NULL,
392 `assigned_items` text NOT NULL,
393 `backpack` varchar(64) NOT NULL DEFAULT '""',
394 `backpack_items` text NOT NULL,
395 `backpack_magazines` text NOT NULL,
396 `backpack_weapons` text NOT NULL,
397 `current_weapon` varchar(64) NOT NULL DEFAULT '""',
398 `goggles` varchar(64) NOT NULL DEFAULT '""',
399 `handgun_items` text NOT NULL,
400 `handgun_weapon` varchar(64) NOT NULL DEFAULT '""',
401 `headgear` varchar(64) NOT NULL DEFAULT '""',
402 `binocular` varchar(64) NOT NULL DEFAULT '""',
403 `loaded_magazines` text NOT NULL,
404 `primary_weapon` varchar(64) NOT NULL DEFAULT '""',
405 `primary_weapon_items` text NOT NULL,
406 `secondary_weapon` varchar(64) NOT NULL DEFAULT '""',
407 `secondary_weapon_items` text NOT NULL,
408 `uniform` varchar(64) NOT NULL DEFAULT '""',
409 `uniform_items` text NOT NULL,
410 `uniform_magazines` text NOT NULL,
411 `uniform_weapons` text NOT NULL,
412 `vest` varchar(64) NOT NULL DEFAULT '""',
413 `vest_items` text NOT NULL,
414 `vest_magazines` text NOT NULL,
415 `vest_weapons` text NOT NULL,
416 `zinventar` text NOT NULL,
417 PRIMARY KEY (`uid`),
418 UNIQUE KEY `playerid` (`playerid`),
419 KEY `name` (`name`)
420) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
421
422-- ----------------------------
423-- Table structure for `jail`
424-- ----------------------------
425DROP TABLE IF EXISTS `jail`;
426CREATE TABLE `jail` (
427 `uid` int(12) NOT NULL AUTO_INCREMENT,
428 `name` varchar(32) NOT NULL,
429 `playerid` varchar(50) NOT NULL,
430 `jailtime` int(100) NOT NULL DEFAULT '0',
431 `grund` varchar(500) NOT NULL DEFAULT '""',
432 PRIMARY KEY (`uid`),
433 UNIQUE KEY `playerid` (`playerid`),
434 KEY `name` (`name`)
435) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
436
437-- ----------------------------
438-- Table structure for `krankheitenciv`
439-- ----------------------------
440DROP TABLE IF EXISTS `krankheitenciv`;
441CREATE TABLE `krankheitenciv` (
442 `uid` int(12) NOT NULL AUTO_INCREMENT,
443 `name` varchar(32) NOT NULL,
444 `playerid` varchar(50) NOT NULL,
445 `hitpoints` text NOT NULL,
446 PRIMARY KEY (`uid`),
447 UNIQUE KEY `playerid` (`playerid`),
448 KEY `name` (`name`)
449) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
450
451-- ----------------------------
452-- Table structure for `krankheiteneast`
453-- ----------------------------
454DROP TABLE IF EXISTS `krankheiteneast`;
455CREATE TABLE `krankheiteneast` (
456 `uid` int(12) NOT NULL AUTO_INCREMENT,
457 `name` varchar(32) NOT NULL,
458 `playerid` varchar(50) NOT NULL,
459 `hitpoints` text NOT NULL,
460 PRIMARY KEY (`uid`),
461 UNIQUE KEY `playerid` (`playerid`),
462 KEY `name` (`name`)
463) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
464
465-- ----------------------------
466-- Table structure for `krankheitenindependent`
467-- ----------------------------
468DROP TABLE IF EXISTS `krankheitenindependent`;
469CREATE TABLE `krankheitenindependent` (
470 `uid` int(12) NOT NULL AUTO_INCREMENT,
471 `name` varchar(32) NOT NULL,
472 `playerid` varchar(50) NOT NULL,
473 `hitpoints` text NOT NULL,
474 PRIMARY KEY (`uid`),
475 UNIQUE KEY `playerid` (`playerid`),
476 KEY `name` (`name`)
477) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
478
479-- ----------------------------
480-- Table structure for `krankheitenwest`
481-- ----------------------------
482DROP TABLE IF EXISTS `krankheitenwest`;
483CREATE TABLE `krankheitenwest` (
484 `uid` int(12) NOT NULL AUTO_INCREMENT,
485 `name` varchar(32) NOT NULL,
486 `playerid` varchar(50) NOT NULL,
487 `hitpoints` text NOT NULL,
488 PRIMARY KEY (`uid`),
489 UNIQUE KEY `playerid` (`playerid`),
490 KEY `name` (`name`)
491) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
492
493-- ----------------------------
494-- Table structure for `messagesystem`
495-- ----------------------------
496DROP TABLE IF EXISTS `messagesystem`;
497CREATE TABLE `messagesystem` (
498 `id` int(12) NOT NULL AUTO_INCREMENT,
499 `message` varchar(500) NOT NULL,
500 PRIMARY KEY (`id`)
501) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
502
503-- ----------------------------
504-- Records of messagesystem
505-- ----------------------------
506INSERT INTO `messagesystem` VALUES ('1', '\"\"');
507
508-- ----------------------------
509-- Table structure for `mullabfuhr`
510-- ----------------------------
511DROP TABLE IF EXISTS `mullabfuhr`;
512CREATE TABLE `mullabfuhr` (
513 `id` int(11) NOT NULL AUTO_INCREMENT,
514 `classname` varchar(32) NOT NULL,
515 `pos` varchar(64) DEFAULT NULL,
516 `dir` varchar(64) DEFAULT NULL,
517 `aktiv` tinyint(4) DEFAULT '1',
518 `remainingtime` int(11) NOT NULL DEFAULT '0',
519 PRIMARY KEY (`id`)
520) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
521
522-- ----------------------------
523-- Records of mullabfuhr
524-- ----------------------------
525INSERT INTO `mullabfuhr` VALUES ('1', 'Land_GarbageContainer_closed_F', '[3299.077,12972.443,0]', '[[0,0,0],[0,0,0.5]]', '1', '0');
526INSERT INTO `mullabfuhr` VALUES ('2', 'Land_GarbageContainer_closed_F', '[3721.233,13166.685,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
527INSERT INTO `mullabfuhr` VALUES ('3', 'Land_GarbageContainer_closed_F', '[3555.471,12494.359,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
528INSERT INTO `mullabfuhr` VALUES ('4', 'Land_GarbageContainer_closed_F', '[3701.199,11873.603,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
529INSERT INTO `mullabfuhr` VALUES ('5', 'Land_GarbageContainer_closed_F', '[3646.972,11146,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
530INSERT INTO `mullabfuhr` VALUES ('6', 'Land_GarbageContainer_closed_F', '[5103.957,11220,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
531INSERT INTO `mullabfuhr` VALUES ('7', 'Land_GarbageContainer_closed_F', '[3957.907,13736.396,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
532INSERT INTO `mullabfuhr` VALUES ('8', 'Land_GarbageContainer_closed_F', '[7390.615,15391.546,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
533INSERT INTO `mullabfuhr` VALUES ('9', 'Land_GarbageContainer_closed_F', '[9119.927,15802.143,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
534INSERT INTO `mullabfuhr` VALUES ('10', 'Land_GarbageContainer_closed_F', '[9521.144,15952.131,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
535INSERT INTO `mullabfuhr` VALUES ('11', 'Land_GarbageContainer_closed_F', '[8762.646,18203.417,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
536INSERT INTO `mullabfuhr` VALUES ('12', 'Land_GarbageContainer_closed_F', '[8573.668,18342.541,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
537INSERT INTO `mullabfuhr` VALUES ('13', 'Land_GarbageContainer_closed_F', '[10301.582,19132.597,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
538INSERT INTO `mullabfuhr` VALUES ('14', 'Land_GarbageContainer_closed_F', '[9471.272,20292.169,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
539INSERT INTO `mullabfuhr` VALUES ('15', 'Land_GarbageContainer_closed_F', '[14573.192,20797.144,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
540INSERT INTO `mullabfuhr` VALUES ('16', 'Land_GarbageContainer_closed_F', '[14015,18856.826,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
541INSERT INTO `mullabfuhr` VALUES ('17', 'Land_GarbageContainer_closed_F', '[13904.453,18573.320,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
542INSERT INTO `mullabfuhr` VALUES ('18', 'Land_GarbageContainer_closed_F', '[14223.456,18694.722,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
543INSERT INTO `mullabfuhr` VALUES ('19', 'Land_GarbageContainer_closed_F', '[14496.777,17745.671,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
544INSERT INTO `mullabfuhr` VALUES ('20', 'Land_GarbageContainer_closed_F', '[16254.194,17306.919,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
545INSERT INTO `mullabfuhr` VALUES ('21', 'Land_GarbageContainer_closed_F', '[16594.171,16148.733,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
546INSERT INTO `mullabfuhr` VALUES ('22', 'Land_GarbageContainer_closed_F', '[18855.169,16602.539,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
547INSERT INTO `mullabfuhr` VALUES ('23', 'Land_GarbageContainer_closed_F', '[18644.166,16816.183,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
548INSERT INTO `mullabfuhr` VALUES ('24', 'Land_GarbageContainer_closed_F', '[18332.388,15259.142,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
549INSERT INTO `mullabfuhr` VALUES ('25', 'Land_GarbageContainer_closed_F', '[17974.546,15120.834,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
550INSERT INTO `mullabfuhr` VALUES ('26', 'Land_GarbageContainer_closed_F', '[19390.173,13260.781,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
551INSERT INTO `mullabfuhr` VALUES ('27', 'Land_GarbageContainer_closed_F', '[19946,11442.054,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
552INSERT INTO `mullabfuhr` VALUES ('28', 'Land_GarbageContainer_closed_F', '[20338.615,11755.076,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
553INSERT INTO `mullabfuhr` VALUES ('29', 'Land_GarbageContainer_closed_F', '[20457.173,8859.342,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
554INSERT INTO `mullabfuhr` VALUES ('30', 'Land_GarbageContainer_closed_F', '[21818.591,7500.071,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
555INSERT INTO `mullabfuhr` VALUES ('31', 'Land_GarbageContainer_closed_F', '[20778.599,6756.805,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
556INSERT INTO `mullabfuhr` VALUES ('32', 'Land_GarbageContainer_closed_F', '[16727.896,12267.928,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
557INSERT INTO `mullabfuhr` VALUES ('33', 'Land_GarbageContainer_closed_F', '[16556.226,12780.644,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
558INSERT INTO `mullabfuhr` VALUES ('34', 'Land_GarbageContainer_closed_F', '[17009.394,12801.679,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
559INSERT INTO `mullabfuhr` VALUES ('35', 'Land_GarbageContainer_closed_F', '[23270.136,19915.644,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
560INSERT INTO `mullabfuhr` VALUES ('36', 'Land_GarbageContainer_closed_F', '[27048.517,23266.363,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
561INSERT INTO `mullabfuhr` VALUES ('37', 'Land_GarbageContainer_closed_F', '[25795.240,21478.716,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
562INSERT INTO `mullabfuhr` VALUES ('38', 'Land_GarbageContainer_closed_F', '[25640.867,21355.152,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
563INSERT INTO `mullabfuhr` VALUES ('39', 'Land_GarbageContainer_closed_F', '[25707.812,21188,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
564INSERT INTO `mullabfuhr` VALUES ('40', 'Land_GarbageContainer_closed_F', '[20831.130,16811.755,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
565INSERT INTO `mullabfuhr` VALUES ('41', 'Land_GarbageContainer_closed_F', '[21130.380,17041.5,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
566INSERT INTO `mullabfuhr` VALUES ('42', 'Land_GarbageContainer_closed_F', '[21402.332,16348.635,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
567INSERT INTO `mullabfuhr` VALUES ('43', 'Land_GarbageContainer_closed_F', '[12467.685,14533.798,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
568INSERT INTO `mullabfuhr` VALUES ('44', 'Land_GarbageContainer_closed_F', '[12415,14179.383,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
569INSERT INTO `mullabfuhr` VALUES ('45', 'Land_GarbageContainer_closed_F', '[11716.259,13697.240,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
570INSERT INTO `mullabfuhr` VALUES ('46', 'Land_GarbageContainer_closed_F', '[10958,13487.744,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
571INSERT INTO `mullabfuhr` VALUES ('47', 'Land_GarbageContainer_closed_F', '[9444.506,11574.295,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
572INSERT INTO `mullabfuhr` VALUES ('48', 'Land_GarbageContainer_closed_F', '[9017.634,12016.468,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
573INSERT INTO `mullabfuhr` VALUES ('49', 'Land_GarbageContainer_closed_F', '[10682.466,12356.111,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
574INSERT INTO `mullabfuhr` VALUES ('50', 'Land_GarbageContainer_closed_F', '[4855.069,16156.791,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
575INSERT INTO `mullabfuhr` VALUES ('51', 'Land_GarbageContainer_closed_F', '[7175.984,16531,0]', '[[0,0,0],[0,0,0.5]]', '1', '-268');
576
577-- ----------------------------
578-- Table structure for `news`
579-- ----------------------------
580DROP TABLE IF EXISTS `news`;
581CREATE TABLE `news` (
582 `id` int(12) NOT NULL AUTO_INCREMENT,
583 `artikelname` varchar(500) NOT NULL,
584 `news` varchar(1000) NOT NULL,
585 `likes` text NOT NULL,
586 `aktiv` tinyint(1) NOT NULL DEFAULT '1',
587 PRIMARY KEY (`id`)
588) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
589
590-- ----------------------------
591-- Table structure for `perso`
592-- ----------------------------
593DROP TABLE IF EXISTS `perso`;
594CREATE TABLE `perso` (
595 `id` int(12) NOT NULL AUTO_INCREMENT,
596 `playerid` varchar(50) NOT NULL,
597 `name` varchar(32) NOT NULL,
598 `bild` varchar(500) NOT NULL,
599 `adress` varchar(500) NOT NULL,
600 `birthday` varchar(500) NOT NULL,
601 `serial` int(100) NOT NULL DEFAULT '0',
602 PRIMARY KEY (`id`)
603) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
604
605-- ----------------------------
606-- Table structure for `schliessfach`
607-- ----------------------------
608DROP TABLE IF EXISTS `schliessfach`;
609CREATE TABLE `schliessfach` (
610 `uid` int(12) NOT NULL AUTO_INCREMENT,
611 `playerid` varchar(50) NOT NULL,
612 `inventory` text NOT NULL,
613 `inventory_weight` int(11) NOT NULL DEFAULT '600',
614 `inventory_maxweight` int(11) NOT NULL DEFAULT '1200',
615 `upgrade_safe` int(100) DEFAULT '0',
616 `owned` text NOT NULL,
617 PRIMARY KEY (`uid`),
618 UNIQUE KEY `playerid` (`playerid`)
619) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
620
621-- ----------------------------
622-- Table structure for `serverstatistik`
623-- ----------------------------
624DROP TABLE IF EXISTS `serverstatistik`;
625CREATE TABLE `serverstatistik` (
626 `uid` int(12) NOT NULL AUTO_INCREMENT,
627 `gesamtanzahl` int(100) NOT NULL DEFAULT '0',
628 `cop` int(100) NOT NULL DEFAULT '0',
629 `med` int(100) NOT NULL DEFAULT '0',
630 `atac` int(100) NOT NULL DEFAULT '0',
631 `civ` int(100) NOT NULL DEFAULT '0',
632 `datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
633 PRIMARY KEY (`uid`)
634) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
635
636-- ----------------------------
637-- Table structure for `supportlog`
638-- ----------------------------
639DROP TABLE IF EXISTS `supportlog`;
640CREATE TABLE `supportlog` (
641 `uid` int(12) NOT NULL AUTO_INCREMENT,
642 `playerid` varchar(32) NOT NULL,
643 `playername` varchar(32) NOT NULL,
644 `logname` varchar(500) NOT NULL,
645 `logtext` text NOT NULL,
646 `remainingtime` int(11) NOT NULL DEFAULT '2',
647 `active` tinyint(4) DEFAULT '1',
648 PRIMARY KEY (`uid`),
649 KEY `playerid` (`playerid`)
650) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
651
652-- ----------------------------
653-- Table structure for `vehicles`
654-- ----------------------------
655DROP TABLE IF EXISTS `vehicles`;
656CREATE TABLE `vehicles` (
657 `id` int(12) NOT NULL AUTO_INCREMENT,
658 `side` varchar(15) NOT NULL,
659 `classname` varchar(32) NOT NULL,
660 `type` varchar(12) NOT NULL,
661 `pid` varchar(50) NOT NULL,
662 `alive` tinyint(1) NOT NULL DEFAULT '1',
663 `active` tinyint(1) NOT NULL DEFAULT '1',
664 `plate` int(20) NOT NULL,
665 `color` int(20) NOT NULL,
666 `inventory` text NOT NULL,
667 `geheimfach` text NOT NULL,
668 `fuel` double NOT NULL DEFAULT '1',
669 `impound` int(100) DEFAULT '1',
670 `tuning` text NOT NULL,
671 `tuningcolor` text NOT NULL,
672 `auction` tinyint(1) NOT NULL DEFAULT '0',
673 `price` int(20) NOT NULL,
674 `lagerraum` int(20) NOT NULL,
675 PRIMARY KEY (`id`),
676 KEY `side` (`side`),
677 KEY `pid` (`pid`),
678 KEY `type` (`type`)
679) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
680
681-- ----------------------------
682-- Table structure for `wanted`
683-- ----------------------------
684DROP TABLE IF EXISTS `wanted`;
685CREATE TABLE `wanted` (
686 `wantedID` varchar(50) NOT NULL,
687 `wantedCrimes` text NOT NULL,
688 PRIMARY KEY (`wantedID`)
689) ENGINE=InnoDB DEFAULT CHARSET=utf8;
690
691-- ----------------------------
692-- Table structure for `west`
693-- ----------------------------
694DROP TABLE IF EXISTS `west`;
695CREATE TABLE `west` (
696 `uid` int(12) NOT NULL AUTO_INCREMENT,
697 `name` varchar(32) NOT NULL,
698 `playerid` varchar(50) NOT NULL,
699 `cash` int(100) NOT NULL DEFAULT '0',
700 `bank` int(100) NOT NULL DEFAULT '85000',
701 `licenses` text,
702 `stats` text NOT NULL,
703 `alive` text NOT NULL,
704 `direction` double NOT NULL DEFAULT '0',
705 `position_x` double NOT NULL DEFAULT '0',
706 `position_y` double NOT NULL DEFAULT '0',
707 `position_z` double NOT NULL DEFAULT '0',
708 `time` int(11) NOT NULL DEFAULT '0',
709 `exp` int(100) NOT NULL DEFAULT '0',
710 `talente` text,
711 `talentpunkte` int(100) NOT NULL DEFAULT '0',
712 `erfolge` text,
713 `title` varchar(150) NOT NULL DEFAULT 'Kein Titel',
714 PRIMARY KEY (`uid`),
715 UNIQUE KEY `playerid` (`playerid`),
716 KEY `name` (`name`)
717) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
718
719-- ----------------------------
720-- Table structure for `westgear`
721-- ----------------------------
722DROP TABLE IF EXISTS `westgear`;
723CREATE TABLE `westgear` (
724 `uid` int(12) NOT NULL AUTO_INCREMENT,
725 `name` varchar(32) NOT NULL,
726 `playerid` varchar(50) NOT NULL,
727 `assigned_items` text NOT NULL,
728 `backpack` varchar(64) NOT NULL DEFAULT '""',
729 `backpack_items` text NOT NULL,
730 `backpack_magazines` text NOT NULL,
731 `backpack_weapons` text NOT NULL,
732 `current_weapon` varchar(64) NOT NULL DEFAULT '""',
733 `goggles` varchar(64) NOT NULL DEFAULT '""',
734 `handgun_items` text NOT NULL,
735 `handgun_weapon` varchar(64) NOT NULL DEFAULT '""',
736 `headgear` varchar(64) NOT NULL DEFAULT '""',
737 `binocular` varchar(64) NOT NULL DEFAULT '""',
738 `loaded_magazines` text NOT NULL,
739 `primary_weapon` varchar(64) NOT NULL DEFAULT '""',
740 `primary_weapon_items` text NOT NULL,
741 `secondary_weapon` varchar(64) NOT NULL DEFAULT '""',
742 `secondary_weapon_items` text NOT NULL,
743 `uniform` varchar(64) NOT NULL DEFAULT '""',
744 `uniform_items` text NOT NULL,
745 `uniform_magazines` text NOT NULL,
746 `uniform_weapons` text NOT NULL,
747 `vest` varchar(64) NOT NULL DEFAULT '""',
748 `vest_items` text NOT NULL,
749 `vest_magazines` text NOT NULL,
750 `vest_weapons` text NOT NULL,
751 `zinventar` text NOT NULL,
752 PRIMARY KEY (`uid`),
753 UNIQUE KEY `playerid` (`playerid`),
754 KEY `name` (`name`)
755) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
756
757-- ----------------------------
758-- Table structure for `whitelist`
759-- ----------------------------
760DROP TABLE IF EXISTS `whitelist`;
761CREATE TABLE `whitelist` (
762 `uid` int(12) NOT NULL AUTO_INCREMENT,
763 `name` varchar(32) NOT NULL,
764 `playerid` varchar(50) NOT NULL,
765 `independentlevel` text,
766 `dienst` varchar(64) NOT NULL DEFAULT 'NONE',
767 `westlevel` text,
768 `eastlevel` text,
769 `supportlevel` int(11) NOT NULL DEFAULT '0',
770 `baned` text NOT NULL,
771 `combatlog` text NOT NULL,
772 PRIMARY KEY (`uid`),
773 UNIQUE KEY `playerid` (`playerid`),
774 KEY `name` (`name`)
775) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
776
777-- ----------------------------
778-- Table structure for `zivilist`
779-- ----------------------------
780DROP TABLE IF EXISTS `zivilist`;
781CREATE TABLE `zivilist` (
782 `uid` int(12) NOT NULL AUTO_INCREMENT,
783 `name` varchar(32) NOT NULL,
784 `playerid` varchar(50) NOT NULL,
785 `cash` int(100) NOT NULL DEFAULT '0',
786 `bank` int(100) NOT NULL DEFAULT '225000',
787 `licenses` text,
788 `stats` text NOT NULL,
789 `alive` text NOT NULL,
790 `direction` double NOT NULL DEFAULT '0',
791 `position_x` double NOT NULL DEFAULT '0',
792 `position_y` double NOT NULL DEFAULT '0',
793 `position_z` double NOT NULL DEFAULT '0',
794 `time` int(11) NOT NULL DEFAULT '0',
795 `exp` int(100) NOT NULL DEFAULT '0',
796 `talente` text,
797 `talentpunkte` int(100) NOT NULL DEFAULT '0',
798 `erfolge` text,
799 `title` varchar(150) NOT NULL DEFAULT 'Kein Titel',
800 `hausanzahl` int(100) NOT NULL DEFAULT '0',
801 `rufpunkte` int(100) NOT NULL DEFAULT '0',
802 PRIMARY KEY (`uid`),
803 UNIQUE KEY `playerid` (`playerid`),
804 KEY `name` (`name`)
805) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
806
807-- ----------------------------
808-- Table structure for `zivilistgear`
809-- ----------------------------
810DROP TABLE IF EXISTS `zivilistgear`;
811CREATE TABLE `zivilistgear` (
812 `uid` int(12) NOT NULL AUTO_INCREMENT,
813 `name` varchar(32) NOT NULL,
814 `playerid` varchar(50) NOT NULL,
815 `assigned_items` text NOT NULL,
816 `backpack` varchar(64) NOT NULL DEFAULT '""',
817 `backpack_items` text NOT NULL,
818 `backpack_magazines` text NOT NULL,
819 `backpack_weapons` text NOT NULL,
820 `current_weapon` varchar(64) NOT NULL DEFAULT '""',
821 `goggles` varchar(64) NOT NULL DEFAULT '""',
822 `handgun_items` text NOT NULL,
823 `handgun_weapon` varchar(64) NOT NULL DEFAULT '""',
824 `headgear` varchar(64) NOT NULL DEFAULT '""',
825 `binocular` varchar(64) NOT NULL DEFAULT '""',
826 `loaded_magazines` text NOT NULL,
827 `primary_weapon` varchar(64) NOT NULL DEFAULT '""',
828 `primary_weapon_items` text NOT NULL,
829 `secondary_weapon` varchar(64) NOT NULL DEFAULT '""',
830 `secondary_weapon_items` text NOT NULL,
831 `uniform` varchar(64) NOT NULL DEFAULT '""',
832 `uniform_items` text NOT NULL,
833 `uniform_magazines` text NOT NULL,
834 `uniform_weapons` text NOT NULL,
835 `vest` varchar(64) NOT NULL DEFAULT '""',
836 `vest_items` text NOT NULL,
837 `vest_magazines` text NOT NULL,
838 `vest_weapons` text NOT NULL,
839 `zinventar` text NOT NULL,
840 PRIMARY KEY (`uid`),
841 UNIQUE KEY `playerid` (`playerid`),
842 KEY `name` (`name`)
843) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
844
845-- ----------------------------
846-- Procedure structure for `deleteDeadVehicles`
847-- ----------------------------
848DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
849DELIMITER ;;
850CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `deleteDeadVehicles`()
851BEGIN
852 DELETE FROM `vehicles` WHERE `alive` = 0;
853END
854;;
855DELIMITER ;
856
857-- ----------------------------
858-- Procedure structure for `deleteOldGangs`
859-- ----------------------------
860DROP PROCEDURE IF EXISTS `deleteOldGangs`;
861DELIMITER ;;
862CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `deleteOldGangs`()
863BEGIN
864 DELETE FROM `gangs` WHERE `active` = 0;
865END
866;;
867DELIMITER ;
868
869-- ----------------------------
870-- Procedure structure for `deleteoldhouse`
871-- ----------------------------
872DROP PROCEDURE IF EXISTS `deleteoldhouse`;
873DELIMITER ;;
874CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `deleteoldhouse`()
875BEGIN
876 DELETE FROM `houses` WHERE `owned` = 0;
877END
878;;
879DELIMITER ;
880
881-- ----------------------------
882-- Procedure structure for `resetaliveeast`
883-- ----------------------------
884DROP PROCEDURE IF EXISTS `resetaliveeast`;
885DELIMITER ;;
886CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `resetaliveeast`()
887BEGIN
888 UPDATE east SET `alive`= 'false';
889END
890;;
891DELIMITER ;
892
893-- ----------------------------
894-- Procedure structure for `resetaliveindependent`
895-- ----------------------------
896DROP PROCEDURE IF EXISTS `resetaliveindependent`;
897DELIMITER ;;
898CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `resetaliveindependent`()
899BEGIN
900 UPDATE independent SET `alive`= 'false';
901END
902;;
903DELIMITER ;
904
905-- ----------------------------
906-- Procedure structure for `resetalivewest`
907-- ----------------------------
908DROP PROCEDURE IF EXISTS `resetalivewest`;
909DELIMITER ;;
910CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `resetalivewest`()
911BEGIN
912 UPDATE west SET `alive`= 'false';
913END
914;;
915DELIMITER ;
916
917-- ----------------------------
918-- Procedure structure for `resetalivezivilist`
919-- ----------------------------
920DROP PROCEDURE IF EXISTS `resetalivezivilist`;
921DELIMITER ;;
922CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `resetalivezivilist`()
923BEGIN
924 UPDATE zivilist SET `alive`= 'false';
925END
926;;
927DELIMITER ;
928
929-- ----------------------------
930-- Procedure structure for `resetLifeVehicles`
931-- ----------------------------
932DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
933DELIMITER ;;
934CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `resetLifeVehicles`()
935BEGIN
936 UPDATE vehicles SET `active`= 0;
937END
938;;
939DELIMITER ;
940
941-- ----------------------------
942-- Procedure structure for `resetmullabfuhr`
943-- ----------------------------
944DROP PROCEDURE IF EXISTS `resetmullabfuhr`;
945DELIMITER ;;
946CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `resetmullabfuhr`()
947BEGIN
948 UPDATE mullabfuhr SET `aktiv`= 1;
949END
950;;
951DELIMITER ;
952
953-- ----------------------------
954-- Procedure structure for `setlogactive`
955-- ----------------------------
956DROP PROCEDURE IF EXISTS `setlogactive`;
957DELIMITER ;;
958CREATE DEFINER=`nocrisgaming`@`localhost` PROCEDURE `setlogactive`()
959BEGIN
960 UPDATE supportlog SET `active`= 0 WHERE `remainingtime` = 0;
961END
962;;
963DELIMITER ;
964
965-- ----------------------------
966-- Event structure for `housing`
967-- ----------------------------
968DROP EVENT IF EXISTS `housing`;
969DELIMITER ;;
970CREATE DEFINER=`nocrisgaming`@`%` EVENT `housing` ON SCHEDULE EVERY 1 DAY STARTS '2016-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE houses
971SET renttime = renttime - 1 WHERE `renttime` > 0
972;;
973DELIMITER ;
974
975-- ----------------------------
976-- Event structure for `jail`
977-- ----------------------------
978DROP EVENT IF EXISTS `jail`;
979DELIMITER ;;
980CREATE DEFINER=`nocrisgaming`@`%` EVENT `jail` ON SCHEDULE EVERY 1 MINUTE STARTS '2016-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE jail
981SET jailtime = jailtime - 1 WHERE `jailtime` > 0
982;;
983DELIMITER ;
984
985-- ----------------------------
986-- Event structure for `launder`
987-- ----------------------------
988DROP EVENT IF EXISTS `launder`;
989DELIMITER ;;
990CREATE DEFINER=`nocrisgaming`@`%` EVENT `launder` ON SCHEDULE EVERY 1 MINUTE STARTS '2016-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE geldwasche
991SET remainingtime = remainingtime - 1 WHERE `remainingtime` > 0
992;;
993DELIMITER ;
994
995-- ----------------------------
996-- Event structure for `mullabfuhr`
997-- ----------------------------
998DROP EVENT IF EXISTS `mullabfuhr`;
999DELIMITER ;;
1000CREATE DEFINER=`nocrisgaming`@`%` EVENT `mullabfuhr` ON SCHEDULE EVERY 1 MINUTE STARTS '2016-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE mullabfuhr
1001SET remainingtime = remainingtime - 1 WHERE `remainingtime` > 0
1002;;
1003DELIMITER ;
1004
1005-- ----------------------------
1006-- Event structure for `setlog`
1007-- ----------------------------
1008DROP EVENT IF EXISTS `setlog`;
1009DELIMITER ;;
1010CREATE DEFINER=`nocrisgaming`@`%` EVENT `setlog` ON SCHEDULE EVERY 1 DAY STARTS '2016-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE supportlog
1011SET remainingtime = remainingtime - 1 WHERE `remainingtime` > 0
1012;;
1013DELIMITER ;