CREATE TABLE `short_url_cache`
( `short_url` VARCHAR(256) NOT NULL ,
  `decoded_url` VARCHAR(512) NOT NULL ,
  `hits` MEDIUMINT NOT NULL DEFAULT 1,
  `created` INT(11) NOT NULL ,
  `modified` INT(11) NOT NULL ,
  PRIMARY KEY (`short_url`)
) ENGINE = InnoDB;
ALTER TABLE `short_url_cache` ADD INDEX `short_url_by_modified` (`short_url`, `modified`);
ALTER TABLE `short_url_cache` ADD INDEX `short_url_modified` (`modified`);
