· 5 years ago · Sep 07, 2020, 05:00 PM
1create table if not exists apartments
2(
3 id int auto_increment
4 primary key,
5 name varchar(255) not null,
6 type varchar(255) not null,
7 label varchar(255) not null,
8 citizenid varchar(255) not null
9)
10 charset = latin1;
11
12create table if not exists bank
13(
14 id int auto_increment,
15 type varchar(45) default 'user' not null,
16 balance int default 0 not null,
17 iban varchar(75) null,
18 job varchar(45) null,
19 label varchar(255) not null,
20 owner varchar(255) null,
21 constraint id_UNIQUE
22 unique (id)
23)
24 charset = latin1;
25
26alter table bank
27 add primary key (id);
28
29create table if not exists bank_transactions
30(
31 id int auto_increment,
32 sender varchar(255) not null,
33 target varchar(255) not null,
34 type varchar(255) not null,
35 amount varchar(225) not null,
36 constraint id_UNIQUE
37 unique (id)
38)
39 charset = latin1;
40
41alter table bank_transactions
42 add primary key (id);
43
44create table if not exists bans
45(
46 id int auto_increment
47 primary key,
48 name varchar(50) null,
49 steam varchar(50) null,
50 license varchar(50) null,
51 discord varchar(50) null,
52 ip varchar(50) null,
53 reason varchar(50) null,
54 expire int null,
55 bannedby varchar(50) null
56);
57
58create table if not exists bills
59(
60 id int auto_increment
61 primary key,
62 citizenid varchar(255) not null,
63 type varchar(255) not null,
64 amount int not null
65);
66
67create table if not exists cardealer_stock
68(
69 modelName varchar(255) not null
70 primary key,
71 number int default 0 null,
72 sellPrice int default 0 null
73);
74
75create table if not exists crypto
76(
77 `#` int auto_increment
78 primary key,
79 crypto varchar(50) default 'qbit' not null,
80 worth int default 0 not null,
81 history text null
82);
83
84create table if not exists crypto_transactions
85(
86 id int auto_increment
87 primary key,
88 citizenid varchar(50) null,
89 title varchar(50) null,
90 message varchar(50) null,
91 date timestamp default CURRENT_TIMESTAMP null
92);
93
94create index citizenid
95 on crypto_transactions (citizenid);
96
97create table if not exists dealers
98(
99 `#` int auto_increment
100 primary key,
101 name varchar(50) default '0' not null,
102 coords longtext collate utf8mb4_bin null,
103 time longtext collate utf8mb4_bin null,
104 createdby varchar(50) default '0' not null
105)
106 charset = latin1;
107
108create table if not exists failed_jobs
109(
110 id bigint unsigned auto_increment
111 primary key,
112 connection text not null,
113 queue text not null,
114 payload longtext not null,
115 exception longtext not null,
116 failed_at timestamp default CURRENT_TIMESTAMP not null
117)
118 collate = utf8mb4_unicode_ci;
119
120create table if not exists gangs
121(
122 id int auto_increment
123 primary key,
124 name varchar(255) not null,
125 label varchar(255) not null,
126 grades text not null
127)
128 charset = latin1;
129
130create table if not exists general_log
131(
132 event_time timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
133 user_host mediumtext not null,
134 thread_id bigint unsigned not null,
135 server_id int unsigned not null,
136 command_type varchar(64) not null,
137 argument mediumtext not null
138);
139
140create table if not exists gloveboxitems
141(
142 id int auto_increment
143 primary key,
144 plate varchar(255) not null,
145 name varchar(255) not null,
146 amount int not null,
147 info text not null,
148 type varchar(255) not null,
149 slot int not null
150)
151 charset = latin1;
152
153create table if not exists gloveboxitemsnew
154(
155 id int auto_increment
156 primary key,
157 plate varchar(255) not null,
158 items longtext collate utf8mb4_bin null
159)
160 charset = latin1;
161
162create table if not exists house_plants
163(
164 id int auto_increment
165 primary key,
166 building varchar(50) null,
167 stage varchar(50) default 'stage-a' null,
168 sort varchar(50) null,
169 gender varchar(50) null,
170 food int default 100 null,
171 health int default 100 null,
172 progress int default 0 null,
173 coords text null,
174 plantid varchar(50) null
175);
176
177create table if not exists houselocations
178(
179 id int auto_increment
180 primary key,
181 name varchar(255) not null,
182 label varchar(255) not null,
183 coords text not null,
184 owned tinyint not null,
185 price int not null,
186 tier tinyint not null,
187 garage text null
188)
189 charset = latin1;
190
191create table if not exists jobs
192(
193 id int auto_increment
194 primary key,
195 name varchar(255) not null,
196 label varchar(255) not null,
197 defaultDuty tinyint default 1 null
198)
199 charset = latin1;
200
201create table if not exists jobs_grades
202(
203 idjobs_grades int auto_increment
204 primary key,
205 grade_name varchar(45) not null,
206 grade_label varchar(45) not null,
207 job varchar(45) not null,
208 salary int not null,
209 boss tinyint default 0 not null,
210 level int not null
211);
212
213create table if not exists lapraces
214(
215 id int auto_increment
216 primary key,
217 name varchar(50) null,
218 checkpoints text null,
219 records text null,
220 creator varchar(50) null,
221 distance int null,
222 raceid varchar(50) null
223);
224
225create table if not exists lawyers
226(
227 id int auto_increment
228 primary key,
229 citizenid varchar(55) null,
230 label varchar(55) null
231)
232 charset = latin1;
233
234create table if not exists migrations
235(
236 id int unsigned auto_increment
237 primary key,
238 migration varchar(255) not null,
239 batch int not null
240)
241 collate = utf8mb4_unicode_ci;
242
243create table if not exists occasion_vehicles
244(
245 id int auto_increment
246 primary key,
247 seller varchar(50) null,
248 price int null,
249 description longtext null,
250 plate varchar(50) null,
251 model varchar(50) null,
252 mods text null,
253 occasionId varchar(50) null
254);
255
256create table if not exists panel_failed_jobs
257(
258 id bigint unsigned auto_increment
259 primary key,
260 connection text not null,
261 queue text not null,
262 payload longtext not null,
263 exception longtext not null,
264 failed_at timestamp default CURRENT_TIMESTAMP not null
265)
266 collate = utf8mb4_unicode_ci;
267
268create table if not exists panel_password_resets
269(
270 email varchar(255) not null,
271 token varchar(255) not null,
272 created_at timestamp null
273)
274 collate = utf8mb4_unicode_ci;
275
276create index panel_password_resets_email_index
277 on panel_password_resets (email);
278
279create table if not exists panel_users
280(
281 id bigint unsigned auto_increment
282 primary key,
283 name varchar(255) not null,
284 email varchar(255) not null,
285 email_verified_at timestamp null,
286 password varchar(255) not null,
287 remember_token varchar(100) null,
288 created_at timestamp null,
289 updated_at timestamp null,
290 constraint panel_users_email_unique
291 unique (email)
292)
293 collate = utf8mb4_unicode_ci;
294
295create table if not exists password_resets
296(
297 email varchar(255) not null,
298 token varchar(255) not null,
299 created_at timestamp null
300)
301 collate = utf8mb4_unicode_ci;
302
303create index password_resets_email_index
304 on password_resets (email);
305
306create table if not exists permissions
307(
308 id int auto_increment
309 primary key,
310 name varchar(255) not null,
311 steam varchar(255) not null,
312 license varchar(255) not null,
313 permission varchar(255) not null
314)
315 charset = latin1;
316
317create table if not exists phone_112
318(
319 id int unsigned auto_increment
320 primary key,
321 job varchar(55) not null,
322 label varchar(55) not null,
323 firstletter varchar(45) not null,
324 color varchar(45) null,
325 `desc` varchar(555) null,
326 logo_url varchar(999) null
327)
328 charset = latin1;
329
330create table if not exists phone_invoices
331(
332 invoiceid int auto_increment
333 primary key,
334 citizenid varchar(45) null,
335 amount int default 0 not null,
336 sender varchar(45) null,
337 sender_citizenid varchar(55) null,
338 label varchar(255) default 'Onbekend' not null,
339 status int default 0 not null
340)
341 charset = latin1;
342
343create table if not exists phone_messages
344(
345 id int auto_increment
346 primary key,
347 citizenid varchar(50) null,
348 number varchar(50) null,
349 messages text null
350);
351
352create table if not exists phone_tweets
353(
354 id int auto_increment
355 primary key,
356 citizenid varchar(50) null,
357 sender varchar(50) null,
358 message text null,
359 date datetime default CURRENT_TIMESTAMP null
360);
361
362create table if not exists player_boats
363(
364 `#` int auto_increment
365 primary key,
366 citizenid varchar(50) null,
367 model varchar(50) null,
368 plate varchar(50) null,
369 boathouse varchar(50) null,
370 fuel int default 100 not null,
371 state int default 0 not null
372);
373
374create table if not exists player_contacts
375(
376 id int auto_increment
377 primary key,
378 citizenid varchar(50) null,
379 name varchar(50) null,
380 number varchar(50) null,
381 iban varchar(50) null
382);
383
384create table if not exists player_houses
385(
386 house varchar(50) not null
387 primary key,
388 identifier varchar(50) null,
389 citizenid varchar(50) null,
390 keyholders text null,
391 decorations text null,
392 stash text null,
393 outfit text null,
394 logout text null
395);
396
397create table if not exists player_mails
398(
399 id int auto_increment
400 primary key,
401 citizenid varchar(50) null,
402 sender varchar(50) null,
403 subject varchar(50) null,
404 message text null,
405 `read` tinyint default 0 null,
406 mailid int null,
407 date timestamp default CURRENT_TIMESTAMP null,
408 button text null
409);
410
411create table if not exists player_outfits
412(
413 id int auto_increment
414 primary key,
415 citizenid varchar(50) null,
416 outfitname varchar(50) not null,
417 model varchar(50) null,
418 skin text null,
419 outfitId varchar(50) not null
420);
421
422create table if not exists player_training
423(
424 citizenid varchar(11) not null
425 primary key,
426 job text null,
427 trainingen text null
428);
429
430create table if not exists player_vehicles
431(
432 steam varchar(50) null,
433 citizenid varchar(50) null,
434 vehicle varchar(50) null,
435 hash varchar(50) null,
436 mods longtext collate utf8mb4_bin null,
437 plate varchar(50) not null
438 primary key,
439 fakeplate varchar(50) null,
440 garage varchar(50) null,
441 fuel int default 100 null,
442 engine float default 1000 null,
443 body float default 1000 null,
444 state int default 1 null,
445 depotprice int default 0 not null,
446 km double default 0 not null,
447 forSale int default 0 not null,
448 salePrice int default 0 null,
449 isSecured int default 0 not null,
450 status text null,
451 drivingdistance int null
452);
453
454create table if not exists player_warns
455(
456 `#` int auto_increment
457 primary key,
458 senderIdentifier varchar(50) null,
459 targetIdentifier varchar(50) null,
460 reason text null,
461 warnId varchar(50) null
462);
463
464create table if not exists playerammo
465(
466 id int auto_increment
467 primary key,
468 citizenid varchar(255) not null,
469 ammo text null
470)
471 charset = latin1;
472
473create table if not exists playeritems
474(
475 id int auto_increment
476 primary key,
477 citizenid varchar(255) not null,
478 name varchar(255) not null,
479 amount int not null,
480 info text null,
481 type varchar(255) not null,
482 slot int not null
483)
484 charset = latin1;
485
486create table if not exists players
487(
488 `#` int auto_increment
489 primary key,
490 citizenid varchar(255) not null,
491 cid int null,
492 steam varchar(255) not null,
493 license varchar(255) not null,
494 name varchar(255) not null,
495 money text not null,
496 charinfo text null,
497 job text not null,
498 gang text not null,
499 position text not null,
500 metadata text not null,
501 inventory longtext null
502)
503 charset = latin1;
504
505create table if not exists playerskins
506(
507 id int auto_increment
508 primary key,
509 citizenid varchar(255) not null,
510 model varchar(255) not null,
511 skin text not null,
512 active tinyint default 1 not null
513)
514 charset = latin1;
515
516create table if not exists police_failed_jobs
517(
518 id bigint unsigned auto_increment
519 primary key,
520 connection text not null,
521 queue text not null,
522 payload longtext not null,
523 exception longtext not null,
524 failed_at timestamp default CURRENT_TIMESTAMP not null
525)
526 collate = utf8mb4_unicode_ci;
527
528create table if not exists police_password_resets
529(
530 email varchar(255) not null,
531 token varchar(255) not null,
532 created_at timestamp null
533)
534 collate = utf8mb4_unicode_ci;
535
536create index police_password_resets_email_index
537 on police_password_resets (email);
538
539create table if not exists police_users
540(
541 id bigint unsigned auto_increment
542 primary key,
543 name varchar(255) not null,
544 email varchar(255) not null,
545 email_verified_at timestamp null,
546 password varchar(255) not null,
547 remember_token varchar(100) null,
548 created_at timestamp null,
549 updated_at timestamp null,
550 constraint police_users_email_unique
551 unique (email)
552)
553 collate = utf8mb4_unicode_ci;
554
555create table if not exists queue
556(
557 id int auto_increment
558 primary key,
559 steam varchar(255) not null,
560 license varchar(255) not null,
561 name varchar(255) not null,
562 priority int not null
563);
564
565create table if not exists slow_log
566(
567 start_time timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
568 user_host mediumtext not null,
569 query_time time not null,
570 lock_time time not null,
571 rows_sent int not null,
572 rows_examined int not null,
573 db varchar(512) not null,
574 last_insert_id int not null,
575 insert_id int not null,
576 server_id int unsigned not null,
577 sql_text mediumtext not null,
578 thread_id bigint unsigned not null
579)
580 comment 'Slow log' engine = CSV
581 charset = utf8;
582
583create table if not exists society_vehicles
584(
585 id_socVeh int auto_increment
586 primary key,
587 vehicle_model text null
588);
589
590create table if not exists stashitems
591(
592 id int auto_increment
593 primary key,
594 stash varchar(255) not null,
595 name varchar(255) not null,
596 amount int not null,
597 info text not null,
598 type varchar(255) not null,
599 slot int not null
600)
601 charset = latin1;
602
603create table if not exists stashitemsnew
604(
605 id int auto_increment
606 primary key,
607 stash varchar(255) not null,
608 items longtext collate utf8mb4_bin null
609)
610 charset = latin1;
611
612create table if not exists trunkitems
613(
614 id int auto_increment
615 primary key,
616 plate varchar(255) not null,
617 name varchar(255) not null,
618 amount int not null,
619 info text not null,
620 type varchar(255) not null,
621 slot int not null
622)
623 charset = latin1;
624
625create table if not exists trunkitemsnew
626(
627 id int auto_increment
628 primary key,
629 plate varchar(255) not null,
630 items longtext collate utf8mb4_bin null
631)
632 charset = latin1;
633
634create table if not exists type_training
635(
636 type_training int auto_increment
637 primary key,
638 job varchar(45) null,
639 label varchar(45) null,
640 name varchar(45) null
641);
642
643create table if not exists users
644(
645 id bigint unsigned auto_increment
646 primary key,
647 name varchar(255) not null,
648 email varchar(255) not null,
649 email_verified_at timestamp null,
650 password varchar(255) not null,
651 remember_token varchar(100) null,
652 created_at timestamp null,
653 updated_at timestamp null,
654 constraint users_email_unique
655 unique (email)
656)
657 collate = utf8mb4_unicode_ci;
658
659create table if not exists vehicle_category
660(
661 categoryName varchar(45) not null
662 primary key,
663 cat_label varchar(45) null
664);
665
666create table if not exists vehicle_delivery
667(
668 idvehicle_delivery int auto_increment
669 primary key,
670 vehicleModel text null,
671 deliveryDate date null
672);
673
674create table if not exists vehicle_list
675(
676 model_name varchar(90) not null
677 primary key,
678 type varchar(45) not null,
679 label varchar(45) not null,
680 job varchar(45) null,
681 trailer varchar(45) null,
682 buyInPrice int default 20000 null,
683 category varchar(45) default 'suv' null,
684 trunkspace int default 10000 null,
685 trunkslots int default 80 null,
686 brand varchar(45) null,
687 certification varchar(45) null
688);
689
690create table if not exists whitelist
691(
692 steam varchar(255) not null
693 primary key,
694 license varchar(255) not null,
695 name varchar(255) not null,
696 constraint identifier
697 unique (license)
698)
699 charset = latin1;
700
701