Revision 78d19e27
Von Jan Büren vor etwa 3 Jahren hinzugefügt
| SL/DB/MetaSetup/ShopOrder.pm | ||
|---|---|---|
|
shop_customer_number => { type => 'text' },
|
||
|
shop_id => { type => 'integer' },
|
||
|
shop_ordernumber => { type => 'text' },
|
||
|
shop_trans_id => { type => 'integer', not_null => 1 },
|
||
|
shop_trans_id => { type => 'text', not_null => 1 },
|
||
|
tax_included => { type => 'boolean' },
|
||
|
transfer_date => { type => 'date' },
|
||
|
transferred => { type => 'boolean', default => 'false' },
|
||
| SL/DB/MetaSetup/ShopOrderItem.pm | ||
|---|---|---|
|
price => { type => 'numeric', precision => 15, scale => 5 },
|
||
|
quantity => { type => 'numeric', precision => 25, scale => 5 },
|
||
|
shop_order_id => { type => 'integer' },
|
||
|
shop_trans_id => { type => 'integer', not_null => 1 },
|
||
|
shop_trans_id => { type => 'text', not_null => 1 },
|
||
|
tax_rate => { type => 'numeric', precision => 15, scale => 2 },
|
||
|
);
|
||
|
|
||
| sql/Pg-upgrade2/shop_orders_update_4.sql | ||
|---|---|---|
|
-- @tag: shop_orders_update_4
|
||
|
-- @description: Ändern der Tabellen shop_orders, shop_trans_id darf auch Text enthalten
|
||
|
-- @depends: shop_orders_update_1 shop_orders_update_2 shop_orders_update_3
|
||
|
|
||
|
-- @ignore: 0
|
||
|
|
||
|
ALTER TABLE shop_orders ALTER COLUMN shop_trans_id TYPE text;
|
||
|
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)