Mysql error help! +rep

[Carlle]

mysql_real_query(): DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin` < 1344973404; - MYSQL ERROR: Table 'blitzserverz.guild_wars' doesn't exist (1146)
[16/08/2012 21:43:24] mysql_real_query(): UPDATE `guild_wars` SET `status` = 5, `end` = 1345146204 WHERE `status` = 1 AND `end` > 0 AND `end` < 1345146204; - MYSQL ERROR: Table 'blitzserverz.guild_wars' doesn't exist (1146)


How can i fix these errors? i cant find how to fix this!


REP!

 

[Cronox]

try use this query:

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT '0',
  `end` BIGINT NOT NULL DEFAULT '0',
  `frags` INT UNSIGNED NOT NULL DEFAULT '0',
  `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `guild_id` (`guild_id`),
  KEY `enemy_id` (`enemy_id`)
) ENGINE=InnoDB;
 
ALTER TABLE `guild_wars`
  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;