[sqlite] disable update's & delete's via triggers?

[Igor Tandetnik]

On 9/20/2015 6:13 PM, James Hartley wrote:
> I ask because I am wanting to log all activity on another table.  I can
> successfully do this with triggers.  What I am curious to do is disable
> UPDATE's & DELETE's on the log tables themselves.

Something along these lines, perhaps:

create trigger no_delete before delete on log_table
begin
   select raise(IGNORE);
end;

-- 
Igor Tandetnik