Триггер для SQLite который срабатывает при удалении записи

CREATE TRIGGER TR_AD_DAILY_ANIMAL
         AFTER DELETE
         ON resight
         FOR EACH ROW
BEGIN
    DELETE FROM daily
    WHERE r_year = OLD.r_year AND 
                animal_name = OLD.animal_name AND 
                site = OLD.site;
END;

CREATE TRIGGER TR_AD_DAILY_ANIMAL
         AFTER DELETE
         ON resight
         FOR EACH ROW
BEGIN
    INSERT delete_animal_daily(r_year, animal_name, site)
              VALUES(OLD.r_year, OLD.animal_name, OLD.site);                                      
 
    DELETE FROM daily
    WHERE r_year = OLD.r_year AND 
                animal_name = OLD.animal_name AND 
                site = OLD.site;
END;

resight (
    r_year        INTEGER,
    site          INTEGER,
    animal_name   TEXT,
    brand_quality TEXT,
    sex_r         TEXT,
    STATUS        TEXT,
    comments      TEXT,
    control       INTEGER,
    datecreated   TEXT,
    idkey         INTEGER PRIMARY KEY AUTOINCREMENT

daily (
    id          INTEGER,
    r_year      INTEGER,
    site        INTEGER,
    animal_name TEXT,
    r_date      TEXT,
    STATUS      TEXT,
    local_site  TEXT,
    comments    TEXT,
    observer    TEXT,
    datecreated TEXT,
    idkey       INTEGER PRIMARY KEY AUTOINCREMENT

delete_animal_daily(
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    date_delete     TEXT,
    reason_delete   TEXT,
    observer_delete TEXT,
    r_year          INTEGER,
    site            INTEGER,
    animal_name     TEXT,
    r_date          TEXT,
    STATUS          TEXT,
    local_site      TEXT,
    comments        TEXT,
    observer        TEXT,
    datecreated     TEXT

INSERT delete_animal_daily(r_date, STATUS, local_site, comments, observer, datecreated, r_year, animal_name, site)
              SELECT d.r_date, d.status, d.local_site, '', '', DATE('now'), OLD.r_year, OLD.animal_name, OLD.site
              FROM daily d WHERE
                             d.r_year = OLD.r_year AND 
                             d.animal_name = OLD.animal_name AND 
                             d.site = OLD.site
              LIMIT 1;