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/Invoice.pm
9 9
__PACKAGE__->meta->table('ar');
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
  customer_id               => { type => 'integer' },
17
  taxincluded               => { type => 'boolean' },
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 },
15
  cusordnumber              => { type => 'text' },
16
  customer_id               => { type => 'integer' },
21 17
  datepaid                  => { type => 'date' },
22
  duedate                   => { type => 'date' },
18
  delivery_customer_id      => { type => 'integer' },
19
  delivery_vendor_id        => { type => 'integer' },
23 20
  deliverydate              => { type => 'date' },
24
  invoice                   => { type => 'boolean', default => 'false' },
25
  shippingpoint             => { type => 'text' },
26
  terms                     => { type => 'integer', default => '0' },
27
  notes                     => { type => 'text' },
28
  ordnumber                 => { type => 'text' },
21
  department_id             => { type => 'integer' },
22
  direct_debit              => { type => 'boolean', default => 'false' },
23
  donumber                  => { type => 'text' },
24
  duedate                   => { type => 'date' },
25
  dunning_config_id         => { type => 'integer' },
29 26
  employee_id               => { type => 'integer' },
30
  quonumber                 => { type => 'text' },
31
  cusordnumber              => { type => 'text' },
27
  gldate                    => { type => 'date', default => 'now' },
28
  globalproject_id          => { type => 'integer' },
29
  id                        => { type => 'integer', not_null => 1, sequence => 'glid' },
32 30
  intnotes                  => { type => 'text' },
33
  department_id             => { type => 'integer' },
34
  shipvia                   => { type => 'text' },
31
  invnumber                 => { type => 'text', not_null => 1 },
32
  invnumber_for_credit_note => { type => 'text' },
33
  invoice                   => { type => 'boolean', default => 'false' },
35 34
  itime                     => { type => 'timestamp', default => 'now()' },
36
  mtime                     => { type => 'timestamp' },
37
  cp_id                     => { type => 'integer' },
38 35
  language_id               => { type => 'integer' },
39
  payment_id                => { type => 'integer' },
40
  delivery_customer_id      => { type => 'integer' },
41
  delivery_vendor_id        => { type => 'integer' },
42
  storno                    => { type => 'boolean', default => 'false' },
43
  taxzone_id                => { type => 'integer' },
44
  shipto_id                 => { type => 'integer' },
45
  type                      => { type => 'text' },
46
  dunning_config_id         => { type => 'integer' },
36
  marge_percent             => { type => 'numeric', precision => 5, scale => 15 },
37
  marge_total               => { type => 'numeric', precision => 5, scale => 15 },
38
  mtime                     => { type => 'timestamp' },
39
  netamount                 => { type => 'numeric', precision => 5, scale => 15 },
40
  notes                     => { type => 'text' },
47 41
  orddate                   => { type => 'date' },
42
  ordnumber                 => { type => 'text' },
43
  paid                      => { type => 'numeric', precision => 5, scale => 15 },
44
  payment_id                => { type => 'integer' },
48 45
  quodate                   => { type => 'date' },
49
  globalproject_id          => { type => 'integer' },
46
  quonumber                 => { type => 'text' },
50 47
  salesman_id               => { type => 'integer' },
51
  transaction_description   => { type => 'text' },
48
  shippingpoint             => { type => 'text' },
49
  shipto_id                 => { type => 'integer' },
50
  shipvia                   => { type => 'text' },
51
  storno                    => { type => 'boolean', default => 'false' },
52 52
  storno_id                 => { type => 'integer' },
53
  marge_total               => { type => 'numeric', precision => 5, scale => 15 },
54
  marge_percent             => { type => 'numeric', precision => 5, scale => 15 },
55
  donumber                  => { type => 'text' },
56
  invnumber_for_credit_note => { type => 'text' },
57
  direct_debit              => { type => 'boolean', default => 'false' },
58
  currency_id               => { type => 'integer', not_null => 1 },
53
  taxincluded               => { type => 'boolean' },
54
  taxzone_id                => { type => 'integer' },
55
  terms                     => { type => 'integer', default => '0' },
56
  transaction_description   => { type => 'text' },
57
  transdate                 => { type => 'date', default => 'now' },
58
  type                      => { type => 'text' },
59 59
);
60 60

  
61 61
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
......
124 124
  },
125 125
);
126 126

  
127
# __PACKAGE__->meta->initialize;
128

  
129 127
1;
130 128
;

Auch abrufbar als: Unified diff