Revision c550bc01
Von Kivitendo Admin vor 6 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.