From a89af9c2a38f19bc2834a2e09a286ff36c9ef3d7 Mon Sep 17 00:00:00 2001 From: "G. Richardson" Date: Sun, 28 Aug 2016 10:23:11 +0200 Subject: [PATCH] AssortmentItem um Boolean "charge" erweitert MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Sortimentsartikel erweitert, bestimmen ob Artikel berechnet werden soll. Kann in SL::DB::Part->items_sellprice_sum abgefragt werden, ebenso beim Hinzufügen von Artikeln (Auftrag, CSV-Import) --- SL/DB/MetaSetup/AssortmentItem.pm | 1 + sql/Pg-upgrade2/assortment_charge.sql | 5 +++++ 2 files changed, 6 insertions(+) create mode 100644 sql/Pg-upgrade2/assortment_charge.sql diff --git a/SL/DB/MetaSetup/AssortmentItem.pm b/SL/DB/MetaSetup/AssortmentItem.pm index 5cedfbfa9..9f217430b 100644 --- a/SL/DB/MetaSetup/AssortmentItem.pm +++ b/SL/DB/MetaSetup/AssortmentItem.pm @@ -10,6 +10,7 @@ __PACKAGE__->meta->table('assortment_items'); __PACKAGE__->meta->columns( assortment_id => { type => 'integer', not_null => 1 }, + charge => { type => 'boolean', default => 'true' }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, parts_id => { type => 'integer', not_null => 1 }, diff --git a/sql/Pg-upgrade2/assortment_charge.sql b/sql/Pg-upgrade2/assortment_charge.sql new file mode 100644 index 000000000..c04397f73 --- /dev/null +++ b/sql/Pg-upgrade2/assortment_charge.sql @@ -0,0 +1,5 @@ +-- @tag: assortment_charge +-- @description: Sortimentsartikel erweitert, bestimmen ob Artikel berechnet werden soll +-- @depends: release_3_3_0 assortment_items + +ALTER TABLE assortment_items ADD COLUMN charge BOOLEAN DEFAULT TRUE; -- 2.20.1