admin
9482a97795
CI (SIAX Cloud) / security (push) Successful in 13s
CI (SIAX Cloud) / contracts (pull_request) Successful in 17s
CI (SIAX Cloud) / security (pull_request) Successful in 13s
CI (SIAX Cloud) / contracts (push) Successful in 16s
CI (SIAX Cloud) / quality (push) Successful in 52s
CI (SIAX Cloud) / quality (pull_request) Successful in 1m13s
- schema migration 001 (registries, scans; owner_sub = introspected subject) - pg pool + services; scan ownership enforced in SQL (INSERT ... SELECT WHERE owner_sub) - real handlers: 201/400/404/500, owner-scoped GET/POST, listScans registryId filter - graceful shutdown closes pool; 7 new persistence tests (21/21)
27 lines
997 B
SQL
27 lines
997 B
SQL
-- C0PY 001 — registries + scans (canonical capture target registry)
|
|
-- Idempotent; owner_sub is the Zitadel introspection subject (never client-controlled).
|
|
|
|
CREATE TABLE IF NOT EXISTS registries (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
owner_sub TEXT NOT NULL,
|
|
name TEXT NOT NULL,
|
|
url TEXT NOT NULL,
|
|
config JSONB NOT NULL DEFAULT '{}'::jsonb,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS registries_owner_idx ON registries(owner_sub);
|
|
|
|
CREATE TABLE IF NOT EXISTS scans (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
registry_id UUID NOT NULL REFERENCES registries(id) ON DELETE CASCADE,
|
|
owner_sub TEXT NOT NULL,
|
|
status TEXT NOT NULL DEFAULT 'pending',
|
|
result JSONB NOT NULL DEFAULT '{}'::jsonb,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS scans_owner_idx ON scans(owner_sub);
|
|
CREATE INDEX IF NOT EXISTS scans_registry_idx ON scans(registry_id);
|