How do if this problem with the user database from esx?

[Police_Driver]

So i accidentaly deletet the user database and i cant join anymore. I youst stay on a black screen and this message pops up:

[script:esx_multichar] SCRIPT ERROR: @esx_multicharacter/server/main.lua:60: esx_multicharacter was unable to execute a query!
[script:esx_multichar] Query: SELECT identifier, accounts, job, job_grade, firstname, lastname, dateofbirth, sex, skin, disabled FROM users WHERE identifier LIKE ? LIMIT ?
[script:esx_multichar] ["char%:011d806d98fad2887d81be3aed54ffab5c1d84de",4]
[script:esx_multichar] Unknown column 'accounts' in 'field list'

I already have a new user database, but it stays like this. Can someone help?

[Tilltheprogamer]

Ist missing only the accounts collum

[Police_Driver]

Im soory im kinda dumb rn, how do i fix this?

[Tilltheprogamer]

Look were the Accounts collum is in wich sql file and add it to your sql

[Police_Driver]

I still cant get this to work

[Sammy232]

go to your es_extended databse or what you named you database and paste in the following sql:

CREATE TABLE `users` (
  `identifier` varchar(60) NOT NULL,
  `accounts` longtext DEFAULT NULL,
  `group` varchar(50) DEFAULT 'user',
  `inventory` longtext DEFAULT NULL,
  `job` varchar(20) DEFAULT 'unemployed',
  `job_grade` int(11) DEFAULT 0,
  `loadout` longtext DEFAULT NULL,
  `metadata` LONGTEXT NULL DEFAULT NULL,
  `position` longtext NULL DEFAULT NULL,
  `firstname` varchar(16) DEFAULT NULL,
  `lastname` varchar(16) DEFAULT NULL,
  `dateofbirth` varchar(10) DEFAULT NULL,
  `sex` varchar(1) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `skin` longtext DEFAULT NULL,
  `status` longtext DEFAULT NULL,
  `is_dead` tinyint(1) DEFAULT 0,
  `id` int(11) NOT NULL,
  `disabled` TINYINT(1) NULL DEFAULT '0',
  `last_property` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `last_seen` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `phone_number` VARCHAR(20) DEFAULT NULL
) ENGINE=InnoDB;

In the second row is the accounts row what the script is searching for.

Or if you always have your users database you can also put following code in:

ALTER TABLE users 
ADD COLUMN accounts LONGTEXT DEFAULT NULL;

[Police_Driver]

Thank you so much man,