cmd/icingadb-migrate/embed/ido_migration_progress_schema.sql


1
2
3
4
5
6
7
8
9

CREATE TABLE IF NOT EXISTS ido_migration_progress (
    environment_id CHAR(40)    NOT NULL, -- Hex SHA1. Rationale: CHAR(40) is not RDBMS-specific
    history_type   VARCHAR(63) NOT NULL,
    from_ts        BIGINT      NOT NULL,
    to_ts          BIGINT      NOT NULL,
    last_ido_id    BIGINT      NOT NULL,

    CONSTRAINT pk_ido_migration_progress PRIMARY KEY (environment_id, history_type, from_ts, to_ts)
);