[help] User sql error

FiveM Server Development Server Discussion
, , , ,
1

Hi, when i try to alter table user i get this error:

ALTER TABLE ADD COLUMN `users`
(`name` VARCHAR 50, NULL DEFAULT '' AFTER `money`,
`skin` LONGTEXT NULL AFTER `name`,
`job` varchar 50, NULL DEFAULT 'unemployed' AFTER `skin`,
`job_grade` INT NULL DEFAULT 0 AFTER `job`,
`loadout` LONGTEXT NULL AFTER `job_grade`,
`position` VARCHAR 36, NULL AFTER `loadout`);

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD COLUMN users(nameVARCHAR 50, NULL DEFAULT '' AFTERmoney,skin…’ at line 1`

sql:

USE s22672_essentialmode;

ALTER TABLE ADD COLUMN users
(name VARCHAR 50, NULL DEFAULT ‘’ AFTER money,
skin LONGTEXT NULL AFTER name,
job varchar 50, NULL DEFAULT ‘unemployed’ AFTER skin,
job_grade INT NULL DEFAULT 0 AFTER job,
loadout LONGTEXT NULL AFTER job_grade,
position VARCHAR 36, NULL AFTER loadout)
;

thx to whoever fix this😁