Kleinere DB-Details (Fremdschlüssel und verwaiste Tabelle)

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

diff --git a/SL/DB/MetaSetup/Contact.pm b/SL/DB/MetaSetup/Contact.pm
index 4287a561de4b73f128dad1331f6e75d17b811471..8a749bb3c6b4d075eeb70bb2d736327b66afa663 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(
 __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_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_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_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_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_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_street      => { type => 'text' },

+  cp_title       => { type => 'varchar', length => 75 },

   cp_zipcode     => { type => 'text' },
   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->primary_key_columns([ 'cp_id' ]);
 
 __PACKAGE__->meta->allow_inline_column_values(1);
 

-# __PACKAGE__->meta->initialize;
-

 1;
 ;
 1;
 ;