1 -- @tag: transfer_type_stocktaking
2 -- @description: neuer Transfertyp stocktaking für Inventur
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));