kivitendo/sql/Pg-upgrade/Pg-upgrade-2.2.0.24-2.2.0.25.sql @ a921e75a
|
ALTER TABLE rmaitems ADD COLUMN tmp varchar(20);
|
|
|
UPDATE rmaitems SET tmp = unit;
|
|
|
ALTER TABLE rmaitems DROP COLUMN unit;
|
|
|
ALTER TABLE rmaitems RENAME tmp TO unit;
|