SQL-query:

ALTER TABLE `its_products` ADD `prod_vendorcost` FLOAT( 255 ) NOT NULL ,
ADD `prod_retailcost` FLOAT( 255 ) ,
ADD `prod_cost` FLOAT( 255 )

MySQL said: Documentation
#1063 - Incorrect column specifier for column 'prod_vendorcost'