Revision ad9d0526
Von Jan Büren vor etwa 3 Jahren hinzugefügt
| SL/DB/MetaSetup/ShopOrder.pm | ||
|---|---|---|
| 77 | 77 |
shop_customer_number => { type => 'text' },
|
| 78 | 78 |
shop_id => { type => 'integer' },
|
| 79 | 79 |
shop_ordernumber => { type => 'text' },
|
| 80 |
shop_trans_id => { type => 'integer', not_null => 1 },
|
|
| 80 |
shop_trans_id => { type => 'text', not_null => 1 },
|
|
| 81 | 81 |
tax_included => { type => 'boolean' },
|
| 82 | 82 |
transfer_date => { type => 'date' },
|
| 83 | 83 |
transferred => { type => 'boolean', default => 'false' },
|
| SL/DB/MetaSetup/ShopOrderItem.pm | ||
|---|---|---|
| 17 | 17 |
price => { type => 'numeric', precision => 15, scale => 5 },
|
| 18 | 18 |
quantity => { type => 'numeric', precision => 25, scale => 5 },
|
| 19 | 19 |
shop_order_id => { type => 'integer' },
|
| 20 |
shop_trans_id => { type => 'integer', not_null => 1 },
|
|
| 20 |
shop_trans_id => { type => 'text', not_null => 1 },
|
|
| 21 | 21 |
tax_rate => { type => 'numeric', precision => 15, scale => 2 },
|
| 22 | 22 |
); |
| 23 | 23 |
|
| sql/Pg-upgrade2/shop_orders_update_4.sql | ||
|---|---|---|
| 1 |
-- @tag: shop_orders_update_4 |
|
| 2 |
-- @description: Ändern der Tabellen shop_orders, shop_trans_id darf auch Text enthalten |
|
| 3 |
-- @depends: shop_orders_update_1 shop_orders_update_2 shop_orders_update_3 |
|
| 4 |
|
|
| 5 |
-- @ignore: 0 |
|
| 6 |
|
|
| 7 |
ALTER TABLE shop_orders ALTER COLUMN shop_trans_id TYPE text; |
|
| 8 |
ALTER TABLE shop_order_items ALTER COLUMN shop_trans_id TYPE text; |
|
Auch abrufbar als: Unified diff
Shop: shop_trans_id darf auch alphanumerisch sein (e030amdf)