Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision a3511b2d

Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt

  • ID a3511b2d8974c72e4d26b2d85c5cf1cd711ccb6f
  • Vorgänger 6c22ee7e
  • Nachfolger fb03d191

MetaSetups mit RDBO >= 0.809 neu bauen

Siehe 6c22ee7eb1f64431bade6f361259737ed23b7ecc für die Erläuterung.

Unterschiede anzeigen:

SL/DB/MetaSetup/Part.pm
19 19 
  ean                => { type => 'text' },
20 20 
  expense_accno_id   => { type => 'integer' },
21 21 
  formel             => { type => 'text' },
22 
  gv                 => { type => 'numeric', precision => 5, scale => 15 },
22 
  gv                 => { type => 'numeric', precision => 15, scale => 5 },
23 23 
  has_sernumber      => { type => 'boolean', default => 'false' },
24 24 
  id                 => { type => 'integer', not_null => 1, sequence => 'id' },
25 25 
  image              => { type => 'text' },
26 26 
  income_accno_id    => { type => 'integer' },
27 27 
  inventory_accno_id => { type => 'integer' },
28 28 
  itime              => { type => 'timestamp', default => 'now()' },
29 
  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
30 
  listprice          => { type => 'numeric', precision => 5, scale => 15 },
29 
  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
30 
  listprice          => { type => 'numeric', precision => 15, scale => 5 },
31 31 
  makemodel          => { type => 'boolean', default => 'false' },
32 32 
  microfiche         => { type => 'text' },
33 33 
  mtime              => { type => 'timestamp' },
34 34 
  not_discountable   => { type => 'boolean', default => 'false' },
35 35 
  notes              => { type => 'text' },
36 36 
  obsolete           => { type => 'boolean', default => 'false' },
37 
  onhand             => { type => 'numeric', default => '0', precision => 5, scale => 25 },
37 
  onhand             => { type => 'numeric', default => '0', precision => 25, scale => 5 },
38 38 
  partnumber         => { type => 'text', not_null => 1 },
39 39 
  partsgroup_id      => { type => 'integer' },
40 40 
  payment_id         => { type => 'integer' },
41 41 
  price_factor_id    => { type => 'integer' },
42 42 
  priceupdate        => { type => 'date', default => 'now' },
43 
  rop                => { type => 'float', precision => 4 },
44 
  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
43 
  rop                => { type => 'float', scale => 4 },
44 
  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
45 45 
  shop               => { type => 'boolean', default => 'false' },
46 46 
  stockable          => { type => 'boolean', default => 'false' },
47 47 
  unit               => { type => 'varchar', length => 20, not_null => 1 },
48 48 
  ve                 => { type => 'integer' },
49 49 
  warehouse_id       => { type => 'integer' },
50 
  weight             => { type => 'float', precision => 4 },
50 
  weight             => { type => 'float', scale => 4 },
51 51 
);
52 52 

  		




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


  		












Auch abrufbar als:  Unified diff