Revision d7077fec
Von Kivitendo Admin vor 27 Tagen hinzugefügt
SL/DB/MetaSetup/PartsGroup.pm | ||
---|---|---|
9 | 9 |
__PACKAGE__->meta->table('partsgroup'); |
10 | 10 |
|
11 | 11 |
__PACKAGE__->meta->columns( |
12 |
id => { type => 'integer', not_null => 1, sequence => 'id' }, |
|
13 |
itime => { type => 'timestamp', default => 'now()' }, |
|
14 |
mtime => { type => 'timestamp' }, |
|
15 |
obsolete => { type => 'boolean', default => 'false' }, |
|
16 |
partsgroup => { type => 'text' }, |
|
17 |
sortkey => { type => 'integer', not_null => 1 }, |
|
12 |
description => { type => 'text' }, |
|
13 |
id => { type => 'integer', not_null => 1, sequence => 'id' }, |
|
14 |
itime => { type => 'timestamp', default => 'now()' }, |
|
15 |
mtime => { type => 'timestamp' }, |
|
16 |
obsolete => { type => 'boolean', default => 'false' }, |
|
17 |
partsgroup => { type => 'text' }, |
|
18 |
sortkey => { type => 'integer', not_null => 1 }, |
|
18 | 19 |
); |
19 | 20 |
|
20 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
sql/Pg-upgrade2/partsgroup_description.sql | ||
---|---|---|
1 |
-- @tag: partsgroup_description |
|
2 |
-- @description: Warengruppe um Beschreibungsfeld erweitert |
|
3 |
-- @depends: release_3_5_5 |
|
4 |
|
|
5 |
ALTER TABLE partsgroup ADD COLUMN description TEXT; |
Auch abrufbar als: Unified diff
Warengruppe um Feld "Beschreibung" erweitert
Um z.B. zusätzliche Informationen zu hinterlegen, wenn man die Artikel
z.B. für einen Katalog exportieren möchte.