g1t/services/search/migrations/0002_requested_by.sql
| 1 | -- g1t is the author of the pull requests it makes and the issues its |
| 2 | -- agent files; the person who asked for the work is kept beside it, as |
| 3 | -- the work service now stores it (its 0025_requested_by). |
| 4 | ALTER TABLE items ADD COLUMN requested_by TEXT; |
| 5 | |
| 6 | -- Items indexed before name the person who asked as their author. Running |
| 7 | -- the backfill again reindexes every repository's issues and pull |
| 8 | -- requests as they are stored now; its code is compared with the index |
| 9 | -- and only what differs is read. |
| 10 | DELETE FROM meta WHERE key = 'backfill'; |