1 2 3 4 5 6 7 8 9 10 11
| if (OLD.NOM is distinct from NEW.NOM) then
insert into trace_table (LA_DATE, L_HEURE, LE_USER, NOM_DU_CHAMP, ANCIENNE_VALEUR, NOUVELLE_VALEUR)
values (CURRENT_DATE, CURRENT_TIME, CURRENT_USER, 'NOM', OLD.NOM, NEW.NOM);
if (OLD.ADRESSE is distinct from NEW.ADRESSE) then
insert into trace_table (LA_DATE, L_HEURE, LE_USER, NOM_DU_CHAMP, ANCIENNE_VALEUR, NOUVELLE_VALEUR)
values (CURRENT_DATE, CURRENT_TIME, CURRENT_USER, 'ADRESSE', OLD.ADRESSE, NEW.ADRESSE);
if (OLD.VILLE is distinct from NEW.VILLE) then
insert into trace_table (LA_DATE, L_HEURE, LE_USER, NOM_DU_CHAMP, ANCIENNE_VALEUR, NOUVELLE_VALEUR)
values (CURRENT_DATE, CURRENT_TIME, CURRENT_USER, 'VILLE', OLD.VILLE, NEW.VILLE); |
Partager