lorentz
1112a06afe
- RMM Overshell (migration 077): admin page, dispatch UI, executor/worker, target resolver, script registry (AD/DHCP/DNS/event-log/services/software/network/loglift) - LogLift evidence pipeline (migration 078): upload webhook, B2 storage client, receiver/matcher, EventLogCollector PowerShell script - IT Glue audit + write-back (migrations 075, 076): asset-audit runner, ticket xrefs, applications/configurations browse pages + apply/revert/audit endpoints - Link-aware analyzer bundles (migration 073) + provider toggle (migration 074): link-discovery service, OpenRouter LLM provider, related-tickets/itglue-suggestion panels, analyze-bundle endpoint - Endpoint data model + device-link reconciliation (migrations 079, 080): conflicts admin page, reconciler service, resolve endpoints - Dashboard overhaul: integration-health service + alerts, overview/health endpoints - Permissions: add itglue + rmm scopes; middleware: public /api/rmm/loglift route Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
38 lines
1.7 KiB
SQL
38 lines
1.7 KiB
SQL
-- AI Ticket Analyzer — provider column for per-run LLM provider tracking.
|
|
--
|
|
-- Adds a `provider` field so multiple analyses can coexist for the same
|
|
-- ticket from different LLM providers (Claude vs DeepSeek-via-OpenRouter)
|
|
-- without colliding on the (ticket_number, analysis_version) uniqueness.
|
|
--
|
|
-- analysis_version is now monotonic *within (ticket_number, provider)*, not
|
|
-- globally per ticket. This means:
|
|
-- - The first Anthropic run is v1, first OpenRouter run is also v1.
|
|
-- - Re-runs of Anthropic produce v2, v3, …; OpenRouter likewise.
|
|
|
|
ALTER TABLE analyzer_analyses
|
|
ADD COLUMN IF NOT EXISTS provider TEXT NOT NULL DEFAULT 'anthropic'
|
|
CHECK (provider IN ('anthropic', 'openrouter'));
|
|
|
|
ALTER TABLE analyzer_jobs
|
|
ADD COLUMN IF NOT EXISTS provider TEXT NOT NULL DEFAULT 'anthropic'
|
|
CHECK (provider IN ('anthropic', 'openrouter'));
|
|
|
|
-- Replace the old unique constraint with a provider-scoped one.
|
|
ALTER TABLE analyzer_analyses
|
|
DROP CONSTRAINT IF EXISTS analyzer_analyses_version_unique;
|
|
ALTER TABLE analyzer_analyses
|
|
ADD CONSTRAINT analyzer_analyses_version_unique
|
|
UNIQUE (ticket_number, provider, analysis_version);
|
|
|
|
-- Useful covering index for the listing path.
|
|
DROP INDEX IF EXISTS idx_analyzer_analyses_ticket_version;
|
|
CREATE INDEX IF NOT EXISTS idx_analyzer_analyses_ticket_provider_version
|
|
ON analyzer_analyses (ticket_number, provider, analysis_version DESC);
|
|
|
|
COMMENT ON COLUMN analyzer_analyses.provider IS
|
|
'Which LLM provider produced this analysis. anthropic=Claude direct; '
|
|
'openrouter=DeepSeek (V4 Pro/Flash + R1) via OpenRouter.';
|
|
|
|
COMMENT ON COLUMN analyzer_jobs.provider IS
|
|
'Provider the worker should use when running this job. Set by the analyze '
|
|
'endpoint based on the user''s pick.';
|