Iv'e tried to run this in my query
Imgur
- CREATE TABLE `tiles`
- (
- `id` INT UNSIGNED NOT NULL,
- `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
- `house_id` INT UNSIGNED NOT NULL,
- `x` INT(5) UNSIGNED NOT NULL,
- `y` INT(5) UNSIGNED NOT NULL,
- `z` TINYINT(2) UNSIGNED NOT NULL,
- UNIQUE (`id`, `world_id`),
- KEY (`x`, `y`, `z`),
- FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
- ) ENGINE = InnoDB;
- CREATE TABLE `tile_items`
- (
- `tile_id` INT UNSIGNED NOT NULL,
- `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
- `sid` INT NOT NULL,
- `pid` INT NOT NULL DEFAULT 0,
- `itemtype` INT NOT NULL,
- `count` INT NOT NULL DEFAULT 0,
- `attributes` BLOB NOT NULL,
- UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
- FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
- ) ENGINE = InnoDB;