Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 8325a281

Von Tamino Steinert vor etwa 2 Jahren hinzugefügt

  • ID 8325a2811bac010a9de48a564a3877ca9702f036
  • Vorgänger 0ecd797d
  • Nachfolger bd110579

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