Easiest way is to add a new BOOL column to the table like
enabled with a default value of
UPDATE table_name SET enabled = 0 when you would like
to "delete" the row.
And filter out "deleted" rows in your queries like:
SELECT * FROM table_name WHERE ... AND enabled = 1