Sql help

[drullen]

Hello I try to add a sql script to my database (it's to guild war system)

ALTER TABLE `guilds`
ADD `invited_to` INT( 11 ) NOT NULL ,
ADD `invited_by` INT( 11 ) NOT NULL ,
ADD `in_war_with` INT( 11 ) NOT NULL ,
ADD `kills` INT( 11 ) NOT NULL ,
ADD `show` SMALLINT( 1 ) NOT NULL ,
ADD `war_time` INT( 11 ) NOT NULL ;
CREATE TABLE `deaths_in_wars` (
`guild_id` INT( 11 ) NOT NULL ,
`player_id` INT( 11 ) NOT NULL ,
`killer_guild` INT( 11 ) NOT NULL ,
`killer` INT( 11 ) NOT NULL ,
`date` INT( 11 ) NOT NULL
) ENGINE = MYISAM ;



^ the script..



I get this error #1060 - Duplicate column name 'invited_to'


Please help!!


Rep++ for helping me

 

[Cykotitan]

It's because you already have that column, try to only execute the second query (CREATE TABLE `deaths...)

 

[drullen]

k thanks,