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/Order.pm
9 9
__PACKAGE__->meta->table('oe');
10 10

  
11 11
__PACKAGE__->meta->columns(
12
  id                      => { type => 'integer', not_null => 1, sequence => 'id' },
13
  ordnumber               => { type => 'text', not_null => 1 },
14
  transdate               => { type => 'date', default => 'now' },
15
  vendor_id               => { type => 'integer' },
16
  customer_id             => { type => 'integer' },
17 12
  amount                  => { type => 'numeric', precision => 5, scale => 15 },
18
  netamount               => { type => 'numeric', precision => 5, scale => 15 },
19
  reqdate                 => { type => 'date' },
20
  taxincluded             => { type => 'boolean' },
21
  shippingpoint           => { type => 'text' },
22
  notes                   => { type => 'text' },
23
  employee_id             => { type => 'integer' },
24 13
  closed                  => { type => 'boolean', default => 'false' },
25
  quotation               => { type => 'boolean', default => 'false' },
26
  quonumber               => { type => 'text' },
14
  cp_id                   => { type => 'integer' },
15
  currency_id             => { type => 'integer', not_null => 1 },
27 16
  cusordnumber            => { type => 'text' },
28
  intnotes                => { type => 'text' },
17
  customer_id             => { type => 'integer' },
18
  delivered               => { type => 'boolean', default => 'false' },
19
  delivery_customer_id    => { type => 'integer' },
20
  delivery_vendor_id      => { type => 'integer' },
29 21
  department_id           => { type => 'integer' },
22
  employee_id             => { type => 'integer' },
23
  globalproject_id        => { type => 'integer' },
24
  id                      => { type => 'integer', not_null => 1, sequence => 'id' },
25
  intnotes                => { type => 'text' },
30 26
  itime                   => { type => 'timestamp', default => 'now()' },
31
  mtime                   => { type => 'timestamp' },
32
  shipvia                 => { type => 'text' },
33
  cp_id                   => { type => 'integer' },
34 27
  language_id             => { type => 'integer' },
28
  marge_percent           => { type => 'numeric', precision => 5, scale => 15 },
29
  marge_total             => { type => 'numeric', precision => 5, scale => 15 },
30
  mtime                   => { type => 'timestamp' },
31
  netamount               => { type => 'numeric', precision => 5, scale => 15 },
32
  notes                   => { type => 'text' },
33
  ordnumber               => { type => 'text', not_null => 1 },
35 34
  payment_id              => { type => 'integer' },
36
  delivery_customer_id    => { type => 'integer' },
37
  delivery_vendor_id      => { type => 'integer' },
38
  taxzone_id              => { type => 'integer' },
39 35
  proforma                => { type => 'boolean', default => 'false' },
40
  shipto_id               => { type => 'integer' },
41
  delivered               => { type => 'boolean', default => 'false' },
42
  globalproject_id        => { type => 'integer' },
36
  quonumber               => { type => 'text' },
37
  quotation               => { type => 'boolean', default => 'false' },
38
  reqdate                 => { type => 'date' },
43 39
  salesman_id             => { type => 'integer' },
40
  shippingpoint           => { type => 'text' },
41
  shipto_id               => { type => 'integer' },
42
  shipvia                 => { type => 'text' },
43
  taxincluded             => { type => 'boolean' },
44
  taxzone_id              => { type => 'integer' },
44 45
  transaction_description => { type => 'text' },
45
  marge_total             => { type => 'numeric', precision => 5, scale => 15 },
46
  marge_percent           => { type => 'numeric', precision => 5, scale => 15 },
47
  currency_id             => { type => 'integer', not_null => 1 },
46
  transdate               => { type => 'date', default => 'now' },
47
  vendor_id               => { type => 'integer' },
48 48
);
49 49

  
50 50
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
......
118 118
  },
119 119
);
120 120

  
121
# __PACKAGE__->meta->initialize;
122

  
123 121
1;
124 122
;

Auch abrufbar als: Unified diff