X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FVendor.pm;h=cb36289d9acb41106a4b024c253111172f9055f2;hb=d0c938cfb5fbb8c1c03b94d395d6c7839a1c597e;hp=6d858e59f8fc73a7f2cf0a0af0cdbcf812181b70;hpb=82515b2d93dc5632f24d6e0b6f8f05f3fd19fbb0;p=kivitendo-erp.git

diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm
index 6d858e59f..cb36289d9 100644
--- a/SL/DB/MetaSetup/Vendor.pm
+++ b/SL/DB/MetaSetup/Vendor.pm
@@ -19,7 +19,7 @@ __PACKAGE__->meta->setup(
     city           => { type => 'varchar', length => 75 },
     country        => { type => 'varchar', length => 75 },
     contact        => { type => 'varchar', length => 75 },
-    phone          => { type => 'varchar', length => 30 },
+    phone          => { type => 'text' },
     fax            => { type => 'varchar', length => 30 },
     homepage       => { type => 'text' },
     email          => { type => 'text' },
@@ -29,7 +29,6 @@ __PACKAGE__->meta->setup(
     vendornumber   => { type => 'text' },
     cc             => { type => 'text' },
     bcc            => { type => 'text' },
-    gifi_accno     => { type => 'text' },
     business_id    => { type => 'integer' },
     taxnumber      => { type => 'text' },
     discount       => { type => 'float', precision => 4 },
@@ -38,7 +37,6 @@ __PACKAGE__->meta->setup(
     bank_code      => { type => 'varchar', length => 10 },
     bank           => { type => 'text' },
     language       => { type => 'varchar', length => 5 },
-    datevexport    => { type => 'integer' },
     itime          => { type => 'timestamp', default => 'now()' },
     mtime          => { type => 'timestamp' },
     obsolete       => { type => 'boolean', default => 'false' },
@@ -51,14 +49,30 @@ __PACKAGE__->meta->setup(
     taxzone_id     => { type => 'integer', default => '0', not_null => 1 },
     greeting       => { type => 'text' },
     ustid          => { type => 'varchar', length => 14 },
-    direct_debit   => { type => 'boolean', default => 'false' },
     iban           => { type => 'varchar', length => 100 },
     bic            => { type => 'varchar', length => 100 },
+    direct_debit   => { type => 'boolean', default => 'false' },
+    currency_id    => { type => 'integer', not_null => 1 },
   ],
 
   primary_key_columns => [ 'id' ],
 
-  allow_inline_column_values => 1,
+  foreign_keys => [
+    business => {
+      class       => 'SL::DB::Business',
+      key_columns => { business_id => 'id' },
+    },
+
+    language_obj => {
+      class       => 'SL::DB::Language',
+      key_columns => { language_id => 'id' },
+    },
+
+    payment => {
+      class       => 'SL::DB::PaymentTerm',
+      key_columns => { payment_id => 'id' },
+    },
+  ],
 );
 
 1;