· 8 years ago · Mar 28, 2018, 04:46 PM
1[GHMattiMySQL Debug] Connection: 360ms; Interaction: 53ms; Total 413ms for Query: SELECT 1
2[vRP] Connected to DB using driver "ghmattimysql".
3[GHMattiMySQL Debug] Connection: 0ms; Interaction: 20ms; Total 20ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueuserTrueidentities(
4 userTrueid INTEGER,
5 registration VARCHAR(20),
6 phone VARCHAR(20),
7 firstname VARCHAR(50),
8 name VARCHAR(50),
9 age INTEGER,
10 CONSTRAINT pkTrueuserTrueidentities PRIMARY KEY(userTrueid),
11 CONSTRAINT fkTrueuserTrueidentitiesTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE,
12 INDEX(registration),
13 INDEX(phone)
14);
15
16[GHMattiMySQL Debug] Connection: 0ms; Interaction: 19ms; Total 19ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueuserTruehomes(
17 userTrueid INTEGER,
18 home VARCHAR(100),
19 number INTEGER,
20 CONSTRAINT pkTrueuserTruehomes PRIMARY KEY(userTrueid),
21 CONSTRAINT fkTrueuserTruehomesTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE,
22 UNIQUE(home,number)
23);
24
25[GHMattiMySQL Debug] Connection: 7ms; Interaction: 19ms; Total 26ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueusers(
26 id INTEGER AUTOTrueINCREMENT,
27 lastTruelogin VARCHAR(255),
28 whitelisted BOOLEAN,
29 banned BOOLEAN,
30 CONSTRAINT pkTrueuser PRIMARY KEY(id)
31);
32
33CREATE TABLE IF NOT EXISTS vrpTrueuserTrueids(
34 identifier VARCHAR(100),
35 userTrueid INTEGER,
36 CONSTRAINT pkTrueuserTrueids PRIMARY KEY(identifier),
37 CONSTRAINT fkTrueuserTrueidsTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
38);
39
40CREATE TABLE IF NOT EXISTS vrpTrueuserTruedata(
41 userTrueid INTEGER,
42 dkey VARCHAR(100),
43 dvalue TEXT,
44 CONSTRAINT pkTrueuserTruedata PRIMARY KEY(userTrueid,dkey),
45 CONSTRAINT fkTrueuserTruedataTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
46);
47
48CREATE TABLE IF NOT EXISTS vrpTruesrvTruedata(
49 dkey VARCHAR(100),
50 dvalue TEXT,
51 CONSTRAINT pkTruesrvTruedata PRIMARY KEY(dkey)
52);
53
54[GHMattiMySQL Debug] Connection: 0ms; Interaction: 0ms; Total 0ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueuserTruebusiness(
55 userTrueid INTEGER,
56 name VARCHAR(30),
57 description TEXT,
58 capital INTEGER,
59 laundered INTEGER,
60 resetTruetimestamp INTEGER,
61 CONSTRAINT pkTrueuserTruebusiness PRIMARY KEY(userTrueid),
62 CONSTRAINT fkTrueuserTruebusinessTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
63);
64
65[GHMattiMySQL Debug] Connection: 0ms; Interaction: 0ms; Total 0ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueuserTruevehicles(
66 userTrueid INTEGER,
67 vehicle VARCHAR(100),
68 CONSTRAINT pkTrueuserTruevehicles PRIMARY KEY(userTrueid,vehicle),
69 CONSTRAINT fkTrueuserTruevehiclesTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
70);
71
72[GHMattiMySQL Debug] Connection: 0ms; Interaction: 0ms; Total 0ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueuserTruemoneys(
73 userTrueid INTEGER,
74 wallet INTEGER,
75 bank INTEGER,
76 CONSTRAINT pkTrueuserTruemoneys PRIMARY KEY(userTrueid),
77 CONSTRAINT fkTrueuserTruemoneysTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
78);
79
80[GHMattiMySQL Debug] Connection: 0ms; Interaction: 15ms; Total 15ms for Query: SELECT dvalue FROM vrpTruesrvTruedata WHERE dkey = vRP:hiddenTruetrs
81[GHMattiMySQL Debug] Connection: 0ms; Interaction: 4ms; Total 4ms for Query: REPLACE INTO vrpTruesrvTruedata(dkey,dvalue) VALUES(vRP:hiddenTruetrs,{"weed field":{"timestamp":1522182439,"position":[2208.0104980469,5577.6987304688,53.739212036133]},"lsd bar":{"timestamp":1522182439,"position":[1992.5993652344,3044.1806640625,47.215068817139]},"police2":{"timestamp":1522182439,"position":[1851.6605224609,3690.6713867188,34.267044067383]},"police1":{"timestamp":1522182439,"position":[439.57083129883,-995.072265625,30.689596176147]},"police3":{"timestamp":1522182439,"position":[-449.43395996094,6010.796875,31.716377258301]},"ems":{"timestamp":1522182439,"position":[465.04064941406,3569.1174316406,33.238555908203]},"cocaine dealer":{"timestamp":1522182439,"position":[-631.00543212891,-229.42568969727,38.057052612305]}})