uUPCDmnz

1[vRP] Connected to DB using driver "ghmattimysql".
2[GHMattiMySQL Debug] Connection: 0ms; Interaction: 31ms; Total 31ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueusers(
3  id INTEGER AUTOTrueINCREMENT,
4  whitelisted BOOLEAN,
5  banned BOOLEAN,
6  CONSTRAINT pkTrueuser PRIMARY KEY(id)
7);
8
9CREATE TABLE IF NOT EXISTS vrpTrueuserTrueids(
10  identifier VARCHAR(100),
11  userTrueid INTEGER,
12  CONSTRAINT pkTrueuserTrueids PRIMARY KEY(identifier),
13  CONSTRAINT fkTrueuserTrueidsTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
14);
15
16CREATE TABLE IF NOT EXISTS vrpTruecharacters(
17  id INTEGER AUTOTrueINCREMENT,
18  userTrueid INTEGER,
19  CONSTRAINT pkTruecharacters PRIMARY KEY(id),
20  CONSTRAINT fkTruecharactersTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
21);
22
23CREATE TABLE IF NOT EXISTS vrpTrueuserTruedata(
24  userTrueid INTEGER,
25  dkey VARCHAR(100),
26  dvalue BLOB,
27  CONSTRAINT pkTrueuserTruedata PRIMARY KEY(userTrueid,dkey),
28  CONSTRAINT fkTrueuserTruedataTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
29);
30
31CREATE TABLE IF NOT EXISTS vrpTruecharacterTruedata(
32  characterTrueid INTEGER,
33  dkey VARCHAR(100),
34  dvalue BLOB,
35  CONSTRAINT pkTruecharacterTruedata PRIMARY KEY(characterTrueid,dkey),
36  CONSTRAINT fkTruecharacterTruedataTruecharacters FOREIGN KEY(characterTrueid) REFERENCES vrpTruecharacters(id) ON DELETE CASCADE
37);
38
39CREATE TABLE IF NOT EXISTS vrpTrueserverTruedata(
40  id VARCHAR(100),
41  dkey VARCHAR(100),
42  dvalue BLOB,
43  CONSTRAINT pkTrueserverTruedata PRIMARY KEY(id, dkey)
44);
45
46CREATE TABLE IF NOT EXISTS vrpTrueglobalTruedata(
47  dkey VARCHAR(100),
48  dvalue BLOB,
49  CONSTRAINT pkTrueglobalTruedata PRIMARY KEY(dkey)
50);
51
52
53Error resuming coroutine: @vrp/lib/utils.lua:69: async wait(): Citizen.Await returned (nil) before the areturn call.
54stack traceback:
55        [C]: in function 'error'
56        @vrp/lib/utils.lua:69: in function <@vrp/lib/utils.lua:63>
57        (...tail calls...)
58        [string "vrp/vRP.lua"]:131: in method 'registerDBDriver'
59        [string "vrp_ghmattimysql/init_vrp.lua"]:66: in function <[string "vrp_ghmattimysql/init_vrp.lua"]:65>
60[GHMattiMySQL Debug] Connection: 0ms; Interaction: 3ms; Total 3ms for Query:     CREATE TABLE IF NOT EXISTS vrpTruecharacterTrueidentities(
61      characterTrueid INTEGER,
62      registration VARCHAR(20),
63      phone VARCHAR(20),
64      firstname VARCHAR(50),
65      name VARCHAR(50),
66      age INTEGER,
67      CONSTRAINT pkTruecharacterTrueidentities PRIMARY KEY(characterTrueid),
68      CONSTRAINT fkTruecharacterTrueidentitiesTruecharacters FOREIGN KEY(characterTrueid) REFERENCES vrpTruecharacters(id) ON DELETE CASCADE,
69      INDEX(registration),
70      INDEX(phone)
71    );