-- Changeset liveness-check-proxy/1.3.x/20260407-add-subject-id-to-audit-log.xml::1::Pavel Sindelar
-- Add column subject_id to audit_log
ALTER TABLE audit_log ADD subject_id varchar(256);
GO

-- Changeset liveness-check-proxy/1.3.x/20260407-add-subject-id-to-audit-log.xml::2::Pavel Sindelar
-- Create index on audit_log(subject_id)
CREATE NONCLUSTERED INDEX audit_log_subject_id_idx ON audit_log(subject_id);
GO

-- Changeset liveness-check-proxy/1.3.x/20260517-add-onboarding-event.xml::1::Michal Rozehnal
-- Add column timestamp_onboarding_event to table lcp_enrollment
ALTER TABLE lcp_enrollment ADD timestamp_onboarding_event datetime2;
GO

-- Changeset liveness-check-proxy/1.3.x/20260517-add-onboarding-event.xml::2::Michal Rozehnal
-- Create index lcp_enrollment_external_id_idx
CREATE NONCLUSTERED INDEX lcp_enrollment_external_id_idx ON lcp_enrollment(external_id);
GO
