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


