noalyss-commit
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Noalyss-commit] [noalyss] 04/05: add index on action_person


From: Dany De Bontridder
Subject: [Noalyss-commit] [noalyss] 04/05: add index on action_person
Date: Mon, 24 Nov 2014 19:39:37 +0000

sparkyx pushed a commit to branch master
in repository noalyss.

commit 019930169270df334386a24d581125d47ba9b785
Author: Dany De Bontridder <address@hidden>
Date:   Mon Nov 24 20:20:24 2014 +0100

    add index on action_person
---
 sql/upgrade.sql |    3 +++
 1 files changed, 3 insertions(+), 0 deletions(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index f32de1e..1d94e02 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -185,6 +185,8 @@ comment on column action_person.ag_id is 'fk to fiche';
 ALTER TABLE action_person ADD CONSTRAINT action_gestion_ag_id_fk2 FOREIGN KEY 
(ag_id) REFERENCES  action_gestion (ag_id);
 ALTER TABLE action_person ADD CONSTRAINT fiche_f_id_fk2  FOREIGN KEY (f_id) 
REFERENCES fiche(f_id);
 ALTER TABLE action_gestion ADD CONSTRAINT fiche_f_id_fk3  FOREIGN KEY 
(f_id_dest) REFERENCES fiche(f_id);
+create index fk_action_person_action_gestion on action_person (ag_id);
+create index fk_action_person_fiche on action_person (f_id);
 
 alter table action_gestion alter f_id_dest drop not null;
 update action_gestion set f_id_dest = null where f_id_dest = 0;
@@ -210,3 +212,4 @@ CREATE TRIGGER trg_category_card_before_delete
   EXECUTE PROCEDURE comptaproc.category_card_before_delete();
 
 alter table action_gestion add constraint fk_action_gestion_document_type 
foreign key (ag_type) references document_type(dt_id);
+



reply via email to

[Prev in Thread] Current Thread [Next in Thread]