Table tile_store .. Does anybody have it ?

[Kakaher]

Hello everyone..

So, I'm having a little problem on my server, everything was working fine till I upgraded to a new TFS
But, I need this new server because of some lua functions it has..

The problem is that now my houses are not saving, because my database doesn't have a table called "tile_store"

I'm here to ask if anybody's database has this table, and if so, can you please tell me how does this table look like so that I can create it on my database ?

The server I downloaded did not come with a database, that is why I'm asking here...

Here is the error I get:

mysql_real_query(): SELECT `house_id`, `data` FROM `tile_store` WHERE `world_id` = 0 - MYSQL ERROR: Table ´kakaher.tile_store´ doesn´t exist (1146)

Thanks already everyone for the help

 

[Critico]

try this

CREATE TABLE `tile_store`
(
`house_id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(4) UNSIGNED NOT NULL DEFAULT 0,
`data` LONGBLOB NOT NULL,
FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Kakaher]

try this

CREATE TABLE `tile_store`
(
`house_id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(4) UNSIGNED NOT NULL DEFAULT 0,
`data` LONGBLOB NOT NULL,
FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Thanks so much, that is it ! = )
Rep !