Merge branch 'master' of github.com:kivitendo/kivitendo-erp

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

diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm
index 9365eac9dcf8638847ab6fcb32b89dd2d5c30fe3..6c1e5ecfbc8d32e4fd6e318581adc8929d2e8163 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' },


@@ -36,9 +35,6 @@ __PACKAGE__->meta->setup(
     mtime                               => { type => 'timestamp' },
     rmanumber                           => { type => 'text' },
     cnnumber                            => { type => 'text' },
     mtime                               => { type => 'timestamp' },
     rmanumber                           => { type => 'text' },
     cnnumber                            => { type => 'text' },

-    accounting_method                   => { type => 'text' },
-    inventory_system                    => { type => 'text' },
-    profit_determination                => { type => 'text' },

     dunning_ar_amount_fee               => { type => 'integer' },
     dunning_ar_amount_interest          => { type => 'integer' },
     dunning_ar                          => { type => 'integer' },
     dunning_ar_amount_fee               => { type => 'integer' },
     dunning_ar_amount_interest          => { type => 'integer' },
     dunning_ar                          => { type => 'integer' },


@@ -47,31 +43,55 @@ __PACKAGE__->meta->setup(
     ar_paid_accno_id                    => { type => 'integer' },
     id                                  => { type => 'serial', not_null => 1 },
     language_id                         => { type => 'integer' },
     ar_paid_accno_id                    => { type => 'integer' },
     id                                  => { type => 'serial', not_null => 1 },
     language_id                         => { type => 'integer' },

-    payments_changeable                 => { type => 'integer', default => '0', not_null => 1 },
-    show_bestbefore                     => { type => 'boolean', default => 'false' },
+    accounting_method                   => { type => 'text' },
+    inventory_system                    => { type => 'text' },
+    profit_determination                => { type => 'text' },

     datev_check_on_sales_invoice        => { type => 'boolean', default => 'true' },
     datev_check_on_purchase_invoice     => { type => 'boolean', default => 'true' },
     datev_check_on_ar_transaction       => { type => 'boolean', default => 'true' },
     datev_check_on_ap_transaction       => { type => 'boolean', default => 'true' },
     datev_check_on_gl_transaction       => { type => 'boolean', default => 'true' },
     datev_check_on_sales_invoice        => { type => 'boolean', default => 'true' },
     datev_check_on_purchase_invoice     => { type => 'boolean', default => 'true' },
     datev_check_on_ar_transaction       => { type => 'boolean', default => 'true' },
     datev_check_on_ap_transaction       => { type => 'boolean', default => 'true' },
     datev_check_on_gl_transaction       => { type => 'boolean', default => 'true' },

+    payments_changeable                 => { type => 'integer', default => '0', not_null => 1 },

     is_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     ir_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     ar_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     ap_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     gl_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     is_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     ir_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     ar_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     ap_changeable                       => { type => 'integer', default => 2, not_null => 1 },
     gl_changeable                       => { type => 'integer', default => 2, not_null => 1 },

-    is_show_mark_as_paid                => { type => 'boolean', default => 'true' },
-    ir_show_mark_as_paid                => { type => 'boolean', default => 'true' },
-    ar_show_mark_as_paid                => { type => 'boolean', default => 'true' },
-    ap_show_mark_as_paid                => { type => 'boolean', default => 'true' },
+    show_bestbefore                     => { type => 'boolean', default => 'false' },

     sales_order_show_delete             => { type => 'boolean', default => 'true' },
     purchase_order_show_delete          => { type => 'boolean', default => 'true' },
     sales_delivery_order_show_delete    => { type => 'boolean', default => 'true' },
     purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' },
     sales_order_show_delete             => { type => 'boolean', default => 'true' },
     purchase_order_show_delete          => { type => 'boolean', default => 'true' },
     sales_delivery_order_show_delete    => { type => 'boolean', default => 'true' },
     purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' },

+    is_show_mark_as_paid                => { type => 'boolean', default => 'true' },
+    ir_show_mark_as_paid                => { type => 'boolean', default => 'true' },
+    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 },
+    show_weight                         => { type => 'boolean', default => 'false', not_null => 1 },

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

+
+  foreign_keys => [
+    bin => {
+      class       => 'SL::DB::Bin',
+      key_columns => { bin_id => 'id' },
+    },
+
+    warehouse => {
+      class       => 'SL::DB::Warehouse',
+      key_columns => { warehouse_id => 'id' },
+    },
+    currency => {
+      class       => 'SL::DB::Currency',
+      key_columns => { currency_id => 'id' },
+    },
+  ],

 );
 
 1;
 );
 
 1;