Revision b17ffd97
Von Tamino Steinert vor fast 3 Jahren hinzugefügt
| sql/Pg-upgrade2/reclamations.sql | ||
|---|---|---|
|
);
|
||
|
CREATE TRIGGER mtime_reclamations BEFORE UPDATE ON reclamations FOR EACH ROW EXECUTE PROCEDURE set_mtime();
|
||
|
|
||
|
CREATE INDEX reclamations_record_number_key ON reclamations (record_number);
|
||
|
CREATE INDEX reclamations_customer_id_key ON reclamations (customer_id);
|
||
|
CREATE INDEX reclamations_vendor_id_key ON reclamations (vendor_id);
|
||
|
|
||
|
|
||
|
ALTER TABLE defaults ADD COLUMN p_reclamation_record_number TEXT NOT NULL DEFAULT 0;
|
||
|
ALTER TABLE defaults ADD COLUMN s_reclamation_record_number TEXT NOT NULL DEFAULT 0;
|
||
|
|
||
Auch abrufbar als: Unified diff
Reclamation: add indexes for record_number, customer_id and vendor_id