Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision e6ea2905

Von Tamino Steinert vor fast 2 Jahren hinzugefügt

  • ID e6ea29056c07c72e66285d974c2a5455b7100606
  • Vorgänger e796f2d7
  • Nachfolger af10df1d

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