From 28f63405d915b1921189f0ebfc223b006b85e361 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Fri, 19 Jun 2020 11:36:38 +0200 Subject: [PATCH] Lieferdatum in Dialogbuchung: DB-Upgrade + Rose --- SL/DB/MetaSetup/GLTransaction.pm | 1 + sql/Pg-upgrade2/gl_add_deliverydate.sql | 5 +++++ 2 files changed, 6 insertions(+) create mode 100644 sql/Pg-upgrade2/gl_add_deliverydate.sql diff --git a/SL/DB/MetaSetup/GLTransaction.pm b/SL/DB/MetaSetup/GLTransaction.pm index 3b829d54d..f59251362 100644 --- a/SL/DB/MetaSetup/GLTransaction.pm +++ b/SL/DB/MetaSetup/GLTransaction.pm @@ -10,6 +10,7 @@ __PACKAGE__->meta->table('gl'); __PACKAGE__->meta->columns( cb_transaction => { type => 'boolean' }, + deliverydate => { type => 'date' }, department_id => { type => 'integer' }, description => { type => 'text' }, employee_id => { type => 'integer' }, diff --git a/sql/Pg-upgrade2/gl_add_deliverydate.sql b/sql/Pg-upgrade2/gl_add_deliverydate.sql new file mode 100644 index 000000000..2e5500ed3 --- /dev/null +++ b/sql/Pg-upgrade2/gl_add_deliverydate.sql @@ -0,0 +1,5 @@ +-- @tag: gl_add_deliverydate +-- @description: Liefer-/Leistungsdatum in Dialogbuchungen +-- @depends: release_3_5_5 + +ALTER TABLE gl ADD COLUMN deliverydate DATE; -- 2.20.1