From 5bfe4005e836dc3a91a590c9846fdb1b26a22426 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Tue, 23 Nov 2021 16:35:50 +0100 Subject: [PATCH] =?utf8?q?Neues=20Feld=20=C3=9Cbernahme=20Beschreibung/Lan?= =?utf8?q?gtext=20aus=20Stammdaten?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/Shop.pm | 43 +++++++++++++++++++------------------ sql/Pg-upgrade2/shops_5.sql | 6 ++++++ 2 files changed, 28 insertions(+), 21 deletions(-) create mode 100644 sql/Pg-upgrade2/shops_5.sql diff --git a/SL/DB/MetaSetup/Shop.pm b/SL/DB/MetaSetup/Shop.pm index 1110fd07a..690afc585 100644 --- 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 index 000000000..72b435583 --- /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; -- 2.20.1