Skip to content

The only tool you need to know what is happening and how to fix it.

304 B
Raw Blame
CREATE TABLE IF NOT EXISTS v2_move_over_days (
    source_table TEXT NOT NULL,
    day TEXT NOT NULL,
    state TEXT NOT NULL CHECK (state IN ('started', 'done')),
    moved_rows INTEGER NOT NULL DEFAULT 0 CHECK (moved_rows >= 0),
    updated_at DATETIME NOT NULL,
    PRIMARY KEY (source_table, day)
);