mirror of
https://github.com/Icinga/icingadb.git
synced 2026-02-03 20:40:34 -05:00
9 lines
416 B
SQL
9 lines
416 B
SQL
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)
|
|
);
|