sql/redirectors_pg.sql

CREATE TABLE redir_url_cache (
  redir_url VARCHAR(256) NOT NULL,
  target_url VARCHAR(512) NOT NULL,
  hits INT NOT NULL DEFAULT 1,
  created INT NOT NULL,
  modified INT NOT NULL,
  PRIMARY KEY (redirs_url)
);
-- Maintaining index for cleaning is likely more expensive than occasional full table scan
-- ALTER TABLE redir_url_cache ADD INDEX redir_url_created (created);