Page History

...

This script should be run intially to move values from square_footage to facility_size and set the Uom
update FACILITY set UPDATE Facility SET facility_size=square_footage;
update FACILITY set UPDATE Facility SET facility_size_uom_id='AREA_ft2';
then the square_footage column might be removed
ALTER TABLE Facility DROP COLUMN square_footage;