Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 3eb3d1b1

Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt

  • ID 3eb3d1b144adb92e62de08e67dc6ff3d39bf7483
  • Vorgänger e7ae5b6a
  • Nachfolger 0b5b8355

MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren

Unterschiede anzeigen:

SL/DB/MetaSetup/PurchaseInvoice.pm
9 9
__PACKAGE__->meta->table('ap');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  id                      => { type => 'integer', not_null => 1, sequence => 'glid' },
13
  invnumber               => { type => 'text', not_null => 1 },
14
  transdate               => { type => 'date', default => 'now' },
15
  gldate                  => { type => 'date', default => 'now' },
16
  vendor_id               => { type => 'integer' },
17
  taxincluded             => { type => 'boolean', default => 'false' },
18 12
  amount                  => { type => 'numeric', precision => 5, scale => 15 },
19
  netamount               => { type => 'numeric', precision => 5, scale => 15 },
20
  paid                    => { type => 'numeric', precision => 5, scale => 15 },
13
  cp_id                   => { type => 'integer' },
14
  currency_id             => { type => 'integer', not_null => 1 },
21 15
  datepaid                => { type => 'date' },
16
  deliverydate            => { type => 'date' },
17
  department_id           => { type => 'integer' },
18
  direct_debit            => { type => 'boolean', default => 'false' },
22 19
  duedate                 => { type => 'date' },
23
  invoice                 => { type => 'boolean', default => 'false' },
24
  ordnumber               => { type => 'text' },
25
  notes                   => { type => 'text' },
26 20
  employee_id             => { type => 'integer' },
27
  quonumber               => { type => 'text' },
21
  gldate                  => { type => 'date', default => 'now' },
22
  globalproject_id        => { type => 'integer' },
23
  id                      => { type => 'integer', not_null => 1, sequence => 'glid' },
28 24
  intnotes                => { type => 'text' },
29
  department_id           => { type => 'integer' },
25
  invnumber               => { type => 'text', not_null => 1 },
26
  invoice                 => { type => 'boolean', default => 'false' },
30 27
  itime                   => { type => 'timestamp', default => 'now()' },
31
  mtime                   => { type => 'timestamp' },
32
  shipvia                 => { type => 'text' },
33
  cp_id                   => { type => 'integer' },
34 28
  language_id             => { type => 'integer' },
29
  mtime                   => { type => 'timestamp' },
30
  netamount               => { type => 'numeric', precision => 5, scale => 15 },
31
  notes                   => { type => 'text' },
32
  orddate                 => { type => 'date' },
33
  ordnumber               => { type => 'text' },
34
  paid                    => { type => 'numeric', precision => 5, scale => 15 },
35 35
  payment_id              => { type => 'integer' },
36
  quodate                 => { type => 'date' },
37
  quonumber               => { type => 'text' },
38
  shipvia                 => { type => 'text' },
36 39
  storno                  => { type => 'boolean', default => 'false' },
40
  storno_id               => { type => 'integer' },
41
  taxincluded             => { type => 'boolean', default => 'false' },
37 42
  taxzone_id              => { type => 'integer' },
38
  type                    => { type => 'text' },
39
  orddate                 => { type => 'date' },
40
  quodate                 => { type => 'date' },
41
  globalproject_id        => { type => 'integer' },
42 43
  transaction_description => { type => 'text' },
43
  storno_id               => { type => 'integer' },
44
  direct_debit            => { type => 'boolean', default => 'false' },
45
  deliverydate            => { type => 'date' },
46
  currency_id             => { type => 'integer', not_null => 1 },
44
  transdate               => { type => 'date', default => 'now' },
45
  type                    => { type => 'text' },
46
  vendor_id               => { type => 'integer' },
47 47
);
48 48

  
49 49
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
......
97 97
  },
98 98
);
99 99

  
100
# __PACKAGE__->meta->initialize;
101

  
102 100
1;
103 101
;

Auch abrufbar als: Unified diff