-- The state each followed bookmark's pins were indexed at (oxygenhub#210):

-- the reconciler compares it with the bookmark as it is and re-indexes

-- where they differ, so an index write that failed is mended within

-- minutes rather than at the next restart.

CREATE TABLE diffusion_indexed (

    consumer_id INTEGER NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,

    bookmark TEXT NOT NULL,

    heads TEXT NOT NULL,

    updated_ms INTEGER NOT NULL,

    PRIMARY KEY (consumer_id, bookmark)

);