nicht benutzte Spalte parts.alternate entfernen

diff --git a/SL/Controller/CsvImport/Part.pm b/SL/Controller/CsvImport/Part.pm
index 98ee01d74fdbd2db3d27b3f0d037695912905255..ad098964f8c367d153adb7a290d9d63691cbe626 100644 (file)
--- 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 2008fef80f034209d794d86f457174b08fe9a10e..392249d835b5ce000028402f0646cd6ad41ea91c 100644 (file)
--- 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 81b3cce94e6f1756310b4761efb02365a4978fda..09b9bdbca9f0ef3f28fdd003a227a19c878a3cf3 100644 (file)
--- 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 (file)
index 0000000..8feadb2
--- /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 48b0ab185b43861109770575fb7986b44b733e90..cde2642c3d614ef38b3f895be52ef9cd4d3982a4 100644 (file)
--- 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) %]">