ungenutzte Spalte "ranking" aus Tabelle "payment_terms" entfernt

Überbleibsel aus uraltem Zahlungsbedingungsfeature

diff --git a/SL/DB/MetaSetup/PaymentTerm.pm b/SL/DB/MetaSetup/PaymentTerm.pm
index eb7647113be905b559638ca33cc6618cc7bf0c36..6ba8c00de0a86dffab7331882947de28e708e163 100644 (file)
--- 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 78a12927066c5c60a90e44b991375aaf951e4fdd..27c319cad15486c21fae6bbfe5b4191305662d71 100644 (file)
--- 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 (file)
index 0000000..736c939
--- /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;