Revision 744958b4
Von Cem Aydin vor mehr als 2 Jahren hinzugefügt
| SL/DB/MetaSetup/Invoice.pm | ||
|---|---|---|
|
ordnumber => { type => 'text' },
|
||
|
paid => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
|
||
|
payment_id => { type => 'integer' },
|
||
|
qr_reference => { type => 'text' },
|
||
|
qrbill_without_amount => { type => 'boolean', default => 'false' },
|
||
|
quodate => { type => 'date' },
|
||
|
quonumber => { type => 'text' },
|
||
| sql/Pg-upgrade2/ar_add_qr_reference.sql | ||
|---|---|---|
|
-- @tag: ar_add_qr_reference
|
||
|
-- @description: Spalte für QR-Referenz
|
||
|
-- @depends: release_3_6_1
|
||
|
ALTER TABLE ar ADD COLUMN qr_reference text;
|
||
Auch abrufbar als: Unified diff
Swiss QR-Bill: Datenbankupgrade: QR-Referenz in Rechnung speichern