• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

TFS 1.X+ Error 'otserv.tiles' doesn't exist

Ryan6554

New Member
Joined
Nov 18, 2016
Messages
15
Reaction score
0
Iv'e tried to run this in my query
  1. CREATE TABLE `tiles`
  2. (
  3. `id` INT UNSIGNED NOT NULL,
  4. `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
  5. `house_id` INT UNSIGNED NOT NULL,
  6. `x` INT(5) UNSIGNED NOT NULL,
  7. `y` INT(5) UNSIGNED NOT NULL,
  8. `z` TINYINT(2) UNSIGNED NOT NULL,
  9. UNIQUE (`id`, `world_id`),
  10. KEY (`x`, `y`, `z`),
  11. FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
  12. ) ENGINE = InnoDB;

  13. CREATE TABLE `tile_items`
  14. (
  15. `tile_id` INT UNSIGNED NOT NULL,
  16. `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
  17. `sid` INT NOT NULL,
  18. `pid` INT NOT NULL DEFAULT 0,
  19. `itemtype` INT NOT NULL,
  20. `count` INT NOT NULL DEFAULT 0,
  21. `attributes` BLOB NOT NULL,
  22. UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
  23. FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
  24. ) ENGINE = InnoDB;
But this doesn't seem to work it just comes up with...
eNlR6TL
Imgur
 
Back
Top