From 574855561514a864f554776c421e7037196e714d Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Mon, 23 Jun 2014 13:55:49 +0200 Subject: [PATCH] =?utf8?q?DB-Schema-Anpassungen=20f=C3=BCr=20=C2=BBSpalten?= =?utf8?q?typ=20Text=20anstelle=20von=20varchar()=20in=20diversen=20Tabell?= =?utf8?q?en=C2=AB?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/Contact.pm | 12 ++++++------ SL/DB/MetaSetup/Customer.pm | 22 +++++++++++----------- SL/DB/MetaSetup/Vendor.pm | 22 +++++++++++----------- 3 files changed, 28 insertions(+), 28 deletions(-) diff --git a/SL/DB/MetaSetup/Contact.pm b/SL/DB/MetaSetup/Contact.pm index 8a749bb3c..7f8217519 100644 --- a/SL/DB/MetaSetup/Contact.pm +++ b/SL/DB/MetaSetup/Contact.pm @@ -16,21 +16,21 @@ __PACKAGE__->meta->columns( cp_email => { type => 'text' }, cp_fax => { type => 'text' }, cp_gender => { type => 'character', length => 1 }, - cp_givenname => { type => 'varchar', length => 75 }, + cp_givenname => { type => 'text' }, cp_id => { type => 'integer', not_null => 1, sequence => 'id' }, cp_mobile1 => { type => 'text' }, cp_mobile2 => { type => 'text' }, - cp_name => { type => 'varchar', length => 75 }, - cp_phone1 => { type => 'varchar', length => 75 }, - cp_phone2 => { type => 'varchar', length => 75 }, - cp_position => { type => 'varchar', length => 75 }, + 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 => 'varchar', length => 75 }, + cp_title => { type => 'text' }, cp_zipcode => { type => 'text' }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm index ea5e3281b..b80211917 100644 --- a/SL/DB/MetaSetup/Customer.pm +++ b/SL/DB/MetaSetup/Customer.pm @@ -13,32 +13,32 @@ __PACKAGE__->meta->columns( bank => { type => 'text' }, bank_code => { type => 'text' }, bcc => { type => 'text' }, - bic => { type => 'varchar', length => 100 }, + bic => { type => 'text' }, business_id => { type => 'integer' }, c_vendor_id => { type => 'text' }, cc => { type => 'text' }, - city => { type => 'varchar', length => 75 }, + city => { type => 'text' }, contact => { type => 'text' }, - country => { type => 'varchar', length => 75 }, + country => { type => 'text' }, creditlimit => { type => 'numeric', default => '0', precision => 15, scale => 5 }, currency_id => { type => 'integer', not_null => 1 }, customernumber => { type => 'text' }, delivery_term_id => { type => 'integer' }, - department_1 => { type => 'varchar', length => 75 }, - department_2 => { type => 'varchar', length => 75 }, + department_1 => { type => 'text' }, + department_2 => { type => 'text' }, depositor => { type => 'text' }, direct_debit => { type => 'boolean', default => 'false' }, discount => { type => 'float', scale => 4 }, email => { type => 'text' }, - fax => { type => 'varchar', length => 30 }, + fax => { type => 'text' }, greeting => { type => 'text' }, homepage => { type => 'text' }, hourly_rate => { type => 'numeric', precision => 8, scale => 2 }, - iban => { type => 'varchar', length => 100 }, + iban => { type => 'text' }, id => { type => 'integer', not_null => 1, sequence => 'id' }, itime => { type => 'timestamp', default => 'now()' }, klass => { type => 'integer', default => '0' }, - language => { type => 'varchar', length => 5 }, + language => { type => 'text' }, language_id => { type => 'integer' }, mandate_date_of_signature => { type => 'date' }, mandator_id => { type => 'text' }, @@ -49,16 +49,16 @@ __PACKAGE__->meta->columns( payment_id => { type => 'integer' }, phone => { type => 'text' }, salesman_id => { type => 'integer' }, - street => { type => 'varchar', length => 75 }, + street => { type => 'text' }, taxincluded => { type => 'boolean' }, taxincluded_checked => { type => 'boolean' }, taxnumber => { type => 'text' }, taxzone_id => { type => 'integer', default => '0', not_null => 1 }, terms => { type => 'integer', default => '0' }, user_password => { type => 'text' }, - username => { type => 'varchar', length => 50 }, + username => { type => 'text' }, ustid => { type => 'text' }, - zipcode => { type => 'varchar', length => 10 }, + zipcode => { type => 'text' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm index ef3f37f48..9a113fa7e 100644 --- a/SL/DB/MetaSetup/Vendor.pm +++ b/SL/DB/MetaSetup/Vendor.pm @@ -13,25 +13,25 @@ __PACKAGE__->meta->columns( bank => { type => 'text' }, bank_code => { type => 'text' }, bcc => { type => 'text' }, - bic => { type => 'varchar', length => 100 }, + bic => { type => 'text' }, business_id => { type => 'integer' }, cc => { type => 'text' }, - city => { type => 'varchar', length => 75 }, + city => { type => 'text' }, contact => { type => 'text' }, - country => { type => 'varchar', length => 75 }, + country => { type => 'text' }, creditlimit => { type => 'numeric', precision => 15, scale => 5 }, currency_id => { type => 'integer', not_null => 1 }, delivery_term_id => { type => 'integer' }, - department_1 => { type => 'varchar', length => 75 }, - department_2 => { type => 'varchar', length => 75 }, + department_1 => { type => 'text' }, + department_2 => { type => 'text' }, depositor => { type => 'text' }, direct_debit => { type => 'boolean', default => 'false' }, discount => { type => 'float', scale => 4 }, email => { type => 'text' }, - fax => { type => 'varchar', length => 30 }, + fax => { type => 'text' }, greeting => { type => 'text' }, homepage => { type => 'text' }, - iban => { type => 'varchar', length => 100 }, + iban => { type => 'text' }, id => { type => 'integer', not_null => 1, sequence => 'id' }, itime => { type => 'timestamp', default => 'now()' }, language => { type => 'varchar', length => 5 }, @@ -43,17 +43,17 @@ __PACKAGE__->meta->columns( payment_id => { type => 'integer' }, phone => { type => 'text' }, salesman_id => { type => 'integer' }, - street => { type => 'varchar', length => 75 }, + street => { type => 'text' }, taxincluded => { type => 'boolean' }, taxnumber => { type => 'text' }, taxzone_id => { type => 'integer', default => '0', not_null => 1 }, terms => { type => 'integer', default => '0' }, - user_password => { type => 'varchar', length => 12 }, - username => { type => 'varchar', length => 50 }, + user_password => { type => 'text' }, + username => { type => 'text' }, ustid => { type => 'text' }, v_customer_id => { type => 'text' }, vendornumber => { type => 'text' }, - zipcode => { type => 'varchar', length => 10 }, + zipcode => { type => 'text' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); -- 2.20.1