7 lines
415 B
SQL
7 lines
415 B
SQL
ALTER TABLE vehicle_reconciliation_issue
|
|
ADD COLUMN archived_at DATETIME(3) NULL AFTER due_at,
|
|
ADD COLUMN archived_by VARCHAR(128) NOT NULL DEFAULT '' AFTER archived_at,
|
|
ADD COLUMN archive_reason VARCHAR(500) NOT NULL DEFAULT '' AFTER archived_by,
|
|
ADD INDEX idx_reconciliation_archive (archived_at, severity, last_seen_at),
|
|
ADD INDEX idx_reconciliation_archive_actor (archived_by, archived_at);
|