X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/43bcf835ebe883d3ba2e9bf23b7ca3d2bb215e9c..3aef41d7db2adc2cd04638a4abcf22acb0de8a15:/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 index a7add57f7..6992607e7 100644 --- a/sql/Pg-upgrade2/add_warehouse_client_config_default.sql +++ b/sql/Pg-upgrade2/add_warehouse_client_config_default.sql @@ -1,9 +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 +-- @charset: utf-8 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); -