← Code-Übersicht

0011_schema_migration.sql

Pfad: migrations/0011_schema_migration.sql

Ext: sql

Größe: 456 Bytes

Geändert: 2026-07-16 16:59:35+02

-- Migration 0011: Nachvollziehbarer, checksum-basierter Migrationsstand.
CREATE TABLE IF NOT EXISTS public.schema_migration (
    version integer PRIMARY KEY,
    file_name text NOT NULL,
    checksum char(64) NOT NULL,
    status text NOT NULL CHECK (status IN ('APPLIED', 'BASELINED', 'SUPERSEDED')),
    applied_at timestamptz NOT NULL DEFAULT clock_timestamp(),
    actor text NOT NULL
);

GRANT SELECT, INSERT ON public.schema_migration TO demo_app;