MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren

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

diff --git a/SL/DB/MetaSetup/Contact.pm b/SL/DB/MetaSetup/Contact.pm
index 4287a56..8a749bb 100644 (file)
--- a/SL/DB/MetaSetup/Contact.pm
+++ b/SL/DB/MetaSetup/Contact.pm
@@ -9,38 +9,36 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('contacts');
 
 __PACKAGE__->meta->columns(
-  cp_id          => { type => 'integer', not_null => 1, sequence => 'id' },
+  cp_abteilung   => { type => 'text' },
+  cp_birthday    => { type => 'date' },
+  cp_city        => { type => 'text' },
   cp_cv_id       => { type => 'integer' },
-  cp_title       => { type => 'varchar', length => 75 },
-  cp_givenname   => { type => 'varchar', length => 75 },
-  cp_name        => { type => 'varchar', length => 75 },
   cp_email       => { type => 'text' },
-  cp_phone1      => { type => 'varchar', length => 75 },
-  cp_phone2      => { type => 'varchar', length => 75 },
-  itime          => { type => 'timestamp', default => 'now()' },
-  mtime          => { type => 'timestamp' },
   cp_fax         => { type => 'text' },
+  cp_gender      => { type => 'character', length => 1 },
+  cp_givenname   => { type => 'varchar', length => 75 },
+  cp_id          => { type => 'integer', not_null => 1, sequence => 'id' },
   cp_mobile1     => { type => 'text' },
   cp_mobile2     => { type => 'text' },
-  cp_satphone    => { type => 'text' },
-  cp_satfax      => { type => 'text' },
-  cp_project     => { type => 'text' },
-  cp_privatphone => { type => 'text' },
+  cp_name        => { type => 'varchar', length => 75 },
+  cp_phone1      => { type => 'varchar', length => 75 },
+  cp_phone2      => { type => 'varchar', length => 75 },
+  cp_position    => { type => 'varchar', length => 75 },
   cp_privatemail => { type => 'text' },
-  cp_abteilung   => { type => 'text' },
-  cp_gender      => { type => 'character', length => 1 },
+  cp_privatphone => { type => 'text' },
+  cp_project     => { type => 'text' },
+  cp_satfax      => { type => 'text' },
+  cp_satphone    => { type => 'text' },
   cp_street      => { type => 'text' },
+  cp_title       => { type => 'varchar', length => 75 },
   cp_zipcode     => { type => 'text' },
-  cp_city        => { type => 'text' },
-  cp_birthday    => { type => 'date' },
-  cp_position    => { type => 'varchar', length => 75 },
+  itime          => { type => 'timestamp', default => 'now()' },
+  mtime          => { type => 'timestamp' },
 );
 
 __PACKAGE__->meta->primary_key_columns([ 'cp_id' ]);
 
 __PACKAGE__->meta->allow_inline_column_values(1);
 
-# __PACKAGE__->meta->initialize;
-
 1;
 ;