Page History

...

1. Upgrade and restart the system.
2. Run the migrateAgreementWorkEffortAppl service from WebTools.
3. Check to make sure all data was transferred from OldAgreementWorkEffortAppl to AgreementWorkEffortApplic.
4. Drop the AgreementWorkEffortAppl table.

R929503: rename square_footage to facility_size, change its type to fixed-point, add a facility_size_uom_id colum

...

• Postgres: ALTER TABLE facility ALTER square_footage TYPE DEC(18,6);
• MySql (and Oracle at least I think): ALTER TABLE facility MODIFY square_footage TYPE DEC(18,6);

...

R929912: deprecate squareFootage and replace it by facilitySize (type fixed-point) and facilitySizeUomId

This script should be run intially to move values from square_footage to facility_size and set the Uom
update FACILITY set facility_size=square_footage;
update FACILITY set

...

facility_size_uom_id

...

='AREA_ft2';