Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision b17ffd97

Von Tamino Steinert vor mehr als 2 Jahren hinzugefügt

  • ID b17ffd976b6490bb30a6488d13ec9e70a24d1fb9
  • Vorgänger f5868597
  • Nachfolger ba93909c

Reclamation: add indexes for record_number, customer_id and vendor_id

Unterschiede anzeigen:

sql/Pg-upgrade2/reclamations.sql
66 66 
);
67 67 
CREATE TRIGGER mtime_reclamations BEFORE UPDATE ON reclamations FOR EACH ROW EXECUTE PROCEDURE set_mtime();
68 68 

  		




  
  69
  
    
CREATE INDEX reclamations_record_number_key ON reclamations (record_number);


  		




  
  70
  
    
CREATE INDEX reclamations_customer_id_key ON reclamations (customer_id);


  		




  
  71
  
    
CREATE INDEX reclamations_vendor_id_key ON reclamations (vendor_id);


  		




  
  72
  
    

  		




  
  73
  
    

  		




  69
  74
  
    
ALTER TABLE defaults ADD COLUMN p_reclamation_record_number TEXT NOT NULL DEFAULT 0;


  		




  70
  75
  
    
ALTER TABLE defaults ADD COLUMN s_reclamation_record_number TEXT NOT NULL DEFAULT 0;


  		




  71
  76
  
    

  		












Auch abrufbar als:  Unified diff