From bbb91c0852fc27fadf8770e8f46e518156383810 Mon Sep 17 00:00:00 2001 From: "G. Richardson" Date: Wed, 6 Feb 2019 14:55:54 +0100 Subject: [PATCH] ungenutzte Spalte "ranking" aus Tabelle "payment_terms" entfernt MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Überbleibsel aus uraltem Zahlungsbedingungsfeature --- SL/DB/MetaSetup/PaymentTerm.pm | 1 - doc/changelog | 2 ++ sql/Pg-upgrade2/drop_payment_terms_ranking.sql | 5 +++++ 3 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 sql/Pg-upgrade2/drop_payment_terms_ranking.sql diff --git a/SL/DB/MetaSetup/PaymentTerm.pm b/SL/DB/MetaSetup/PaymentTerm.pm index eb7647113..6ba8c00de 100644 --- a/SL/DB/MetaSetup/PaymentTerm.pm +++ b/SL/DB/MetaSetup/PaymentTerm.pm @@ -18,7 +18,6 @@ __PACKAGE__->meta->columns( mtime => { type => 'timestamp' }, obsolete => { type => 'boolean', default => 'false' }, percent_skonto => { type => 'float', scale => 4 }, - ranking => { type => 'integer' }, sortkey => { type => 'integer', not_null => 1 }, terms_netto => { type => 'integer' }, terms_skonto => { type => 'integer' }, diff --git a/doc/changelog b/doc/changelog index 78a129270..27c319cad 100644 --- a/doc/changelog +++ b/doc/changelog @@ -45,6 +45,8 @@ Kleinere neue Features und Detailverbesserungen: - Dialogbuchungen aus Kontoauszugs-Import erstellen, der Verwendungszweck wird in die Beschreibung übernommen +- ungenutzte Spalte "ranking" aus Tabelle "payment_terms" entfernt + 2019-01-03 - Release 3.5.3 Mittelgroße neue Features: diff --git a/sql/Pg-upgrade2/drop_payment_terms_ranking.sql b/sql/Pg-upgrade2/drop_payment_terms_ranking.sql new file mode 100644 index 000000000..736c93924 --- /dev/null +++ b/sql/Pg-upgrade2/drop_payment_terms_ranking.sql @@ -0,0 +1,5 @@ +-- @tag: drop_payment_terms_ranking +-- @description: Entfernt Spalte ranking in payment_terms +-- @depends: release_3_5_3 + +ALTER TABLE payment_terms DROP COLUMN ranking; -- 2.20.1