From e0df6dc51d60422009da0edb2c11ab7bee3cf156 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Tue, 4 Jun 2013 14:46:34 +0200 Subject: [PATCH] Weitere Lagerverfahren Konfigurationen in defaults abbilden --- sql/Pg-upgrade2/add_warehouse_client_config_default.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/Pg-upgrade2/add_warehouse_client_config_default.sql diff --git a/sql/Pg-upgrade2/add_warehouse_client_config_default.sql b/sql/Pg-upgrade2/add_warehouse_client_config_default.sql new file mode 100644 index 000000000..a7add57f7 --- /dev/null +++ b/sql/Pg-upgrade2/add_warehouse_client_config_default.sql @@ -0,0 +1,9 @@ +-- @tag: add_warehouse_client_config_default +-- @description: Konfigurations-Optionen für das Standard-Auslager-Verfahren +-- @depends: release_3_0_0 add_warehouse_defaults +ALTER TABLE defaults add column transfer_default boolean default true; +ALTER TABLE defaults add column transfer_default_use_master_default_bin boolean default false; +ALTER TABLE defaults add column transfer_default_ignore_onhand boolean default false; +ALTER TABLE defaults ADD COLUMN warehouse_id_ignore_onhand integer references warehouse(id); +ALTER TABLE defaults add column bin_id_ignore_onhand integer references bin(id); + -- 2.20.1