-- The rows each import from the old shop made, so an import can be undone (import_runs already lists the runs).
ALTER TABLE import_runs ADD COLUMN summary VARCHAR(255) NOT NULL DEFAULT '' AFTER rows_skipped;
CREATE TABLE import_rows (
  id        BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  run_id    INT UNSIGNED NOT NULL,
  tbl       VARCHAR(40) NOT NULL,
  row_id    VARCHAR(60) NOT NULL,
  KEY idx_run (run_id),
  FOREIGN KEY (run_id) REFERENCES import_runs(id) ON DELETE CASCADE
) ENGINE=InnoDB;
