Revision e225f710
Von Kivitendo Admin vor mehr als 7 Jahren hinzugefügt
| SL/DB/MetaSetup/Part.pm | ||
|---|---|---|
| 15 | 15 |
description => { type => 'text' },
|
| 16 | 16 |
drawing => { type => 'text' },
|
| 17 | 17 |
ean => { type => 'text' },
|
| 18 |
expense_accno_id => { type => 'integer' },
|
|
| 19 | 18 |
formel => { type => 'text' },
|
| 20 | 19 |
gv => { type => 'numeric', precision => 15, scale => 5 },
|
| 21 | 20 |
has_sernumber => { type => 'boolean', default => 'false' },
|
| 22 | 21 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
| 23 | 22 |
image => { type => 'text' },
|
| 24 |
income_accno_id => { type => 'integer' },
|
|
| 25 |
inventory_accno_id => { type => 'integer' },
|
|
| 26 | 23 |
itime => { type => 'timestamp', default => 'now()' },
|
| 27 | 24 |
lastcost => { type => 'numeric', precision => 15, scale => 5 },
|
| 28 | 25 |
listprice => { type => 'numeric', precision => 15, scale => 5 },
|
| ... | ... | |
| 66 | 63 |
key_columns => { buchungsgruppen_id => 'id' },
|
| 67 | 64 |
}, |
| 68 | 65 |
|
| 69 |
expense_account => {
|
|
| 70 |
class => 'SL::DB::Chart', |
|
| 71 |
key_columns => { expense_accno_id => 'id' },
|
|
| 72 |
}, |
|
| 73 |
|
|
| 74 |
income_account => {
|
|
| 75 |
class => 'SL::DB::Chart', |
|
| 76 |
key_columns => { income_accno_id => 'id' },
|
|
| 77 |
}, |
|
| 78 |
|
|
| 79 |
inventory_account => {
|
|
| 80 |
class => 'SL::DB::Chart', |
|
| 81 |
key_columns => { inventory_accno_id => 'id' },
|
|
| 82 |
}, |
|
| 83 |
|
|
| 84 | 66 |
partsgroup => {
|
| 85 | 67 |
class => 'SL::DB::PartsGroup', |
| 86 | 68 |
key_columns => { partsgroup_id => 'id' },
|
| doc/UPGRADE | ||
|---|---|---|
| 28 | 28 |
neue Spalte part_type vom ENUM-Typ, der auf die Werte 'part', 'service', |
| 29 | 29 |
'assembly' und 'assortment' beschränkt ist. |
| 30 | 30 |
|
| 31 |
* In der Tabelle parts wurde die Spalten inventory_accno_id, expense_accno_id |
|
| 32 |
und income_accno_id entfernt. Deren Funktionalität wurde schon lange durch |
|
| 33 |
Buchungsgruppen ersetzt und für die Erkennung des Artikeltyps gibt es nun die |
|
| 34 |
Spalte part_type |
|
| 35 |
|
|
| 31 | 36 |
Upgrade auf v3.4.1 |
| 32 | 37 |
================== |
| 33 | 38 |
|
| sql/Pg-upgrade2/parts_remove_unneeded_fields.sql | ||
|---|---|---|
| 1 |
-- @tag: part_remove_unneeded_fields |
|
| 2 |
-- @description: Removing colums assembly, inventory_accno_id, expense_accno_id, income_accno_id |
|
| 3 |
-- @depends: part_type_enum |
|
| 4 |
|
|
| 5 |
ALTER TABLE parts DROP COLUMN assembly; |
|
| 6 |
ALTER TABLE parts DROP COLUMN inventory_accno_id; |
|
| 7 |
ALTER TABLE parts DROP COLUMN expense_accno_id; |
|
| 8 |
ALTER TABLE parts DROP COLUMN income_accno_id; |
|
| 9 |
-- keep for now: |
|
| 10 |
-- ALTER TABLE parts DROP COLUMN makemodel; |
|
Auch abrufbar als: Unified diff
Part: columns assembly und (inventory|expense|income)_accno_id entfernt