Revision e225f710
Von Kivitendo Admin vor mehr als 8 Jahren hinzugefügt
| SL/DB/MetaSetup/Part.pm | ||
|---|---|---|
|
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' },
|
||
|
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 },
|
||
| ... | ... | |
|
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' },
|
||
| doc/UPGRADE | ||
|---|---|---|
|
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
|
||
|
==================
|
||
|
|
||
| sql/Pg-upgrade2/parts_remove_unneeded_fields.sql | ||
|---|---|---|
|
-- @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;
|
||
Auch abrufbar als: Unified diff
Part: columns assembly und (inventory|expense|income)_accno_id entfernt