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

  
11 11
__PACKAGE__->meta->columns(
12
  id                 => { type => 'integer', not_null => 1, sequence => 'delivery_order_items_id' },
12
  base_qty           => { type => 'float', precision => 4 },
13
  cusordnumber       => { type => 'text' },
13 14
  delivery_order_id  => { type => 'integer', not_null => 1 },
14
  parts_id           => { type => 'integer', not_null => 1 },
15 15
  description        => { type => 'text' },
16
  qty                => { type => 'numeric', precision => 5, scale => 25 },
17
  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
18 16
  discount           => { type => 'float', precision => 4 },
17
  id                 => { type => 'integer', not_null => 1, sequence => 'delivery_order_items_id' },
18
  itime              => { type => 'timestamp', default => 'now()' },
19
  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
20
  longdescription    => { type => 'text' },
21
  marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
22
  mtime              => { type => 'timestamp' },
23
  ordnumber          => { type => 'text' },
24
  parts_id           => { type => 'integer', not_null => 1 },
25
  price_factor       => { type => 'numeric', default => 1, precision => 5, scale => 15 },
26
  price_factor_id    => { type => 'integer' },
27
  pricegroup_id      => { type => 'integer' },
19 28
  project_id         => { type => 'integer' },
29
  qty                => { type => 'numeric', precision => 5, scale => 25 },
20 30
  reqdate            => { type => 'date' },
31
  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
21 32
  serialnumber       => { type => 'text' },
22
  ordnumber          => { type => 'text' },
23 33
  transdate          => { type => 'text' },
24
  cusordnumber       => { type => 'text' },
25 34
  unit               => { type => 'varchar', length => 20 },
26
  base_qty           => { type => 'float', precision => 4 },
27
  longdescription    => { type => 'text' },
28
  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
29
  price_factor_id    => { type => 'integer' },
30
  price_factor       => { type => 'numeric', default => 1, precision => 5, scale => 15 },
31
  marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
32
  itime              => { type => 'timestamp', default => 'now()' },
33
  mtime              => { type => 'timestamp' },
34
  pricegroup_id      => { type => 'integer' },
35 35
);
36 36

  
37 37
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
......
65 65
  },
66 66
);
67 67

  
68
# __PACKAGE__->meta->initialize;
69

  
70 68
1;
71 69
;

Auch abrufbar als: Unified diff