0021_projection_atomic_generations.up.sql (842B)
1 CREATE TABLE radroots_runtime_projection_generations ( 2 projection_id TEXT NOT NULL CHECK(length(projection_id) BETWEEN 1 AND 128), 3 generation BLOB NOT NULL CHECK(length(generation) = 32), 4 source_generation BLOB NOT NULL CHECK(length(source_generation) = 32), 5 source_epoch INTEGER NOT NULL CHECK(source_epoch >= 0), 6 expected_active BLOB CHECK(expected_active IS NULL OR length(expected_active) = 32), 7 phase TEXT NOT NULL CHECK(phase IN ('staging', 'promoted', 'retired')), 8 document_rows INTEGER NOT NULL DEFAULT 0 CHECK(document_rows >= 0), 9 value_bytes INTEGER NOT NULL DEFAULT 0 CHECK(value_bytes >= 0), 10 PRIMARY KEY(projection_id, generation) 11 ) STRICT, WITHOUT ROWID; 12 13 CREATE UNIQUE INDEX radroots_runtime_projection_generations_staging_idx 14 ON radroots_runtime_projection_generations(projection_id) WHERE phase = 'staging';