12 lines
469 B
SQL
12 lines
469 B
SQL
CREATE TABLE configuration_revisions (
|
|
instance_id TEXT NOT NULL REFERENCES instances(id) ON DELETE CASCADE,
|
|
revision INTEGER NOT NULL CHECK (revision >= 1),
|
|
redacted_snapshot TEXT NOT NULL,
|
|
reason TEXT NOT NULL CHECK (length(reason) BETWEEN 1 AND 100),
|
|
created_by TEXT,
|
|
created_at TEXT NOT NULL,
|
|
PRIMARY KEY (instance_id, revision)
|
|
);
|
|
|
|
CREATE INDEX configuration_revision_history_idx ON configuration_revisions(instance_id, revision DESC);
|