SQL Tables Error

I added a mod that adds more colored ranks to groups, Index.php, and Viewonline.php. All went well untill i had to add the SQL tables to my data base. This is the erros i got, can anyone tell me what i'm doing wrong or what i need to do.

"Duplicate column name 'user_whosonline_color' "

I'm not exsactly sure what that means.


These are the SQL codes i am suppose to run.


Code:
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_whosonline_ranks` (
`whosonline_rank_id` tinyint(4) NOT NULL auto_increment,
`whosonline_rank_name` varchar(50) NOT NULL default '',
`whosonline_rank_color` varchar(9) NOT NULL default '',
`whosonline_lang_key` smallint(1) unsigned NOT NULL default '0',
`whosonline_rank_order` int(11) NOT NULL default '0',
PRIMARY KEY (`whosonline_rank_id`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;

#
#-----[ SQL ]------------------------------------------
#
INSERT INTO `phpbb_whosonline_ranks` VALUES (1, 'Test', 'red', 0, 10);

#
#-----[ SQL ]------------------------------------------
#

ALTER TABLE phpbb_users ADD user_whosonline_color int(11) DEFAULT '0' NOT NULL;

#
#-----[ SQL ]------------------------------------------
#

ALTER TABLE `phpbb_groups` ADD `group_color` smallint(8) DEFAULT '0' NOT NULL ;

#
#-----[ SQL ]------------------------------------------
#

INSERT INTO `phpbb_config` VALUES ('allow_group_index', '0');

#