Erro

consulta SQL:

KEY `guild_id` ( `guild_id` ) , KEY `enemy_id` ( `enemy_id` ) 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

Mensagens do MySQL :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY `guild_id` (`guild_id`),

KEY `enemy_id` (`enemy_id`)

ALTER TABLE `guild_' at line 1

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;

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;

CREATE TABLE IF NOT EXISTS `guild_kills` (

  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

  `guild_id` INT NOT NULL,

  `war_id` INT NOT NULL,

  `death_id` INT NOT NULL

) ENGINE = InnoDB;

ALTER TABLE `guild_kills`

  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,

  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,

  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

Créditos: Walef Xavier

Erro

consulta SQL:

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`

Mensagens do MySQL :

#1060 - Duplicate column name 'balance'

Erro

consulta SQL:

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0

Mensagens do MySQL : #1060 - Duplicate column name 'war'

Olha pessoal se pode fazer isso aqui

poste um link com um servidor 9.1 ou mais atualizado ja com war system se por eu agradeço desde ja

Cara, essas colunas já existem.

Então, vê se agora vai dar o erro.

o mesmo erro

da SS la em cima