Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 2bdd0bc5

Von Sven Schöling vor etwa 10 Jahren hinzugefügt

  • ID 2bdd0bc580210b18c1b76a0d0bd4fc3bd3fceca2
  • Vorgänger df1b03d5
  • Nachfolger 418f0e70

PriceSource: pricegroup migration

Unterschiede anzeigen:

sql/Pg-upgrade2/recorditem_active_price_source.sql
3 3 
-- @depends: release_2_6_2
4 4 
-- @encoding: utf-8
5 5 

  		




  6
  
  
    
ALTER TABLE orderitems ADD COLUMN active_price_source TEXT NOT NULL DEFAULT '';


  		




  
  6
  
    
ALTER TABLE orderitems           ADD COLUMN active_price_source TEXT NOT NULL DEFAULT '';


  		




  7
  7
  
    
ALTER TABLE delivery_order_items ADD COLUMN active_price_source TEXT NOT NULL DEFAULT '';


  		




  8
  
  
    
ALTER TABLE invoice ADD COLUMN active_price_source TEXT NOT NULL DEFAULT '';


  		




  
  8
  
    
ALTER TABLE invoice              ADD COLUMN active_price_source TEXT NOT NULL DEFAULT '';


  		




  
  9
  
    

  		




  
  10
  
    
UPDATE orderitems           SET active_price_source = 'pricegroup/' || pricegroup_id WHERE pricegroup_id > 0;


  		




  
  11
  
    
UPDATE delivery_order_items SET active_price_source = 'pricegroup/' || pricegroup_id WHERE pricegroup_id > 0;


  		




  
  12
  
    
UPDATE invoice              SET active_price_source = 'pricegroup/' || pricegroup_id WHERE pricegroup_id > 0;


  		












Auch abrufbar als:  Unified diff