- columns => [
- cp_id => { type => 'integer', not_null => 1, sequence => 'id' },
- 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_mobile1 => { type => 'text' },
- cp_mobile2 => { type => 'text' },
- cp_satphone => { type => 'text' },
- cp_satfax => { type => 'text' },
- cp_project => { type => 'text' },
- cp_privatphone => { type => 'text' },
- cp_privatemail => { type => 'text' },
- cp_birthday => { type => 'text' },
- cp_abteilung => { type => 'text' },
- cp_gender => { type => 'character', length => 1 },
- ],
+__PACKAGE__->meta->columns(
+ cp_abteilung => { type => 'text' },
+ cp_birthday => { type => 'date' },
+ cp_city => { type => 'text' },
+ cp_cv_id => { type => 'integer' },
+ cp_email => { type => 'text' },
+ 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_name => { type => 'text' },
+ cp_phone1 => { type => 'text' },
+ cp_phone2 => { type => 'text' },
+ cp_position => { type => 'text' },
+ cp_privatemail => { type => 'text' },
+ 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' },
+ itime => { type => 'timestamp', default => 'now()' },
+ mtime => { type => 'timestamp' },
+);