I'm making a fivem server but when i add essentialmode to my database and when i run the server.bat it shows me ER_BAD_FIELD_ERROR: Unknown column "inventory" in "field list".
Please help i would really appreciate it.
CODE:
CREATE TABLE users
(
identifier
VARCHAR(50) NOT NULL COLLATE 'utf8mb4_bin',
license
VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
money
INT(11) NULL DEFAULT NULL,
name
VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
skin
LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
job
VARCHAR(50) NULL DEFAULT 'unemployed' COLLATE 'utf8mb4_bin',
job_grade
INT(11) NULL DEFAULT 0,
loadout
LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
position
VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
bank
INT(11) NULL DEFAULT NULL,
permission_level
INT(11) NULL DEFAULT NULL,
group
VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
firstname
VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
lastname
VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
dateofbirth
VARCHAR(25) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
sex
VARCHAR(10) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
height
VARCHAR(5) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
status
LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
last_property
VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
is_dead
TINYINT(1) NULL DEFAULT 0,
phone_number
VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
PRIMARY KEY (identifier
)
)
COLLATE='utf8mb4_bin'
ENGINE=InnoDB
Labels |
Added:
?
|
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2020-02-20 17:55:48 |
Closed_By | ⇒ | alikon |
??
this the the repo for Joomla CMS