Changes between Version 2 and Version 3 of Ticket #226


Ignore:
Timestamp:
Jan 24, 2017 1:55:35 PM (8 years ago)
Author:
marion
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #226 – Description

    v2 v3  
    2727--On les refait en ajoutant ce champ à la clé 
    2828ALTER TABLE t_marque_mqe ADD CONSTRAINT c_pk_mqe PRIMARY KEY (mqe_reference, mqe_nmq_code, mqe_org_code); 
    29 ALTER TABLE tj_actionmarquage_act ADD CONSTRAINT c_fk_act_mqe_reference FOREIGN KEY (act_mqe_reference, act_nmq_code, act_org_code) REFERENCES t_marque_mqe (mqe_reference, mqe_nmq_code, mqe_org_code) MATCH SIMPLE 
    30       ON UPDATE CASCADE ON DELETE NO ACTION; 
     29ALTER TABLE tj_actionmarquage_act ADD CONSTRAINT c_fk_act_mqe_reference FOREIGN KEY (act_mqe_reference, act_nmq_code, act_org_code) REFERENCES t_marque_mqe (mqe_reference, mqe_nmq_code, mqe_org_code) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION; 
    3130');