bmc_hub/migrations/1068_workflow_customer_card_coverage.sql

-- Additive customer-level coverage; no balances, invoices or existing coverage are changed.
CREATE TABLE IF NOT EXISTS bmc_workflow_customer_card_coverage (
 customer_id BIGINT PRIMARY KEY,
 workflow_coverage JSONB NOT NULL,
 updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
Add comprehensive test coverage for case creation, assignment, and remote recovery - Introduced tests for case creation commands, ensuring proper handling of UUIDs and payloads. - Added tests for v5 assignment functionality, validating employee identification and group assignment. - Implemented tests for remote recovery scenarios, including handling network failures and response validation. - Created tests for hardware label generation and validation, ensuring proper URL formatting and QR code generation. - Developed extensive tests for remote control functionality, covering connection isolation, command execution, and user permissions. - Added tests for workflow timer registration, ensuring correct handling of timer states and ownership validation. 2026-10-15 12:17:09 +02:00			`-- Additive customer-level coverage; no balances, invoices or existing coverage are changed.`
			`CREATE TABLE IF NOT EXISTS bmc_workflow_customer_card_coverage (`
			`customer_id BIGINT PRIMARY KEY,`
			`workflow_coverage JSONB NOT NULL,`
			`updated_at TIMESTAMPTZ NOT NULL DEFAULT now()`
			`);`