g1t/services/search/migrations/0002_requested_by.sql
Pick any line to see why it is the way it is: the commit, the pull request and issue it came from, and what the agent was thinking.
| g1t is the stored author of what it opens; the person who asked is requested_by and keeps the author's rights | 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'; |