Files
miem_workers/migrations/012_council_corrections.sql
codex f45c66e069
CI / test (pull_request) Successful in 9m28s
CI / Fingerprint diagnostics (production deployment temporarily disabled) (pull_request) Has been skipped
feat: add council publication and journal quartile editor
2026-10-09 12:03:19 +03:00

9 lines
306 B
SQL

-- Additive storage: original employee publications remain unchanged.
CREATE TABLE IF NOT EXISTS council_corrections (
id INTEGER PRIMARY KEY,
revision INTEGER NOT NULL,
data JSONB NOT NULL,
updated_by VARCHAR(255) NOT NULL,
updated_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
);