From 56803dc2cb26945f73ddaf03400c6308d5053297 Mon Sep 17 00:00:00 2001
From: Moritz Bunkus <m.bunkus@linet-services.de>
Date: Thu, 28 Jul 2016 11:55:38 +0200
Subject: [PATCH] nicht benutzte Spalte parts.alternate entfernen

---
 SL/Controller/CsvImport/Part.pm                 | 2 +-
 SL/DB/MetaSetup/Part.pm                         | 1 -
 SL/IC.pm                                        | 1 -
 sql/Pg-upgrade2/remove_alternate_from_parts.sql | 4 ++++
 templates/webpages/ic/form_header.html          | 1 -
 5 files changed, 5 insertions(+), 4 deletions(-)
 create mode 100644 sql/Pg-upgrade2/remove_alternate_from_parts.sql

diff --git a/SL/Controller/CsvImport/Part.pm b/SL/Controller/CsvImport/Part.pm
index 98ee01d74..ad098964f 100644
--- a/SL/Controller/CsvImport/Part.pm
+++ b/SL/Controller/CsvImport/Part.pm
@@ -480,7 +480,7 @@ sub init_profile {
   my ($self) = @_;
 
   my $profile = $self->SUPER::init_profile;
-  delete @{$profile}{qw(alternate assembly bom expense_accno_id income_accno_id inventory_accno_id makemodel priceupdate stockable type)};
+  delete @{$profile}{qw(assembly bom expense_accno_id income_accno_id inventory_accno_id makemodel priceupdate stockable type)};
 
   $profile->{"pricegroup_$_"} = '' for 1 .. scalar @{ $_[0]->all_pricegroups };
 
diff --git a/SL/DB/MetaSetup/Part.pm b/SL/DB/MetaSetup/Part.pm
index 2008fef80..392249d83 100644
--- a/SL/DB/MetaSetup/Part.pm
+++ b/SL/DB/MetaSetup/Part.pm
@@ -9,7 +9,6 @@ use parent qw(SL::DB::Object);
 __PACKAGE__->meta->table('parts');
 
 __PACKAGE__->meta->columns(
-  alternate          => { type => 'boolean', default => 'false' },
   assembly           => { type => 'boolean', default => 'false' },
   bin_id             => { type => 'integer' },
   bom                => { type => 'boolean', default => 'false' },
diff --git a/SL/IC.pm b/SL/IC.pm
index 81b3cce94..09b9bdbca 100644
--- a/SL/IC.pm
+++ b/SL/IC.pm
@@ -327,7 +327,6 @@ sub save {
          partnumber = ?,
          description = ?,
          makemodel = ?,
-         alternate = 'f',
          assembly = ?,
          listprice = ?,
          sellprice = ?,
diff --git a/sql/Pg-upgrade2/remove_alternate_from_parts.sql b/sql/Pg-upgrade2/remove_alternate_from_parts.sql
new file mode 100644
index 000000000..8feadb2f9
--- /dev/null
+++ b/sql/Pg-upgrade2/remove_alternate_from_parts.sql
@@ -0,0 +1,4 @@
+-- @tag: remove_alternate_from_parts
+-- @description: Veraltete Spalte »alternate« aus Tabelle »parts« entfernen
+-- @depends: release_3_4_1
+ALTER TABLE parts DROP COLUMN alternate;
diff --git a/templates/webpages/ic/form_header.html b/templates/webpages/ic/form_header.html
index 48b0ab185..cde2642c3 100644
--- a/templates/webpages/ic/form_header.html
+++ b/templates/webpages/ic/form_header.html
@@ -12,7 +12,6 @@
   <input name="item" type="hidden" value="[% HTML.escape(item) %]">
   <input name="title" type="hidden" value="[% HTML.escape(title) %]">
   <input name="makemodel" type="hidden" value="[% HTML.escape(makemodel) %]">
-  <input name="alternate" type="hidden" value="[% HTML.escape(alternate) %]">
   <input name="onhand" type="hidden" value="[% HTML.escape(onhand) %]">
   <input name="orphaned" type="hidden" value="[% HTML.escape(orphaned) %]">
   <input name="taxaccounts" type="hidden" value="[% HTML.escape(taxaccounts) %]">
-- 
2.20.1