From 71ada638068acc8b1481b7392bc0511fa627647e Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Thu, 11 Feb 2016 22:56:03 +0100 Subject: [PATCH] GLN: neue Spalte bei customer, vendor und shipto; DB-Upgrade-Skript u. Rose --- SL/DB/MetaSetup/Customer.pm | 1 + SL/DB/MetaSetup/Shipto.pm | 1 + SL/DB/MetaSetup/Vendor.pm | 1 + SL/DB/Shipto.pm | 2 +- 4 files changed, 4 insertions(+), 1 deletion(-) diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm index 173cb7580..aca587470 100644 --- a/SL/DB/MetaSetup/Customer.pm +++ b/SL/DB/MetaSetup/Customer.pm @@ -31,6 +31,7 @@ __PACKAGE__->meta->columns( discount => { type => 'float', scale => 4 }, email => { type => 'text' }, fax => { type => 'text' }, + gln => { type => 'text' }, greeting => { type => 'text' }, homepage => { type => 'text' }, hourly_rate => { type => 'numeric', precision => 8, scale => 2 }, diff --git a/SL/DB/MetaSetup/Shipto.pm b/SL/DB/MetaSetup/Shipto.pm index beab032f7..57b4971cf 100644 --- a/SL/DB/MetaSetup/Shipto.pm +++ b/SL/DB/MetaSetup/Shipto.pm @@ -21,6 +21,7 @@ __PACKAGE__->meta->columns( shiptodepartment_2 => { type => 'text' }, shiptoemail => { type => 'text' }, shiptofax => { type => 'text' }, + shiptogln => { type => 'text' }, shiptoname => { type => 'text' }, shiptophone => { type => 'text' }, shiptostreet => { type => 'text' }, diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm index 54e9d07b5..e3a1b93d4 100644 --- a/SL/DB/MetaSetup/Vendor.pm +++ b/SL/DB/MetaSetup/Vendor.pm @@ -29,6 +29,7 @@ __PACKAGE__->meta->columns( discount => { type => 'float', scale => 4 }, email => { type => 'text' }, fax => { type => 'text' }, + gln => { type => 'text' }, greeting => { type => 'text' }, homepage => { type => 'text' }, iban => { type => 'text' }, diff --git a/SL/DB/Shipto.pm b/SL/DB/Shipto.pm index b8868ab1e..c83fceca9 100644 --- a/SL/DB/Shipto.pm +++ b/SL/DB/Shipto.pm @@ -6,7 +6,7 @@ use SL::DB::MetaSetup::Shipto; use SL::DB::Manager::Shipto; use Rose::DB::Object::Helpers qw(clone_and_reset clone); -our @SHIPTO_VARIABLES = qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact +our @SHIPTO_VARIABLES = qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptogln shiptocontact shiptophone shiptofax shiptoemail shiptodepartment_1 shiptodepartment_2); __PACKAGE__->meta->initialize; -- 2.20.1