Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 6ea99163

Von Tamino Steinert vor etwa 2 Jahren hinzugefügt

  • ID 6ea99163c2783232cd0ed9f03c65a0a4c2a7ec65
  • Vorgänger bb6ab1cd
  • Nachfolger 5f42175e

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