Standardlager und Lagerplatz entsprechende Vorauswahl beim Einkaufslieferschein

[mfinanz.git] / SL / DB / MetaSetup / Default.pm

diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm
index 8063f9ed5fd7e928111fcbb4ccc0b8d96853a0c4..d6b6b8458bbc46744a0c24c363129f0d74a92c1e 100644 (file)
--- a/SL/DB/MetaSetup/Default.pm
+++ b/SL/DB/MetaSetup/Default.pm
@@ -20,7 +20,6 @@ __PACKAGE__->meta->setup(
     weightunit                          => { type => 'varchar', length => 5 },
     businessnumber                      => { type => 'text' },
     version                             => { type => 'varchar', length => 8 },
     weightunit                          => { type => 'varchar', length => 5 },
     businessnumber                      => { type => 'text' },
     version                             => { type => 'varchar', length => 8 },

-    curr                                => { type => 'text' },

     closedto                            => { type => 'date' },
     revtrans                            => { type => 'boolean', default => 'false' },
     ponumber                            => { type => 'text' },
     closedto                            => { type => 'date' },
     revtrans                            => { type => 'boolean', default => 'false' },
     ponumber                            => { type => 'text' },


@@ -70,10 +69,13 @@ __PACKAGE__->meta->setup(
     assemblynumber                      => { type => 'text' },
     warehouse_id                        => { type => 'integer' },
     bin_id                              => { type => 'integer' },
     assemblynumber                      => { type => 'text' },
     warehouse_id                        => { type => 'integer' },
     bin_id                              => { type => 'integer' },

+    currency_id                         => { type => 'integer', not_null => 1 },

   ],
 
   primary_key_columns => [ 'id' ],
 
   ],
 
   primary_key_columns => [ 'id' ],
 

+  allow_inline_column_values => 1,
+

   foreign_keys => [
     bin => {
       class       => 'SL::DB::Bin',
   foreign_keys => [
     bin => {
       class       => 'SL::DB::Bin',


@@ -84,6 +86,10 @@ __PACKAGE__->meta->setup(
       class       => 'SL::DB::Warehouse',
       key_columns => { warehouse_id => 'id' },
     },
       class       => 'SL::DB::Warehouse',
       key_columns => { warehouse_id => 'id' },
     },

+    currency => {
+      class       => 'SL::DB::Currency',
+      key_columns => { currency_id => 'id' },
+    },

   ],
 );
 
   ],
 );