trigger.sql

create or replace function do_record_deleted_campground_reviews()
  returns trigger as
$BODY$
begin
 insert into deleted_records(table_name,record_id,deleted_at)
 select 'campground_reviews', OLD.id, now();
 
end;
$BODY$
language plpgsql;

create trigger record_deleted_campground_reviews before delete on campground_reviews 
  for each row execute procedure do_record_deleted_campground_reviews();