| 1 | -- What g1t was asked in issues and pull requests (src/summon.rs): one row |
| 2 | -- per ask acted on, by the event that asked (assigned, or mentioned in a |
| 3 | -- comment), so a delivery seen twice starts one session. `thread` is |
| 4 | -- `namespace/name#number`, for answering a thread a few times an hour at |
| 5 | -- most. Rows older than a week are cleared by the cron. |
| 6 | CREATE TABLE summons ( |
| 7 | event_id TEXT PRIMARY KEY, |
| 8 | thread TEXT NOT NULL, |
| 9 | at TEXT NOT NULL |
| 10 | ); |
| 11 | CREATE INDEX summons_by_thread ON summons (thread, at); |