Revision 9dc688b3
Von Jan Büren vor 10 Monaten hinzugefügt
| SL/DB/MetaSetup/Reclamation.pm | ||
|---|---|---|
|
tax_point => { type => 'date' },
|
||
|
taxincluded => { type => 'boolean', not_null => 1 },
|
||
|
taxzone_id => { type => 'integer', not_null => 1 },
|
||
|
ticket_id => { type => 'integer' },
|
||
|
transaction_description => { type => 'text' },
|
||
|
transdate => { type => 'date', default => 'now()' },
|
||
|
vendor_id => { type => 'integer' },
|
||
| sql/Pg-upgrade2/reclamation_add_ticket_id.sql | ||
|---|---|---|
|
-- @tag: reclamation_add_ticket_id
|
||
|
-- @description: KIX18 Spalte für verknüpfte Tickets mit ID (bspw. KIX18) in reclamations
|
||
|
-- @depends: release_3_9_0
|
||
|
|
||
|
ALTER TABLE reclamations ADD ticket_id integer;
|
||
|
|
||
Auch abrufbar als: Unified diff
Revert "kix18: Reklamationen dürfen auch eine ticket_id haben (Testfall)"
This reverts commit f0c62c1bfa00ed02e94f28ff46c7eda5e4cf7f9e.