Revision b403498c
Von Jan Büren vor mehr als 2 Jahren hinzugefügt
| SL/DB/MetaSetup/InvoiceItem.pm | ||
|---|---|---|
| 35 | 35 |
price_factor_id => { type => 'integer' },
|
| 36 | 36 |
pricegroup_id => { type => 'integer' },
|
| 37 | 37 |
project_id => { type => 'integer' },
|
| 38 |
qty => { type => 'float', precision => 4, scale => 4 },
|
|
| 38 |
qty => { type => 'numeric', precision => 25, scale => 5 },
|
|
| 39 | 39 |
sellprice => { type => 'numeric', precision => 15, scale => 5 },
|
| 40 | 40 |
serialnumber => { type => 'text' },
|
| 41 | 41 |
subtotal => { type => 'boolean', default => 'false' },
|
| SL/DB/MetaSetup/OrderItem.pm | ||
|---|---|---|
| 31 | 31 |
price_factor_id => { type => 'integer' },
|
| 32 | 32 |
pricegroup_id => { type => 'integer' },
|
| 33 | 33 |
project_id => { type => 'integer' },
|
| 34 |
qty => { type => 'float', precision => 4, scale => 4 },
|
|
| 34 |
qty => { type => 'numeric', precision => 25, scale => 5 },
|
|
| 35 | 35 |
reqdate => { type => 'date' },
|
| 36 | 36 |
sellprice => { type => 'numeric', precision => 15, scale => 5 },
|
| 37 | 37 |
serialnumber => { type => 'text' },
|
| sql/Pg-upgrade2/convert_real_qty.sql | ||
|---|---|---|
| 1 |
-- @tag: convert_real_qty |
|
| 2 |
-- @description: Spaltentyp auf Numeric anstelle von Real für qty |
|
| 3 |
-- @depends: release_3_6_0 |
|
| 4 |
ALTER TABLE orderitems ALTER column qty type numeric(25,5); |
|
| 5 |
ALTER TABLE invoice ALTER column qty type numeric(25,5); |
|
| 6 |
|
|
| 7 |
|
|
Auch abrufbar als: Unified diff
qty real nach numeric migrieren Ticket #491