| 1 | -- What the desktop app last said of the runner it keeps on a person's |
| 2 | -- computer: its diagnosis (state, why, the fix) and what to show once g1t |
| 3 | -- is closed there, as JSON in the app's own words. One row per computer |
| 4 | -- in a workspace, replaced at each report. |
| 5 | CREATE TABLE desktop_runners ( |
| 6 | workspace TEXT NOT NULL, |
| 7 | machine TEXT NOT NULL, |
| 8 | person TEXT NOT NULL, |
| 9 | backend TEXT NOT NULL, |
| 10 | version TEXT, |
| 11 | diagnosis TEXT NOT NULL, |
| 12 | closed TEXT NOT NULL, |
| 13 | reported_at TEXT NOT NULL, |
| 14 | PRIMARY KEY (workspace, machine) |
| 15 | ); |