city => { type => 'varchar', length => 75 },
country => { type => 'varchar', length => 75 },
contact => { type => 'varchar', length => 75 },
- phone => { type => 'varchar', length => 30 },
+ phone => { type => 'text' },
fax => { type => 'varchar', length => 30 },
homepage => { type => 'text' },
email => { type => 'text' },
bank_code => { type => 'varchar', length => 10 },
bank => { type => 'text' },
language => { type => 'varchar', length => 5 },
- datevexport => { type => 'integer' },
itime => { type => 'timestamp', default => 'now()' },
mtime => { type => 'timestamp' },
obsolete => { type => 'boolean', default => 'false' },
taxzone_id => { type => 'integer', default => '0', not_null => 1 },
greeting => { type => 'text' },
ustid => { type => 'varchar', length => 14 },
- direct_debit => { type => 'boolean', default => 'false' },
iban => { type => 'varchar', length => 100 },
bic => { type => 'varchar', length => 100 },
+ direct_debit => { type => 'boolean', default => 'false' },
+ curr => { type => 'character', length => 3 },
],
primary_key_columns => [ 'id' ],