use strict;
-use base qw(SL::DB::Object);
+use parent 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 => 'text' },
+ 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 => 'text' },
+ cp_phone1 => { type => 'text' },
+ cp_phone2 => { type => 'text' },
+ cp_position => { 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_title => { 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->initialize;
-
1;
;