Opened 8 years ago
Closed 8 years ago
#227 closed defect (fixed)
Modification contrainte c_fk_ope_dic_identifiant
Reported by: | marion | Owned by: | |
---|---|---|---|
Priority: | minor | Milestone: | 5 Release stacomiR_0.5 |
Component: | database | Version: | 0.5 |
Keywords: | Cc: |
Description
Modification de la contrainte c_fk_ope_dic_identifiant qui ne permet pas de garantir qu'on met bien un identifiant de DC dans ope_dic_identifiant (puisque table tg_dispositif_dis mélange DF et DC).
Lancer ces 2 lignes pour modifier la contrainte (à lancer sur tous les schémas) :
alter table logrami.t_operation_ope drop constraint c_fk_ope_dic_identifiant;
alter table logrami.t_operation_ope add constraint c_fk_ope_dic_identifiant FOREIGN KEY (ope_dic_identifiant, ope_org_code) REFERENCES logrami.t_dispositifcomptage_dic (dic_dis_identifiant, dic_org_code) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION;
Change History (1)
comment:1 Changed 8 years ago by cedric
- Resolution set to fixed
- Status changed from new to closed
Note: See
TracTickets for help on using
tickets.