Revision 5ae5002c
Von Cem Aydin vor fast 3 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 |
qrbill_without_amount => { type => 'boolean', default => 'false' },
|
|
| 47 | 48 |
quodate => { type => 'date' },
|
| 48 | 49 |
quonumber => { type => 'text' },
|
| 49 | 50 |
salesman_id => { type => 'integer' },
|
| sql/Pg-upgrade2/ar_add_qrbill_without_amount.sql | ||
|---|---|---|
| 1 |
-- @tag: ar_add_qrbill_without_amount |
|
| 2 |
-- @description: Spalte für QR-Rechnung ohne Betrag |
|
| 3 |
-- @depends: release_3_5_8 |
|
| 4 |
ALTER TABLE ar ADD COLUMN qrbill_without_amount boolean; |
|
| 5 |
ALTER TABLE ar ALTER COLUMN qrbill_without_amount SET DEFAULT FALSE; |
|
| 6 |
UPDATE ar SET qrbill_without_amount = FALSE; |
|
Auch abrufbar als: Unified diff
Swiss QR-Bill: Datenbankupgrade Invoice/ar: Option Rechnung ohne Betrag hinzugefügt