9 lines
352 B
SQL
9 lines
352 B
SQL
-- Remediation Engine storage v1: derived flags and package definitions only.
|
|
CREATE SCHEMA IF NOT EXISTS assessor_remediation;
|
|
CREATE TABLE IF NOT EXISTS assessor_remediation.package_snapshots (
|
|
scope_key text PRIMARY KEY,
|
|
data jsonb NOT NULL,
|
|
created_at timestamptz NOT NULL DEFAULT now(),
|
|
CHECK (jsonb_typeof(data->'packages') = 'array')
|
|
);
|