Revision 3b61c95f
Von Jan Büren vor 12 Monaten hinzugefügt
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
|
is_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
||
|
is_transfer_out => { type => 'boolean', default => 'false', not_null => 1 },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
|
kix18 => { type => 'boolean', default => 'false' },
|
||
|
language_id => { type => 'integer' },
|
||
|
layout_style => { type => 'text' },
|
||
|
letternumber => { type => 'integer' },
|
||
| SL/DB/MetaSetup/Order.pm | ||
|---|---|---|
|
tax_point => { type => 'date' },
|
||
|
taxincluded => { type => 'boolean' },
|
||
|
taxzone_id => { type => 'integer', not_null => 1 },
|
||
|
ticket_id => { type => 'integer' },
|
||
|
transaction_description => { type => 'text' },
|
||
|
transdate => { type => 'date', default => 'now' },
|
||
|
vendor_confirmation_number => { type => 'text' },
|
||
| sql/Pg-upgrade2/order_add_ticket.sql | ||
|---|---|---|
|
-- @tag: order_add_ticket
|
||
|
-- @description: KIX18 Funktion in defaults und Spalte für verknüpfte Tickets mit ID (bspw. KIX18) in oe
|
||
|
-- @depends: release_3_9_0
|
||
|
|
||
|
ALTER TABLE oe ADD ticket_id integer;
|
||
|
ALTER TABLE defaults ADD kix18 boolean DEFAULT FALSE;
|
||
Auch abrufbar als: Unified diff
kix18: db änderungen (feature konfigurierbar, ticket_id in oe)