Neues Feld Übernahme Beschreibung/Langtext aus Stammdaten

diff --git a/SL/DB/MetaSetup/Shop.pm b/SL/DB/MetaSetup/Shop.pm
index 1110fd0..690afc5 100644 (file)
--- a/SL/DB/MetaSetup/Shop.pm
+++ b/SL/DB/MetaSetup/Shop.pm
@@ -9,27 +9,28 @@ use parent qw(SL::DB::Object);
 __PACKAGE__->meta->table('shops');
 
 __PACKAGE__->meta->columns(
-  connector               => { type => 'text' },
-  description             => { type => 'text' },
-  id                      => { type => 'serial', not_null => 1 },
-  itime                   => { type => 'timestamp', default => 'now()' },
-  last_order_number       => { type => 'integer' },
-  login                   => { type => 'text' },
-  mtime                   => { type => 'timestamp', default => 'now()' },
-  obsolete                => { type => 'boolean', default => 'false', not_null => 1 },
-  orders_to_fetch         => { type => 'integer' },
-  password                => { type => 'text' },
-  path                    => { type => 'text', default => '/', not_null => 1 },
-  port                    => { type => 'integer' },
-  price_source            => { type => 'text' },
-  pricetype               => { type => 'text' },
-  protocol                => { type => 'text', default => 'http', not_null => 1 },
-  realm                   => { type => 'text' },
-  server                  => { type => 'text' },
-  shipping_costs_parts_id => { type => 'integer' },
-  sortkey                 => { type => 'integer' },
-  taxzone_id              => { type => 'integer' },
-  transaction_description => { type => 'text' },
+  connector                => { type => 'text' },
+  description              => { type => 'text' },
+  id                       => { type => 'serial', not_null => 1 },
+  itime                    => { type => 'timestamp', default => 'now()' },
+  last_order_number        => { type => 'integer' },
+  login                    => { type => 'text' },
+  mtime                    => { type => 'timestamp', default => 'now()' },
+  obsolete                 => { type => 'boolean', default => 'false', not_null => 1 },
+  orders_to_fetch          => { type => 'integer' },
+  password                 => { type => 'text' },
+  path                     => { type => 'text', default => '/', not_null => 1 },
+  port                     => { type => 'integer' },
+  price_source             => { type => 'text' },
+  pricetype                => { type => 'text' },
+  protocol                 => { type => 'text', default => 'http', not_null => 1 },
+  realm                    => { type => 'text' },
+  server                   => { type => 'text' },
+  shipping_costs_parts_id  => { type => 'integer' },
+  sortkey                  => { type => 'integer' },
+  taxzone_id               => { type => 'integer' },
+  transaction_description  => { type => 'text' },
+  use_part_longdescription => { type => 'boolean', default => 'false' },
 );
 
 __PACKAGE__->meta->primary_key_columns([ 'id' ]);

diff --git a/sql/Pg-upgrade2/shops_5.sql b/sql/Pg-upgrade2/shops_5.sql
new file mode 100644 (file)
index 0000000..72b4355
--- /dev/null
+++ b/sql/Pg-upgrade2/shops_5.sql
@@ -0,0 +1,6 @@
+-- @tag: shops_5
+-- @description: Shop-Config um Option zur direkten Beschreibungsübernahme erweitern
+-- @depends: shop_4
+-- @ignore: 0
+
+ALTER TABLE shops ADD COLUMN use_part_longdescription BOOLEAN default false;