sql/Pg-upgrade2/transfer_type_stocktaking.sql

   1 -- @tag: transfer_type_stocktaking
   2 -- @description: neuer Transfertyp stocktaking für Inventur
   3 -- @depends: warehouse
   4
   5 INSERT INTO transfer_type (direction, description, sortkey) VALUES ('in',  'stocktaking', (SELECT COALESCE(MAX(sortkey), 0) + 1 FROM transfer_type));
   6 INSERT INTO transfer_type (direction, description, sortkey) VALUES ('out', 'stocktaking', (SELECT COALESCE(MAX(sortkey), 0) + 1 FROM transfer_type));