ENW6d7HC

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