Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 78d19e27

Von Jan Büren vor fast 3 Jahren hinzugefügt

  • ID 78d19e27983335bbf6aae17a47799722c9e4b74c
  • Vorgänger 98d0f52e
  • Nachfolger faec06a4

Shop: shop_trans_id darf auch alphanumerisch sein (e030amdf)

Unterschiede anzeigen:

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