From 1deb1fbe7e1c00bb64df6e8d47023c1e429af8f6 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Mon, 28 Dec 2020 10:02:51 +0100 Subject: [PATCH] =?utf8?q?time-recording:=20Boolean=20f=C3=BCr=20abgerechn?= =?utf8?q?ete=20und=20an=20die=20LohnBu=20gemeldete=20Zeiten?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/TimeRecording.pm | 2 ++ sql/Pg-upgrade2/time_recordings2.sql | 6 ++++++ 2 files changed, 8 insertions(+) create mode 100644 sql/Pg-upgrade2/time_recordings2.sql diff --git a/SL/DB/MetaSetup/TimeRecording.pm b/SL/DB/MetaSetup/TimeRecording.pm index 518a03710..cb3bdd50a 100644 --- a/SL/DB/MetaSetup/TimeRecording.pm +++ b/SL/DB/MetaSetup/TimeRecording.pm @@ -9,6 +9,7 @@ use parent qw(SL::DB::Object); __PACKAGE__->meta->table('time_recordings'); __PACKAGE__->meta->columns( + booked => { type => 'boolean', default => 'false' }, customer_id => { type => 'integer', not_null => 1 }, description => { type => 'text', not_null => 1 }, employee_id => { type => 'integer', not_null => 1 }, @@ -16,6 +17,7 @@ __PACKAGE__->meta->columns( id => { type => 'serial', not_null => 1 }, itime => { type => 'timestamp', default => 'now()', not_null => 1 }, mtime => { type => 'timestamp', default => 'now()', not_null => 1 }, + payroll => { type => 'boolean', default => 'false' }, project_id => { type => 'integer' }, staff_member_id => { type => 'integer', not_null => 1 }, start_time => { type => 'timestamp', not_null => 1 }, diff --git a/sql/Pg-upgrade2/time_recordings2.sql b/sql/Pg-upgrade2/time_recordings2.sql new file mode 100644 index 000000000..afebb212a --- /dev/null +++ b/sql/Pg-upgrade2/time_recordings2.sql @@ -0,0 +1,6 @@ +-- @tag: time_recordings2 +-- @description: Ergänzung zur Zeiterfassung +-- @depends: time_recordings +ALTER TABLE time_recordings ADD column booked boolean DEFAULT false; +ALTER TABLE time_recordings ADD column payroll boolean DEFAULT false; + -- 2.20.1