You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
24 lines
691 B
24 lines
691 B
-- Migration: create audit_events table
|
|
-- Date: 2026-03-22
|
|
-- Description: Placeholder migration to add an audit_events table to record audit logs.
|
|
--
|
|
-- Decision: The actual SQL is intentionally left commented out to avoid making
|
|
-- database changes during test runs. When ready to apply, uncomment and
|
|
-- adapt the SQL for your database engine.
|
|
|
|
/*
|
|
CREATE TABLE audit_events (
|
|
id UUID PRIMARY KEY,
|
|
actor_id UUID NOT NULL,
|
|
action TEXT NOT NULL,
|
|
target_type TEXT,
|
|
target_id UUID,
|
|
metadata JSONB,
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT now()
|
|
);
|
|
|
|
-- Add indexes as needed, e.g.:
|
|
-- CREATE INDEX ON audit_events (actor_id);
|
|
*/
|
|
|
|
-- End of migration placeholder
|
|
|