Solved TFS 0.4 Error in data base -MySql

[EstebanGod]

Im getting this error at my console:

Anybody can help me out with the query to fix this?

 

[Limos]

Import right MySQL schema, the one for your server, or add the tables with a query.

CREATE TABLE `bans`
(
   `id` INT UNSIGNED NOT NULL auto_increment,
   `type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
   `value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
   `param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
   `active` TINYINT(1) NOT NULL DEFAULT TRUE,
   `expires` INT NOT NULL,
   `added` INT UNSIGNED NOT NULL,
   `admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
   `comment` TEXT NOT NULL,
   `reason` INT UNSIGNED NOT NULL DEFAULT 0,
   `action` INT UNSIGNED NOT NULL DEFAULT 0,
   `statement` VARCHAR(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `type` (`type`, `value`),
   KEY `active` (`active`)
) ENGINE = InnoDB;

CREATE TABLE `player_depotitems`
(
   `player_id` INT NOT NULL,
   `sid` INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
   `pid` INT NOT NULL DEFAULT 0,
   `itemtype` INT NOT NULL,
   `count` INT NOT NULL DEFAULT 0,
   `attributes` BLOB NOT NULL,
   KEY (`player_id`), UNIQUE (`player_id`, `sid`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[EstebanGod]

Im using TFS 0.4

Im using the oonly schema I got

Worked! thanks alot Limos!