kivitendo/sql/Pg-upgrade/Pg-upgrade-2.2.0.24-2.2.0.25.sql @ 677f9c72
|
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;
|