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