GLN: neue Spalte bei customer, vendor und shipto; DB-Upgrade-Skript u. Rose

diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index 173cb758038f6f6ee9acbd003ad47a3cc6f20e07..aca58747029048a3e88ebd8ba25e0867e77fa51e 100644 (file)
--- 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' },
   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 },
   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 beab032f7ca5b30c064b36196b1d983af23a02d0..57b4971cff84512af38d4c0010145f4a18b62b9c 100644 (file)
--- 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' },
   shiptodepartment_2 => { type => 'text' },
   shiptoemail        => { type => 'text' },
   shiptofax          => { type => 'text' },

+  shiptogln          => { type => 'text' },

   shiptoname         => { type => 'text' },
   shiptophone        => { type => 'text' },
   shiptostreet       => { 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 54e9d07b564278c1c4c84b91e6164b7a775b76f6..e3a1b93d41be5ba7ecb74c9dc09df18543d35b96 100644 (file)
--- 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' },
   discount         => { type => 'float', scale => 4 },
   email            => { type => 'text' },
   fax              => { type => 'text' },

+  gln              => { type => 'text' },

   greeting         => { type => 'text' },
   homepage         => { type => 'text' },
   iban             => { type => 'text' },
   greeting         => { type => 'text' },
   homepage         => { type => 'text' },
   iban             => { type => 'text' },

diff --git a/SL/DB/Shipto.pm b/SL/DB/Shipto.pm
index b8868ab1e15a8af03d1850fd41b551bdbf5ef613..c83fceca9cb96574351cc3329066cfd26df7789c 100644 (file)
--- 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);
 
 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;
                            shiptophone shiptofax shiptoemail shiptodepartment_1 shiptodepartment_2);
 
 __PACKAGE__->meta->initialize;