Revision f0c62c1b
| SL/DB/MetaSetup/Reclamation.pm | ||
|---|---|---|
| 40 | 40 |
tax_point => { type => 'date' },
|
| 41 | 41 |
taxincluded => { type => 'boolean', not_null => 1 },
|
| 42 | 42 |
taxzone_id => { type => 'integer', not_null => 1 },
|
| 43 |
ticket_id => { type => 'integer' },
|
|
| 43 | 44 |
transaction_description => { type => 'text' },
|
| 44 | 45 |
transdate => { type => 'date', default => 'now()' },
|
| 45 | 46 |
vendor_id => { type => 'integer' },
|
| sql/Pg-upgrade2/reclamation_add_ticket_id.sql | ||
|---|---|---|
| 1 |
-- @tag: reclamation_add_ticket_id |
|
| 2 |
-- @description: KIX18 Spalte für verknüpfte Tickets mit ID (bspw. KIX18) in reclamations |
|
| 3 |
-- @depends: release_3_9_0 |
|
| 4 |
|
|
| 5 |
ALTER TABLE reclamations ADD ticket_id integer; |
|
| 6 |
|
|
Auch abrufbar als: Unified diff
kix18: Reklamationen dürfen auch eine ticket_id haben (Testfall)