MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren

[kivitendo-erp.git] / SL / DB / MetaSetup / Customer.pm

diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index bd54c07..1752d2a 100644 (file)
--- a/SL/DB/MetaSetup/Customer.pm
+++ b/SL/DB/MetaSetup/Customer.pm
@@ -9,51 +9,51 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('customer');
 
 __PACKAGE__->meta->columns(
-  id                  => { type => 'integer', not_null => 1, sequence => 'id' },
-  name                => { type => 'text', not_null => 1 },
-  department_1        => { type => 'varchar', length => 75 },
-  department_2        => { type => 'varchar', length => 75 },
-  street              => { type => 'varchar', length => 75 },
-  zipcode             => { type => 'varchar', length => 10 },
+  account_number      => { type => 'text' },
+  bank                => { type => 'text' },
+  bank_code           => { type => 'text' },
+  bcc                 => { type => 'text' },
+  bic                 => { type => 'varchar', length => 100 },
+  business_id         => { type => 'integer' },
+  c_vendor_id         => { type => 'text' },
+  cc                  => { type => 'text' },
   city                => { type => 'varchar', length => 75 },
-  country             => { type => 'varchar', length => 75 },
   contact             => { type => 'text' },
-  phone               => { type => 'text' },
-  fax                 => { type => 'varchar', length => 30 },
-  homepage            => { type => 'text' },
-  email               => { type => 'text' },
-  notes               => { type => 'text' },
-  discount            => { type => 'float', precision => 4 },
-  taxincluded         => { type => 'boolean' },
+  country             => { type => 'varchar', length => 75 },
   creditlimit         => { type => 'numeric', default => '0', precision => 5, scale => 15 },
-  terms               => { type => 'integer', default => '0' },
+  currency_id         => { type => 'integer', not_null => 1 },
   customernumber      => { type => 'text' },
-  cc                  => { type => 'text' },
-  bcc                 => { type => 'text' },
-  business_id         => { type => 'integer' },
-  taxnumber           => { type => 'text' },
-  account_number      => { type => 'text' },
-  bank_code           => { type => 'text' },
-  bank                => { type => 'text' },
-  language            => { type => 'varchar', length => 5 },
+  department_1        => { type => 'varchar', length => 75 },
+  department_2        => { type => 'varchar', length => 75 },
+  direct_debit        => { type => 'boolean', default => 'false' },
+  discount            => { type => 'float', precision => 4 },
+  email               => { type => 'text' },
+  fax                 => { type => 'varchar', length => 30 },
+  greeting            => { type => 'text' },
+  homepage            => { type => 'text' },
+  iban                => { type => 'varchar', length => 100 },
+  id                  => { type => 'integer', not_null => 1, sequence => 'id' },
   itime               => { type => 'timestamp', default => 'now()' },
-  mtime               => { type => 'timestamp' },
-  obsolete            => { type => 'boolean', default => 'false' },
-  username            => { type => 'varchar', length => 50 },
-  user_password       => { type => 'text' },
-  salesman_id         => { type => 'integer' },
-  c_vendor_id         => { type => 'text' },
   klass               => { type => 'integer', default => '0' },
+  language            => { type => 'varchar', length => 5 },
   language_id         => { type => 'integer' },
+  mtime               => { type => 'timestamp' },
+  name                => { type => 'text', not_null => 1 },
+  notes               => { type => 'text' },
+  obsolete            => { type => 'boolean', default => 'false' },
   payment_id          => { type => 'integer' },
+  phone               => { type => 'text' },
+  salesman_id         => { type => 'integer' },
+  street              => { type => 'varchar', length => 75 },
+  taxincluded         => { type => 'boolean' },
+  taxincluded_checked => { type => 'boolean' },
+  taxnumber           => { type => 'text' },
   taxzone_id          => { type => 'integer', default => '0', not_null => 1 },
-  greeting            => { type => 'text' },
+  terms               => { type => 'integer', default => '0' },
+  user_password       => { type => 'text' },
+  username            => { type => 'varchar', length => 50 },
   ustid               => { type => 'text' },
-  direct_debit        => { type => 'boolean', default => 'false' },
-  iban                => { type => 'varchar', length => 100 },
-  bic                 => { type => 'varchar', length => 100 },
-  taxincluded_checked => { type => 'boolean' },
-  currency_id         => { type => 'integer', not_null => 1 },
+  zipcode             => { type => 'varchar', length => 10 },
 );
 
 __PACKAGE__->meta->primary_key_columns([ 'id' ]);
@@ -82,7 +82,5 @@ __PACKAGE__->meta->foreign_keys(
   },
 );
 
-# __PACKAGE__->meta->initialize;
-
 1;
 ;