mirror of
https://git.proxmox.com/git/proxmox-spamassassin
synced 2025-08-06 17:52:00 +00:00
11 lines
373 B
SQL
11 lines
373 B
SQL
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);
|