Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision fa1b9d49

Von Tamino Steinert vor fast 2 Jahren hinzugefügt

  • ID fa1b9d4958f141e3f9026de40361c0ada63b4267
  • Vorgänger b03da1a4
  • Nachfolger 1f53f425

DB::Reclamation: Persistenter Record-Type

Unterschiede anzeigen:

SL/DB/MetaSetup/Reclamation.pm
31 31 
  notes                   => { type => 'text' },
32 32 
  payment_id              => { type => 'integer' },
33 33 
  record_number           => { type => 'text', not_null => 1 },
34 
  record_type             => { type => 'text', not_null => 1 },
34 35 
  reqdate                 => { type => 'date' },
35 36 
  salesman_id             => { type => 'integer' },
36 37 
  shippingpoint           => { type => 'text' },
sql/Pg-upgrade2/reclamation_type.sql
1 
-- @tag: reclamation_type
2 
-- @description: Persistente Typen in Reklamationen
3 
-- @depends: release_3_7_0
4 

  		




  
  5
  
    
ALTER TABLE reclamations ADD COLUMN record_type TEXT;


  		




  
  6
  
    

  		




  
  7
  
    
UPDATE reclamations SET record_type = 'sales_reclamaiton' WHERE customer_id IS NOT NULL;


  		




  
  8
  
    
UPDATE reclamations SET record_type = 'purchase_reclamation' WHERE vendor_id IS NOT NULL;


  		




  
  9
  
    

  		




  
  10
  
    
ALTER TABLE reclamations ALTER COLUMN record_type SET NOT NULL;


  		




  
  11
  
    

  		




  
  12
  
    

  		












Auch abrufbar als:  Unified diff