File: decodeshorturl_mysql.sql

package info (click to toggle)
spamassassin 4.0.2-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 22,268 kB
  • sloc: perl: 88,850; ansic: 5,193; sh: 3,737; javascript: 339; sql: 295; makefile: 209; python: 49
file content (10 lines) | stat: -rw-r--r-- 415 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
 
CREATE TABLE `short_url_cache`
( `short_url` VARCHAR(255) NOT NULL,
  `decoded_url` VARCHAR(512) NOT NULL,
  `hits` INT NOT NULL DEFAULT 1,
  `created` INT(11) NOT NULL,
  `modified` INT(11) NOT NULL,
  PRIMARY KEY (`short_url`)
) ENGINE = InnoDB;
-- Maintaining index for cleaning is likely more expensive than occasional full table scan
-- ALTER TABLE `short_url_cache` ADD INDEX `short_url_created` (`created`);