lib

Core libraries for Radroots
git clone https://radroots.dev/git/lib.git
Log | Files | Refs | README

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';