Revision c550bc01
Von Kivitendo Admin vor 4 Monaten hinzugefügt
| SL/DB/MetaSetup/PartsGroup.pm | ||
|---|---|---|
|
__PACKAGE__->meta->table('partsgroup');
|
||
|
|
||
|
__PACKAGE__->meta->columns(
|
||
|
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
mtime => { type => 'timestamp' },
|
||
|
obsolete => { type => 'boolean', default => 'false' },
|
||
|
partsgroup => { type => 'text' },
|
||
|
sortkey => { type => 'integer', not_null => 1 },
|
||
|
description => { type => 'text' },
|
||
|
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
mtime => { type => 'timestamp' },
|
||
|
obsolete => { type => 'boolean', default => 'false' },
|
||
|
partsgroup => { type => 'text' },
|
||
|
sortkey => { type => 'integer', not_null => 1 },
|
||
|
);
|
||
|
|
||
|
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
|
||
| sql/Pg-upgrade2/partsgroup_description.sql | ||
|---|---|---|
|
-- @tag: partsgroup_description
|
||
|
-- @description: Warengruppe um Beschreibungsfeld erweitert
|
||
|
-- @depends: release_3_5_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.