Revision 1deb1fbe
Von Jan Büren vor fast 4 Jahren hinzugefügt
| SL/DB/MetaSetup/TimeRecording.pm | ||
|---|---|---|
|
__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 },
|
||
| ... | ... | |
|
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 },
|
||
| sql/Pg-upgrade2/time_recordings2.sql | ||
|---|---|---|
|
-- @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;
|
||
|
|
||
Auch abrufbar als: Unified diff
time-recording: Boolean für abgerechnete und an die LohnBu gemeldete Zeiten