File: decodeshorturl_pg.sql

package info (click to toggle)
spamassassin 4.0.1-5
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 22,960 kB
  • sloc: perl: 86,207; ansic: 5,193; sh: 3,710; javascript: 339; sql: 279; makefile: 209; python: 49
file content (10 lines) | stat: -rw-r--r-- 373 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
 
CREATE TABLE short_url_cache (
  short_url VARCHAR(256) NOT NULL,
  decoded_url VARCHAR(512) NOT NULL,
  hits INT NOT NULL DEFAULT 1,
  created INT NOT NULL,
  modified INT NOT NULL,
  PRIMARY KEY (short_url)
);
-- Maintaining index for cleaning is likely more expensive than occasional full table scan
-- ALTER TABLE short_url_cache ADD INDEX short_url_created (created);