ALTER TABLE users
ADD COLUMN name
VARCHAR(255) NULL DEFAULT ‘’ AFTER money
,
ADD COLUMN skin
LONGTEXT NULL AFTER name
,
ADD COLUMN job
varchar(255) NULL DEFAULT ‘unemployed’ AFTER skin
,
ADD COLUMN job_grade
INT NULL DEFAULT 0 AFTER job
,
ADD COLUMN loadout
LONGTEXT NULL AFTER job_grade
,
ADD COLUMN position
VARCHAR(255) NULL AFTER loadout
Im trying to install es_extend but it says: “SQL Error (1060): Duplicate column name ‘name’”