Skip to content

g1t/services/identity/migrations/0033_identity_jobs.sql

11 lines516 bytesCodeBlame
1-- Work identity does once, a page at a time, from its scheduled handler,
2-- and where each got to. The first is `creator_grants`: giving the person
3-- who created each existing repository the Admin role on it
4-- (src/members.rs), as a new repository's creator now gets at creation.
5CREATE TABLE IF NOT EXISTS identity_jobs (
6 name TEXT PRIMARY KEY,
7 -- The last repository id done; NULL before the first page.
8 cursor TEXT,
9 done_at TEXT
10);
11INSERT OR IGNORE INTO identity_jobs (name) VALUES ('creator_grants');