-- Writers should not have to wait for readers
ALTER TABLE access_log ENGINE = InnoDB;

ALTER TABLE cookies ENGINE = InnoDB;

-- ALTER TABLE headers_in ENGINE = InnoDB;

-- ALTER TABLE headers_out ENGINE = InnoDB;

-- ALTER TABLE notes ENGINE = InnoDB;


-- We need an ordered key to do paging
ALTER TABLE access_log ADD (
  line INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE INDEX i_cookies_id 
ON cookies(id);

CREATE INDEX i_access_log_id 
ON access_log(id);