DROP TABLE IF EXISTS caintermediate;
CREATE TABLE caintermediate (
  id BIGINT AUTO_INCREMENT NOT NULL,
  url VARCHAR(2000) NOT NULL,
  certificate MEDIUMTEXT,
  lastmodified BIGINT NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE UNIQUE INDEX caintermediate_url ON caintermediate(url);