Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 4521429b

Von Jan Büren vor fast 4 Jahren hinzugefügt

  • ID 4521429b5a98a1f4e1723dac8f0f8ada601031c0
  • Vorgänger b93e041b

time-recording: Boolean für abgerechnete und an die LohnBu gemeldete Zeiten

Unterschiede anzeigen:

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