Module schema 

Idempotent schema creation for the libSQL event store. Idempotent schema DDL for the libSQL event store.

Constants

CREATE_EVENTS_PROJECTION_INDEX

Event index supporting lifecycle projection scans and filter subqueries.

CREATE_EVENTS_TABLE

Append-only workflow event table.

CREATE_NAMESPACES_CREATED_AT_INDEX

Namespace index supporting the created_at ASC (tie-break name) list ordering.

CREATE_NAMESPACES_TABLE

Durable minted-on-use namespace registry (Control-Plane Phase 1).

CREATE_OUTBOX_CLAIMED_INDEX

Partial index over stale-claim reconciliation candidates.

CREATE_OUTBOX_PENDING_INDEX

Partial index over claimable rows, supporting the dispatcher’s status='pending' claim scan ordered by visible_after. Restricting the index to pending rows keeps it small as completed rows accumulate.

CREATE_OUTBOX_TABLE

Durable fan-out dispatch outbox.

CREATE_PACKAGES_TABLE

Runtime-deployed package archives keyed by (workflow_type, content_hash).

CREATE_PACKAGE_ROUTES_TABLE

Per-workflow-type route pointer for new workflow starts.

CREATE_TIMERS_FIRE_AT_INDEX

Timer index supporting due-timer range scans.

CREATE_TIMERS_TABLE

Durable workflow timers table.

CREATE_VISIBILITY_CLOSE_TIME_INDEX

Visibility index supporting close-time range filters.

CREATE_VISIBILITY_START_TIME_INDEX

Visibility index supporting start-time range filters and ordering.

CREATE_VISIBILITY_STATUS_INDEX

Visibility index supporting status equality filters.

CREATE_VISIBILITY_TABLE

Workflow visibility projection table.

CREATE_VISIBILITY_WORKFLOW_TYPE_INDEX

Visibility index supporting workflow-type equality filters.

Functions

ensure_schema

Ensure the libSQL schema exists on a fresh or previously-created database.