ALTER TABLE `vendorpurchase` ADD `price` decimal(10,2) NOT NULL DEFAULT '0' AFTER `zip`;