Linux Database tables get deleted randomly + need tile_items query

[jiotrus]

Hello, why does tile_items sometimes get deleted, as well as other tables?
+ Need tile_items query, I get errno150 when creating it in database with sql file..

 

[valivan601]

DROP TABLE IF EXISTS `tile_items`;
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;