Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 9810bb98

Von Tamino Steinert vor etwa 2 Jahren hinzugefügt

  • ID 9810bb9873d7b0614ad49a378a0eca88c666c628
  • Vorgänger 9b0937a9
  • Nachfolger 2f56fd8d

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