ALTER TABLE `be_Product` ADD `m3Self` INT NULL DEFAULT NULL AFTER `type` , ADD `ft3Self` INT NULL DEFAULT NULL AFTER `m3Self` , ADD `m3Conv` INT NULL DEFAULT NULL AFTER `ft3Self` , ADD `ft3Conv` INT NULL DEFAULT NULL AFTER `m3Conv` ALTER TABLE `be_Product` CHANGE `m3Self` `m3Self` FLOAT NULL DEFAULT NULL , CHANGE `ft3Self` `ft3Self` FLOAT NULL DEFAULT NULL , CHANGE `m3Conv` `m3Conv` FLOAT NULL DEFAULT NULL , CHANGE `ft3Conv` `ft3Conv` FLOAT NULL DEFAULT NULL; UPDATE `be_Product` SET `m3Self`=90, `ft3Self`=1000, `m3Conv`=48, `ft3Conv`=1200 WHERE `type` = "utilityPole"; DELETE FROM `be_zz_Settings` WHERE `name` = 'selfUnloadMeter' OR `name` = 'selfUnloadFoot' OR `name` = 'conventionalMeter' OR `name` = 'conventionalFoot'; ALTER TABLE `be_Product` CHANGE `m3Self` `selfUnloadMeter` FLOAT NULL DEFAULT NULL , CHANGE `ft3Self` `selfUnloadFoot` FLOAT NULL DEFAULT NULL , CHANGE `m3Conv` `conventionalMeter` FLOAT NULL DEFAULT NULL , CHANGE `ft3Conv` `conventionalFoot` FLOAT NULL DEFAULT NULL