Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811
[kivitendo-erp.git] / 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;