Part: columns assembly und (inventory|expense|income)_accno_id entfernt

diff --git a/SL/DB/MetaSetup/Part.pm b/SL/DB/MetaSetup/Part.pm
index 7e9eedcfa6ae344833c7308916703420ccd22eba..65cd85da24e15a03d3b6862d0c01808a78eb4063 100644 (file)
--- a/SL/DB/MetaSetup/Part.pm
+++ b/SL/DB/MetaSetup/Part.pm
@@ -15,14 +15,11 @@ __PACKAGE__->meta->columns(
   description        => { type => 'text' },
   drawing            => { type => 'text' },
   ean                => { type => 'text' },
   description        => { type => 'text' },
   drawing            => { type => 'text' },
   ean                => { type => 'text' },

-  expense_accno_id   => { type => 'integer' },

   formel             => { type => 'text' },
   gv                 => { type => 'numeric', precision => 15, scale => 5 },
   has_sernumber      => { type => 'boolean', default => 'false' },
   id                 => { type => 'integer', not_null => 1, sequence => 'id' },
   image              => { type => 'text' },
   formel             => { type => 'text' },
   gv                 => { type => 'numeric', precision => 15, scale => 5 },
   has_sernumber      => { type => 'boolean', default => 'false' },
   id                 => { type => 'integer', not_null => 1, sequence => 'id' },
   image              => { type => 'text' },

-  income_accno_id    => { type => 'integer' },
-  inventory_accno_id => { type => 'integer' },

   itime              => { type => 'timestamp', default => 'now()' },
   lastcost           => { type => 'numeric', precision => 15, scale => 5 },
   listprice          => { type => 'numeric', precision => 15, scale => 5 },
   itime              => { type => 'timestamp', default => 'now()' },
   lastcost           => { type => 'numeric', precision => 15, scale => 5 },
   listprice          => { type => 'numeric', precision => 15, scale => 5 },


@@ -66,21 +63,6 @@ __PACKAGE__->meta->foreign_keys(
     key_columns => { buchungsgruppen_id => 'id' },
   },
 
     key_columns => { buchungsgruppen_id => 'id' },
   },
 

-  expense_account => {
-    class       => 'SL::DB::Chart',
-    key_columns => { expense_accno_id => 'id' },
-  },
-
-  income_account => {
-    class       => 'SL::DB::Chart',
-    key_columns => { income_accno_id => 'id' },
-  },
-
-  inventory_account => {
-    class       => 'SL::DB::Chart',
-    key_columns => { inventory_accno_id => 'id' },
-  },
-

   partsgroup => {
     class       => 'SL::DB::PartsGroup',
     key_columns => { partsgroup_id => 'id' },
   partsgroup => {
     class       => 'SL::DB::PartsGroup',
     key_columns => { partsgroup_id => 'id' },

diff --git a/doc/UPGRADE b/doc/UPGRADE
index 2b7b3b7d78b78b27717e2ed6403997f49177b1ac..b92165ded42eb54425359ea199dc47cdeeae0541 100644 (file)
--- a/doc/UPGRADE
+++ b/doc/UPGRADE
@@ -28,6 +28,11 @@ Upgrade auf v3.4.x Unstable
   neue Spalte part_type vom ENUM-Typ, der auf die Werte 'part', 'service',
   'assembly' und 'assortment' beschränkt ist.
 
   neue Spalte part_type vom ENUM-Typ, der auf die Werte 'part', 'service',
   'assembly' und 'assortment' beschränkt ist.
 

+* In der Tabelle parts wurde die Spalten inventory_accno_id, expense_accno_id
+  und income_accno_id entfernt. Deren Funktionalität wurde schon lange durch
+  Buchungsgruppen ersetzt und für die Erkennung des Artikeltyps gibt es nun die
+  Spalte part_type
+

 Upgrade auf v3.4.1
 ==================
 
 Upgrade auf v3.4.1
 ==================
 

diff --git a/sql/Pg-upgrade2/parts_remove_unneeded_fields.sql b/sql/Pg-upgrade2/parts_remove_unneeded_fields.sql
new file mode 100644 (file)
index 0000000..fa3a672
--- /dev/null
+++ b/sql/Pg-upgrade2/parts_remove_unneeded_fields.sql
@@ -0,0 +1,10 @@
+-- @tag: part_remove_unneeded_fields
+-- @description: Removing colums assembly, inventory_accno_id, expense_accno_id, income_accno_id
+-- @depends: part_type_enum
+
+ALTER TABLE parts DROP COLUMN assembly;
+ALTER TABLE parts DROP COLUMN inventory_accno_id;
+ALTER TABLE parts DROP COLUMN expense_accno_id;
+ALTER TABLE parts DROP COLUMN income_accno_id;
+-- keep for now:
+-- ALTER TABLE parts DROP COLUMN makemodel;