SL::DBUpgrade2::Base neue Funktion db_errstr() für korrekt encodierte Datenbankfehler...

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

diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm
index 7b1df394f4ad588de11040b6dff1f856636d2e6e..cbacbf4ee95e9d79ee1c4de1e520a8f2539fbf39 100644 (file)
--- a/SL/DB/MetaSetup/Default.pm
+++ b/SL/DB/MetaSetup/Default.pm
@@ -67,18 +67,45 @@ __PACKAGE__->meta->setup(
     ar_show_mark_as_paid                => { type => 'boolean', default => 'true' },
     ap_show_mark_as_paid                => { type => 'boolean', default => 'true' },
     assemblynumber                      => { type => 'text' },
     ar_show_mark_as_paid                => { type => 'boolean', default => 'true' },
     ap_show_mark_as_paid                => { type => 'boolean', default => 'true' },
     assemblynumber                      => { type => 'text' },

+    warehouse_id                        => { type => 'integer' },
+    bin_id                              => { type => 'integer' },

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

-  ],
+    show_weight                         => { type => 'boolean', default => 'false', not_null => 1 },
+    transfer_default                        => { type => 'boolean', default => 'true' },
+    transfer_default_use_master_default_bin => { type => 'boolean', default => 'false' },
+    transfer_default_ignore_onhand          => { type => 'boolean', default => 'false' },
+    warehouse_id_ignore_onhand              => { type => 'integer' },
+    bin_id_ignore_onhand                    => { type => 'integer' },
+ ],

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

-

   foreign_keys => [
   foreign_keys => [

+    bin => {
+      class       => 'SL::DB::Bin',
+      key_columns => { bin_id => 'id' },
+    },
+
+    bin_obj => {
+      class       => 'SL::DB::Bin',
+      key_columns => { bin_id_ignore_onhand => 'id' },
+    },
+

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

+
+    warehouse => {
+      class       => 'SL::DB::Warehouse',
+      key_columns => { warehouse_id => 'id' },
+    },
+
+    warehouse_obj => {
+      class       => 'SL::DB::Warehouse',
+      key_columns => { warehouse_id_ignore_onhand => 'id' },
+    },

   ],
 );
 
   ],
 );