Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision b8b112a3

Von Sven Schöling vor mehr als 11 Jahren hinzugefügt

  • ID b8b112a39bd601b0bc717646d78de470631da22a
  • Vorgänger c0931303
  • Nachfolger 2d7e4203

MetaSetup neu generiert

Unterschiede anzeigen:

SL/DB/MetaSetup/Tax.pm
6 6

  
7 7
use base qw(SL::DB::Object);
8 8

  
9
__PACKAGE__->meta->setup(
10
  table   => 'tax',
11

  
12
  columns => [
13
    chart_id         => { type => 'integer' },
14
    rate             => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
15
    taxnumber        => { type => 'text' },
16
    taxkey           => { type => 'integer', not_null => 1 },
17
    taxdescription   => { type => 'text', not_null => 1 },
18
    itime            => { type => 'timestamp', default => 'now()' },
19
    mtime            => { type => 'timestamp' },
20
    id               => { type => 'integer', not_null => 1, sequence => 'id' },
21
    chart_categories => { type => 'text', not_null => 1 },
22
  ],
23

  
24
  primary_key_columns => [ 'id' ],
25

  
26
  allow_inline_column_values => 1,
27

  
28
  foreign_keys => [
29
    chart => {
30
      class       => 'SL::DB::Chart',
31
      key_columns => { chart_id => 'id' },
32
    },
33
  ],
9
__PACKAGE__->meta->table('tax');
10

  
11
__PACKAGE__->meta->columns(
12
  chart_id         => { type => 'integer' },
13
  rate             => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
14
  taxnumber        => { type => 'text' },
15
  taxkey           => { type => 'integer', not_null => 1 },
16
  taxdescription   => { type => 'text', not_null => 1 },
17
  itime            => { type => 'timestamp', default => 'now()' },
18
  mtime            => { type => 'timestamp' },
19
  id               => { type => 'integer', not_null => 1, sequence => 'id' },
20
  chart_categories => { type => 'text', not_null => 1 },
34 21
);
35 22

  
23
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
24

  
25
__PACKAGE__->meta->allow_inline_column_values(1);
26

  
27
__PACKAGE__->meta->foreign_keys(
28
  chart => {
29
    class       => 'SL::DB::Chart',
30
    key_columns => { chart_id => 'id' },
31
  },
32
);
33

  
34
# __PACKAGE__->meta->initialize;
35

  
36 36
1;
37 37
;

Auch abrufbar als: Unified diff