Versions Compared

Old Version 35

changes.mady.by.user Jacques Le Roux

Saved on

compared with

New Version 36

changes.mady.by.user Jacques Le Roux

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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);
  2. ALTER TABLE facility RENAME COLUMN square_footage TO facility_size;
  3. ALTER TABLE facility ADD COLUMN facility_size_uom_id VARCHAR(20);