Database Table: captchas
From Dreamwidth Notes
Revision as of 23:35, 26 March 2009 by Twentyfourhours (Talk | contribs)
Definition
CREATE TABLE captchas ( capid INT UNSIGNED NOT NULL AUTO_INCREMENT, TYPE enum('image','audio'), issuetime INT UNSIGNED NOT NULL DEFAULT 0, answer CHAR(10), userid INT UNSIGNED NOT NULL DEFAULT 0, anum SMALLINT UNSIGNED NOT NULL, INDEX(TYPE,issuetime), INDEX(userid), PRIMARY KEY(capid) )
Relationships
Foreign key userid to user.userid