Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision ef8bf303

Von Tamino Steinert vor mehr als 2 Jahren hinzugefügt

  • ID ef8bf303d37ffef1c435b03f3cd378329f4eb97d
  • Vorgänger 9c6751b7
  • Nachfolger b10162ca

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