agent-radar
7be535059e
Dependency audit / audit (push) Canceled after 0s
CI / plan (push) Canceled after 0s
Gitoxide helper admission / macos-latest (push) Canceled after 0s
Gitoxide helper admission / ubuntu-latest (push) Canceled after 0s
Gitoxide helper admission / windows-latest (push) Canceled after 0s
Runtime Host peer admission / quality (push) Canceled after 0s
Windows recovery / windows_recovery (push) Canceled after 0s
CI / heavy (push) Canceled after 0s
CI / test (push) Canceled after 0s
120 lines
3.8 KiB
SQL
120 lines
3.8 KiB
SQL
-- Exact workflow schema as of the released schema-8 migration
|
|
-- (packages/storage/src/sqlite-workflow-schema.ts before the Work Board PR).
|
|
-- Applied on top of the v0.1.6 operational-state fixture to build a real
|
|
-- schema-8 database for the 8 -> 9 upgrade test.
|
|
--
|
|
-- Precondition: the v0.1.6 fixture already defines
|
|
-- workflow_quote_companion_cleanup WITHOUT record_json, so the CREATE TABLE
|
|
-- below is a no-op for it and the ALTER TABLE at the end adds the column.
|
|
-- If the table were absent, CREATE TABLE would define record_json and the
|
|
-- ALTER would fail with "duplicate column name".
|
|
|
|
DROP INDEX IF EXISTS workflow_plan_reminders_order;
|
|
DROP TABLE IF EXISTS workflow_plan_reminders;
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_task_ledger_events (
|
|
session_id TEXT NOT NULL,
|
|
sequence INTEGER NOT NULL CHECK (sequence >= 0),
|
|
event_id TEXT NOT NULL,
|
|
record_json TEXT NOT NULL,
|
|
PRIMARY KEY (session_id, sequence),
|
|
UNIQUE (session_id, event_id)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_task_ledger_projections (
|
|
session_id TEXT PRIMARY KEY,
|
|
record_json TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_plan_events (
|
|
session_id TEXT NOT NULL,
|
|
sequence INTEGER NOT NULL CHECK (sequence >= 0),
|
|
event_id TEXT NOT NULL,
|
|
store_version INTEGER NOT NULL CHECK (store_version > 0),
|
|
record_json TEXT NOT NULL,
|
|
PRIMARY KEY (session_id, sequence),
|
|
UNIQUE (session_id, event_id),
|
|
UNIQUE (session_id, store_version)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_plan_projections (
|
|
session_id TEXT PRIMARY KEY,
|
|
store_version INTEGER NOT NULL CHECK (store_version >= 0),
|
|
record_json TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_deep_research_events (
|
|
session_id TEXT NOT NULL,
|
|
sequence INTEGER NOT NULL CHECK (sequence >= 0),
|
|
event_id TEXT NOT NULL,
|
|
record_json TEXT NOT NULL,
|
|
PRIMARY KEY (session_id, sequence),
|
|
UNIQUE (session_id, event_id)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_scheduled_tasks (
|
|
task_id TEXT PRIMARY KEY,
|
|
created_at INTEGER NOT NULL,
|
|
updated_at INTEGER NOT NULL,
|
|
record_json TEXT NOT NULL
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS workflow_scheduled_tasks_order
|
|
ON workflow_scheduled_tasks(created_at, task_id);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_scheduled_task_fires (
|
|
claim_id TEXT PRIMARY KEY,
|
|
task_id TEXT NOT NULL UNIQUE,
|
|
claimed_at INTEGER NOT NULL,
|
|
record_json TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_quote_companion_cleanup (
|
|
session_id TEXT PRIMARY KEY,
|
|
tracked_at INTEGER NOT NULL,
|
|
record_json TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_daily_review_state (
|
|
singleton INTEGER PRIMARY KEY CHECK (singleton = 1),
|
|
config_json TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_daily_review_authority_state (
|
|
singleton INTEGER PRIMARY KEY CHECK (singleton = 1),
|
|
revision INTEGER NOT NULL CHECK (revision >= 0)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_daily_review_archives (
|
|
archive_id TEXT PRIMARY KEY,
|
|
generated_at INTEGER NOT NULL,
|
|
day_from_ms INTEGER NOT NULL,
|
|
record_json TEXT NOT NULL
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS workflow_daily_review_archives_order
|
|
ON workflow_daily_review_archives(generated_at DESC, day_from_ms DESC, archive_id);
|
|
|
|
CREATE TABLE IF NOT EXISTS workflow_goal_authority (
|
|
session_id TEXT PRIMARY KEY,
|
|
authority_revision INTEGER NOT NULL CHECK (authority_revision >= 0),
|
|
goal_id TEXT NOT NULL,
|
|
goal_revision INTEGER NOT NULL CHECK (goal_revision >= 0),
|
|
status TEXT NOT NULL,
|
|
record_json TEXT NOT NULL
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS workflow_goal_authority_status
|
|
ON workflow_goal_authority(status, session_id);
|
|
|
|
ALTER TABLE workflow_quote_companion_cleanup ADD COLUMN record_json TEXT;
|
|
UPDATE workflow_quote_companion_cleanup
|
|
SET record_json = json_object(
|
|
'version', 1,
|
|
'sessionId', session_id,
|
|
'trackedAt', tracked_at,
|
|
'phase', 'cleanup',
|
|
'cancelRequested', json('true')
|
|
)
|
|
WHERE record_json IS NULL;
|