Mysql table missing

[davidcantu96]

mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `guild_wars` WHERE (`guild_id` = 4 OR `enemy_id` = 4) AND `status` IN (1,4) - MYSQL ERROR: Table 'hongot.guild_wars' doesn't exist (1146)

i get this error every time someone with a guild logs in the server.

 

[Shyzoul]

You know the table is missing why dont you just create it?

 

[Raggaer]

This should work

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guild1` int(11) NOT NULL DEFAULT '0',
  `guild2` int(11) NOT NULL DEFAULT '0',
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `started` bigint(15) NOT NULL DEFAULT '0',
  `ended` bigint(15) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guild1` (`guild1`),
  KEY `guild2` (`guild2`)
) ENGINE=InnoDB;