Revision 220779bd
Von Jan Büren vor etwa 4 Jahren hinzugefügt
| SL/DB/MetaSetup/TimeRecording.pm | ||
|---|---|---|
| 9 | 9 |
__PACKAGE__->meta->table('time_recordings');
|
| 10 | 10 |
|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 |
booked => { type => 'boolean', default => 'false' },
|
|
| 12 | 13 |
customer_id => { type => 'integer', not_null => 1 },
|
| 13 | 14 |
description => { type => 'text', not_null => 1 },
|
| 14 | 15 |
employee_id => { type => 'integer', not_null => 1 },
|
| ... | ... | |
| 16 | 17 |
id => { type => 'serial', not_null => 1 },
|
| 17 | 18 |
itime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
| 18 | 19 |
mtime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
| 20 |
payroll => { type => 'boolean', default => 'false' },
|
|
| 19 | 21 |
project_id => { type => 'integer' },
|
| 20 | 22 |
staff_member_id => { type => 'integer', not_null => 1 },
|
| 21 | 23 |
start_time => { type => 'timestamp', not_null => 1 },
|
| sql/Pg-upgrade2/time_recordings2.sql | ||
|---|---|---|
| 1 |
-- @tag: time_recordings2 |
|
| 2 |
-- @description: Ergänzung zur Zeiterfassung |
|
| 3 |
-- @depends: time_recordings |
|
| 4 |
ALTER TABLE time_recordings ADD column booked boolean DEFAULT false; |
|
| 5 |
ALTER TABLE time_recordings ADD column payroll boolean DEFAULT false; |
|
| 6 |
|
|
Auch abrufbar als: Unified diff
time-recording: Boolean für abgerechnete und an die LohnBu gemeldete Zeiten