Difference between revisions of "Database Table: captcha cache"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table captcha_cache)
 
(No difference)

Latest revision as of 04:04, 8 June 2013

This is a global table.

Definition

CREATE TABLE captcha_cache (
    `captcha_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `question`   VARCHAR(255) NOT NULL,
    `answer`     VARCHAR(255) NOT NULL,
    `issuetime`  INT UNSIGNED NOT NULL DEFAULT 0,
 
    PRIMARY KEY (`captcha_id`),
    INDEX(`issuetime`)
)

Relationships