columns => [
id => { type => 'integer', not_null => 1, sequence => 'id' },
- name => { type => 'varchar', length => 75, not_null => 1 },
+ name => { type => 'text', not_null => 1 },
department_1 => { type => 'varchar', length => 75 },
department_2 => { type => 'varchar', length => 75 },
street => { type => 'varchar', length => 75 },
zipcode => { type => 'varchar', length => 10 },
city => { type => 'varchar', length => 75 },
country => { type => 'varchar', length => 75 },
- contact => { type => 'varchar', length => 75 },
+ contact => { type => 'text' },
phone => { type => 'varchar', length => 30 },
fax => { type => 'varchar', length => 30 },
homepage => { type => 'text' },
bcc => { type => 'text' },
business_id => { type => 'integer' },
taxnumber => { type => 'text' },
- account_number => { type => 'varchar', length => 15 },
- bank_code => { type => 'varchar', length => 10 },
+ account_number => { type => 'text' },
+ bank_code => { type => 'text' },
bank => { type => 'text' },
language => { type => 'varchar', length => 5 },
datevexport => { type => 'integer' },
payment_id => { type => 'integer' },
taxzone_id => { type => 'integer', default => '0', not_null => 1 },
greeting => { type => 'text' },
- ustid => { type => 'varchar', length => 14 },
- direct_debit => { type => 'boolean', default => 'false' },
+ ustid => { type => 'text' },
iban => { type => 'varchar', length => 100 },
bic => { type => 'varchar', length => 100 },
+ direct_debit => { type => 'boolean', default => 'false' },
],
primary_key_columns => [ 'id' ],