codeintel: add sequence number and optype to audit logs
Created by: Strum355
No optype for delete, as the time of delete can be trivially and unambiguously derived from record_deleted_at
column. The rest of this is just replacing triggers and the inverse for down migration.
Test plan
Will be caught by back-compat and existing tests as they are triggers