g1t/services/packages/migrations/0003_composer.sql
| 1 | -- Composer packages are found in the workspace's repositories, not |
| 2 | -- uploaded: the backfill walks every repository once, a page an hour, so |
| 3 | -- repositories that had a composer.json before the registry existed are |
| 4 | -- found without waiting for their next push. |
| 5 | CREATE TABLE composer_backfill ( |
| 6 | key TEXT PRIMARY KEY, |
| 7 | -- The last repository id done. |
| 8 | after TEXT, |
| 9 | finished_at TEXT |
| 10 | ); |
| 11 | CREATE INDEX versions_commit ON versions (package_id, digest); |