projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
booking roundings to new standard-accounts
[kivitendo-erp.git]
/
SL
/
DB
/
MetaSetup
/
Contact.pm
diff --git
a/SL/DB/MetaSetup/Contact.pm
b/SL/DB/MetaSetup/Contact.pm
index
4287a56
..
8d71fcc
100644
(file)
--- a/
SL/DB/MetaSetup/Contact.pm
+++ b/
SL/DB/MetaSetup/Contact.pm
@@
-4,43
+4,41
@@
package SL::DB::Contact;
use strict;
use strict;
-use
base
qw(SL::DB::Object);
+use
parent
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 => 'text' },
+ 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_p
roject
=> { type => 'text' },
- cp_p
rivatphone
=> { type => 'text' },
+ cp_
name
=> { type => 'text' },
+ cp_
phone1
=> { type => 'text' },
+ cp_p
hone2
=> { type => 'text' },
+ cp_p
osition
=> { type => 'text' },
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 => 'text' },
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;
;